Question 1

Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?

Accepted Answer

A)   Hand
B)   Blackbox
C)   Paintbrush
D)   UnderscoreE) A) and B)
F) B) and C)

Question 2

Currency is an example of a number format.

Accepted Answer

A) True 
 B)False

Question 3

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)   underlineE) All of the above
F) None of the above

Question 4

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Accepted Answer

A) True 
 B)False

Question 5

To copy a cell's formatting to another cell, which of the following can you use?

Accepted Answer

A)   Format Cells dialog box
B)   Format Painter
C)   Quick Analysis Tool
D)   Format as TableE) A) and D)
F) C) and D)

Question 6

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

Accepted Answer

A)   Click on the select button in Rows to repeat at top area and select a title row.
B)   Click on the select button in Columns to repeat at left area and select a title row.
C)   Click the check box before Row and column headings under Print.
D)   Click the check box before Gridlines under Print.E) A) and C)
F) A) and B) A

Question 7

The Clipboard task pane shows the contents of the _____.

Accepted Answer

A)   Office Clipboard
B)   Table Styles gallery
C)   Quick Analysis tool
D)   Recently-Used Add-InsE) A) and B)
F) A) and C)

Question 8

You can edit a worksheet footer in _____.

Accepted Answer

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

Question 9

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)   StylesE) A) and B)
F) B) and C) C

Question 10

To change the background color of a cell, you use the Background color button.

Accepted Answer

False - Fi...

Question 11

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Accepted Answer

A)   Currency
B)   Accounting
C)   Percentage
D)   GeneralE) B) and C)
F) A) and D)

Question 12

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 formattingE) A) and B)
F) A) and C)

Question 13

To change the color of cell content, you use the ________ color list arrow.

Accepted Answer

A)   Cell
B)   Text
C)   Pattern
D)   FontE) None of the above
F) All of the above

Question 14

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 15

To return cell contents to its default font and style, you can use the _____ command.

Accepted Answer

A)   Clear Formats
B)   Clear Contents
C)   Clear All
D)   Clear CommentsE) B) and D)
F) All of the above A

Question 16

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

Accepted Answer

A)   Layout
B)   Insert
C)   View
D)   HomeE) A) and C)
F) B) and D)

Question 17

On which tab and button are document properties located for editing?

Accepted Answer

A)   File tab, Info Button
B)   View tab, Show button
C)   Review tab, Changes button
D)   Home tab, Alignment buttonE) A) and B)
F) All of the above

Question 18

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 EditE) All of the above
F) B) and C)

Question 19

A _______ refers to a collection of characters with a similar, specific design.

Accepted Answer

A)   symbol
B)   font
C)   point
D)   keywordE) A) and B)
F) B) and C)

Question 20

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Accepted Answer

A)   reverse
B)   transpose
C)   fill
D)   mergeE) C) and D)
F) A) and D)

Exam 2: Formatting Workbook Text and Data

Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?

Correct AnswerverifiedShow Answer

Currency is an example of a number format.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

Correct AnswerverifiedShow Answer

To copy a cell's formatting to another cell, which of the following can you use?

Correct AnswerverifiedShow Answer

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

Correct AnswerverifiedA

The Clipboard task pane shows the contents of the _____.

Correct AnswerverifiedShow Answer

You can edit a worksheet footer in _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

To change the background color of a cell, you use the Background color button.

Correct AnswerverifiedFalse - Fi...View AnswerShow Answer

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To change the color of cell content, you use the ________ color list arrow.

Correct AnswerverifiedShow Answer

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Correct AnswerverifiedShow Answer

To return cell contents to its default font and style, you can use the _____ command.

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

On which tab and button are document properties located for editing?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A _______ refers to a collection of characters with a similar, specific design.

Correct AnswerverifiedShow Answer

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified
False - Fi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified