Computing Final CH13

Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it: A) is truncated B) is abbreviated C) is hyphenated D) cannot be entered into a cell

A. Is truncated

Cell references that do not change when copied from one cell to another are called ________ references.

Absolute

Spreadsheets are used primarily in: A) education B) business C) government D) the home

B. Business

To select a range of cells: A) double-click the first and last cells B) drag the cursor across the cells C) click Select on the Edit menu D) click the Add icon

B. Drag the cursor across the cells

Which of the following is used for computing common, summary applications in a spreadsheet? A) formulas B) functions C) tables D) formatting

B. Functions

The main purpose of a spreadsheet is to: A) display numerical results B) process numerical data C) organize factual data D) graphically present data

B. Process numerical data

The basic unit of a spreadsheet is a: A) box B) cube C) cell D) grid

C. Cell

We can see spreadsheet results graphically by creating: A) complex formulas B) hidden columns C) charts D) absolute cell references

C. Charts

In Microsoft Excel, all of the contents of the spreadsheet's cells, including the formulas, can be displayed by using the keyboard shortcut: A) Ctrl+Alt+Tab B) Ctrl+F1 C) Ctrl+` Note: grave accent is on the key with tilde (~) D) Ctrl+C

C. Ctrl+` Note: grave accent is on the key with tilde(~)

In a spreadsheet, a(n) ________ is a naming scheme that allows the user to refer to a group of cells by naming the first cell and the last cell and placing a colon (:) in between.

Cell Range

To help us create a list, spreadsheets give us an array of ________ that we fill in to set up our list.

Cells

A range of cells can include: A) cells from more than one row B) cells from more than one column C) the entire spreadsheet D) all of the above

D. All of the above

Spreadsheets: A) can only be sorted by column A B) can be sorted by any column provided the column is named C) are sorted by rows then columns D) can be sorted by any column

D. Can be sorted by any column

An example of conditional formatting is: A) applying a font color, e.g., green, to values over 500 B) applying currency format to cells that refer to money values C) applying italics to one column and bold to another column D) formatting a spreadsheet with alternate colors for each row

D. Formatting a spreadsheet with alternate colors for each row

A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n): A) date copy B) auto-increment C) conditional fill D) series fill

D. Series fill

A formula reference begins with: A) f() B) a cell reference C) any number D) the equals sign (=)

D. The equal sign (=)

An absolute cell reference makes use of the ________ symbol in its formula.

Dollar Sign ($)

The ________ at the beginning of a cell entry determines whether a spreadsheet cell contains a formula or data.

Equal Sign (=)

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

Filling

Data from another application that one wants to import into a spreadsheet is called ________.

Foreign Data

To change the way contents of a cell appears, you change its ________.

Format

Spreadsheet columns are labeled with ________.

Letters

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

Minimum

The rows of a spreadsheet are designated with ________.

Numbers

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

Text