Excel 1.03-1.05 (Part 2) Question Preview (ID: 38976)
1.03 - 1.05.
TEACHERS: click here for quick copy question ID numbers.
Where can you find the Insert Function button in Microsoft Excel?
a) Quick Access Toolbar
b) Formula bar
c) Status bar
d) Shortcut menu
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
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
What function adds all of the numbers in a range of cells?
a) Calculate
b) Sum
c) Compute
d) Add
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
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
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
What area contains the command used to customize the print options in Microsoft Excel?
a) Home Ribbon
b) Page Layout Ribbon
c) Quick Access Toolbar
d) File Tab
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.
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
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 38976 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 38976 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register