21 Objective MCQs on MicroSoft Excel
Which keyboard shortcut is used to save an Excel file?
A) Ctrl + S
B) Ctrl + O
C) Ctrl + N
D) Ctrl + P
Which option is used to set the print area in Excel?
A) Page Setup
B) Print Preview
C) Print Area
D) Header & Footer
Which function is used to find the maximum value in a range of cells?
A) MAX
B) MIN
C) SUM
D) AVERAGE
Which keyboard shortcut is used to insert a new row in Excel?
A) Ctrl + R
B) Ctrl + A
C) Ctrl + I
D) Ctrl + Shift + +
Which of the following chart types is used to show the trend of data over time?
A) Pie chart
B) Bar chart
C) Line chart
D) Scatter chart
Which of the following is not a valid alignment option in Excel?
A) Left
B) Right
C) Justify
D) Middle
Which of the following is not a valid format for a cell in Excel?
A) Date
B) Time
C) Currency
D) Font Size
Which keyboard shortcut is used to select an entire row in Excel?
A) Ctrl + R
B) Ctrl + A
C) Ctrl + Shift + =
D) Ctrl + Shift + 0
Which of the following is not a valid function category in Excel?
A) Text
B) Logical
C) Financial
D) Image
Which option is used to sort data in Excel?
A) Sort
B) Filter
C) Find & Replace
D) Group
Which keyboard shortcut is used to select an entire column in Excel?
A) Ctrl + C
B) Ctrl + V
C) Ctrl + Shift + 0
D) Ctrl + Spacebar
Which of the following is not a valid chart type in Excel?
A) Bar chart
B) Line chart
C) Column chart
D) Circle chart
Which option is used to freeze the top row in Excel?
A) Freeze Panes
B) Split Cells
C) Merge Cells
D) Wrap Text
Which function is used to count the number of cells in a range that contain a number?
A) COUNT
B) SUM
C) AVERAGE
D) MAX
Which of the following is not a valid data type in Excel?
A) Number
B) Text
C) Date/Time
D) Sound
Which option is used to create a chart in Excel?
A) Insert
B) Format
C) View
D) File
Which keyboard shortcut is used to close an Excel workbook?
A) Ctrl + W
B) Ctrl + O
C) Ctrl + N
D) Ctrl + S
Which function is used to calculate the average value in a range of cells?
A) AVERAGE
B) COUNT
C) MAX
D) MIN
Which of the following is not a valid conditional formatting option in Excel?
A) Highlight Cells Rules
B) Data Bars
C) Color Scales
D) Font Styles
Which option is used to find a specific value in an Excel workbook?
A) Find
B) Replace
C) Sort
D) Filter
Which keyboard shortcut is used to open the Format Cells dialog box in Excel?
A) Ctrl + Shift + F
B) Ctrl + Shift + C
C) Ctrl + Shift + P
D) Ctrl + Shift + 1