Spreadsheets Quiz 1

Quiz
•
Computers
•
6th Grade
•
Medium
+2
Standards-aligned
Michael Keeton
Used 34+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Spreadsheets - Lesson 3

Quiz
•
6th - 9th Grade
15 questions
ÔN TẬP TIN HỌC 7 TUẦN 7 25-30/10/2021

Quiz
•
6th - 9th Grade
14 questions
Excel Functions Quiz

Quiz
•
6th Grade
20 questions
Computer 6 Lesson 3 MS Excel

Quiz
•
6th Grade
20 questions
Google Sheets Review

Quiz
•
KG - University
15 questions
Advanced Functions and Formulas

Quiz
•
6th - 8th Grade
18 questions
Google Sheets

Quiz
•
2nd - 6th Grade
20 questions
Excel

Quiz
•
5th - 7th Grade
Popular Resources on Wayground
18 questions
Writing Launch Day 1

Lesson
•
3rd Grade
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
40 questions
Algebra Review Topics

Quiz
•
9th - 12th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
19 questions
Handbook Overview

Lesson
•
9th - 12th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
Discover more resources for Computers
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
30 questions
Teacher Facts

Quiz
•
6th Grade
24 questions
Flinn Lab Safety Quiz

Quiz
•
5th - 8th Grade
20 questions
Adding and Subtracting Integers

Quiz
•
6th Grade
10 questions
Essential Lab Safety Practices

Interactive video
•
6th - 10th Grade