1000+ Advanced Excel MCQ Questions and Answers Pdf - 2

Question: 6

Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet of workbook?

(A) Data sheet

(B) Module sheet

(C) Chart sheet

(D) Worksheet

Question: 7

Which of the following methods cannot be used to enter data in a cell?

(A) clicking the enter button to the formula bar

(B) pressing the Esc key

(C) pressing the tab key

(D) pressing an arrow key

Question: 8

Excel is a

(A) a spreadsheet

(B) word processor

(C) graphic program

(D) none of these

Question: 9

What is the keyboard shortcut for creating a chart from the selected cells?

(A) F3

(B) F5

(C) F7

(D) F11

Question: 10

You can use the formula palette to

(A) copy a range of cells

(B) format cells containing numbers

(C) entered assumptions data

(D) create and edit formulas containing functions