Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Lesson 4
Test Description: This is my first test.
Instructions: Answer all questions to get your test result.
1) If you type =Sum(B7+D7) into a cell, which of the following best describes what you have entered?
A
Labels
B
Value
C
Text
D
Formula
2) Which of the formulas is the correct way to calculate the value of A7 taken from the value of C12?
A
=A7-C12
B
C12-A7
C
A7-C12
D
=C12-A7
3) If you copy a formula from one cell into another, which type of reference will automatically adjust the cell references based on the new location?
A
Relative References
B
Absolute References
C
External Refrences
D
Mixed References
4) If you have a cell in your spreadsheet that contains a formula such as =(BudgetUS!B3), what does the BudgetUS represent?
A
Scope
B
Range
C
External Reference
D
Named Range
5) What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
A
Name Reference
B
Calling the Sheet
C
Sheet Name
D
Worksheet Reference
6) If you create a spreadsheet with a cell that contains =SUM(Income) What does the (Income) represent?
A
Scope
B
Named Range
C
Names Manager
D
External Reference
7) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Cell reference and cell location are outlined in matching colors
B
Lines connect from the formula to the location
C
Arrows pointing from the formula to the location
D
Cell reference and cell location are circled
8) What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
A
Relative
B
Unconditional
C
Mixed
D
Absolute
9) Which formula divides C3 by C7?
A
C7/C3
B
=C7/C3
C
=C3/C7
D
C3/C7
10) You need to create a formula that does not change when it is copied to cell E2. Which formula should you create?
A
=1$E$+15
B
=E1:E3
C
=E1+15
D
=$E$1+15
11) What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
A
Copy using the Quick Access Toolbar
B
Copy method from Shortcut Menu
C
Copy using the Fill Handle
D
Copy from the Home Ribbon
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?