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
20 questions
PRETES TIK HARDWARE DAN SOFTWARE
Quiz
•
1st - 9th Grade
17 questions
Interland - Reality River
Quiz
•
3rd - 6th Grade
18 questions
history of video games
Quiz
•
6th Grade
20 questions
Productivity Programs
Quiz
•
6th - 8th Grade
20 questions
BÀI 6 ĐỊNH DẠNG TRANG TÍNH
Quiz
•
1st - 12th Grade
20 questions
Access-Basic
Quiz
•
6th - 9th Grade
20 questions
MICROSOFT EXCEL 2016
Quiz
•
6th Grade
15 questions
Cembridje Informatika 6-klass II-sherek
Quiz
•
6th 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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
