Excel Chapter 5 Questions

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

Which is a prewritten formula that is built into Microsoft Excel?

• Utility

• Procedure

• Function

• Statement

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

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

Which are valid Microsoft Excel functions?

• AVERAGE, MAX, and NUM

• MAX, MIN, and WEEK

• AVERAGE, MAX, and MIN

• WEEKDAY, MAX, and CLOSE

Which group on the Formulas Ribbon enables a user to specify when a formula is computed?

• Function Library

• Defined Names

• Formula Auditing

• Calculation

Where is the Insert Function button found in Microsoft Excel?

• Quick Access Toolbar

• Formula bar

• Status bar

• Shortcut menu

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

• Function Library

• Defined Names

• Formula Auditing

• Calculation

Larry has created a spreadsheet containing student grades.

Which function would he use to return the current date in cell A1?

• COUNT

• IF

• NOW

• TODAY

Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?

• Today

• Weekday

• Date

• CurrentDate