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
Text
B
Value
C
Labels
D
Formula
2) Which of the formulas is the correct way to calculate the value of A7 taken from the value of C12?
A
C12-A7
B
=A7-C12
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
External Refrences
B
Mixed References
C
Relative References
D
Absolute 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
External Reference
C
Named Range
D
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
Calling the Sheet
B
Worksheet Reference
C
Name Reference
D
Sheet Name
6) If you create a spreadsheet with a cell that contains =SUM(Income) What does the (Income) represent?
A
Names Manager
B
Scope
C
Named Range
D
External Reference
7) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Lines connect from the formula to the location
B
Arrows pointing from the formula to the location
C
Cell reference and cell location are circled
D
Cell reference and cell location are outlined in matching colors
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
Mixed
B
Absolute
C
Unconditional
D
Relative
9) Which formula divides C3 by C7?
A
C3/C7
B
=C7/C3
C
C7/C3
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+15
C
=$E$1+15
D
=E1:E3
11) What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
A
Copy method from Shortcut Menu
B
Copy using the Quick Access Toolbar
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?