
Excel Reverences Revision
Authored by Yousra Abdelhamed
Computers
8th - 12th Grade
Used 7+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
By default, all cell references are _________ references.
Absolute
Relative
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
_________ references do not change when copied or filled.
Absolute
Relative
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
#
&
$
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
Absolute
Relative
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you don't want a cell reference to change when copied to other cells, use _________ references
Absolute
Relative
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want a cell reference to change when copied to other cells, use _________ references
Absolute
Relative
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The most common way to identify a cell reference is
$D2
$D$2
D$2
D2$
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
15 questions
Chapter 8 by PD
Quiz
•
10th Grade
10 questions
Table in PowerPoint
Quiz
•
9th Grade
10 questions
Animasi 2D dan 3D Ulangan Harian BAB 1
Quiz
•
11th Grade
15 questions
ИТ
Quiz
•
8th Grade
10 questions
Augmented Reality
Quiz
•
12th Grade
12 questions
Wee Word Intro
Quiz
•
7th - 12th Grade
15 questions
Text Boxes, Images, and Shapes
Quiz
•
8th - 12th Grade
12 questions
Spreadsheet
Quiz
•
5th - 11th 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