Excel Functions Quiz
Authored by mohd rostam undefined
Others
9th - 12th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to add all of its arguments that meet multiple criteria?
XLOOKUP
IFERROR
SUMIFS
XIRR
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to calculate the payment for a loan based on constant payments and a constant interest rate?
EOMONTH
SLOPE
XIRR
PMT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function finds the last day of the month after you add a specific number of months to a date?
XLOOKUP
EOMONTH
SEQUENCE
IFERROR
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is needed to find out the annual growth rate of an investment?
XLOOKUP
IFERROR
SLOPE
XIRR
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function combination can look up values in the whole table and is 2 Dimensional?
INDEX & MATCH
IFERROR
XLOOKUP
SEQUENCE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function allows you to generate a list of sequential numbers in an array?
IFERROR
XLOOKUP
EOMONTH
SEQUENCE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function calculates the value of an investment/company/project in today's terms?
XIRR
SLOPE
XNPV
PMTO
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
5 questions
Estructura interna del corazón
Quiz
•
10th Grade
10 questions
Exploring Cell Structure
Quiz
•
9th Grade
10 questions
Gearbox Maintenance Quiz
Quiz
•
12th Grade
10 questions
Exploring Cell Structure and Function
Quiz
•
10th Grade
10 questions
Understanding Functions
Quiz
•
9th Grade
10 questions
Understanding IT Terminology
Quiz
•
10th Grade
8 questions
Economics Chapter 20
Quiz
•
12th Grade
5 questions
Cell Structure
Quiz
•
9th 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
Discover more resources for Others
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
18 questions
SAT Prep: Ratios, Proportions, & Percents
Quiz
•
9th - 10th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade