Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.04
Test Description: Excel 2016
Instructions: Answer all questions to get your test result.
1) Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
A
=D4-F4
B
=D4 x F4
C
=D4*F4
D
=D4+F4
2) Jennifer is calculating her GPA. If she uses '=(A1+A2+A3+A4)/4', this is an example of which type of entry?
A
Labels
B
Functions
C
Values
D
Formulas
3) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Arrows pointing from the formula to the location
B
Cell reference and cell location are outlined in matching colors
C
Lines connect from the formula to the location
D
Cell reference and cell location are circled
4) 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
D
=B4+C4
5) 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
Relative
D
Unconditional
6) 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
=B1:B3
C
=$B$1+25
D
=B1+25
7) 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
8) Joshua created a budget workbook that contains the formula = (Summary!B3). 'Summary' is an example of a/an:
A
names manager.
B
external reference.
C
named range.
D
scope.
9) Tyler created a monthly sales workbook that contains the formula = (January!B3). 'January' is an example of a/an:
A
named range.
B
names manager.
C
external reference.
D
scope.
10) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
Absolute reference
B
Relative reference
C
Certain reference
D
Variable reference
11) What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
A
Sheet Name
B
Calling the Sheet
C
Name reference
D
Worksheet Reference
12) Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:
A
names manager.
B
scope.
C
named range.
D
external reference.
*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?