Excel Functions and Formatting Quiz
Authored by Andrew Lucas
Computers
10th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNTIF function do in Excel?
Counts the number of cells that contain numbers
Counts the number of cells that meet a specified condition
Counts the total number of cells in a range
Counts the number of empty cells
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a correct syntax for the COUNTIF function?
`=COUNTIF(range, criteria)`
`=COUNTIF(criteria, range)`
`=COUNTIF(range)`
`=COUNTIF(criteria)`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of conditional formatting in Excel?
To format cells based on a condition
To count the number of cells in a range
To look up values in a table
To sum values in a range
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a feature of conditional formatting?
Highlighting cells with specific text
Changing font colour based on cell value
Automatically sorting data
Creating data bars within cells
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the LOOKUP function do in Excel?
Finds a value in a table based on a row and column number
Looks up a value in a single row or column and returns a corresponding value
Counts the number of cells that contain text
Formats cells based on a condition
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the COUNT function do in Excel?
Counts the number of cells that contain numbers
Counts the number of cells that contain text
Counts the number of empty cells
Counts the number of cells that meet a specified condition
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a correct syntax for the COUNT function?
`=COUNT(range)`
`=COUNT(range, criteria)`
`=COUNT(criteria)`
`=COUNT()`
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
