NEW
Font size
WorksheetsMS Excel MCQs
Total questions: 41
Worksheet time: 32mins
Which file extension is used for Excel workbooks?
.xls
.xlsx
.csv
.docx
What is the function used to calculate the sum of a range in Excel?
SUM
TOTAL
ADD
COUNT
What does the COUNT function do in Excel?
Counts all cells
Counts only numeric values
Counts empty cells
Counts characters in a cell
Which function returns the largest number in a given set of values?
LARGE
MAXIMUM
MAX
BIGGEST
Which function rounds a number down to the nearest integer?
ROUND
CEILING
ROUNDDOWN
FLOOR
What is the shortcut to create a new workbook in Excel?
Ctrl + N
Ctrl + W
Ctrl + O
Ctrl + Shift + N
What is the shortcut for AutoSum in Excel?
Ctrl + S
Alt + =
Shift + A
Ctrl + Alt + S
Which key allows you to edit the content of a cell?
F1
F2
F3
F4
How can you remove all formatting in a cell?
Delete the cell
Use the Clear Formats option
Press Ctrl + R
Apply a new format
What does the Filter function do in Excel?
Applies a filter to the dataset
Removes all blank rows
Sorts data
Deletes duplicate values
Which feature restricts data entry to specific values?
Conditional Formatting
Data Validation
Sorting
Filtering
What function returns TRUE only if all conditions are met?
OR
AND
XOR
NOT
What function returns TRUE if at least one condition is met?
AND
OR
XOR
NOT
In the IF function, what is returned if the condition is FALSE?
0
An error
The value specified for FALSE
TRUE
What function is used for conditional logic?
COUNTIF
IF
SUMIF
LOGIC
What is a Pivot Table used for?
Sorting data
Summarizing and analyzing large data sets
Formatting tables
Creating charts
Which of these is NOT a valid Excel data type?
Text
Numbers
Pictures
Date
What is a Pivot Chart?
A visual representation of a Pivot Table
A special type of pie chart
A linked table
A summary table
How do you refresh a Pivot Table?
Reopen the Excel file
Click 'Refresh' under the Pivot Table options
Recreate the table
Use Ctrl + F5
What happens when you double-click a Pivot Table value?
Deletes the value
Opens a new sheet with the related data
Shows a tooltip
Nothing
What is the purpose of the VLOOKUP function?
A) Look up values in a vertical column
B) Look up values in a row
C) Validate user input
D) Count non-empty cells
What function extracts a specific number of characters from the middle of a text string?
A) LEFT
B) RIGHT
C) MID
D) TRIM
Which function removes all extra spaces from text except for single spaces between words?
A) CLEAN
B) TRIM
C) SUBSTITUTE
D) REMOVE
What function is used to find the average of a set of numbers in Excel?
A) AVERAGE
B) MEAN
C) AVG
D) SUM
Which of the following functions can be used to count the number of non-empty cells in a range?
D) COUNT
C) COUNTBLANK
B) COUNTIF
A) COUNTA
What is the purpose of the CONCATENATE function in Excel?
A) To combine multiple text strings into one
B) To split a text string into multiple parts
C) To find the length of a text string
D) To convert text to uppercase
What is the function used to find the minimum value in a range of cells?
MIN
MINIMUM
LOWEST
LEAST
Which function is used to combine the contents of multiple cells into one cell?
JOIN
CONCATENATE
MERGE
COMBINE
What is the purpose of the HLOOKUP function in Excel?
B) Look up values in a vertical column
A) Look up values in a horizontal row
C) Validate user input
D) Count the number of cells
Which function is used to find the maximum value in a range of cells?
B) HIGHEST
D) MAXIMUM
A) MAX
C) TOP
What function can be used to check if a cell is empty?
B) EMPTY
C) ISNULL
D) CHECKEMPTY
A) ISBLANK
Which function is used to convert text to lowercase in Excel?
A) LOWER
B) LCASE
D) SMALL
C) TOLOWER
What is the function used to count the number of cells that meet a specific condition?
SUMIF
AVERAGEIF
FILTER
COUNTIF
How can you quickly format a range of cells as a table in Excel?
Use the Insert tab and select Table
Both A and C
Right-click and select 'Format Cells'
Use the Format as Table option in the Home tab
What does the CONCAT function do in Excel?
Combines multiple text strings into one
Finds the length of a text string
Converts text to lowercase
Splits a text string into multiple parts
Which function is used to find the minimum value in a range of cells?
D) SMALLEST
C) MINIMUM
B) LOWEST
A) MIN
What function can be used to replace specific text in a string?
B) REPLACE
A) SUBSTITUTE
D) EDIT
C) CHANGE
Which function is used to calculate the average of a range in Excel?
D) MEDIAN
A) AVERAGE
B) MEAN
C) AVG
Which function is used to convert text to uppercase in Excel?
D) CAPITALIZE
C) TOUPPER
B) UCASE
A) UPPER
What function can be used to find the average of a set of numbers in Excel?
A) MEAN
D) MEDIAN
B) AVERAGE
C) AVG
Which function is used to concatenate text strings in Excel?
B) CONCATENATE
A) JOIN
C) MERGE
D) COMBINE
