Spreadsheet - Advanced Functions and Formulae
Quiz
•
Computers
•
10th - 11th Grade
•
Medium
Cadile Whittle
Used 96+ times
FREE Resource
Enhance your content in a minute
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A Lookup function is used to?
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
This function returns the number of cells that meet a condition set forth in a formula
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"
Count
Countif
If
Vlookup
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which function would display "Yes" if D13 is greater than 0?
=IF(D13>0, "Yes", "No")
=IF(D13<0, "Yes", "No")
=IF(D13>0: "Yes", "No")
=IF(D13<0: "Yes", "No")
5.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
You are creating a spreadsheet that contains Community Service Hours goals. Column A lists the number of community service hours. Based on the value in column A, column B indicates if the community service hours goal of 500 hrs. was met. Choose the formula that will calculate if the goal was achieved.
=IF(A1>=500, "Yes","No")
A. =IF(A1>=500,[Yes", "No"])
A. =IF(A1>=500,(Yes), (No))
A. =IF[A1>=500, Yes, No]
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The countif function uses two (2) arguments
False
True
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The first argument in the CountIF function is range
True
False
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
18 questions
Publisher Basics
Quiz
•
7th - 10th Grade
15 questions
Google Spreadsheet
Quiz
•
11th Grade
20 questions
Skill Competition Quiz 2024
Quiz
•
10th Grade - University
15 questions
Introducción Redes Tele1 IB
Quiz
•
10th Grade - University
20 questions
Processing- The CPU Quiz
Quiz
•
10th Grade - University
18 questions
The Rise of Intelligent Machines
Quiz
•
8th Grade - University
16 questions
Tips for Searching the Internet
Quiz
•
6th Grade - University
16 questions
Hour_of_Code
Quiz
•
5th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
