MS Excel Templates, Functions & Formulas

___________________________ is a predesigned spreadsheet you can use to create new spreadsheets with the same formatting and predefined formulas

• Default setting

• Outline

• Template

• Preset

Which of the following is not a template that is valuable for frequently used document types in Excel?

• Excel Calendars

• Excel Budget Planners

• Excel News Reports

• Excel Invoices

_______________________ a list of goods sent or services provided, with a statement of the sum due for these; a bill.

• Food Budget

• Calendars

• Invoices

• Product Price List

__________________ is a statement or list of the prevailing prices of the company’s merchandise.

• Invoices

• Product Price List

• Food Budget

• Calendar

_____________________ is a chart or series of pages showing the days, weeks, and months of a particular year, or giving particular seasonal information.

• Calendar

• Invoice

• Product Price List

• Food Budget

A _________________________ is a predefined formula that performs calculations using specific values in a particular order.

• Formula Bar

• Name Box

• Function

• Cell

____________________ is an expression that operates on values in a range of cells or a cell.

• Selecting Cells

• Name Box

• Formula

• None of the Above

Write a formula that will add the contents of B3 to B6 in the cell below it.

Given the excel image provided, write out how the AVERAGE function would look if you were to calculate the average of B3 to B6.

Which of the following would allow you to view formulas in an Excel workbook?

• Ctrl+F

• Ctrl+`

• Shift+Enter

• Alt+Enter