Unit 8 Apps 2

Which software will he need to use to create a graph?

Which function rounds a number to a specified number of digits?

What function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?

in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

what must you key for the program you are entering a formula instead of entering text?

There are 4 types of cell data: labels, values, formulas and functions.

Which function would be used to add a range of cells in a spreadsheet?

in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 31?

Kimberly uses which application software to compute the payment for her car loan?

Which function would be used to return the largest value in a range of spreadsheet cells?

An active cell is indicated by a blinking boarder.

Labels are alphabetical text.

 in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 2?

To see the results of entering a formula, depress what key?

 program that allows a user to use rows and columns of data to manage, predict?

A cell range is a group or block of cells.

Values are numerical data used in calculations.

The Order of Operations should be followed to complete calculations

Columns are identified by numbers.

Which function would be used to return the smallest value in a range of spreadsheet cells?

A cell address is also call a cell reference.

In the Order of Operations the formula calculates the data in parentheses last.

One advantage of a spreadsheet program is that it does what?

$ is also used in a mixed cell.

A cell is an intersection of 2 rows.

designate a cell as an absolute cell key what symbol in front of the letter and behind 

Cell references or cell names that automatically change when copied are called what?

Cell references of cells names that need to remain the same when copied are called what?

In a spreadsheet formula, the asterisk and diagonal stand for what mathematical symbols?

Which function will count the number of cells in a range?

the number of hours worked in cell B6 hourly rate in cell C6. calculate his weekly salary?

How is spreadsheet software used for personal use?

Active cell are ready to recieve data.

Rows are identified by numbers.

An apostrophe (') can be typed before a number to make the entry recognized as a label.