Question 1

When you change cell contents to italics,you are changing the cell's alignment.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

Accepted Answer

A)   one
B)   two
C)   three
D)   fourE) B) and D)
F) A) and B)

Question 4

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

Question 5

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

Question 6

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

Accepted Answer

A)   Insert
B)   Developer
C)   Formulas
D)   Page LayoutE) All of the above
F) A) and C)

Question 7

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Accepted Answer

A) True 
 B)False

Question 8

From how many theme options can you choose to change the theme of a Power View report?

Accepted Answer

A)   12
B)   20
C)   39
D)   56E) B) and C)
F) A) and C)

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

To enter your name in the lower right corner of a worksheet page,you can _____.

Accepted Answer

A)   Use a button on the Header and Footer Tools Design tab.
B)   Type your name in the Header and Footer Elements group.
C)   Type your name in the lower right cell of the worksheet.
D)   Select the right footer text box and type your name.E) B) and C)
F) None of the above

Question 14

To load the Analysis ToolPak and select Anova: Single Factor for statistical analysis in Excel,one should click on the following series: File tab > Options > Add-Ins category > Manage box > Excel Add-ins > Go .select Analysis ToolPak option on the appearing dialog box > OK > Data > Analysis > Data Analysis dialog box > Anova: Single Factor > OK.

Accepted Answer

A) True 
 B)False

Question 15

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Accepted Answer

A)   Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.
B)   Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines.
C)   Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines.
D)   Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines.E) B) and D)
F) All of the above

Question 16

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

Accepted Answer

A)   Cell
B)   Text
C)   Pattern
D)   FontE) B) and C)
F) A) and B)

Question 17

Jim frequently prints out the same section of a worksheet.To do so,he selects the cells he wants to define as print area,then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

Accepted Answer

A) True 
 B)False

Question 18

To rotate cell contents to an exact value,you change its _____.

Accepted Answer

A)   Font
B)   Width
C)   Indent
D)   OrientationE) A) and B)
F) A) and C)

Question 19

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Accepted Answer

A) True 
 B)False

Question 20

You can create conditional cell formats using either the Home tab or the _____.

Accepted Answer

A)   Quick Analysis tool
B)   Cell Styles dialog box
C)   Font formatting buttons on the Home tab
D)   Number formatting buttons on the Home tabE) A) and C)
F) C) and D)

Exam 2: Formatting Workbook Text and Data

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Correct Answer
verified

When you change cell contents to italics,you are changing the cell's alignment.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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 Answer
verified

Correct Answer
verified

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

Correct Answer
verified

You can create conditional cell formats using either the Home tab or the _____.

Correct Answer
verified

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

Correct Answer
verified

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Correct Answer
verified

To rotate cell contents to an exact value,you change its _____.

Correct Answer
verified

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 Answer
verified

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 Answer
verified

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

Correct Answer
verified

Jim frequently prints out the same section of a worksheet.To do so,he selects the cells he wants to define as print area,then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

Correct Answer
verified

From how many theme options can you choose to change the theme of a Power View report?

Correct Answer
verified

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Correct Answer
verified

To enter your name in the lower right corner of a worksheet page,you can _____.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 2: Formatting Workbook Text and Data

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Correct AnswerverifiedShow Answer

When you change cell contents to italics,you are changing the cell's alignment.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can create conditional cell formats using either the Home tab or the _____.

Correct AnswerverifiedShow Answer

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

Correct AnswerverifiedShow Answer

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Correct AnswerverifiedShow Answer

To rotate cell contents to an exact value,you change its _____.

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

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 AnswerverifiedShow Answer

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

Correct AnswerverifiedShow Answer

Jim frequently prints out the same section of a worksheet.To do so,he selects the cells he wants to define as print area,then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

Correct AnswerverifiedShow Answer

From how many theme options can you choose to change the theme of a Power View report?

Correct AnswerverifiedShow Answer

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Correct AnswerverifiedShow Answer

To enter your name in the lower right corner of a worksheet page,you can _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified