# Excel 1.03-1.05 (Part 2) Question Preview (ID: 38976)

### 1.03 - 1.05.[print questions] Answers? Play games to get them!

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.
d) scope.

Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
a) named range.
b) external reference.
c) names manager.
d) scope.

What area contains the command used to customize the print options in Microsoft Excel?
a) Home Ribbon
b) Page Layout Ribbon
d) File Tab

John's workbooks includes 3 worksheets. Which option should he choose to print them?
a) Print Selection
b) Print Active Sheet
c) Print Entire Workbook
d) Fit to One Page

Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
a) Form
b) Boilerplate
c) Smart Sheet
d) Template

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) AVERAGE
b) MAX
c) MIN
d) SUM

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) =\$B\$1+25
b) =B1+25
c) =SUM(B1:B39)
d) =B1:B39

What function adds all of the numbers in a range of cells?
a) Calculate
b) Sum
c) Compute

Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
a) Close
b) Save
c) Save As
d) Exit

What is a prewritten formula that is built into Microsoft Excel called?
a) Utility
b) Procedure
c) Function
d) Statement

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) Today
b) Weekday
c) Date
d) CurrentDate

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

Where can you find the Insert Function button in Microsoft Excel?