Microsoft Office Excel – MCQ Set 2

1.____ appear at the bottom of the Excel window.

(A) Title bar

(B) Formula bar

(C) Work sheet tabs

(D) Name box


2. What are the basic rectangular building blocks of a spreadsheet?

(A) Cells

(B) Zoom slider

(C) Help button

(D) All of these


3. Which of the following is not a term pertaining to spreadsheets?

(A) Cell

(B) Character

(C) Browser

(D) Formula


4. Another name for a pre-programmed formula in Excel is

(A) Cell

(B) Graph

(C) Function

(D) Range


5. Excel is a program that is used to prepare a

(A) Slide presentation

(B) Spreadsheet

(C) Text document

(D) Database


6. In which tab wrap text feature is present in MS Excel 2007?

(A) Formulas

(B) View

(C) Insert

(D) Home


7. Which of the following identifies a cell in Excel?

(A) Address

(B) Formula

(C) Name

(D) Label


8. Which term is used to join the selected cells in to one cell?

(A) Filter

(B) Wrap

(C) Pivot

(D) Merge


9. Which of the following Excel charts represents only one value for each variable?

(A) Bar

(B) Pie

(C) Line

(D) Function


10. A formula in Excel always begins with an ____

(A) Equal sign

(B) Colon

(C) Comma

(D) Space


11. When the CPU detects an interrupt, then it saves its

(A) Previous state

(B) Next state

(C) Current state

(D) All of the above


12. A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

(A) List

(B) Section

(C) Range

(D) Area


13. What is the extension of saved file in MS Excel?

(A) .xls

(B) .xks

(C) .xos

(D) .xbs


14. Which command is used to close the window of Excel?

(A) Alt+ F4

(B) Ctrl + W

(C) Ctrl +R

(D) Ctrl+ C


15.What is the total region surrounding the chart?

(A) Chart area

(B) legend

(C) Clipart area

(D) Plot area


16. ____ returns the least common multiple.

(A) LCCM()

(B) LCM()

(C) TLCM()



17. This is not a function category in Excel.

(A) Logical

(B) Text

(C) Financial

(D) Data series


18. How many columns are there in old version of MS Excel?

(A) 250

(B) 256

(C) 265

(D) 269


19. Which bar show the used formula of selected active cell?

(A) Formula bar

(B) Ribbon

(C) Menu bar

(D) Scroll bar


20. Typed text showed in active cell and also in ___

(A) Formula bar

(B) Ribbon

(C) Title bar

(D) Scroll bar


21. What is the default row height of MS Excel?

(A) 10

(B) 12

(C) 13

(D) 15


22. Excel documents are stored as files called

(A) Workgroups

(B) Worktables

(C) Worksheets

(D) Workforce


23. What refers to the horizontal cells which can contain information?

(A) Ribbon

(B) Rows

(C) Columns

(D) Horizontal scrollbar


24. Today motherboard typically use

(A) 70 pin modules

(B) 72 pin modules

(C) 74 pin modules

(D) 76 pin modules


25. To minimize the currently selected window, press

(A) Ctrl+ F11

(B) Ctrl+ F12

(C) Ctrl+ F9

(D) Ctrl+ F10