Question 1

One can use Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in table changes.

Accepted Answer

A) True 
 B)False

Question 2

You double-click the Format Painter button when you want to _____.

Accepted Answer

A)  copy a cell's data to another cell 
B)  paste the same format multiple times 
C)  paste conditional formatting only 
D)  clear a cell's formatting

Question 3

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Accepted Answer

A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function.

Question 4

Colin wants to apply a Quick Style to a SmartArt graphic. To do so, he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice. Which of these can X be in the following series of clicks?

Accepted Answer

A)  Insert tab 
B)  Format tab 
C)  Design tab 
D)  Review tab

Question 5

If you are working with scenarios on one worksheet, you can merge scenarios from other worksheets or workbooks.

Accepted Answer

A) True 
 B)False

Question 6

To illustrate different data levels using small graphics representing values, which of the following can you use?

Accepted Answer

A)  icon sets 
B)  data bars 
C)  Highlight Cells Rules 
D)  color scales

Question 7

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?

Accepted Answer

A)  Icon Sets 
B)  Color Scales 
C)  Data Bars 
D)  Highlight Cells Rules

Question 9

You can create conditional cell formats using either the Home tab or the _____.

Accepted Answer

A)  Quick Analysis tool 
B)  Cell Styles dialog box 
C)  Font formatting buttons on the Home tab 
D)  Number formatting buttons on the Home tab

Question 10

When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.

Accepted Answer

A)  copy 
B)  paste 
C)  cut 
D)  move

Question 11

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Accepted Answer

A)  Calculate Now 
B)  Calculate Sheet 
C)  Watch Window 
D)  Calculation Options

Question 12

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Accepted Answer

A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators

Question 13

Because loading data from a query creates a snapshot of the data, you need to _____ the connection if the values in the data source change.

Accepted Answer

A)  freeze 
B)  save 
C)  refresh 
D)  delete

Question 14

To select a single worksheet cell so you can work with it, which of the following would you do?

Accepted Answer

A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box.

Question 15

The _____ function returns the value from a range of data at the intersection of a specified row and column.

Accepted Answer

A)  INDEX 
B)  MATCH 
C)  LOOKUP 
D)  ARRAY

Question 16

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

Accepted Answer

A)  AutoSum list 
B)  AutoFill Options button 
C)  Paste Options button 
D)  Quick Analysis

Question 18

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

Question 19

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

Accepted Answer

A)  =ROUND(A5,2) 
B)  =MROUND(A5,2) 
C)  =ROUND(A5,2.0) 
D)  =MROUND(A5,0.2)

Question 20

You can edit cell contents in the formula bar or in the cell itself.

Accepted Answer

A) True 
 B)False

Exam 2: Excel 2019

One can use Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in table changes.

You double-click the Format Painter button when you want to _____.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Colin wants to apply a Quick Style to a SmartArt graphic. To do so, he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice. Which of these can X be in the following series of clicks?

If you are working with scenarios on one worksheet, you can merge scenarios from other worksheets or workbooks.

To illustrate different data levels using small graphics representing values, which of the following can you use?

To delete a scenario, open the Scenario Manager dialog box, select the scenario, and then click the Delete button.

Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?

You can create conditional cell formats using either the Home tab or the _____.

When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Because loading data from a query creates a snapshot of the data, you need to _____ the connection if the values in the data source change.

To select a single worksheet cell so you can work with it, which of the following would you do?

The _____ function returns the value from a range of data at the intersection of a specified row and column.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

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

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

You can edit cell contents in the formula bar or in the cell itself.