
Excel Lesson 5 Knowledge Assessment
Authored by Sophia Patterson
Computers
9th - 12th Grade
Used 13+ times

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?
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The arguments of a function are contained within which of the following?
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When using the SUBTOTAL function, what is the function number for the SUM function?
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function do you use?
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is not a required argument for the PMT function?
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to calculate the number of non-blank cells in your worksheet. Which function do you use?
7.
MULTIPLE CHOICE QUESTION
30 sec • 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?
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
Quiz 5 - Excel
Quiz
•
11th Grade
13 questions
Stepwise Refinement
Quiz
•
11th - 12th Grade
11 questions
Threats to Data
Quiz
•
9th - 12th Grade
11 questions
HEALTH AND SAFETY 9
Quiz
•
7th - 9th Grade
15 questions
1.1.1 The structure and function of the processor
Quiz
•
11th Grade - University
10 questions
Basic Parts of Speech EPS
Quiz
•
9th - 10th Grade
10 questions
COMPUTER PROGRAMMING Q2_FLOWCHART (2 points each)
Quiz
•
11th - 12th Grade
9 questions
OCR GCSE CS - 2.1 ERL sorts and searches
Quiz
•
10th - 11th 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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade