Exam 2: Formatting Workbook Text and Data

In the Format Cells dialog box,the _____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.

One of the benefits of Live Preview is that it _____.

By default,Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin._________________________  

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

As a general rule,you should _____.

To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

By default,Excel displays text in a black font color._________________________

_____ merges each of the rows in the selected range across the columns in the range.

Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel.She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -Each worksheet will contain a specific class with the students' grades for the entire term.In order to determine the current student grade,Antoinette would have to use the _____ function.

By default,numbers appear in the _____ and generally display values exactly as you type them.

Case 2-1 Harold has been working as a real estate agent.He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. -Harold would like to center a title across the top of his data.His data runs across five columns,from column A to column E.One way he could accomplish this is to _____.

In Excel,dates are _____-aligned in the cell by default,regardless of date format.

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value._________________________  

A conditional format can make negative numbers red and positive numbers black._________________________  

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

To avoid splitting a worksheet in awkward places,you can insert a _____ to specify a specific breaking point.

Calculated values too large to fit into the cell are displayed in scientific notation._________________________