
Microsoft Excel Unit 5
Authored by Thomas Martinez
Computers
9th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?
AVERAGE
AutoSum
COUNTA
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The arguments of a function are contained within which of the following?
brackets
asterisks
commas
parentheses
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to calculate the number of nonblank cells in your worksheet. Which function
do you use?
SUM
COUNT
COUNTA
MAX
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
The COUNT and MIN functions are examples of which category of functions?
text
statistical
financial
logical
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to sum multiple noncontiguous cell ranges that are named. Which of the following is best to use?
AutoSum
SUBTOTAL
MAX
MIN
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
You want to create a formula that calculates the number of years you have lived. You were born in 1991. Which of the following formulas is correct?
=YEAR(TODAY())-1991
=YEAR(TODAY())+1991
=YEAR(COUNT())-1991
=YEAR(COUNT())+1991
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
In the PMT function, the Nper argument is the total number of payments for the loan.
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
10 questions
Youtubers Charlie.C-J
Quiz
•
3rd - 9th Grade
10 questions
4 การใช้เทคโนโลยีสารสนเทศอย่างปลอดภัย และนำผลงานมาใช้ ม.3
Quiz
•
9th Grade
8 questions
Basic computer
Quiz
•
9th - 12th Grade
10 questions
Visual Basic 2010
Quiz
•
8th Grade - University
10 questions
สอบปลายภาคเรียน2/64 วิทยาการคำนวณ
Quiz
•
9th Grade
9 questions
IT related jobs
Quiz
•
9th Grade
10 questions
S2 Subject Choice Quiz
Quiz
•
8th - 10th Grade
10 questions
Contact Center Sevices
Quiz
•
7th - 10th 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