Question 1

Which of the following can be the target of a hyperlink in Excel?

Accepted Answer

A)  New blank workbook 
B)  Worksheet in the current workbook 
C)  Print setting in the current workbook, 
D)  New worksheet in the current workbook 
A)  New blank workbook 
B)  Worksheet in the current workbook 
C)  Print setting in the current workbook, 
D)  New worksheet in the current workbook

Question 2

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

Accepted Answer

A) True 
 B)False

Question 3

To move a chart to another location on the same worksheet, drag it to the location you want.

Accepted Answer

A) True 
 B)False

Question 4

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Accepted Answer

A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function 
A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function

Question 5

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

Accepted Answer

A)  Icon Sets 
B)  Color Scales 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules 
A)  Icon Sets 
B)  Color Scales 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules

Question 6

When a PivotTable has two levels of data in the Rows or Columns area, which of the following can you do?

Accepted Answer

A)  Filter on multiple fields. 
B)  Refresh only the second level of data. 
C)  Add a slicer that displays buttons for both fields. 
D)  Drill up or down in the data. 
A)  Filter on multiple fields. 
B)  Refresh only the second level of data. 
C)  Add a slicer that displays buttons for both fields. 
D)  Drill up or down in the data.

Question 7

Which of the following are methods you can use to insert the AVERAGE function in a formula? Select all the options that apply.

Accepted Answer

A)  AutoSum arrow 
B)  Insert Function dialog box 
C)  Insert Formula dialog box 
D)  Typing and using Formula AutoComplete 
A)  AutoSum arrow 
B)  Insert Function dialog box 
C)  Insert Formula dialog box 
D)  Typing and using Formula AutoComplete

Question 8

In a PivotTable, the Row Labels appear above the PivotTable values.

Accepted Answer

A) True 
 B)False

Question 9

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin.What view are you in?

Accepted Answer

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

Question 10

How many actions does the Undo button let you reverse?

Accepted Answer

A)  24 
B)  50 
C)  75 
D)  100 
A)  24 
B)  50 
C)  75 
D)  100

Question 11

An Excel table contains columns named Salary and Commission.Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

Accepted Answer

A)  '=[Salary]+[Commission] 
B)  =[Salary+Commission] 
C)  =(Salary)+(Commission) 
D)  ="Salary" + "Commission" 
A)  '=[Salary]+[Commission] 
B)  =[Salary+Commission] 
C)  =(Salary)+(Commission) 
D)  ="Salary" + "Commission"

Question 12

Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.

Accepted Answer

A) True 
 B)False

Question 13

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

Accepted Answer

A) True 
 B)False

Question 14

A predesigned combination of formats, such as font size and color, is called a cell default.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following functions are text functions that convert the case of text? Select all the options that apply.

Accepted Answer

A)  UPPER 
B)  LEN 
C)  LOWER 
D)  PROPER 
A)  UPPER 
B)  LEN 
C)  LOWER 
D)  PROPER

Question 16

You can import text data into Excel and save the imported data in Excel format.

Accepted Answer

A) True 
 B)False

Question 17

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data.How can he work more efficiently?

Accepted Answer

A)  Select the Manual Calculation option. 
B)  Use the Quick Analysis tool to control calculations. 
C)  Round all the decimal values. 
D)  Remove any Date functions. 
A)  Select the Manual Calculation option. 
B)  Use the Quick Analysis tool to control calculations. 
C)  Round all the decimal values. 
D)  Remove any Date functions.

Question 18

To remove a field from a PivotTable, clear its check box in the field list.

Accepted Answer

A) True 
 B)False

Question 19

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Accepted Answer

A) True 
 B)False

Question 20

Amanda wants to calculate formulas only when she saves or opens a workbook.Which of the following calculation options should she select?

Accepted Answer

A)  Calculate Now 
B)  Manual 
C)  On Save 
D)  Recalculate 
A)  Calculate Now 
B)  Manual 
C)  On Save 
D)  Recalculate

Which of the following can be the target of a hyperlink in Excel?

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

To move a chart to another location on the same worksheet, drag it to the location you want.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

When a PivotTable has two levels of data in the Rows or Columns area, which of the following can you do?

Which of the following are methods you can use to insert the AVERAGE function in a formula? Select all the options that apply.

In a PivotTable, the Row Labels appear above the PivotTable values.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin.What view are you in?

How many actions does the Undo button let you reverse?

An Excel table contains columns named Salary and Commission.Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

A predesigned combination of formats, such as font size and color, is called a cell default.

Which of the following functions are text functions that convert the case of text? Select all the options that apply.

You can import text data into Excel and save the imported data in Excel format.

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data.How can he work more efficiently?

To remove a field from a PivotTable, clear its check box in the field list.

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Amanda wants to calculate formulas only when she saves or opens a workbook.Which of the following calculation options should she select?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Which of the following can be the target of a hyperlink in Excel?

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

To move a chart to another location on the same worksheet, drag it to the location you want.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

When a PivotTable has two levels of data in the Rows or Columns area, which of the following can you do?

Which of the following are methods you can use to insert the AVERAGE function in a formula? Select all the options that apply.

In a PivotTable, the Row Labels appear above the PivotTable values.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin.What view are you in?

How many actions does the Undo button let you reverse?

An Excel table contains columns named Salary and Commission.Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

Jose inserts the formula =DATE(2021, 2, 15) in cell A15.When he presses ENTER, 2/15/2021 will appear in the cell.

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

A predesigned combination of formats, such as font size and color, is called a cell default.

Which of the following functions are text functions that convert the case of text? Select all the options that apply.

You can import text data into Excel and save the imported data in Excel format.

Patrick is editing a worksheet with many formulas and functions, making the worksheet slow to update when he changes data.How can he work more efficiently?

To remove a field from a PivotTable, clear its check box in the field list.

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Amanda wants to calculate formulas only when she saves or opens a workbook.Which of the following calculation options should she select?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters