Exam 13: The Basics of Spreadsheets

The Min function is used to display the ________ item in a list .

Spreadsheets were invented in 1979 and ran on the ________ computer

A formula in a cell always starts with an equals sign (=) .

An absolute cell reference uses the ________ symbol to identify the value as an absolute reference .

A file with a . txt extension is an ASCII ________ file .

Functions and column letters in a spreadsheet are not case sensitive .

You can see spreadsheet results graphically by creating

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

If cell F5 on row 5 points to cell G5 and then a new row is inserted so that cell F5 is now cell F6, it will now point to

To change the way contents of a cell appear, you change the cell's ________ .

The basic unit of a spreadsheet is a

Spreadsheets

Spreadsheets can only sort data in ascending order .

Which of the following is used to compute common summary applications in a spreadsheet?

Tables from a web page can be pasted into a spreadsheet .

The process of copying from one cell to many others by dragging through those cells is called ________ .

Column widths in a spreadsheet must be set manually .

Cell entries in spreadsheets can be formatted in a manner similar to formatting text in a word processor .

The fill handle can be used to copy values but not formulas .

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