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?
Similar Resources on Wayground
10 questions
R082 Book Cover Assets planning
Quiz
•
7th - 12th Grade
15 questions
Uji Pemahaman Formula Excel
Quiz
•
9th Grade - University
10 questions
Microsoft Word 2019 - Unit 1
Quiz
•
10th Grade
16 questions
Conditions
Quiz
•
8th - 10th Grade
15 questions
1.1.1 Structure of a Processor
Quiz
•
10th - 12th Grade
10 questions
Arithmetic Operators, Casting, Concatenation
Quiz
•
9th - 12th Grade
16 questions
LA3.C3: Variables
Quiz
•
9th Grade - University
11 questions
Creative iMedia: Strengths, Weaknesses and Improvements
Quiz
•
10th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
