Spreadsheet Modeling: Basic Functions

A_________ is a built in mathematical formula included in excel.

• Function
• Cell
• Formula

Formulas in a cell start with a _______.

• :
• =
• (

Which function would you use to find the largest number of a selected range?

• maximum
• max
• largeest

are individual locations on a spreadsheet

• Rows
• Cells
• Boxes
• Columns

is an arrangement of cells in columns and rows used to organize, analyze, calculate

• Cell
• Workbook
• Document
• Spreadsheet

Instructs the software to perform a calculation

• Cell range
• Formula
• Spreadsheet
• Equation

The function used to add up a range of cells

• MAX
• MIN
• AVERAGE
• SUM

The function used to find the maximum value in a range of cells

• AVERAGE
• SUM
• MIN
• MAX

The function used to find the minimum value in a range of cells

• MIN
• MAX
• SUM
• AVERAGE

If you click on a cell, where can the data in the cell be seen?

• Name Box
• Formula Bar
• Enter
• Cell Address