Exam 2: Formatting Workbook Text and Data

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

Currency is an example of a number format.

To apply formats to data when it meets criteria you specify,you can use conditional formatting.

To combine multiple cells into one combined cell,which of the following do you use?

To apply a cell style,you would use the Cell Styles command on the _____ tab.

To help you easily identify sheets in a workbook,you can add _____ to the sheet tab.

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

Betty wants to choose the list to create a custom number format.To do so,what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

To format a cell range so that values between 100 and 500 appear in red,which of the following can you use?

You can repeatedly paste an item from the Office Clipboard as many times as you like.

You want to change all worksheet occurrences of "Radio" to "TV"; to do this,you can use the _____ feature.

You can edit a worksheet footer in _____.

Decreasing a cell's indent moves its contents to the right one space.

You double-click the Format Painter button when you want to _____.

The Comma Style format adds a comma and a dollar sign to a cell value.

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

Igor wants to set margins for a worksheet he has created per his choice.Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top,Header,Left,Right,Bottom and Footer text boxes > OK?

To paste only a copied cell's formats,use the Paste Special command.

To change a range's conditional formatting from data bars to icon sets,which of the following can you do?

To choose a standard theme color,click on the Insert tab,click Colors,then pick the color set you want.