Exam 2: Formatting Workbook Text and Data

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. -Antoinette wants all her worksheets to have the same formatting for text,colors,and graphical effects applied to create a specific look and feel.Antoinette needs to apply a _____.

The code _____ will display the filename of the current workbook.

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

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. -Because Antoinette is familiar with conditional formatting,she can use the _____,which provides access to the most common tools for data analysis and formatting.

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Put the following five steps in the order in which you would perform them to use the Paste Special function.?1.Select and copy a range.?2.Click the Paste button arrow in the Clipboard group on the HOME Tab.?3.Specify exactly what you want to paste.?4.Click Paste Special to open the dialog box.?5.Select the range where you want to paste the Clipboard contents.

One way to align text over several columns or rows is to ____________________,or combine,several cells into one cell.

The cell reference for the merged cell is the upper-right cell reference._________________________

_____ are an example of conditional formats in Excel.

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 needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.

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. -Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.

You can open the Format Cells dialog box by right-clicking a cell or selected range,and then clicking _____ on the shortcut menu.

A(n)____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line._________________________ 

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. -Antoinette's workbook has all the data entered and students' current grades displayed.She would like the current grade cells to display the value in red if it is less than 60.Antoinette needs to add _____ to the cell.

Excel organizes fonts into theme and non-theme fonts._________________________

The background image does not affect any cell's format or content._________________________

A(n)____________________ is text printed in the top margin of each page.

The header and footer sections include a _____.