Absolute & Relative Reference in Excel 2016

Quiz
•
Computers
•
12th Grade
•
Medium

Nixon Lopez
Used 2+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
During a math class, Elijah is learning about different types of cell references in spreadsheets. What type of cell reference changes when copied to another cell?
Absolute reference
Mixed reference
Relative reference
Fixed reference
Answer explanation
A relative reference changes when copied to another cell because it adjusts based on the position of the new cell. In contrast, absolute references remain constant, while mixed references have both fixed and variable components.
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Avery is trying to create a budget spreadsheet. How is an absolute reference designated in a formula?
With a dollar sign ($)
With an ampersand sign (&)
With a percentage sign (%)
With an exclamation mark (!)
Answer explanation
An absolute reference in a formula is designated with a dollar sign ($). This indicates that the row and/or column referenced will not change when the formula is copied to another cell.
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
During a math class, Benjamin is trying to understand what happens to relative references when copying a formula in his spreadsheet.
They remain constant
They are removed
They change according to the relative position
They become absolute references
Answer explanation
Relative references in a formula adjust based on their position when copied to another cell. This means they change according to the relative position, allowing for dynamic calculations across different cells.
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
During a class project, Hannah is working on a spreadsheet. Which key can she press to toggle between relative and absolute references?
F6
F4
F2
F5
Answer explanation
Pressing F4 toggles between relative and absolute references in spreadsheet applications like Excel. This allows users to quickly switch how cell references behave in formulas.
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Evelyn is learning about different types of references in her programming class. What type of reference is used least frequently?
Mixed reference
Absolute reference
Dynamic reference
Relative reference
Answer explanation
Mixed reference is used least frequently because it combines both absolute and relative references, making it more complex and less intuitive for users compared to the more straightforward absolute and relative references.
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Anika is trying to reference a cell from another sheet in her Excel workbook. How does she do it?
With an equal sign (=)
With a number sign (#)
With an exclamation mark (!)
With a plus sign (+)
Answer explanation
To reference a cell from another sheet in Excel, you use an exclamation mark (!). For example, 'Sheet2!A1' refers to cell A1 in Sheet2. The other symbols do not serve this purpose.
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What error appears if Samuel enters the name of a sheet incorrectly?
#VALUE!
#REF!
#NAME?
#DIV/0!
Answer explanation
The error #NAME? appears when a formula refers to a name that Excel does not recognize, such as an incorrectly entered sheet name. This indicates that the name is not valid or does not exist.
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Excel Formulas/Functions

Quiz
•
9th - 12th Grade
15 questions
DIT Excel 2016 Review

Quiz
•
8th - 12th Grade
20 questions
Google Sheets: Functions and Behavior Check-Up

Quiz
•
12th Grade - University
20 questions
Aplikasi Pengolah Angka

Quiz
•
12th Grade - University
10 questions
Google Sheets Basics

Quiz
•
12th Grade
20 questions
Excel Spreadsheet Fun (2nd)

Quiz
•
10th - 12th Grade
10 questions
Microsoft Excel Final

Quiz
•
9th - 12th Grade
20 questions
Excel - Formulas, Functions & Formatting

Quiz
•
10th - 12th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade