Sample ch 8

A

A ________ is a horizontal group of cells in a worksheet. a. row b. column c. column heading d. row heading

A

A data ________ is a value that originates in a worksheet cell. a. point b. group c. marker d. series

B

The default width of a column is ________ pixels. a. 32 b. 64 c. 128 d. 16

A

Which of the following is not true about formatting cells with Merge & Center and cell styles? a. Use the Merge & Center command to maintain a consistent look in a worksheet and across worksheets in a workbook. b. The Merge & Center command joins selected cells into one larger cell and centers the contents in the new cell. c. Formatting cells makes your worksheet attractive and easy to read. d. A cell style is a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

A

Clicking on the ________ displays sheet tabs that are not in view. a. sheet tab scrolling button b. Name Box c. expand horizontal scroll bar button d. Formula Bar

C

Which of the following is not true about printing and deleting an Excel worksheet? a. If you attempt to delete a worksheet with data, Excel will display a warning and permit you to cancel the deletion. b. In Normal view, the vertical dotted line between columns indicates that as currently arranged, only the columns to the left of the dotted line will print on the first page. c. It is necessary to delete unused sheets to save storage space and remove any doubt that additional information is in the workbook. d. Scaling shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convenient for printing formulas.

A

Which of the following is not true about statistical functions? a. The MEDIAN function finds the average value that has as many values above it in the group as are below it. b. The SUM function is a predefined formula that adds all the numbers in a selected range of cells. c. Statistical functions, which include the AVERAGE, MEDIAN, MIN, and MAX functions, are useful to analyze a group of measurements. d. The AVERAGE function adds a group of values, and then divides the result by the number of values in the group.

B

Which of the following is not true regarding Excel tables? a. You can sort and filter the data in an Excel table. b. Sorting and filtering arrows display after you convert the table into a normal range. c. The Freeze Panes command enables you to select one or more rows or columns and then freeze them into place. d. To analyze a group of related data, you can convert a range of cells to an Excel table.

B

Which of the following is not true regarding clearing formats? a. You can choose to clear the contents of a cell, the formatting of a cell, or both. b. Clearing the contents of a cell deletes the value or formula typed there, including the formatting applied to a cell. c. Deleting the contents does not delete the formatting of the cell. d. Clearing the date formatting from the cell displays the date's serial number.

B

Which of the following is not true regarding conditional formatting? a. If the condition is true, the cell is formatted based on that condition. b. Conditional formatting should only be used on numeric values. c. A conditional format changes the appearance of a cell based on a condition d. If the condition is false, the cell is not formatted.