NEW
Font size
WorksheetsExcel MCQ Quiz
Total questions: 60
Worksheet time: 30mins
What is the default file extension used by Excel 2016 and later versions?
.xls
.xlsx
.xlsm
.xlsb
Which area in Excel displays the active cell address?
Formula Bar
Status Bar
Name Box
Ribbon
What does a cell's "fill handle" typically look like?
A solid square
A dotted line
A diagonal arrow
A circle
Which feature would you use to capture and analyze data from multiple sheets into one sheet?
PivotTable
Data Form
Consolidate
Template
What functionality does the 'Freeze Panes' feature provide in Excel?
Securing data
Hiding data
Splitting window
Locking rows/columns
How can you quickly select an entire worksheet in Excel?
Click the corner button
Double-click a tab
Right-click a tab
Use a shortcut
Which key combination is used to insert a new worksheet in Excel?
Ctrl + N
Ctrl + T
Ctrl + Shift + N
Shift + F11
What is the quickest way to resize a column to fit its contents?
Double-click the column header
Drag the header
Right-click and select resize
Use Format options
What shortcut performs the 'Paste Special' operation in Excel?
Ctrl + V
Ctrl + Alt + V
Ctrl + Shift + V
Alt + E, S
How do you apply a currency format to a cell in Excel?
Right-click and choose Format Cells
Use the $ button on Home tab
Ctrl + Shift + $
All of these
How would you quickly find all cells in a worksheet that contain formulas?
Use Find feature
Filter by color
Go to Special
Use Trace Precedents
What feature should you use to compare two Excel sheets side by side?
New Window
Arrange All
View Side by Side
Split
What symbol is used to start a formula in Excel?
@
#
=
+
Which function would you use to calculate the average value of a range of cells?
SUM()
AVERAGE()
MEAN()
TOTAL()
In Excel, which function returns the current date and time?
TODAY()
NOW()
DATE()
TIME()
What function would you use to find the lowest number in a range of data?
MIN()
MAX()
LOWER()
LEAST()
What does the COUNTA function do in Excel?
Counts cells containing any type of data
Counts only cells containing formulas
Counts empty cells
Counts cells containing numbers
Which function can be used to conditionally sum values in a range based on a criterion?
SUMIF()
SUM()
IFSUM()
TOTALIF()
What is the purpose of using the $ symbol in an Excel formula?
To convert currency
To indicate absolute reference
To highlight the cell
To mark important formulas
How do you display the formulas within the cells on an Excel worksheet?
Press Ctrl + `
Press F2
Select from View menu
Right-click and choose display formulas
What shortcut adds a new row in Excel?
Ctrl + Shift + " + "
Ctrl + " + "
Alt + Shift + " + "
Shift + " + "
To quickly calculate the sum of a column in Excel, which feature would you use?
Quick Analysis Tool
AutoSum
Formula Tab
All of these
What is the function to convert text to uppercase in Excel?
UPPERCASE()
UPPER()
CAPS()
TEXTUP()
Which function checks for the presence of a text string inside another string?
FIND()
SEARCH()
INSTRING()
TEXTFIND()
How can you create a dynamic formula that updates as new data is added?
Use an array formula
Use a volatile function
Use a named range
All of these
What Excel feature lets you apply a logical test to a value, then return one value if TRUE, another if FALSE?
IF()
TEST()
CHECK()
DECIDE()
You need to track changes made by team members on an Excel workbook. What feature should you use?
Track Changes
Audit Trail
Revision History
Document Inspector
How can you protect a worksheet from being edited accidentally?
Use a password
Lock cells
Set as read-only
All of these
How do you determine the number of numeric entries in a range?
Use COUNT()
Use NUMCOUNT()
Use COUNTNUM()
Use COUNTA()
Which Excel function is used to calculate the internal rate of return for a series of cash flows?
IRR()
ROI()
IRRVAL()
NETRATE()
What does the function XLOOKUP() replace in newer versions of Excel?
VLOOKUP() and HLOOKUP()
LOOKUP()
MATCH()
INDEX()
How do you calculate the number of workdays between two dates, excluding weekends and holidays?
WORKDAY()
NETWORKDAYS()
TOTALDAYS()
WORKDAYS()
Which function can be used to perform a lookup across multiple criteria in Excel?
XLOOKUP()
DLOOKUP()
MULTILOOKUP()
SUMIFS()
What function should be used to find the root of a number in Excel?
SQRT()
ROOT()
POW()
RADICAL()
Which function allows you to count unique values within a range that meet specified criteria?
COUNTIF()
COUNTA()
COUNTIFS()
UNIQUE()
How can you calculate the depreciation of an asset using the double-declining balance method in Excel?
DDB()
DB()
SLN()
SYD()
What Excel function is used to forecast a future value based on existing values?
FORECAST()
PREDICT()
PROJECT()
ESTIMAT
How can you split text from one cell into multiple columns?
Use Text to Columns feature
Use SPLIT() function
Use DIVIDE()
Use SEGMENT()
Which tool in Excel can automatically apply complex calculations to data in a table format?
Formulas
Functions
What-If Analysis
Quick Analysis
How do you link data from a cell in one worksheet to another worksheet within the same workbook?
Use the Link feature
Type the cell reference directly
Use a hyperlink
Use a formula
What function calculates the sum of the products of corresponding ranges or arrays?
SUMPRODUCT()
PRODUCTSUM()
MULTISUM()
ARRAYSUM()
What is the purpose of the INDIRECT function in Excel?
To delay calculation
To convert text into a formula
To prevent auto-calculation
To create dynamic cell references
Which function dynamically ranks values within a data set in Excel?
RANK()
RANK.EQ()
RANK.AVG()
RANK.DYNAMIC()
How do you array-enter a formula in Excel (versions prior to dynamic arrays)?
Press Enter
Press Ctrl + Shift + Enter
Press Shift + Enter
Press Alt + Enter
Which function would you use to analyze trends in data over intervals you specify?
TREND()
LINEST()
GROWTH()
FREQUENCY()
What feature would you use to automatically update the results of a formula when the input data changes?
AutoCalculate
AutoFill
AutoUpdate
Automatic Formulas
You have a large dataset where multiple entries per individual need to be summed up. Which function helps streamline this process?
SUMIF()
SUMIFS()
AGGREGATE()
CONSOLIDATE()
How can you merge data from multiple sheets into one master sheet without using VBA?
Use the Consolidate function
Use a macro
Use a pivot table
Use a template
How would you create a dynamic drop-down list that adjusts based on the data in another cell?
Use the Data Validation feature with INDIRECT()
Use a simple drop-down
Use a macro
Use Conditional Formatting
What is the maximum number of rows supported in an Excel 2019 worksheet?
1,048,576
65,536
100,000
500,000
Which feature automatically adjusts the width of a column to fit the longest cell entry?
AutoFit
AutoFill
AutoAdjust
AutoSize
In Excel, what does the 'Sort & Filter' feature allow you to do?
Modify data types
Change cell colors
Organize data alphabetically or numerically
Create data forms
What function would you use to combine data from two different cells into one?
CONCAT()
MERGE()
COMBINE()
LINK()
Which Excel tool allows you to manage large amounts of data from different sources?
Data Model
PivotTable
Formula Bar
Data Types
What is the purpose of Data Validation in Excel?
To filter data
To format data
To restrict data input types
To analyze data
Which feature should be used to track changes and updates made by different users in a shared Excel file?
Document Inspector
Track Changes
Shared Workbook
Audit Trail
How can you prevent other users from making unintended changes to a workbook?
Enable protection
Lock the file
Create a read-only copy
Password-protect the file
What shortcut key combination is used to hide a row in Excel?
Ctrl + 9
Ctrl + H
Ctrl + 0
Ctrl + Shift + 9
How do you display hidden rows or columns in an Excel worksheet?
Right-click and select 'Show'
Use the Unhide command
Use the Format menu
Click the Home tab
Which function is best to use when you need to find data within a range based on a condition?
LOOKUP()
SEARCH()
VLOOKUP()
FIND()
