Excel Chapter 4 Test
Authored by Cheryl Albright
Computers
9th - 12th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Calling the Sheet
Name reference
Sheet Name
Worksheet Reference
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jennifer is calculating her GPA. If
she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?
Values
Formulas
Labels
Functions
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Joshua created a budget workbook that contains the formula =(Summary!B3). 'Summary' is an example of a/an:
named range.
external reference.
names manager
scope.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
named range.
external reference.
names manager
scope
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
=D4+F4
=D4*F4
=D4-F4
=D4 x F4
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=$B$1+25
=B1+25
=1$B$+25
=B1:B3
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Absolute reference
Certain reference
Variable reference
Relative reference
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
