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

Question 2

Which of the following options can you use to increase the level of a SmartArt shape?

Accepted Answer

A)  Promote 
B)  Demote 
C)  Level Up 
D)  Larger

Question 3

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?

Accepted Answer

A)  Switch the rows and columns. 
B)  Apply a Quick Layout. 
C)  Select the data series and then press DEL. 
D)  Right-click the data series and then click Hide.

Question 4

The rows of Jonathan's PivotTable display store details for each quarter. To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area.

Accepted Answer

A) True 
 B)False

Question 5

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

Accepted Answer

A)  =DAY(A1) 
B)  =DAY("A1'') 
C)  =DATE(DAY(A1)) 
D)  =DATE("DAY"(A1))

Question 6

Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?

Accepted Answer

A)  HOUR(A1) 
B)  =HOUR(A1) 
C)  =HOUR("12:00:56") 
D)  HOUR("12:00:56")

Question 7

Which of the following lets you edit the contents of a cell?

Accepted Answer

A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar.

Question 8

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

Accepted Answer

A) True 
 B)False

Question 9

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Accepted Answer

A) True 
 B)False

Question 10

Filtering a PivotChart does not affect the corresponding PivotTable.

Accepted Answer

A) True 
 B)False

Question 11

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

Accepted Answer

A) True 
 B)False

Question 12

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

Accepted Answer

A) True 
 B)False

Question 13

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she do?

Accepted Answer

A)  Mark as the workbook as final. 
B)  Encrypt the workbook with a password. 
C)  Protect the current sheet. 
D)  Protect the workbook structure.

Question 14

Which Command Button property is used to internally reference the button?

Accepted Answer

A)  Caption 
B)  Name 
C)  Identifier 
D)  Description

Question 15

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

Accepted Answer

A) True 
 B)False

Question 16

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.

Question 17

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

Accepted Answer

A)  Top Values filter 
B)  Advanced filter 
C)  Logical filter 
D)  Multicolumn filter

Question 18

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

Accepted Answer

A)  Replace 
B)  Find 
C)  Select 
D)  Paste

Question 19

Which of the following is true of the Excel spell checker?

Accepted Answer

A)  You can change all instances of a flagged word to a selected suggestion. 
B)  You cannot add words to the spell checker dictionary. 
C)  You must accept all spell checker suggested replacement words. 
D)  For multiple instances of a misspelled word, you must change each one individually.

Question 20

Which of the following methods copies an existing worksheet within the same workbook?

Accepted Answer

A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location.

Exam 2: Excel 2019

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

Which of the following options can you use to increase the level of a SmartArt shape?

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?

The rows of Jonathan's PivotTable display store details for each quarter. To display quarterly details for each store, he can reorder the Store and Quarter fields in the Rows area.

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

Sheila wants to extract the hour from the time, 12:00:56, in cell A1. Which formula can she use to do this?

Which of the following lets you edit the contents of a cell?

You can use the Update Links button on the Data tab to manage links in an Excel workbook.

To retrieve data values from a comma-separated values (CSV) file, you use the From Text/CSV button in the Get & Transform group on the Data tab.

Filtering a PivotChart does not affect the corresponding PivotTable.

To make your workbooks usable by people with disabilities, you can use the Accessibility Checker in Excel.

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she do?

Which Command Button property is used to internally reference the button?

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

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

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

Which of the following is true of the Excel spell checker?

Which of the following methods copies an existing worksheet within the same workbook?