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?
Similar Resources on Wayground
19 questions
Edublock input and ouput
Quiz
•
6th Grade
15 questions
KS3 Y8 Kodu Quiz
Quiz
•
5th - 8th Grade
15 questions
Computer Lab Rules
Quiz
•
KG - 8th Grade
20 questions
TEST -EXCEL 1
Quiz
•
1st - 10th Grade
13 questions
Five Nights At Freddy's: Security Breach Quiz
Quiz
•
KG - Professional Dev...
15 questions
IT General Knowledge Quiz!
Quiz
•
5th - 6th Grade
13 questions
Computational Thinking
Quiz
•
6th Grade
16 questions
Revision MIT App Inventor after lvl3 clouds
Quiz
•
5th - 12th 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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
