Excel Basics Quiz

1. The ______________ formula returns a mathematical mean of a given cell range.

• AVERAGE

• MEDIAN

• SUM

• MIN

2. A ____________ is the intersection of the columns and rows and is where a user will enter data/information.

• Piece of Paper

• Worksheet

• Cell

• Tab

What formula will return the total number of items in the cell range?

• MIN

• COUNT

• MAX

• Active Cell

The ___________ ___________ are the tabs at the bottom of the spreadsheet that allow you to navigate to other pages.

(a)  

The ________ ________ is the currently selected item and is outlined in a green box.

• Basic Formula

• Worksheet Tab

• Navigated Box

• Active Cell

(a)   are the mathematical equations, cell references, or functions that can be placed inside a cell to produce a value.

This returns a mathematical mean of a given cell range.

• AVERAGE

• MEDIAN

• MODE

• COUNT

The (a)   formula totals the numbers in a given cell range.

What is used to indicate that each formula is used for a specific set of cells?

• Worksheet Tab

• Cell Range

• Sum Formula

• Active Tab

If MAX finds the largest number and MIN finds the smallest number, what does MEDIAN find?

• Average of all the numbers in the range

• Total Number of Cells

• The number that falls in the middle

• All the numbers added together