NEW
Font size
WorksheetsSpreadsheet (IF,Validation rules,Data types,Absolute,Filter)
Total questions: 22
Worksheet time: 16mins
If you copy the formula =$B38 into another cell, the result will be:
The column part will remain the same
The row part will remain the same
Both the column and row will remain the same
Both will change
What function offers you the possibility to view different results depending on the entered condition?
=if()
=sumif()
=sum()
=TRUEFALSE()
When creating an IF function, a ____ separates the logical test from the value if true/false.
colon
semicolon
comma
dash
What does data validation allow you to do?
all of these answers
restrict or limit data entry to your specifications (i.e. only positive numbers, maximum of 10 characters, etc.)
check the accuracy of your unique Excel worksheet functions
lock cells to prevent others from editing them
What is the advantage of using data validation?
It takes longer to complete the spreadsheet.
It improves the accuracy of our data.
It means that more mistakes can be made.
The correct answer may have been entered.
Changing the appearance of a cell based on a rule is called?
Conditional Formatting
Data Validation
User Input
Sorting
A small red triangle in the top-right corner of the cell means that the cell contains ____.
an error
a formula
a red triangle
a comment
=IF([@Roses]>=[@Daisies],"Roses","Daisies")
In the formula above, what will be displayed if the Roses are greater than Daisies?
greater than
Daisies
Roses
less than
A small green triangle in the top-left corner of the cells (see image below), means that the cells may contain ____.
an error
a formula
a green triangle
a comment
Merging cells
moves them over one cell
combines multiple cells into one
adds a cell in the middle of a row
adds the cell contents
