Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.03-1.05(Part 1)
Test Description: 1.03 - 1.05
Instructions: Answer all questions to get your test result.
1) Jim would like to print only the cell range A1:F20. What page setup option should he change?
A
Page Break
B
Print Titles
C
Orientation
D
Print Area
2) 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
D
Name reference
3) 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
Arrows pointing from the formula to the location
C
Lines connect from the formula to the location
D
Cell reference and cell location are outlined in matching colors
4) Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
A
=B4 x C4
B
=B4-C4
C
=B4+C4
D
=B4*C4
5) 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
functions
C
formulas
D
labels
6) 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
D
Unconditional
7) Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
A
scope.
B
names manager.
C
external reference.
D
named range.
8) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
Certain reference
B
Variable reference
C
Absolute reference
D
Relative reference
9) 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
10) Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
A
=B1+25
B
=B1:B3
C
=1$B$+25
D
=$B$1+25
11) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
A
MAX
B
AVERAGE
C
SUM
D
MIN
12) Steve would like to print only the worksheet he is currently working on. What print option should he choose?
A
Active Sheets
B
Quick Print
C
Print Area
D
Entire Workbook
13) Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
A
Calculate
B
Add
C
AutoSum
D
Total
14) Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
A
Function Library
B
Formula Auditing
C
Defined Names
D
Calculation
15) Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
A
Defined Names
B
Calculation
C
Function Library
D
Formula Auditing
16) Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
A
Defined Names
B
Calculation
C
Function Library
D
Formula Auditing
17) Angie is calculating her average sales for the past four months. If she uses =AVERAGE(B1:B4), this is an example of which type of entry?
A
labels
B
formulas
C
functions
D
values
18) Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
A
TODAY
B
COUNT
C
NOW
D
IF
19) Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
A
COUNT
B
IF
C
NOW
D
TODAY
20) Which of the following are valid Microsoft Excel functions?
A
WEEKDAY, MAX, and CLOSE
B
AVERAGE, MAX, and NUM
C
AVERAGE, MAX, and MIN
D
MAX, MIN, and WEEK
*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?