MS Excel Question & Answer MCQ SET 2
11.Which of the following is an absolute cell reference?
A) !A!1
B) $A$1
C) #a#1
D) A1
ANSWER: OPTION B
12.Which Chart can be created in Excel?
A) Area
B) Line
C) Pie
D) All of 1,2 and 3 Options
ANSWER: OPTION D
13.How do you change column width to fit the contents?
A) Single-click the boundary to the column heading
B) Double click the boundary to the right of the column heading
C) Press Alt and single click anywhere in column
D) All of above
ANSWER: OPTION B
14.How should you print a selected area of a worksheet, if you’ll want to print a
different area next time?
A) On the file menu, point to print area, and then click set print area .B) On the file menu , click print, and then click selection under print what
C) On the view menu, click custom views, then click add
D) All of above
ANSWER: OPTION B
15.What does SUMIF function do?
A) Adds up cell values based on a condition
B) Adds all the numbers in a range of cells
C) Returns a subtotal in a list or database
D) All of above
ANSWER: OPTION A
16.Extension of Excel 2007 file
A) .exl
B) .xlsx
C) .xls
D) All of the above
ANSWER: OPTION B
17.A quick way to return to a specific area of a worksheet is to type in the ______
A) Zoom Box
B) Formula Bar
C) Name Box
D) All of these
ANSWER: OPTION C
18.What key is used to select multiple ranges of cells?
A) Shift
B) Ctrl
C) Alt
D) AltCar or AltGr
ANSWER: OPTION B
19.Worksheet can be renamed by
A) Click on Worksheet tab by Holding CTRL Key and type new name
B) Double Click on the Worksheet tab and type new name
C) Worksheet cannot renamed
D) At The Time
ANSWER: OPTION B
20.Each excel file is a workbook that contains different sheets. Which of the
following can not be a sheet in workbook?
A) data sheet
B) work sheet
C) module sheet
D) chart sheet
ANSWER: OPTION D
0 Comments