
Excel Quiz 2
Authored by Paige Russell
Computers
11th Grade
Used 21+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
39 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would you type in the Criteria box? Use the COUNTIF function to count the number of times that the values in cell rand B6:B15 "exceed 5000".
<5000
>5000
=5000
/5000
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would you type in the Range box? Insert a COUNTIF formula to count the data in cell range D43:D51 that is greater than 0.
D43:D51
0
>0
D43:D59
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the concatenate function do?
allows you to combine text from different cells into one cell.
allows you to delete text from different cells into one cell.
used for counting cells within a specified range that meet a certain criterion, or condition.
perform a logical test and return one value for a TRUE result, and another for a FALSE result.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What do you put in the Logical Test Box? Use the IF function to show Close if the SUM of C9:D9 is greater than 22500 and Not Close if it is less than or equal to 22500.
SUM(C9:D9)>22500
Close
Not Close
SUM(C9:D9)<22500
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the formulas tab, what button do you click on to insert an IF formula?
insert function
autosum
define name
more funtions
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would you type in the Criteria box? In cell G5 create an AVERAGEIF formula to calculate the average Amount if the Truck Type if General.
General
Amount
Truck Type
G5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What do you type in the Text box? Create a formula in cell C2 of the Trucks worksheet that returns the first three letters of the Truck column.
A2
3
Truck
C2
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
42 questions
CompSci District Test Prep Form I
Quiz
•
9th - 12th Grade
44 questions
AP Computer Science Principles Units 1, 2 & 3
Quiz
•
10th - 12th Grade
35 questions
EmTech Q1 Reviewer
Quiz
•
11th Grade
35 questions
Computer Parts and Accessories
Quiz
•
7th Grade - Professio...
36 questions
User Interface
Quiz
•
10th - 11th Grade
40 questions
ข้อสอบปลายภาค วิชา ออกแบบและเทคโนโลยี
Quiz
•
11th Grade
39 questions
Media and Information Literacy Quiz
Quiz
•
11th Grade
35 questions
Esports & Speedrunning NJ
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade