MS Excel Question & Answer MCQ SET 3
21.Which of the following is not the correct method of editing the cell content?
A) Press the Alt key
B) Double click the cell
C) Press the F2 key
D) Click the formula bar
ANSWER: OPTION A
22.What is the shortcut key to hide entire row?
A) CTRL + H
B) CTRL + R
C) CTRL + 9
D) CTRL + D
ANSWER: OPTION C
23.What is the short cut key to replace a data with another in sheet?
A) Ctrl + R
B) Ctrl + Shift + R
C) Ctrl + H
D) Ctrl + F
ANSWER: OPTION D
24.To move to the previous worksheet press
A) Shift + Tab
B) Ctrl + Pgdown
C) Ctrl + PgUp
D) ctrl + Tab
ANSWER: OPTION C
25.Pivot table comes in _______ Tab
A) Home
B) Page Layout
C) Insert
D) Data
ANSWER: OPTION C
26.Month Function is used to
A) pick up the month from a date
B) create a date
C) pick up the minute from a date
D) display current month
ANSWER: OPTION A
27.Red triangle at the top right corner of cell indicates
A) comment
B) syntax
C) text in cell is red
D) error entry
ANSWER: OPTION A
28.If we want to fix a cell address, one should press
A) F5
B) F6
C) F4
D) F3
ANSWER: OPTION C
29.MAX Function is used for
A) Find the maximum value from a number series
B) Find the minimum value from a number series
C) add numbers
D) for calculate average
ANSWER: OPTION A
30.Excel probably considers the cell entry January 1, 2000 to be a
A) Text string
B) Value
C) Label
D) Formula
ANSWER: OPTION B
0 Comments