MS Excel Multiple Choice Questions and Answers - 2

Question: 6

______ inserts a new worksheet.

(A) Alt + Shift + F1

(B) Alt + Shift + F2

(C) Alt + Shift + F3

(D) Alt + Shift + F4

Question: 7

_____ creates a chart of the data in the current range.

(A) Alt + F1

(B) Ctrl + F1

(C) Ctrl + Alt + F1

(D) Esc + F1

Question: 8

Which sign is used for absolute addressing?

(A) @

(B) $

(C) &

(D) *

Question: 9

Press ______ to open the Excel formula window.

(A) Shift + F3

(B) Shift + F4

(C) Shift + F5

(D) Shift + F6

Question: 10

A spreadsheet is a sheet which is spread in such a way that it divides itself into the various _____ and ______

(A) Horizontal columns, vertical row

(B) Horizontal table, vertical cell

(C) Horizontal cell, vertical table

(D) Horizontal row, vertical columns