Office Automation (CSCT2201)
DIPET 1 in Mathematics, Science and Technology - MSTT
Semester: Second Semester
Level: 200
Year: 2019
REPUBLIC OK CAMEROON THE UNIVERSITY OF BA MEN DA
Peace-Work-Fatherland P.O. Box 39 Bambili
Second Semester Examinations
School: HTTTC Department: Computer Science Option: All Industrials (Level 100)
Course Code: Course Title: Office Automation
Lecturer: Mbiethieu Cezar Credit Value: 2
Date: Time: 1h Start Time: Eend Time:
Instructions: I. Answer following the order; 2. Only write the question number followed by the
character of the answer e.g 45. A; 3. Fill all the answers on a single page
SECTION A MCQ (10 marks)
1. In MS-Word grammatical errors are underlined in
a. Red b. blue c. Yellow d. Green
2. Which of these characters cannot be contained in a
file name?
a. ? b. < > c. / d. all the above
3. What word refers to the characteristics of word style
in Word?
a. Ribbon b. Font c. bold d. Merge
4. We can insert a page number at
(A) Header (B) Footer (C) Both A and B (D) None
5
Which one can be used as watermark in a word
document
(A) Text (B) Image
(C) Both A and B (D) None
6
Which item appears dimly behind the main body
text?
(A) Water color (B) Back ground (C) Water mark
(D) Back color
7. The direction of a rectangular page for viewing
and printing is called (A) Orientation (B) Print Layout
(C) Direction (D) Preview
9.
We can remove / hide border of a shape by selecting
(A) No Line (B) No Outline
(C) White line (D) No Border
10. To apply center alignment to a paragraph we can
press
(A) Ctrl + C (B) Ctrl + S
(C) Ctrl C + A (D) Ctrl + E
11. Which can be used for quick access to commonly
used commands and tools?
a. Status bar b. Tool bar
c. Menu bar d. Title bar
11. “Ctrl + Right Arrow” is used to
a. Moves the cursor one word right
b. Moves the cursor end of the line
c. Moves the cursor end of the document
d. Moves the cursor one Paragraph down
12. Portrait and Landscape are?
a. Page Orientation b. Paper Size
c. Page Layout d. All of above
13. Change the_______to create a document in wide
format
a. Page Orientation b. Page margins
c. Paper Style d. Paper Source
14. To instruct Word to stop building paragraphs,
do any of the following except __________.
a. press the enter key twice
b. click the Undo button on the Standard toolbar
c. press the backspace key to remove the bullet
d. click the Bullets button on the Formatting toolbar
15. From v here you can access Save command?
a. Home tab b. Insert tab
c. Rev iew tab d. None of above
16. In MS Word, Ctrl+S is for
a. Scenarios b. Size
c. Save d. Spelling Check
17. How can you apply exactly the same formatting
you did to another text?
a. Copy the text and paste in new location Then type the
new text again.
b. Copy the text and click on Paste Special tool on new
place
c. Select the text then click on Format Painter and select
the next text
d. All of above
www.schoolfaqs.net
18 In Excel, a function inside another function is
called?
A. Nested function B. Round function C. Sum function
19. Formulas in Excel start with
A. % B = C. + D
D. Text function
22. The cell reference for cell range of G2 to Ml2 i
A. G2.MI2 B G2;M12 C G2 M12 D G2-M12
23. The .Software which contains rows and columns
is called
A Database B Drawing C Spreadsheet D. Word
processing
24. Where a row and a column meet, what do you
call that? A. A cell B A block C. A box D). None of
the above
25. Give me an example of a cell address
A 11 25 B. 911 C 41A D A21
26. Which is an example of a formula?
A =AI + A2 B. = add(Al:A2) C. A1+A2 D.
SUM(AI:A2)
27. Which is an example of a function?
A. =add(AI:A2) B. =AI+A2 C. =SUM (Al:A2) D
AI+A2
27 B7:B9 indicates:
A Cells B7 and cell B9 only. B. Cells B7 through B9
C. Cell B8 only. D. None of the above
28 What happens when dollar signs ($) are entered in
a cell address? (ex. $B$2:$B$10)
A An absolute cell address is created. B. Cell address
will change when it is copied to another cell. C. The
sheet tab is changed. I). The status bar does not
display the cell address
29. Which would you choose to create a bar
diagram?
A. Edit, Chart B Insert, Chart C. Tools, Chart D.
Format, Chart
30. How do you wrap the text in a cell?
A. Format, cells, font B. Format, cells, protection C.
format, cells, number D. Format, cells, alignment
31.What docs COUNTA () function do?
A. counts cells having alphabets B. counts empty
cells C. counts cells having number D. counts
non-empty cells
32. NOT, AM), OR and XOR arc
A. Logical Operators B. Arithmetic operators C.
Relational operators D. None of the above
33. How do you display current date only in MS
Excel?
A. date () B. Today () C. now() D. tune ()
34. An Excel Workbook is a collection of
A. Workbooks B. Worksheets C. Charts D.
Worksheets and Charts
35. Which types of charts can excel produce?
a.
Line graphs and pie charts only b. Only line
graphs
c.
Bar charts, line graphs and pie charts
d. Bar charts and line graphs only
36. What does the VLOOKUP function do?
a Looks up text that contain V
b.
Checks whether text is the same in one ceil as in
the next
c.
Finds related records
d.
d All of above
37. Which function in Excel tells how many numeric
entries are there?
A. NUM B. COUNT C.SUM D.CIIKNUM
38. In EXCEL, you can sum a large range of data by
simply selecting a tool button called_____?
A AutoFill B Auto correct
C Auto sum D Auto format
39. Which file format can be added to a PowerPoint
show?
a. .jpg b. .giv c. .wav d. All of the above
40. You can create a new presentation by completing
all of the following except
A. Clicking the new button on the standard toolbar
B. Clicking file, new C. Clicking file open
D. Pressing Ctrl + N
41. Special effects used to introduce slides in a
presentation are called
A. effects B. custom animations
C. transitions D. present animations
42. What is the term used when you press and hold
the left mouse key and more the mouse around the
slide?
a. Highlighting b. Dragging c. Selecting d.
Moving
43. Which short cut key inserts a new slide in current
presentation?
A) Ctrl+N B) Ctrl+M C) Ctrl+S D) All of above
44. From which menu you can access Picture, Test
Box, Chart, etc?
A) File B) Edit C) Insert D) View
www.schoolfaqs.net
www.schoolfaqs.net
