15
multiple-choice questions and answers related to Microsoft Excel basics:-
1.
Which tab in the ribbon contains the formatting options in Microsoft Excel?
a)
Home
b)
Insert
c)
Page Layout
d)
Formulas
Answer:
a) Home
2.
Which option is used to save a workbook with a new name or in a different
location in Microsoft Excel?
a)
Save
b)
Save As
c)
Save and Close
d)
Save and Send
Answer:
b) Save As
3.
What is the shortcut to create a new workbook in Microsoft Excel?
a)
Ctrl + S
b)
Ctrl + N
c)
Ctrl + O
d)
Ctrl + P
Answer:
b) Ctrl + N
4.
Which function is used to sum a range of cells in Microsoft Excel?
a) COUNT
b)
MAX
c)
MIN
d)
SUM
Answer:
d) SUM
5.
What is the keyboard shortcut to copy selected cells in Microsoft Excel?
a)
Ctrl + C
b)
Ctrl + X
c)
Ctrl + V
d)
Ctrl + Z
Answer:
a) Ctrl + C
6.
What is the keyboard shortcut to paste copied cells in Microsoft Excel?
a)
Ctrl + C
b)
Ctrl + X
c)
Ctrl + V
d)
Ctrl + Z
Answer:
c) Ctrl + V
7.
Which feature is used to format cells to display currency in Microsoft Excel?
a)
AutoSum
b)
Format Painter
c)
Number Formatting
d)
Conditional Formatting
Answer:
c) Number Formatting
8.
What is the keyboard shortcut to open the Format Cells dialog box in Microsoft
Excel?
a)
Ctrl + 1
b)
Ctrl + 2
c)
Ctrl + 3
d)
Ctrl + 4
Answer:
a) Ctrl + 1
9.
Which function is used to find the highest value in a range of cells in
Microsoft Excel?
a)
COUNT
b)
MAX
c)
MIN
d)
SUM
Answer:
b) MAX
10.
What is the keyboard shortcut to insert a new row in Microsoft Excel?
a)
Ctrl + Shift + =
b)
Ctrl + +
c)
Ctrl + Shift + +
d)
Ctrl + -
Answer:
b) Ctrl + +
11.
Which function is used to find the average value of a range of cells in
Microsoft Excel?
a)
COUNT
b)
MAX
c)
MIN
d)
AVERAGE
Answer:
d) AVERAGE
12.
What is the keyboard shortcut to insert a new column in Microsoft Excel?
a)
Ctrl + Shift + =
b)
Ctrl + +
c)
Ctrl + Shift + +
d)
Ctrl + -
Answer:
c) Ctrl + Shift + +
13.
Which function is used to count the number of cells that contain data in a
range in Microsoft Excel?
a)
COUNT
b)
MAX
c)
MIN
d)
SUM
Answer:
a) COUNT
14.
What is the keyboard shortcut to delete a selected row in Microsoft Excel?
a)
Ctrl + Shift + =
b)
Ctrl + +
c)
Ctrl + Shift + +
d)
Ctrl + -
Answer:
d) Ctrl + -
15.
Which feature in Microsoft Excel is used to automatically correct common
spelling and typing errors?
a)
AutoCorrect
b)
Spell Check
c)
Thesaurus
d)
Find and Replace
Answer:
a) AutoCorrect
No comments:
Post a Comment