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()

(D) RTLCM()

 

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