Spreadsheet Test Review

What should be entered into a spreadsheet to automatically add a column or 10 numbers?

Which mathematical operator represents subtraction?

Which order of operation comes first?

The column letter followed by the row number is the 

Which is an example of a cell address in a spreadsheet?

Spreadsheet equations with symbols for math operations such as + and - are called

Which function will add up a group of cell and divide by the total number of cells added?

What is the function that will add d14, d15, d16, d, 17, and d18?

In a spreadsheet =B3*C3" is a/an

If I wanted to find the student with the highest average which function would I use?

Shortcut formulas that do not use operators to calculate a result

Text, symbols, dates, or numbers not used in a calculation are called

Identified by numbers on the left side of the spreadsheet

A number entered into a spreadsheet cell that will be used for calculations

A computer program that uses rows and columns to manage, predict, and present information

In the function =SUM(C1:C10), (C1:C10) is called the 

Which formula divides c4 by c5?

A simple mathematical equation that is used to calculate spreadsheet values is called a

Which spreadsheet format should be used the following effect? $167,378.69

What function is used to add a range of cells?

In a cell reference the colon represents

A selected group of cells that form a rectangle

What does MIN do to a range of cells?

The cell address B6 represents

Which formula adds f3, f4, and f5?

A vertical line of data across a spreadsheet is called

Identified by letters that appear at the top of the spreadsheet.

Which mathematical operator represents division in a spreadsheet formula?

Intersection of a row and column and is identified by a cell reference

In a spreadsheet, a user's Social Security number is a