Spreadsheets Quiz 1
Authored by Michael Keeton
Computers
6th Grade
TA covered
Used 36+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is one reason to use cell references in a formula?
The answer will change if the numbers in referenced cells change.
You need cell references to use functions.
Only formulas with cell references can be copied and pasted.
You need cell references to use operators.
Tags
TA.6.L.ii
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of these adds two referenced cells?
=B3+C3
=B+C+3+3
=(B3,C3)
=B+C
Tags
TA.6.L.ii
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the operator used to multiply?
@
^
/
*
Tags
TA.6.L.ii
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you type =1+1 in the formula bar, what will show in the cell after you hit Enter or Return?
=1+1
2
1+1
=2
Tags
TA.6.L.ii
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cell C1 has =A1+B1 in it. If you copy and paste cell C1 into cell C2, what will show in the formula bar for C2?
=A1+B1
=C1+C2
=A2+B2
=A1+B1+A2+B2
Tags
TA.6.L.ii
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What would you type to find the sum of the cells D4 through D6?
=SUM(D4/D6)
=SUM(D4,D6)
=SUM(D4:D6)
=SUM(D4-D6)
Tags
TA.6.L.ii
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you copy a formula from one cell into a large group of cells?
Select the group of cells and type the formula into the formula bar.
Retype the formula into each cell.
Copy the formula, select the group of cells, and paste.
Select the group of cells and hit Enter or Return.
Tags
TA.6.L.ii
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?
