
Excel
Quiz
•
Computers
•
9th Grade
•
Medium
Marvin Mangali
Used 10+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used for addition in Excel formulas?
/
*
+
-
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If cell A1 contains 10 and cell B1 contains 5, what formula would you use to subtract B1 from A1?
=A1-B1
=B1-A1
=A1+B1
=A1*B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you write a formula to multiply the values in cells C1 and D1?
=C1+D1
=C1/D1
=C1*D1
=C1-D1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula is used to divide the value in cell E1 by the value in cell F1?
=E1/F1
=E1*F1
=E1+F1
=E1-F1
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the largest number in a range of cells?
=MAX(range)
=MIN(range)
=SUM(range)
=LARGE(range)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the formula =MIN(A1:A10) return?
The largest value in the range
The average value of the range A1 to A10.
The smallest value in the range A1 to A10.
The total sum of the range A1 to A10.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to calculate the average of numbers in cells A1 through A5, which formula should you use?
=AVERAGE(A1:A5)
=SUM(A1:A5)/COUNT(A1:A5)
Both a and b
None of the above
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
10 questions
Excellente
Quiz
•
1st - 10th Grade
6 questions
Basic Spreadsheets Check Point
Quiz
•
7th - 9th Grade
13 questions
Jaringan komputer
Quiz
•
7th - 9th Grade
15 questions
KIỂM TRA CUỐI HỌC KÌ 1 LỚP 8
Quiz
•
9th Grade
12 questions
Excel MOAC Lesson 06: Formatting Cells & Ranges (Part 1)
Quiz
•
9th - 12th Grade
7 questions
Yr 7 Spreadsheets
Quiz
•
7th - 9th Grade
15 questions
Khám Phá Hàm Countif Trong Excel
Quiz
•
9th Grade
15 questions
Google Sheet Chapter 4
Quiz
•
9th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
30 questions
Computer Terminology Exercise #1 ( Fill Ins)
Quiz
•
9th Grade
15 questions
MLA Formatting
Quiz
•
9th Grade
20 questions
Typing Practice
Quiz
•
7th - 12th Grade
14 questions
Inputs and Outputs: Computer Science Intro
Lesson
•
5th - 9th Grade
20 questions
Google Sheets Quiz
Quiz
•
9th Grade