NEW
Font size
WorksheetsExcel functions and formulas assessment
Total questions: 25
Worksheet time: 13mins
Every formula starts with
=
+
$
!
Choose the answer that shows a RELATIVE cell reference
=C4
=($C$1*.5)+$D$1
=$C$4
=4^3
Choose the answer that shows a formula with an ABSOLUTE cell reference
=B1*C4
=B1*$C$4
=A3
=4^3
A RELATIVE reference in Excel means that the cell reference does not change when the formula is copied
True
False
An ABSOLUTE cell reference in Excel means that the cell reference does change when the formula is copied.
True
False
Choose the answer that references a cell
Red Blood
4*12
Mitochondria
C4 or $C$4
Which answer references a cell range
MAX
MIN
=SUMIF(A1:A13,"Brass",C1:C13)
SUM
Excel can find the average of a range of numbers by using the _________ function.
AVERAGE
MIN
MAX
SUM
The _______ function counts the numbers in a range of cells.
SUM
COUNT
AVERAGE
COUNTIF
The _______ function joins multiple items using a delimiter (like a space, period, or comma). The first argument defines the delimiter, the second determines if blank cells will be ignored, and the remaining arguments are the cells that have the data that will be concatenated.
CONCATENATE
TEXTJOIN
MID
LEFT
The _______ function joins multiple items the arguments are the cells that have the data that will be concatenated.
CONCATENATE
TEXTJOIN
MID
PROPER
Choose the best description of the IF function
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false
Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false
Returns a value from a list using a given position
Choose the correct format of the IF function:
=IF(logical test,value if true,value if false)
=IF(value if true,value if false,logical test)
=IF(logical test,value if false,value if true)
=IF(value if false,value if true,logical test)
Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"
IF(B4>200;"High";"Low")
=IF(B4>200,"High","Low")
=IF(B4<200,"High","Low")
=IF(B4>200"High","")
Which of these comparison operations means "Less than or equal to"?
<
<>
<=
$
In this IF function example: =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?
Nothing would show
No
maybe
Yes
The arrangement of data in Z to A will arrange the data in __________ order.
Ascending
Descending
The Sort & Filter option is present under which tab of Microsoft Excel?
Insert Tab
Home tab
Data tab
Format tab
The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .
Filter
Custom Sorting
sort
Removing Filter
State true or false.
You can sort data in only one field.
True
Don`t know
False
Not able to answer
Which is the correct formula for VLOOKUP?
VLOOKUP(cell data to find, sub table, column to return, fuzzy match)
=VLOOKUP(cell data to find, sub table, column to return, fuzzy match)
=VLOOKUP(sub table, cell data to find, column to return, fuzzy match)
=VLOOKUP(cell data to return, sub table, column to find, fuzzy match)
How would I get the total for a range of values?
sumif
countif
vlookup
data validation
how would I find a value for a cell based on the contents of another cell
sumif
countif
vlookup
data validation
how would I ensure the data in a manually entered cell is what I expect
countif
sumif
vlookup
data validation
Where are the graphs?
On the home tab
On the data tab
on the insert tab
on the developer tab
