NEW
Font size
Worksheets2016 - MS Excel - Lesson 5 -Vocats Study Guide
Total questions: 9
Worksheet time: 5mins
Where is the Insert Function button found in Microsoft Excel?
Quick Access Toolbar
Formula bar
Status bar
Shortcut Menu
Which is a prewritten formula that is built into Microsoft Excel?
Function
Procedure
Statement
Utility
Which are valid Microsoft Excel functions?
AVERAGE, MAX, and NUM
AVERAGE, MAX, and MIN
MAX, MIN, and WEEK
WEEKDAY, MAX, and CLOSE
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?
Functions
Formulas
Labels
Values
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
AVERAGE
MAX
MIN
SUM
What function adds all of the numbers in a range of cells?
Add
Calculate
Compute
Sum
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
Add
AutoSum
Calculate
Total
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?
AVERAGE
MAX
MIN
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?
=$B$1+25
=B1+ 25
=SUM(B1:B39)
=B1:B39
