Home >> MS Excel MCQs >>

MS Excel Set 09

MS Excel Set 09

Q.1 The Greater Than sign is an example of ________ operation?
A. Arithmetic
B. Logical
C. Conditional
D. Greater

ANSWER: B) Logical
Explanation : The Greater Than sign is an example of logical operation

Q.2 Which function displays row data into column or column data into row?
A. Hyperlink
B. Index
C. Transpose
D. Rows

ANSWER: C) Transpose
Explanation : Transpose function is used to displays row data into column or column data into row.

Q.3 Microsoft Office Suite spreadsheet program is _________?
A. None of these
B. Microsoft Word
C. Microsoft Excel
D. Microsoft PowerPoint

ANSWER: C) Microsoft Excel
Explanation : MS Excel is a Spreadsheet program provided in MS Office Suite

Q.4 which short key is used to move to Next Sheet in MS Excel:
A. Ctrl + Page Down
B. Shift + Page Down
C. Page Down
D. None of these

ANSWER: A) Ctrl + Page Down
Explanation : CTRL + PageDown is used to move to Next Sheet in MS Excel:

Q.5 Move to next cell in row in MS Excel:
A. Tab
B. Shift
C. Space
D. None of these

ANSWER: A) Tab
Explanation : Pressing Tab key, Conteol will move to the next cell in worksheet.

Q.6 Which of these keys is used in MS Excel to copy formula from above cell?
A. Ctrl+ ”
B. Ctrl+ ;
C. Ctrl+ :
D. Ctrl+ ‘

ANSWER: D) Ctrl+ ‘
Explanation : CTL + ‘ (Apostrophe ) key is used in MS Excel to copy formula from above cell?

Q.7 Which of these keys are used in MS Excel to copy value from above cell?
A. Ctrl + “
B. Ctrl+ E
C. Ctrl+ E
D. Ctrl+ D

ANSWER: D) Ctrl+ D
Explanation : CTRL + D is used to copy the content of above cell in below cell. Where as CTRL+R is used to copy the content of left cell in right cell.

Q.8 Which key is used for help in MS Excel?
A. F1
B. F2
C. F3
D. None of these

ANSWER: A) F1
Explanation : In MS Windows environment, F1 is used to open the help. So in MS office i.e., MS Word, MS Excel or MS Powerpoint F1 is used to open help.

Q.9 Which one is example of spreadsheet software?
A. MS WORD
B. MS EXCEL
C. MS POWERPOINT
D. None of these

ANSWER: B) MS EXCEL
Explanation : MS Excel is an examle of Spreadsheet Software.

Related Posts

More MCQs