
excel absolute reference
Quiz
•
Mathematics
•
4th Grade - University
•
Practice Problem
•
Medium
Soraya elsayed
Used 12+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
By default, all cell references are _________ references.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
It is always best to use the exact value instead of the cell reference when using formulas.
TRUE
FALSE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You can press the F4 key to add the $'s to an absolute reference.
TRUE
FALSE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Unlike _________ references, _________ references do not change when copied or filled.
6.
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.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A_________ is a built in mathematical formula included in excel.
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
COMPLEX NUMBERS 2
Quiz
•
9th Grade
14 questions
11 - Graphs of Trigonometric Functions
Quiz
•
11th Grade
10 questions
12.Symmetry Quiz
Quiz
•
7th Grade
15 questions
Year 10 Solving Equations
Quiz
•
9th - 11th Grade
10 questions
Class Assignment - Unit Conversions - English and Metric Systems
Quiz
•
5th - 6th Grade
10 questions
Tree and Planar Graph
Quiz
•
University
10 questions
Estimation
Quiz
•
5th Grade
15 questions
6INT Math Spring Final Review
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Mathematics
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Exponents
Quiz
•
6th Grade
22 questions
distributive property
Quiz
•
7th Grade
10 questions
Multiplying Fractions
Quiz
•
5th Grade
15 questions
Distributive Property & Review
Quiz
•
6th Grade
77 questions
Mixed Multiplication and Division Facts
Quiz
•
4th Grade
20 questions
Writing Algebraic Expressions
Quiz
•
6th Grade
