Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.04
Test Description: Using Basic Formulas
Instructions: Answer all questions to get your test result.
1) Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry
A
values
B
labels
C
formulas
2) Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
A
=B4+C4
B
=B4-C4
C
=B4/C4
3) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
Certain reference
B
absolute reference
C
Relative reference
4) Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
A
scope.
B
named range.
C
external reference
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
Sheet Name
B
Worksheet Reference
C
Calling the Sheet
6) Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a(n):
A
named range
B
external reference.
C
names manager.
7) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Cell reference and cell location are circled
B
Lines connect from the formula to the location
C
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
relative
B
mixed
C
Absolute
9) Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
A
=B4*C4
B
=B4+C4
C
=B4-C4
10) Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
A
=1$B$+25
B
=$B$1+25
C
=B1+25
11) Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
A
named range.
B
external reference.
C
scope.
12) What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
A
Copy using the Fill Handle
B
Copy using the Quick Access Toolbar
C
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?