Question 1

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

Accepted Answer

A)   left
B)   center
C)   bold
D)   underline A,B

Question 2

Currency is an example of a number format.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A)   Column Width command
B)   Center button
C)   Merge and Center button
D)   Increase Indent button

Question 5

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

Accepted Answer

A)   Layout
B)   Insert
C)   View
D)   Home

Question 6

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

Accepted Answer

A)   Alignment
B)   Fonts
C)   Color
D)   Styles

Question 7

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?

Accepted Answer

A)   X- Normal,Y- Print Area
B)   X- Page Layout,Y- Print Tiles
C)   X- Page Break Preview,Y- Breaks
D)   X- Custom Views,Y- Background

Question 8

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

Accepted Answer

A)   Type
B)   Symbol
C)   Locale
D)   Decimal places

Question 9

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

Accepted Answer

A)   icon sets
B)   themes
C)   Top/Bottom Rules
D)   Highlight Cells Rules

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)   Find and Replace
B)   Locate and Replace
C)   Edit and Find
D)   Find and Edit

Question 12

You can edit a worksheet footer in _____.

Accepted Answer

A)   Page Layout view
B)   Normal view
C)   Page Break Preview
D)   Print Preview

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)   copy a cell's format to more than one cell
B)   copy a cell's format to only one cell
C)   use conditional formatting
D)   clear a cell's formatting

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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?

Accepted Answer

A)   Select the column to the left of the page break you want to delete.
B)   Select the column to the right of the page break you want to delete.
C)   Select the row above the page break you want to delete.
D)   Select the row below the page break you want to delete.

Question 17

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?

Accepted Answer

A)   X- Margins,Y- Narrow
B)   X- Margins,Y- Custom Margins
C)   X- Orientation,Y- Landscape
D)   X- Print Area,Y- Set Print Area

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   Delete the conditional formatting rule.
B)   Edit the conditional formatting rule.
C)   Format the range in the Font dialog box.
D)   Format the range as a table.

Question 20

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

Accepted Answer

A) True 
 B)False

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.