COSC 1301 CH08 Review with
Complete Solutions
The _____ feature can enter many common text or number series in adjacent cells
based on the entry in the active cell. - ANSWER-Auto Fill
The _____ function adds a column or row of numbers. - ANSWER-SUM
The AutoFit feature automatically changes the column width to fit the contents of the -
ANSWER-active cell.
The Fill Color button applies color to the _____ of a cell. - ANSWER-background
The New sheet button is located on the - ANSWER-Sheet tab bar.
The Show Formulas button switches the display back and forth between showing the
formulas in cells and showing _____ in cells. - ANSWER-results
What does the Accounting Number Format include that the Comma Style does not? -
ANSWER-a currency symbol
What is the advantage to formatting a worksheet using Cell Styles? - ANSWER-Cell
Styles promote consistency in formatting headings, totals, and accented cells.
What is the first step to sort worksheet data by more than one column? - ANSWER-
select the range
Which button moves the text in a cell approximately one character width inward from the
left edge of the cell? - ANSWER-Increase Indent
Which character separates the top left cell reference from the lower right cell reference
when specifying a range? - ANSWER-: (colon)
Which feature is often used to center a worksheet title in a worksheet? - ANSWER-
Merge & Center
Which of the following is not a valid cell reference? - ANSWER-15BZ
Which of the following is not a valid entry for a formula? - ANSWER-(A1+A2)*A3
Which scaling option shrinks the size of text so that all of the active worksheet prints on
one page? - ANSWER-Fit Sheet on One Page
Complete Solutions
The _____ feature can enter many common text or number series in adjacent cells
based on the entry in the active cell. - ANSWER-Auto Fill
The _____ function adds a column or row of numbers. - ANSWER-SUM
The AutoFit feature automatically changes the column width to fit the contents of the -
ANSWER-active cell.
The Fill Color button applies color to the _____ of a cell. - ANSWER-background
The New sheet button is located on the - ANSWER-Sheet tab bar.
The Show Formulas button switches the display back and forth between showing the
formulas in cells and showing _____ in cells. - ANSWER-results
What does the Accounting Number Format include that the Comma Style does not? -
ANSWER-a currency symbol
What is the advantage to formatting a worksheet using Cell Styles? - ANSWER-Cell
Styles promote consistency in formatting headings, totals, and accented cells.
What is the first step to sort worksheet data by more than one column? - ANSWER-
select the range
Which button moves the text in a cell approximately one character width inward from the
left edge of the cell? - ANSWER-Increase Indent
Which character separates the top left cell reference from the lower right cell reference
when specifying a range? - ANSWER-: (colon)
Which feature is often used to center a worksheet title in a worksheet? - ANSWER-
Merge & Center
Which of the following is not a valid cell reference? - ANSWER-15BZ
Which of the following is not a valid entry for a formula? - ANSWER-(A1+A2)*A3
Which scaling option shrinks the size of text so that all of the active worksheet prints on
one page? - ANSWER-Fit Sheet on One Page
