Question 1

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Accepted Answer

A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column. 
A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column.

Question 2

Which of the following can you do to decrease the level of a SmartArt shape?

Accepted Answer

A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape. 
A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape.

Question 3

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

Accepted Answer

A) True 
 B)False

Question 4

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 5

How can you tell if Solver is activated in your version of Excel?

Accepted Answer

A)  The Solver button appears in the Analyze group on the Data tab. 
B)  A Solver tab appears on the ribbon. 
C)  The Solver dialog box opens when you click the Data tab. 
D)  Solver appears as the Add-in document property in Backstage view. 
A)  The Solver button appears in the Analyze group on the Data tab. 
B)  A Solver tab appears on the ribbon. 
C)  The Solver dialog box opens when you click the Data tab. 
D)  Solver appears as the Add-in document property in Backstage view.

Question 6

Maria entered three option buttons in a column on a worksheet and linked them to cell B2. When a user clicks the second option button, Excel inserts "2" in cell B2.

Accepted Answer

A) True 
 B)False

Question 7

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Accepted Answer

A)  Home 
B)  Page Layout 
C)  Insert 
D)  View 
A)  Home 
B)  Page Layout 
C)  Insert 
D)  View

Question 8

When you double-click the right border of a column heading, which of the following occurs ?

Accepted Answer

A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry. 
A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry.

Question 9

Fred created a template named Revenue.xltx. What is the name of the that opens when he double-clicks Revenue.xltx for the first time?

Accepted Answer

A)  NewRevenue.xlsx 
B)  Revenue1.xlsx 
C)  Revenue.xltx 
D)  Revenue1.xltx 
A)  NewRevenue.xlsx 
B)  Revenue1.xlsx 
C)  Revenue.xltx 
D)  Revenue1.xltx

Question 10

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu. What is the result

Accepted Answer

A)  The Benefits worksheet is hidden 
B)  The workbook window is hidden 
C)  All the worksheets are password-protected 
D)  The Benefits worksheet is locked 
A)  The Benefits worksheet is hidden 
B)  The workbook window is hidden 
C)  All the worksheets are password-protected 
D)  The Benefits worksheet is locked

Question 11

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Accepted Answer

A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook. 
A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook.

Question 12

Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?

Accepted Answer

A)  Change the number format of the data labels to Currency. 
B)  Change the number format of the source data to Currency. 
C)  Change the placement of the data labels to Best Fit. 
D)  Change the Value setting to Currency. 
A)  Change the number format of the data labels to Currency. 
B)  Change the number format of the source data to Currency. 
C)  Change the placement of the data labels to Best Fit. 
D)  Change the Value setting to Currency.

Question 13

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is not a way to move cell contents?

Accepted Answer

A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop 
A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop

Question 15

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

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 16

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 17

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Accepted Answer

A) True 
 B)False

Question 18

You can move the PivotTable Fields pane, but you cannot hide it.

Accepted Answer

A) True 
 B)False

Question 19

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

Accepted Answer

A) True 
 B)False

Question 20

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

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Which of the following can you do to decrease the level of a SmartArt shape?

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

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

How can you tell if Solver is activated in your version of Excel?

Maria entered three option buttons in a column on a worksheet and linked them to cell B2. When a user clicks the second option button, Excel inserts "2" in cell B2.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

When you double-click the right border of a column heading, which of the following occurs ?

Fred created a template named Revenue.xltx. What is the name of the that opens when he double-clicks Revenue.xltx for the first time?

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu. What is the result

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Which of the following is not a way to move cell contents?

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

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

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

You can move the PivotTable Fields pane, but you cannot hide it.

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

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

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Which of the following can you do to decrease the level of a SmartArt shape?

A chart is a type of table that is not located in a specific cell or range, letting you copy and move it without affecting formulas or data in the worksheet.

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

How can you tell if Solver is activated in your version of Excel?

Maria entered three option buttons in a column on a worksheet and linked them to cell B2. When a user clicks the second option button, Excel inserts "2" in cell B2.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

When you double-click the right border of a column heading, which of the following occurs ?

Fred created a template named Revenue.xltx. What is the name of the that opens when he double-clicks Revenue.xltx for the first time?

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu. What is the result

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Charlie created a pie chart that displays number values in data labels. How can he change the values to show dollar amounts?

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Which of the following is not a way to move cell contents?

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

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

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

You can move the PivotTable Fields pane, but you cannot hide it.

To use the Track Changes feature, you can add the Track Changes button to the ribbon using the Track changes (Legacy) command.

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

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters