Exam 2: Formatting Workbook Text and Data

Ten ____________________ colors-dark red,red,orange,yellow,light green,green,light blue,blue,dark blue,and purple-are always available regardless of the workbook's theme.

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

A theme is a collection of formatting options that include a specified font,font size,font styles,font color,fill color,and borders._________________________

To remove conditional formatting in Excel,click ____________________ after clicking the Conditional Formatting button.

If you want to print only part of a worksheet,you can set a print area,which is the region of the worksheet that is sent to the printer._________________________

A footer appears at the top of each printed page._________________________

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. -When Antoinette shares her worksheet with other colleagues,she wants to ensure that everyone knows why certain cells are highlighted.To accomplish this,she will create a _____.

The Format Cells dialog box has six tabs,including _____.

A conditional format applies formatting to a cell when its value meets a specified condition._________________________

To set a page break in Excel,select the _____.

A _____ is the space between the page content and the edges of the page.

Because Excel stores dates and times as _____,you can apply different formats without affecting the date and time value.

Formatting changes only the appearance of data-it does not affect the data itself._________________________  

The appearance of non-theme fonts,colors,and effects remains unchanged no matter which theme is applied to the workbook._________________________  

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

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. -In one of Harold's columns there are too many numbers after the decimal place.Harold does not need this level of detail.It is distracting from the data and he really only needs two numbers after the decimal.How could Harold make the data appear cleaner in the most efficient way? 

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 has chosen green as the background color for his workbook.He should not use _____ for any of the font or highlight colors.

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 wants to print ranges E6:F12 and E16:F22 of his worksheet.These are referred to as _____ cell ranges.

In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.

When you specify a print area for a nonadjacent range,you are also inserting a(n)____________________ page break.