Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.03-1.05 (Part 2)
Test Description: 1.03 - 1.05
Instructions: Answer all questions to get your test result.
1) Where can you find the Insert Function button in Microsoft Excel?
A
Formula bar
B
Quick Access Toolbar
C
Status bar
D
Shortcut menu
2) 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
Weekday
D
CurrentDate
3) Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
A
Exit
B
Save As
C
Close
D
Save
4) What is a prewritten formula that is built into Microsoft Excel called?
A
Function
B
Procedure
C
Utility
D
Statement
5) What function adds all of the numbers in a range of cells?
A
Sum
B
Compute
C
Calculate
D
Add
6) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
A
MAX
B
AVERAGE
C
SUM
D
MIN
7) Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?
A
=SUM(B1:B39)
B
=$B$1+25
C
=B1+25
D
=B1:B39
8) Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
A
Template
B
Boilerplate
C
Smart Sheet
D
Form
9) John's workbooks includes 3 worksheets. Which option should he choose to print them?
A
Print Selection
B
Fit to One Page
C
Print Entire Workbook
D
Print Active Sheet
10) What area contains the command used to customize the print options in Microsoft Excel?
A
File Tab
B
Quick Access Toolbar
C
Page Layout Ribbon
D
Home Ribbon
11) Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a(n):
A
scope.
B
external reference.
C
names manager.
D
named range.
12) Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
A
names manager.
B
scope.
C
named range.
D
external reference.
13) 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
*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?