Deck 13: The Basics of Spreadsheets

Question 1

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

Answer 1

True

Question 2

Spreadsheets can only sort data in ascending order .

Answer 2

False

Question 3

A group of cells in a spreadsheet is called a range .

Answer 3

True

Question 4

Column widths in a spreadsheet must be set manually .

Question 5

All cells in a spreadsheet are always visible .

Question 6

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

Question 7

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

Question 8

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

Question 9

The manner in which time is displayed in a spreadsheet is always in military format (for example, 21:00:00) .

Question 10

You cannot mix absolute and relative references in one cell reference .

Question 11

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

Question 12

Hidden columns cannot be referenced in a formula .

Question 13

A text file is the same thing as a tab-delimited file .

Question 14

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

Question 15

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

Question 16

Because there are two dimensions in a spreadsheet (columns and rows), there are actually two ways a formula can be relative .

Question 17

Because spreadsheets can only sort numbers, there is no way to alphabetize a column in a spreadsheet .

Question 18

What is the most common use for a spreadsheet?

A) to draw pie charts
B) as a journal
C) to process text
D) to process numerical data

Question 19

The basic unit of a spreadsheet is a

A) grid
B) box
C) cube
D) cell

Question 20

Spreadsheets

A) are sorted by rows and then by columns
B) can be sorted by any column, only in ascending order
C) can only be sorted by the first column, column A
D) can be sorted by any column, either in ascending or descending order

Question 21

Suppose cell B4 has an entry . If the data in cell A4 is too wide to fit in its cell

A) only part of the data will be visible but the rest of the data still exists
B) all the data will be accepted but the part that doesn't fit will overwrite the contents of cell B4
C) the data will not be accepted
D) only the part of the data that fits will be accepted

Question 22

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

A) tables
B) formatting
C) formulas
D) functions

Question 23

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) series fill
B) conditional fill
C) auto-increment
D) date copy

Question 24

An example of conditional formatting is

A) formatting a spreadsheet with alternate colors for each row
B) applying currency format to cells that refer to monetary values
C) applying italics to one column and bold to another
D) applying a font color such as green to all values greater than 500

Question 25

To select a range of cells

A) click Select on the Edit menu
B) click the Add icon
C) drag the cursor across the cells
D) double-click the first and last cells

Question 26

You can see spreadsheet results graphically by creating

A) unhiding columns
B) charts
C) formulas
D) absolute cell references

Question 27

Spreadsheets were invented in 1979 and ran on the ________ computer

A) VisiCalc
B) mainframe
C) PC
D) Apple II

Question 28

If the first character in a cell is the equals sign (=)

A) the cell can only contain cell references and not data
B) the cell must reference at least two other cells
C) the cell contains a formula
D) None of these

Question 29

If a cell points to cell $F$3, this is an example of a(n)

A) absolute cell reference
B) a reference to a cell on another spreadsheet
C) incorrect attempt at a cell reference
D) relative cell reference

Question 30

If a cell points to cell $M3, this is an example of a(n)

A) relative cell reference
B) absolute cell reference
C) an absolute reference to the column and a relative reference to the row
D) an absolute reference to the row and a relative reference to the column

Question 31

If a cell points to cell N$8, this is an example of a(n)

A) an absolute reference to the column and a relative reference to the row
B) absolute cell reference
C) relative cell reference
D) an absolute reference to the row and a relative reference to the column

Question 32

If cell E3 points to cell $F$3, but a row is inserted such that cell E3 is now cell E4, cell E4 will now point to

A) cell F4
B) cell G4
C) cell F3
D) cell G3

Question 33

If a cell points to cell G5, this is an example of a(n)

A) absolute cell reference
B) incorrect attempt at a cell reference
C) relative cell reference
D) a reference to itself

Question 34

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

A) cell F5
B) cell G6
C) cell G5
D) cannot tell what will happen

Question 35

Spreadsheets normally import foreign data as

A) text files
B) tab-delimited text
C) ASCII files
D) All of these

Question 36

Select all that apply . A range of cells can include

A) only cells from one column or one row
B) cells from many columns
C) cells from various rows and columns
D) cells from many rows

Question 37

Select all that apply . Data in a spreadsheet can be sorted

A) from Z to A, in reverse alphabetical order
B) from A to Z, alphabetically
C) from lowest to highest, numerically
D) from highest to lowest, numerically

Question 38

Select all that apply . Which of the following function is(are) available to use in normal spreadsheets?

A) finding the maximum value in a range of values
B) finding the second-to-lowest value in a range of values
C) finding the sum of a range of values
D) finding the average of a range of values

Question 39

Select all that apply . Which of the following are uses for spreadsheets to help people organize personal information?

A) saving emails
B) documenting expenses for income tax purposes
C) setting up an expense budget
D) tracking performance in an exercise regimen

Question 40

Spreadsheet columns are labeled with ________ .

Question 41

The rows of a spreadsheet are labeled with ________ .

Question 42

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

Question 43

Data from another application to be imported into a spreadsheet is called ________ data .

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

Foreign data is often imported into a spreadsheet in ________-delimited format .