Excel prior learning y8
Authored by Conor Frater
Computers
6th Grade
Used 6+ 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
What is the function used to add up a range of cells in Excel?
=SUM
=COMBINE
=TOTAL
=ADD
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used for multiplication in Excel formulas?
!
÷
x
*
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tool in Excel is used to format cells as currency?
Currency Tool
Format Cells
Cell Formatter
Excel Format
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to sum the values in cells A1 to A10 in Excel?
=ADD(A1:A10)
=TOTAL(A1:A10)
=SUM(A1,A10)
=SUM(A1:A10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used for division in Excel formulas?
%
/
x
-
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to divide cell A1 from B1?
=B1/A1
=A1/B1
=A1%B1
=B1\A1
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the total sales amount in cells B1 to B10 in Excel?
=AVERAGE(B1:B10)
=COUNT(B1:B10)
=MAX(B1:B10)
=SUM(B1:B10)
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?
