Question: 6
While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet tab.
(A) Alt
(B) Ctrl
(C) Shift
(D) Insert
Ans: B
Ctrl
Question: 7
This dialog box specifies or modifies the worksheet cell range containing data to be charted.
(A) Chart Location
(B) Chart Style
(C) Chart Options
(D) Chart Source Data
Ans: D
Chart Source Data
Question: 8
Which of the following is the purpose of AutoSum?
(A) Display the sum of the selected cells directly after the selected cells
(B) Display the sum of the selected cells directly before the selected cells
(C) Don’t add the grand total
(D) All of these
Ans: A
Display the sum of the selected cells directly after the selected cells
Question: 9
The default file extension of MS Excel is
(A) Xlr
(B) Exe
(C) Xls
(D) Exl
Ans: C
Xls
Question: 10
By default the cell content alignment is
(A) Text left aligned and number right alignment
(B) Text right aligned and numbers left alignment
(C) Left aligned
(D) Centrally aligned
Ans: A
Text left aligned and number right alignment