Question 1

The _____ number format adds dollar signs and two decimal places to numeric data.

Accepted Answer

A)  Data 
B)  Accounting 
C)  Percentage 
D)  General 
A)  Data 
B)  Accounting 
C)  Percentage 
D)  General B

Question 2

Marianna wants to make the legend stand out on a chart.Which of the following can she do?

Accepted Answer

A)  Add a data series. 
B)  Apply a number format. 
C)  Add a border. 
D)  Change its shape. 
A)  Add a data series. 
B)  Apply a number format. 
C)  Add a border. 
D)  Change its shape. C

Question 3

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

Accepted Answer

A)  Error bars 
B)  Number format code 
C)  Number style 
D)  Trendline 
A)  Error bars 
B)  Number format code 
C)  Number style 
D)  Trendline B

Question 4

Which type of constraint should you use to limit the answer to whole numbers, such as for employees needed?

Accepted Answer

A)  bin 
B)  < (less than) 
C)  integer 
D)  = (equals) 
A)  bin 
B)  < (less than) 
C)  integer 
D)  = (equals)

Question 5

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest.Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Accepted Answer

A)  PMT 
B)  NPER 
C)  FV 
D)  PV 
A)  PMT 
B)  NPER 
C)  FV 
D)  PV

Question 6

Nisha wants to set rows 1 and 2 so that they remain visible as she scrolls through the worksheet.After clicking in row 3, which option should she select on the View tab?

Accepted Answer

A)  Freeze Panes 
B)  Set Rows 
C)  Arrange All 
D)  View Side by Side 
A)  Freeze Panes 
B)  Set Rows 
C)  Arrange All 
D)  View Side by Side

Question 7

Which of the following lets you resize a selected picture on your worksheet?

Accepted Answer

A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture. 
A)  Drag it to a new location. 
B)  Drag any corner handle. 
C)  Drag its top border. 
D)  Double-click the picture.

Question 8

Cedric wants to print one page of worksheet data on two pages.Which of the following can he do?

Accepted Answer

A)  Insert a page break. 
B)  Add print titles. 
C)  Freeze the top row. 
D)  Change the zoom. 
A)  Insert a page break. 
B)  Add print titles. 
C)  Freeze the top row. 
D)  Change the zoom.

Question 9

Jin wants to review types of PivotTables that suit her selected data.Which feature should she use to do so?

Accepted Answer

A)  Print Preview 
B)  Pivot Preview 
C)  Recommended PivotTables 
D)  Recommended Tables 
A)  Print Preview 
B)  Pivot Preview 
C)  Recommended PivotTables 
D)  Recommended Tables

Question 10

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 
A)  icon sets 
B)  themes 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules

Question 11

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Accepted Answer

A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete 
A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete

Question 12

Which part of a Check Box (Form Control) shape should you click to rename the control?

Accepted Answer

A)  text label 
B)  outer edge 
C)  sizing handle 
D)  check box 
A)  text label 
B)  outer edge 
C)  sizing handle 
D)  check box

Question 13

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas.She does not want to update the data tables on the worksheet, but she does want to update the other formulas.Which of the following is the most efficient way for her to do so?

Accepted Answer

A)  Select the Automatic Except for Data Tables option. 
B)  Select the Manual Calculation option and recalculate each cell. 
C)  Retype each formula. 
D)  Create custom number formats for the cells with formulas. 
A)  Select the Automatic Except for Data Tables option. 
B)  Select the Manual Calculation option and recalculate each cell. 
C)  Retype each formula. 
D)  Create custom number formats for the cells with formulas.

Question 16

After selecting a range of data, what can you click to display common chart types based on the range you selected?

Accepted Answer

A)  Chart Options button 
B)  Paste Options button 
C)  Flash Fill button 
D)  Quick Analysis button 
A)  Chart Options button 
B)  Paste Options button 
C)  Flash Fill button 
D)  Quick Analysis button

Question 17

A Scatter chart shows positive values in green and negative values in red.

Accepted Answer

A) True 
 B)False

Question 18

Amelia wants to insert a hyperlink to an e-mail address.Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

Accepted Answer

A)  Link to list 
B)  Text to display box 
C)  Look in box 
D)  Target list 
A)  Link to list 
B)  Text to display box 
C)  Look in box 
D)  Target list

Question 19

The SUMIF function totals only the cells in a range that meet given criteria.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are effects you can apply to the chart title? Select all the options that apply.

Accepted Answer

A)  Shadow 
B)  Glow 
C)  Title style 
D)  Outline 
A)  Shadow 
B)  Glow 
C)  Title style 
D)  Outline

The _____ number format adds dollar signs and two decimal places to numeric data.

Marianna wants to make the legend stand out on a chart.Which of the following can she do?

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

Which type of constraint should you use to limit the answer to whole numbers, such as for employees needed?

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest.Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Nisha wants to set rows 1 and 2 so that they remain visible as she scrolls through the worksheet.After clicking in row 3, which option should she select on the View tab?

Which of the following lets you resize a selected picture on your worksheet?

Cedric wants to print one page of worksheet data on two pages.Which of the following can he do?

Jin wants to review types of PivotTables that suit her selected data.Which feature should she use to do so?

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

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Which part of a Check Box (Form Control) shape should you click to rename the control?

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

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

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas.She does not want to update the data tables on the worksheet, but she does want to update the other formulas.Which of the following is the most efficient way for her to do so?

After selecting a range of data, what can you click to display common chart types based on the range you selected?

A Scatter chart shows positive values in green and negative values in red.

Amelia wants to insert a hyperlink to an e-mail address.Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

The SUMIF function totals only the cells in a range that meet given criteria.

Which of the following are effects you can apply to the chart title? Select all the options that apply.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

The _____ number format adds dollar signs and two decimal places to numeric data.

Marianna wants to make the legend stand out on a chart.Which of the following can she do?

As you change the number format of a chart axis using the Format Axis pane, which of the following axis options can you also add?

Which type of constraint should you use to limit the answer to whole numbers, such as for employees needed?

Curtis is planning to invest $50 per month for the next 60 months and expects to earn 5% in interest.Which of the following functions can he use to determine how much the investment will be worth at the end of 60 months?

Nisha wants to set rows 1 and 2 so that they remain visible as she scrolls through the worksheet.After clicking in row 3, which option should she select on the View tab?

Which of the following lets you resize a selected picture on your worksheet?

Cedric wants to print one page of worksheet data on two pages.Which of the following can he do?

Jin wants to review types of PivotTables that suit her selected data.Which feature should she use to do so?

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

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Which part of a Check Box (Form Control) shape should you click to rename the control?

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

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

Laura is changing data in a worksheet, but the worksheet is not updating the results in cells with formulas.She does not want to update the data tables on the worksheet, but she does want to update the other formulas.Which of the following is the most efficient way for her to do so?

After selecting a range of data, what can you click to display common chart types based on the range you selected?

A Scatter chart shows positive values in green and negative values in red.

Amelia wants to insert a hyperlink to an e-mail address.Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

The SUMIF function totals only the cells in a range that meet given criteria.

Which of the following are effects you can apply to the chart title? Select all the options that apply.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters