Quiz 14

Which is a valid formula in a spreadsheet?

*=B2+C2-6.2 =4A*B6 A3+6B/3 Y2*Y3/3=SUM

A group of cells is called a range.

*True False

By default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change.

*True False

Spreadsheets can both organize textual data and make computations on numerical data.

*True False

To narrow down the spreadsheet data in view:

*apply a filter sort - ascending sort - descending copy portions to another sheet

If the cell does not start with an equal sign then the cell contains ______.

*data formula range numbers

Spreadsheets recalculate

*whenever a cell is changed only when saved only when opened once a minute

When copying the formula =D5 * $A3 from column D to column E (same row), the rusulting formula in column E is:

=D5 * $A3 =E6 * $B4 *=E5 * $A3 =D6 * $A4

Which of the following are functions built into spreadsheets?

SUM AVERAGE COUNTIF *all of the above

Data can be copied from one cell to another, but formulas cannot.

True *False

Spreadsheets can only sort in ascending order.

True *False

The basic unit of a spreadsheet is a:

box cube *cell grid

We can see spreadsheet results graphically by creating:

complex formulas hidden columns *charts absolute cell references

When copying formulas in a spreadsheet, _______ references change based on position and _______ references do not change.

conditional, certain *relative, absolute optional, required relative, definite

Data imported into a spreadsheet should generally be _____.

continuous *tab-delimited numerical textual

If I want to analyze data in a spreadsheet, I could use:

data entered a calculator *functions like COUNTIF, SUM, AVERAGE, MAX, MIN a financial planner

Results of a _______ in Google are put in a spreadsheet by default.

database merge *survey (form) test word processing session

What symbol is used to denote absolute cell references?

equal sign (=) *dollar sign ($) percent sign (%) tilde (~)

To refer to a range of cells, specify the first cell, the last cell, and a ______ between.

semicolon *colon comma dash

customizes the order of spreadsheet data

shuffling swapping *sorting filtering

Spreadsheets perform calculations with:

static values transitions charts *formulas

Conditional formatting can change the:

text color text format cell color *more than one of the above

The results of a calculation in a spreadsheet cell are displayed in:

the cell to the right the cell immediately below *the cell where the formula is entered in a results column