MS Excel MCQ Questions and Answers – Part 3
MS Excel MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about the Workbook, Menu bar, Toolbar, Column headings, Row headings, Name box, Formula bar, and much more. This systematic learning method will easily prepare anyone to pass their exam.
1. What is the shortcut to select the whole column?
A Ctrl + C
B Ctrl + Enter
C Ctrl + R
D Ctrl + Space bar
D
2. In a formula, which symbol specifies the fixed columns or rows?
A $
B *
C %
D &
A
3. Excel displays the current cell address in ______
A Formula bar
B State bar
C Field Name
D Title bar
C
4. What is the best way to reference cell A10 on sheet 3 from sheet 1?
A sheet3!A10
B sheet1!A10
C Sheet3.A10
D A10
A
5. Which language is used to create macros in Excel?
A Visual Basic
B C
C Visual C++
D Java
A
6. Which of the following is not an MS-Excel term?
A Cells
B Lines
C Columns
D Document
D
7. How many worksheets can a workbook have?
A 3
B 8
C 255
D None of the above
D
Although you are limited to 255 sheets in a new workbook, Excel does not limit the number of sheets you can add after you create a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is the RAM of your computer.
8. Which one would you choose to create a bar chart?
A Edit, chart
B Insert, chart
C Tools, chart
D Format, chart
B
9. What setting do you need to change to print a spreadsheet with the header?
A Document
B Margin
C Page layout
D Orientation
B
10. The “Spelling” dialog box can be accessed by choosing “Spelling” from the ________.
A Insert
B File
C Review
D View
C
