Question 1

After you record a macro, you should _____ it to test the actions it contains.

Accepted Answer

A)  save 
B)  run 
C)  customize 
D)  rename 
A)  save 
B)  run 
C)  customize 
D)  rename

Question 2

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is true about adding cell borders?

Accepted Answer

A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines. 
A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines.

Question 4

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

Accepted Answer

A) True 
 B)False

Question 5

When you open a workbook, it contains one or more worksheets.

Accepted Answer

A) True 
 B)False

Question 6

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

Accepted Answer

A)  Versions 
B)  AutoSave 
C)  Change History 
D)  Compatibility Checker 
A)  Versions 
B)  AutoSave 
C)  Change History 
D)  Compatibility Checker

Question 7

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

Accepted Answer

A)  delete 
B)  conditionally format 
C)  edit 
D)  hide 
A)  delete 
B)  conditionally format 
C)  edit 
D)  hide

Question 8

You can insert WordArt into a worksheet, but not a chart.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following chart types shows the distribution of data grouped in bins?

Accepted Answer

A)  Bin chart 
B)  Waterfall chart 
C)  Treemap chart 
D)  Histogram chart 
A)  Bin chart 
B)  Waterfall chart 
C)  Treemap chart 
D)  Histogram chart

Question 10

What happens when you drag a table's sizing handle to the right?

Accepted Answer

A)  You add a column to the table. 
B)  You delete a column from the table. 
C)  You increase the width of the table without adding columns. 
D)  You add a row to the end of the table. 
A)  You add a column to the table. 
B)  You delete a column from the table. 
C)  You increase the width of the table without adding columns. 
D)  You add a row to the end of the table.

Question 11

The predefined colors in a workbook are called the cell styles.

Accepted Answer

A) True 
 B)False

Question 12

In the formula =B6*$B$2, which of the following describes $B$2?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average

Question 13

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Accepted Answer

A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function. 
A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function.

Question 14

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

Accepted Answer

A)  =MONTH(F5) 
B)  =MONTH("F5") 
C)  =MONTH(TODAY(2016,7,0)) 
D)  =MONTH(DAY(2016,7,0)) 
A)  =MONTH(F5) 
B)  =MONTH("F5") 
C)  =MONTH(TODAY(2016,7,0)) 
D)  =MONTH(DAY(2016,7,0))

Question 15

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 16

Which of the following inserts a function into a cell?

Accepted Answer

A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix 
A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix

Question 17

Alex recorded a macro but needs to change a detail. What can he do instead of recording the macro again?

Accepted Answer

A)  Step into the macro. 
B)  Display formulas instead of data in the macro worksheet. 
C)  Open the Visual Basic Editor to edit the macro code. 
D)  Turn on relative referencing. 
A)  Step into the macro. 
B)  Display formulas instead of data in the macro worksheet. 
C)  Open the Visual Basic Editor to edit the macro code. 
D)  Turn on relative referencing.

Question 18

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

Accepted Answer

A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC 
A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC

Question 19

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

Accepted Answer

A) True 
 B)False

Question 20

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.

After you record a macro, you should _____ it to test the actions it contains.

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Which of the following is true about adding cell borders?

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

When you open a workbook, it contains one or more worksheets.

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

You can insert WordArt into a worksheet, but not a chart.

Which of the following chart types shows the distribution of data grouped in bins?

What happens when you drag a table's sizing handle to the right?

The predefined colors in a workbook are called the cell styles.

In the formula =B6*$B$2, which of the following describes $B$2?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

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?

Which of the following inserts a function into a cell?

Alex recorded a macro but needs to change a detail. What can he do instead of recording the macro again?

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

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?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 2: Excel 2019

After you record a macro, you should _____ it to test the actions it contains.

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Which of the following is true about adding cell borders?

To apply banded columns to a table, select the table, click the Column Fill button, and then click Alternating.

When you open a workbook, it contains one or more worksheets.

If you save an Excel workbook on OneDrive, _____ saves versions of your workbook as you make changes.

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

You can insert WordArt into a worksheet, but not a chart.

Which of the following chart types shows the distribution of data grouped in bins?

What happens when you drag a table's sizing handle to the right?

The predefined colors in a workbook are called the cell styles.

In the formula =B6*$B$2, which of the following describes $B$2?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

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?

Which of the following inserts a function into a cell?

Alex recorded a macro but needs to change a detail. What can he do instead of recording the macro again?

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

Leila has a table listing the number of houses each real estate agent sold, if any, each month. She can use the DCOUNTA function to find the number of agents with sales in June.

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?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters