CSC Chapter 1 quiz study guide with
complete solutions
________ a carefully formatted worksheet can save you a lot of time when you need
that formatting on another sheet. - ANSWER-copying
________ can be used in calculations, whereas text cannot. - ANSWER-values
17) What does it mean when you see ####### in a cell?
A) Your formula is incorrect.
B) At least one of the cell references in your formula is pointing to an empty cell.
C) Your column is not wide enough.
D) Your row is not tall enough. - ANSWER-C) Your column is not wide enough.
A range is specified by its ________.
A) top and bottom row and left and right column
B) top row and leftmost column
C) top right and bottom left cells
D) top left and bottom right cells - ANSWER-D) top left and bottom right cells
A(n) ________ is a collection of format characteristics that provides a consistent
appearance within a worksheet and among similar workbooks. - ANSWER-cell style
A(n) ________ is a collection of one or more related worksheets. - ANSWER-workbook,
spreadsheet
A(n) ________ is a group of cells which have been selected at the same time. -
ANSWER-range
A(n) ________ is a line you can put around a cell or range of cells for emphasis. -
ANSWER-border
A(n) ________ is a type of file that organizes data in rows and columns. - ANSWER-
spreadsheet
A(n) ________ range contains multiple ranges that are not positioned in a contiguous
cluster in the worksheet. - ANSWER-nonadjacent
accounting number format - ANSWER-puts a $ at the left margin of the cell
Adding color to cells is considered a professional design strategy.
TRUE
FALSE - ANSWER-TRUE
, Alignment - ANSWER-Refers to how data are positioned in the boundaries of a cell.
Auto Fill - ANSWER-helps complete a logical sequence
AutoComplete - ANSWER-matches the letters you type to another value in the column if
the letters match
Bottom Align is the default vertical alignment.
TRUE
FALSE - ANSWER-TRUE
Cancel - ANSWER-Reverts back to previous data
Cell ________ refers to how data are located within the boundaries of the cell. -
ANSWER-alignment
cell - ANSWER-The intersection of a column and a row
column heading - ANSWER-the letter in the cell reference "F4"
Ctrl+Home - ANSWER-Moves active cell to column A, row 1
currency number format - ANSWER-puts the $ sign next to the leftmost number
Displaying cell formulas can help find errors in formulas more easily.
TRUE
FALSE - ANSWER-TRUE
End - ANSWER-This does nothing by itself
Enter - ANSWER-Accepts the data
fill handle - ANSWER-small green square used to perform various actions
flash fill - ANSWER-fills in data based on previous columns data
For the fill handle to work you need to have two cells selected.
TRUE
FALSE - ANSWER-FALSE
Formula - ANSWER-always begins with an equal sign (=)
Formula Bar - ANSWER-Shows the contents of the active cell
Home - ANSWER-Moves active cell to column A in that row
complete solutions
________ a carefully formatted worksheet can save you a lot of time when you need
that formatting on another sheet. - ANSWER-copying
________ can be used in calculations, whereas text cannot. - ANSWER-values
17) What does it mean when you see ####### in a cell?
A) Your formula is incorrect.
B) At least one of the cell references in your formula is pointing to an empty cell.
C) Your column is not wide enough.
D) Your row is not tall enough. - ANSWER-C) Your column is not wide enough.
A range is specified by its ________.
A) top and bottom row and left and right column
B) top row and leftmost column
C) top right and bottom left cells
D) top left and bottom right cells - ANSWER-D) top left and bottom right cells
A(n) ________ is a collection of format characteristics that provides a consistent
appearance within a worksheet and among similar workbooks. - ANSWER-cell style
A(n) ________ is a collection of one or more related worksheets. - ANSWER-workbook,
spreadsheet
A(n) ________ is a group of cells which have been selected at the same time. -
ANSWER-range
A(n) ________ is a line you can put around a cell or range of cells for emphasis. -
ANSWER-border
A(n) ________ is a type of file that organizes data in rows and columns. - ANSWER-
spreadsheet
A(n) ________ range contains multiple ranges that are not positioned in a contiguous
cluster in the worksheet. - ANSWER-nonadjacent
accounting number format - ANSWER-puts a $ at the left margin of the cell
Adding color to cells is considered a professional design strategy.
TRUE
FALSE - ANSWER-TRUE
, Alignment - ANSWER-Refers to how data are positioned in the boundaries of a cell.
Auto Fill - ANSWER-helps complete a logical sequence
AutoComplete - ANSWER-matches the letters you type to another value in the column if
the letters match
Bottom Align is the default vertical alignment.
TRUE
FALSE - ANSWER-TRUE
Cancel - ANSWER-Reverts back to previous data
Cell ________ refers to how data are located within the boundaries of the cell. -
ANSWER-alignment
cell - ANSWER-The intersection of a column and a row
column heading - ANSWER-the letter in the cell reference "F4"
Ctrl+Home - ANSWER-Moves active cell to column A, row 1
currency number format - ANSWER-puts the $ sign next to the leftmost number
Displaying cell formulas can help find errors in formulas more easily.
TRUE
FALSE - ANSWER-TRUE
End - ANSWER-This does nothing by itself
Enter - ANSWER-Accepts the data
fill handle - ANSWER-small green square used to perform various actions
flash fill - ANSWER-fills in data based on previous columns data
For the fill handle to work you need to have two cells selected.
TRUE
FALSE - ANSWER-FALSE
Formula - ANSWER-always begins with an equal sign (=)
Formula Bar - ANSWER-Shows the contents of the active cell
Home - ANSWER-Moves active cell to column A in that row