SECTION A: MCQ – Each question below gives a multiple choice of answers. Select the best (most

appropriate) option/answer and fill in your answer booklet. E.g. If the answer to question “1” is “d”,

you write as follows: (1) d → Ribbon tabs

1. A component of the Microsoft Office user interface that, by default, is displayed above the left side

of the ribbon and provides users with easy access to commonly used commands is called:

(a) Ribbon

(a) table

(b) database

(c) spreadsheet

(d) workbook

(e) all of the above

3. The ability to combine name and addresses with a standard document is called:

(a) Document formatting

(b) database

(c) mail merge

(d) form letters

5. What do you call ‘a collection of character and paragraph formatting commands’?

(a) The defaults

(b) A template

(c) A style

(d) A boilerplate

6. A ________ is a container that is used to organize text, numerical data, or graphics and consists of

individual cells that are arranged in vertical columns and horizontal rows.

(a) Worksheet

(b) Database

(c) Table

REPUBLIC OF CAMEROON

Peace -Work – Fatherland

UNIVERSITY OF BAMENDA

P.O BOX 39 BAMENDA

TEL: 33 36 36 94

REPUBLIQUE DU CAMEROUN

Paix -Travail – Patrie

7. To create a formula, you can use:

(a) Value and cell references

(b) Values but not cell references

(d) Formatting and editing

(e) All of the above

9. When you click on File Menu is Access 2010, it opens:

(a) File menu

(b) File commands

(c) Backstage View

(d) File ribbon

10. Why the document you created at home displays with a different font at school?

(a) Because you have a different printer at school than at home

(b) Because you have a different monitor at school than at home

(d) By pressing Ctrl + {

12. A (n) ____________ is a dot or other symbol positioned at the beginning of a paragraph.

(a) Bullet

(b) Logo

(c) Cell

(d) Target

13. Except for the _____________ function, a formula with a logical function shows the word “TRUE”

or “FALSE” as a result.

(a) IF

(b) AND

(d) Spell-checking

(e) All of the above

15. Which of the following is true regarding page Orientation of a Document?

(a) Page orientation can be changed at any time

(b) Page orientation of document determines by printer

(c) Page orientation must be set before start typing

(d) Page orientation of a document cannot be change

16. A ____________ is a derived item in the database meant to answer specific questions that relate to

the information in the database. Queries are handy during data processing.

(a) Form

17. Which of the following is a type of page margin?

(a) Angle

(b) Left-Right

(d) Align center

19. In the formula, which symbol specifies the fixed columns or rows?

(a) &

(b) %

(c) $

(d) All of the above

20. When inserting page number in footer it appeared ‘1’ but you wish to show ‘a’. How can you do

that?

(a) From format menu choose bullets and numbering and configure necessary setting

(b) From insert menu choose page numbering and specify necessary setting

(d) Double click the INS status indicator on the status bar

22. Which would you choose to save a document with a new name?

(a) Press Ctrl + S

(b) Click File, Save

(c) Click Tools, Options, Save

(d) F12

23. A function inside another function is called a _______ function.

(a) Nested

(b) Round

(c) Sum

25. Which field type will you select when creating a new table if you require to enter long text in that

field?

(a) Text

(b) Memo

(c) Currency

(d) Hyperlink

26. Which of the following syntax is correct regarding to SUM function in Excel?

(a) = SUM (A1,B1)

(b) = SUM (A1:A9)

(c) = SUM (A1:A9,B1:B9)

(c) Paste and Delete

(d) Paste and Cut

(e) Drop and drag

29. Headers and footers can include text and graphics, as well as the ___________.

(a) Current date

(b) Page number

(c) Current time

(d) All of the above

30. A _____________ enables you to view data from a table based on a specific criterion.

(a) Form

(b) Query

(c) Macro

(d) Report

(e) None of the above

32. “Ctrl + Backspace” is used to:

(a) Delete the single letter just before the cursor

(b) Delete the single letter just after the cursor

(c) Delete the word just before the cursor

(d) Delete the word just after the cursor

33. The paragraph mark (¶) is a formatting mark that indicates where the ________ was pressed.

(a) Tab key

(b) Spacebar

(c) Enter key

35. Ctrl + V is used to:

(a) Paste Texts in the beginning of a document

(b) Paste Images in the beginning of a document

(c) Paste Tables at the middle of a document

(d) None of the above

36. In MS-WORD, for what does ruler help?

(a) To change page margins

(b) To set tabs

(c) To set indents

(d) All of the above

(d) All of the above

38. Which among the following are types of Excel data types?

(a) Numbers, Formulas, Labels

(c) Page orientations

(d) Paginations

(e) All of the above

40. Which of the following database object produces the final to present?

(a) Forms

(b) Reports

(c) Queries

(d) Tables

(e) Worksheet

44. The space between the margin and the text is called ____________.

45. When you type text in Word, the application automatically wraps text to fit the available space. Text

you type is added at the ______________, the blinking bar that shows where text will be inserted.

46. The most basic object in a database is a table in which you store data. List three guidelines that can

help you create efficient tables ___________, ______________, ____________.

47. You are editing a worksheet that you had previously saved. If you want to save the edited sheet with-

out losing the previous one, which command should you use? ____________________.

48. ______________ are groups of procedures written in Visual Basic and used to automate tasks.

49. The _______________ is a floating toolbar that appears when you select text in a document. It dis-

plays options to format the selection without having to work with tabs on the ribbon.

bles, pictures, or shapes.

53. The _______________ is a handy Word tool that helps you copy the formatting in selected text and

apply it to one or more additional selections.

54. ____________ is structure necessary to properly express Excel functions and to define their argu-

ments.

55. Cell or range references that change when users move or copy a formula from one cell to another are

called ______________.

56. Write out a formula to count the number of numeric entries in the cells A1 through A10, B7, and

F11.

57. Each time the ____________ key is pressed, the paragraph formatting in the precious paragraph is

59. Each record in a table should be unique. To distinguish one record from another, tables can contain a

_______ field.

60. Using ____________, Excel displays data that meets specified criteria with the specified formatting

63. ____________ automate common tasks in MS Access and can be run by clicking a button or press-

ing a shortcut key.

64. Alphabetic labels that appear along the top of an Excel worksheet and are used to differentiate indi-

vidual columns are called _________________.

65. In which Office application do you name a file at the same time you create it.

66. The clipboard task pane displays items on the ___________, which is temporary storage are for con-

tent that has been cut or copied from a document.

67. Write out a formula that would return the sum of values between cells C3 and C12 from only the

cells that are greater than 70,000.

68. ____________ formatting is the process of changing the way letters, numbers, punctuation marks