Font size
WorksheetsExcel Assessment
Total questions: 55
Worksheet time: 23mins
What is the shortcut for creating a new workbook?
Ctrl + P
Ctrl + O
Ctrl + N
Ctrl + S
Which function is used to find the average of a range of numbers?
AVG
SUM
AVERAGE
MIN
What symbol is used to start a formula in Excel?
@
+
=
#
How do you create an absolute cell reference?
&A1
A1
#A1
$A$1
Which of the following is a valid cell reference?
A1
1A
$1A
A#1
What does the VLOOKUP function do?
Calculates the sum of a range of cells
Searches for a value in a horizontal row
Looks for a value in a vertical column
Finds the average of a set of numbers
Which of these formulas will add the values in cells A1 through A5?
=SUM(A1:A5)
=SUMMATION(A1:A5)
=ADD(A1:A5)
=SUM(A1;A5)
What does the IF function do?
Counts the number of cells in a range
Checks a condition and returns one value if true and another if false
Adds a series of numbers
Finds the largest number in a range
Which function is used to count the number of cells that contain numbers?
COUNTIF
COUNTIFS
COUNT
COUNTA
How do you combine text from two cells into one cell?
JOIN
CONCATENATE or &
LINK
MERGE
How can you sort data in ascending order?
Home > Sort Ascending
Review > Sort Ascending
Data > Sort Ascending
Insert > Sort Ascending
Which feature allows you to quickly fill cells with repetitive or sequential data?
AutoFill
Flash Fill
Fill Handle
Drag and Drop
What is the keyboard shortcut to copy selected cells?
Ctrl + C
Ctrl + X
Ctrl + A
Ctrl + V
How can you remove duplicates from a dataset?
Insert > Table > Remove Duplicates
Data > Remove Duplicates
Formulas > Remove Duplicates
Home > Clear > Remove Duplicates
Which of the following tools can be used to filter data?
Data > Filter
Review > Filter
Insert > Filter
Home > Filter
How do you create a chart in Excel?
Data > Chart
Insert > Chart
Home > Chart
Pivot > Chart
Which chart type is best for showing trends over time?
Line Chart
Pie Chart
Bar Chart
Scatter Plot
What is a PivotChart?
A chart created in Word
A chart linked to a PivotTable
A chart created in PowerPoint
A chart showing static data
Which chart type is used to compare parts of a whole?
Bar Chart
Scatter Plot
Pie Chart
Line Chart
What is the purpose of a trendline in a chart?
To add labels to the chart
To show the overall direction of the data
To change the color of the chart
To highlight individual data points
What does the PivotTable feature do?
Creates a chart
Summarizes large amounts of data
Filters data
Formats cells
How do you protect a worksheet from being edited?
Insert > Protect Sheet
Data > Protect Sheet
Review > Protect Sheet
Home > Protect Sheet
Which function calculates the payment for a loan based on constant payments and a constant interest rate?
PMT
RATE
FV
PV
What is conditional formatting used for?
To enter data
To apply different formats based on specific conditions
To change the font size
To create charts
How can you display formulas in the cells instead of the calculated results?
Review > Show Formulas
Data > Show Formulas
Formulas > Show Formulas
Home > Show Formulas
Which function would you use to find the smallest value in a range?
MAX
LOWER
MIN
SMALL
What does the SUMIF function do?
Adds all the cells in a range
Adds the cells specified by a given condition
Averages the cells specified by a condition
Counts the cells that meet a condition
How can you group rows in Excel?
Data > Group
Review > Group
Home > Group
Insert > Group
Which function returns the number of working days between two dates?
NETWORKDAYS
WORKDAYS
DAYS360
WEEKDAY
What tool can you use to forecast future values based on historical data?
Goal Seek
Scenario Manager
Forecast Sheet
Solver
How can you add a comment to a cell?
Review > New Comment
Insert > Comment
Data > Comment
Home > Comment
Which function returns the current date and time?
TIME
NOW
DATE
TODAY
How do you merge cells?
Home > Merge & Center
Insert > Merge & Center
Review > Merge & Center
Data > Merge
Which tool allows you to track changes in a worksheet?
Home > Track Changes
Data > Track Changes
Insert > Track Changes
Review > Track Changes
What is the keyboard shortcut to save a workbook?
Ctrl + O
Ctrl + W
Ctrl + S
Ctrl + P
Which function combines the text from multiple ranges and/or strings, but does not provide a delimiter?
CONCATENATE
JOIN
TEXTJOIN
CONCATINATE
What is the purpose of the MATCH function?
Counts the number of cells in a range
Looks for a value in a vertical column
Returns the relative position of an item in a range
Finds the average of a set of numbers
Which function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells?
INDEX
OFFSET
MATCH
VLOOKUP
How do you round a number to the nearest integer?
ROUND
CEILING
FLOOR
MROUND
Which function returns the serial number of the current date?
NOW
TIMESTAMP
TODAY
DATE
What does the INDEX function do?
Counts the number of cells in a range
Looks for a value in a vertical column
Counts the number of cells in a range
Returns the value of a cell at the intersection of a specified row and column
Which function returns the remainder after a number is divided by a divisor?
ROUND
MOD
DIVIDE
QUOTIENT
How can you restrict data entry in a cell to a specific list of values?
Insert > Data Validation
Review > Data Validation
Data > Data Validation
Home > Data Validation
What is the purpose of using data validation?
To format cells based on specific conditions
To control the type of data or the values that users enter into a cell
To create a chart
To summarize large amounts of data
What is the keyboard shortcut to open the Find and Replace dialog box?
Ctrl + G
Ctrl + H
Ctrl + F
Ctrl + R
Which keyboard shortcut applies bold formatting to selected text?
Ctrl + U
Ctrl + B
Ctrl + I
Ctrl + E
How do you apply a conditional format based on a cell's value?
Insert > Conditional Formatting
Review > Conditional Formatting
Data > Conditional Formatting
Home > Conditional Formatting
Which feature allows you to format cells according to certain rules?
Data Validation
Cell Styles
Conditional Formatting
AutoFormat
How can you create a template in Excel?
Insert > Save As > Excel Template
Data > Save As > Excel Template
File > Save As > Excel Template
Home > Save As > Excel Template
What is the purpose of using an Excel template?
To create a pre-designed workbook with specific formatting and formulas
To protect a worksheet from being edited
To create a chart
To enter data
Explain how the VLOOKUP function works in Excel. Provide a simple example of how it can be used.
What is conditional formatting in Excel? Describe a scenario where conditional formatting can help make data more understandable.
Discuss the purpose of using formulas in Excel. Provide 10 examples of common formulas and explain what they do.
Describe how you can sort and filter data in Excel.
a. How do you remove duplicates from a dataset?
b. How will you handle missing values in an excel workbook including numeric values?
