Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #10
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Which Excel term, denoted with square brackets, can be found in the header row of a table and refers to the set of all cells that comprise the named column in the table?
A
FieldName
B
constants
C
absolute cell reference
D
TableName
2) Which symbol refers to a field name in a table that has already been named?
A
#
B
=
C
\
3) Which Excel term refers to a selection of cells?
A
group
B
range
C
name box
D
table
4) Which Excel feature keeps track of defined ranges and cell addresses?
A
Name Manager
B
Content Finder
C
Table Index
D
Group Locator
5) Doug wants to know how many gadgets he would have to sell to make $1,000,0000. Which Excel tool will help Doug find the answer?
A
Scenario Manager
B
Existing Connections
C
Goal Seek
D
Data Validation
6) PMT, PV, and FV are functions found in which Function Library category?
A
Statistical
B
Logical
C
Financial
D
Math and Trig
7) Kash is working with a large, complex worksheet and would like to to see what is going on in different cells in different parts of the workbook. What built-in tool would Kash use to make monitoring various cell values much simpler?
A
Evaluate Formula
B
Watch Window
C
Consolidating Data
D
Error Checking
8) Perry is using multiple worksheets and would like to total the numbers into one summary worksheet. Which built-in Excel tool should Perry use to accomplish his goal quickly?
A
Error Checking
B
Consolidate Data
C
Evaluate Formula
D
Watch Window
9) Mrs. Perry is troubleshooting formulas and functions in her Excel workbook. Which feature would she use to check for common mistakes in formulas?
A
Error Checking
B
Evaluate Errors
C
Watch Window
D
Consolidate Data
10) Michelle is trying to correct a formula error in cell B7. Which command will help her identify the cells that affect the value of B7?
A
Error Checking
B
Trace Dependents
C
Trace Precedents
D
Evaluate Formula
11) Which financial function allows Robyn to determine the amount she must pay each month on her car loan?
A
PMT
B
NPER
C
RATE
D
PV
12) Michelle is trying to review all formulas in her worksheet for accuracy. If the active cell is A2, which command will help identify the cells that are affected by A2?
A
Error Checking
B
Trace Precedents
C
Trace Dependents
D
Evaluate Formula
13) Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?
A
table_array
B
array_table
C
range_lookup
D
lookup_value
14) An Excel formula that is placed within another formula is referred to as:
A
name ranged
B
nested
C
named
D
consolidated
15) Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
A
DATE
B
TODAY
C
CURRENTDATE
D
WEEKDAY
*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?