Microsoft Excel mcqs with answers part 1 ?

1 min read
Multiple Choice Questions of Microsoft Excel

1 A functiotn inside other function is called _______
A. Nested function
B. Round function
C. Sum function
D. Text function

2 Which of the following is not an underline option in the format cells dialog box?
A. Double
B. Single Accounting
C. Double Accounting
D. Single Engineering

3 Formulas in Excel start with
A. %
B. =
C. +
D. –

4 The default header for a worksheet is
A. Username
B. Date and Time
C. Sheet tab Name
D. None

5 Which of the following is not an option of the spelling dialog box?
A. Ignore
B. Ignore all
C. Edit
D. Change

6 Which of the following methods will not enter data in a cell?
A. Pressing the Esc key
B. Pressing an arrow key
C. Pressing the tab key
D. Clicking the enter button to the formula bar

7 The cell reference for cell range of G2 to M12 i s _______
A. G2.M12
B. G2;M12
C. G2:M12
D. G2-M12

8 What is the keyboard shortcut for creating a chart from the selected cell range?
A. F2
B. F4
C. F8
D. F11

9 The Software which contains rows and columns is called ______
A. Database
B. Drawing
C. Spreadsheet
D. Word processing

Also read this post:-
Ms excel mcqs with answers part-2 ?

10 You can group noncontiguous worksheets with
A. The alt+enter key
B. The ctrl key and mouse
C. The shift key and tprocessing
D. The group button on the standard toolbar.




Post a Comment