Exam 2: Formatting Workbook Text and Data

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.

Setting the _____ to A1:L10 will print only data in those cells.

MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell

A(n) $\underline { \text { conditional format } }$ applies formatting to a cell when its value meets a specified condition._________________________

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?

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

What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.

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 _____.

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell

Italic,bold,bold italic,and underline are examples of _____.

Header and footer elements such as worksheet name,current date,and time are _____ elements.

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 _____.

A(n)____________________ is a key that shows each color used in the worksheet and what it means.

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

Information that prints on each page,like a company name or logo,may be set as a _____.

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

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.

The header and footer sections include a _____.

A(n) $\underline { \text { footer } }$ appears at the top of each printed page._________________________