Digital Literacy Unit 3 Common Assessment (Mid-term Exam)
Authored by John Adams
Business
9th - 10th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula gets the biggest value of a range of cells?
MAX
MIN
LARGE
SUM
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which symbol must all formula begin with?
=
+
(
@
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following formulas is not entered correctly?
=10+50
=B7+B8
=B7+14
10+50
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formulas will Excel not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*0.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Columns go...
Across
Down
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?
