NEW
Font size
WorksheetsExcel Post-Assessment 2
Total questions: 10
Worksheet time: 5mins
In cell C1, you type =A1+B1. What does this formula do?
It combines the text from cells A1 and B1.
It adds the values contained in cells A1 and B1.
It links cell C1 to cells A1 and B1.
It is an invalid formula and will return an error.
Which of the following is the correct use of the SUM function to add cells A1, A2, and A3?
=SUM(A1-A3)
=SUM(A1:A3)
=ADD(A1:A3)
=TOTAL(A1:A3)
What does the formula =AVERAGE(B2:B10) calculate?
The sum of cells B2 through B10 divided by 9.
The middle value in the range B2:B10.
The sum of cells B2 through B10.
The largest value in the range B2:B10.
What is the result of the formula =10 + 2 * 5 in Excel?
60
20
100
35
You have a formula in cell C1: =A1*B1. If you copy this formula from C1 and paste it into cell C2, what will the new formula be?
=A1*B1
=A2*B2
=$A$1*$B$1
=A1*B2
Which of these is the correct structure of an IF function?
=IF(condition, value_if_false, value_if_true)
=IF(condition, value_if_true, value_if_false)
=IF(value_if_true, condition, value_if_false)
=IF(value_if_true, value_if_false, condition)
The primary purpose of the VLOOKUP function is to:
Arrange data vertically in a column.
Look for a value in the leftmost column of a table and return a value from the same row in a specified column.
Add up values that meet multiple criteria.
Combine text from two or more cells.
In the formula =VLOOKUP("Apple", A2:C100, 3, FALSE), what does the number 3 represent?
The number of rows to search.
The lookup value is "3".
The column index number from which to return the value (the third column in the range A: C).
An instruction to find the third instance of "Apple".
Unlike VLOOKUP, what is a key advantage of the newer XLOOKUP function?
It can only look up values in the first column of a table.
It defaults to an approximate match.
It can look to the left and right of the lookup column without rearranging data.
It requires the data to be sorted alphabetically.
What is the main purpose of the IFERROR function?
To check if a cell contains an error.
To return a custom result when a formula generates an error, and the standard result otherwise.
To highlight all errors in a worksheet in red.
To correct a formula error automatically.
