Question 1

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

Accepted Answer

A)  Cell 
B)  Text 
C)  Pattern 
D)  Font 
A)  Cell 
B)  Text 
C)  Pattern 
D)  Font

Question 2

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 3

Jesse wants to set up a button shape so that when users click the button, a macro runs. Which of the following should he do?

Accepted Answer

A)  Change the Cell Link property of the button shape. 
B)  Assign a macro to the button shape. 
C)  Assign the same name to the button shape and the macro 
D)  Assign the same shortcut key to the button shape and the macro. 
A)  Change the Cell Link property of the button shape. 
B)  Assign a macro to the button shape. 
C)  Assign the same name to the button shape and the macro 
D)  Assign the same shortcut key to the button shape and the macro.

Question 4

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following elements uses colors to identify how the data is represented in a chart?

Accepted Answer

A)  Gridlines 
B)  Legend 
C)  Chart Title 
D)  Data label 
A)  Gridlines 
B)  Legend 
C)  Chart Title 
D)  Data label

Question 6

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Accepted Answer

A)  master 
B)  model 
C)  template 
D)  standard 
A)  master 
B)  model 
C)  template 
D)  standard

Question 7

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

Accepted Answer

A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  IF 
A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  IF

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

Accepted Answer

A) True 
 B)False

Question 10

You can create a query to by adding what type of data to the data model?

Accepted Answer

A)  Current worksheet data 
B)  Outlook address book 
C)  Word document 
D)  Word mail merge 
A)  Current worksheet data 
B)  Outlook address book 
C)  Word document 
D)  Word mail merge

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following Excel features finds a numeric solution to a problem involving several input values?

Accepted Answer

A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek 
A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek

Question 14

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

Accepted Answer

A) True 
 B)False

Question 15

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He also wants a picture he inserted to fit the worksheet design. Which of the following should he do?

Accepted Answer

A)  Resize the picture. 
B)  Align the picture in the center of the worksheet. 
C)  Apply a reflection effect. 
D)  Add a blue border. 
A)  Resize the picture. 
B)  Align the picture in the center of the worksheet. 
C)  Apply a reflection effect. 
D)  Add a blue border.

Question 16

How are Excel tables and PivotTables similar?

Accepted Answer

A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet. 
A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet.

Question 17

Which of the following is the temporary storage area that holds selections you copy or cut?

Accepted Answer

A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window 
A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window

Question 18

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format .

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)  Font 
B)  Width 
C)  Indent 
D)  Orientation 
A)  Font 
B)  Width 
C)  Indent 
D)  Orientation

Question 20

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Accepted Answer

A) True 
 B)False

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

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?

Jesse wants to set up a button shape so that when users click the button, a macro runs. Which of the following should he do?

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Which of the following elements uses colors to identify how the data is represented in a chart?

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

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

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

You can create a query to by adding what type of data to the data model?

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

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He also wants a picture he inserted to fit the worksheet design. Which of the following should he do?

How are Excel tables and PivotTables similar?

Which of the following is the temporary storage area that holds selections you copy or cut?

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format .

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

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

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

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?

Jesse wants to set up a button shape so that when users click the button, a macro runs. Which of the following should he do?

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Which of the following elements uses colors to identify how the data is represented in a chart?

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

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

If a PivotTable displays the Department and Quarter fields as row headings, you can drag the Department field to the Filters area to filter the PivotTable by Department.

You can create a query to by adding what type of data to the data model?

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

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He also wants a picture he inserted to fit the worksheet design. Which of the following should he do?

How are Excel tables and PivotTables similar?

Which of the following is the temporary storage area that holds selections you copy or cut?

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format .

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

If you want to edit the changing values for a scenario, apply the scenario to the worksheet, and then edit the data directly.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters