Question 1

In VBA, macros are stored in blocks of code called sub procedures.

Accepted Answer

A) True 
 B)False

Question 2

The DB function calculates declining balance depreciation.

Accepted Answer

A) True 
 B)False

Question 3

An advantage of the _____ PivotTable layout is that it reduces the width of the PivotTable by placing all fields from the Rows area in one column.

Accepted Answer

A)  Outline 
B)  Compact 
C)  Tabular 
D)  Subtotals 
A)  Outline 
B)  Compact 
C)  Tabular 
D)  Subtotals

Question 4

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

Accepted Answer

A) True 
 B)False

Question 5

Misha wants to set the brightness of a picture to 40% and contrast to 20%. She clicks the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools. What should she select from the drop-down menu that appears on clicking Corrections and then select the thumbnail that fulfils her purpose?

Accepted Answer

A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast 
A)  Color Tone 
B)  Sharpen/Soften 
C)  Color Saturation 
D)  Brightness/Contrast

Question 6

Laurence created a workbook with macros designed to save users time. However, he does not want users to use the ribbon to run the macros. What can he do instead?

Accepted Answer

A)  Convert the macros to hyperlinks., 
B)  Assign the macros to shapes. 
C)  List the macros on a password-protected worksheet. 
D)  Assign voice commands to the macros. 
A)  Convert the macros to hyperlinks., 
B)  Assign the macros to shapes. 
C)  List the macros on a password-protected worksheet. 
D)  Assign voice commands to the macros.

Question 7

To edit a comment in a cell, select the cell that contains the comment, right-click on it and select the Edit Comment option from the menu.

Accepted Answer

A) True 
 B)False

Question 8

Which formula auditing tool can you use to display the value of each part of a formula?

Accepted Answer

A)  Trace Precedents 
B)  Trace Dependents 
C)  Evaluate Formula dialog box 
D)  Formula Validation 
A)  Trace Precedents 
B)  Trace Dependents 
C)  Evaluate Formula dialog box 
D)  Formula Validation

Question 9

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Accepted Answer

A) True 
 B)False

Question 10

To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is an acceptable name for a range in Excel?

Accepted Answer

A)  Net-Income 
B)  Profit! 
C)  _TotalExpenses 
D)  Average 
A)  Net-Income 
B)  Profit! 
C)  _TotalExpenses 
D)  Average

Question 12

To locate duplicate values in a selected range, start by clicking the Duplicate Formatting button on the Home tab.

Accepted Answer

A) True 
 B)False

Question 13

When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.

Accepted Answer

A) True 
 B)False

Question 14

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Accepted Answer

A)  reverse 
B)  transpose 
C)  fill 
D)  merge 
A)  reverse 
B)  transpose 
C)  fill 
D)  merge

Question 15

The Percent style formats numbers as percentages with _____ decimal places by default.

Accepted Answer

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

Question 16

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

Accepted Answer

A)  "Match not found" message 
B)  #N/A error value 
C)  FALSE 
D)  #NAME error value 
A)  "Match not found" message 
B)  #N/A error value 
C)  FALSE 
D)  #NAME error value

Question 17

When Kai right-clicks a sheet tab in a workbook, some commands on the shortcut menu are gray. That means the worksheet is hidden.

Accepted Answer

A) True 
 B)False

Question 18

You can edit several worksheets at the same time by outlining the worksheets.

Accepted Answer

A) True 
 B)False

Question 19

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Accepted Answer

A)  Normal view 
B)  Page Layout view 
C)  Page Break Preview 
D)  Print Preview 
A)  Normal view 
B)  Page Layout view 
C)  Page Break Preview 
D)  Print Preview

Question 20

The CUMIPMT function has the syntax CUMIPMT(Rate, Nper, Pv, Start, End, Type). What do you enter for the Type argument?

Accepted Answer

A)  Enter the number of payment periods. 
B)  Enter 0 if payments are made at the end of the period, or enter 1 if payments are made at the start. 
C)  Enter the interest rate of the loan or investment. 
D)  Enter the starting and ending payment periods. 
A)  Enter the number of payment periods. 
B)  Enter 0 if payments are made at the end of the period, or enter 1 if payments are made at the start. 
C)  Enter the interest rate of the loan or investment. 
D)  Enter the starting and ending payment periods.

In VBA, macros are stored in blocks of code called sub procedures.

The DB function calculates declining balance depreciation.

An advantage of the _____ PivotTable layout is that it reduces the width of the PivotTable by placing all fields from the Rows area in one column.

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

Laurence created a workbook with macros designed to save users time. However, he does not want users to use the ribbon to run the macros. What can he do instead?

To edit a comment in a cell, select the cell that contains the comment, right-click on it and select the Edit Comment option from the menu.

Which formula auditing tool can you use to display the value of each part of a formula?

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign.

Which of the following is an acceptable name for a range in Excel?

To locate duplicate values in a selected range, start by clicking the Duplicate Formatting button on the Home tab.

When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

The Percent style formats numbers as percentages with _____ decimal places by default.

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

When Kai right-clicks a sheet tab in a workbook, some commands on the shortcut menu are gray. That means the worksheet is hidden.

You can edit several worksheets at the same time by outlining the worksheets.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

The CUMIPMT function has the syntax CUMIPMT(Rate, Nper, Pv, Start, End, Type). What do you enter for the Type argument?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

In VBA, macros are stored in blocks of code called sub procedures.

The DB function calculates declining balance depreciation.

An advantage of the _____ PivotTable layout is that it reduces the width of the PivotTable by placing all fields from the Rows area in one column.

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

Laurence created a workbook with macros designed to save users time. However, he does not want users to use the ribbon to run the macros. What can he do instead?

To edit a comment in a cell, select the cell that contains the comment, right-click on it and select the Edit Comment option from the menu.

Which formula auditing tool can you use to display the value of each part of a formula?

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign.

Which of the following is an acceptable name for a range in Excel?

To locate duplicate values in a selected range, start by clicking the Duplicate Formatting button on the Home tab.

When you set up worksheet protection, you specify which actions users are allowed to perform in the protected sheet.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

The Percent style formats numbers as percentages with _____ decimal places by default.

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

When Kai right-clicks a sheet tab in a workbook, some commands on the shortcut menu are gray. That means the worksheet is hidden.

You can edit several worksheets at the same time by outlining the worksheets.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

The CUMIPMT function has the syntax CUMIPMT(Rate, Nper, Pv, Start, End, Type). What do you enter for the Type argument?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters