Question 1

What is the default number of days for Excel change history?

Accepted Answer

A)  15 
B)  30 
C)  60 
D)  90 
A)  15 
B)  30 
C)  60 
D)  90 B

Question 2

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

Accepted Answer

A)  Excel places them on the Clipboard. 
B)  Excel changes the cell references in the copied formula to reflect the new location of the formula. 
C)  Excel bolds the cell references so you can change them. 
D)  Excel displays a button near the copied cell with options for handling the cell references. 
A)  Excel places them on the Clipboard. 
B)  Excel changes the cell references in the copied formula to reflect the new location of the formula. 
C)  Excel bolds the cell references so you can change them. 
D)  Excel displays a button near the copied cell with options for handling the cell references. B

Question 3

Rohan can display the current date in a cell using the TODAY() function.

Accepted Answer

A) True 
 B)False  True

Question 4

Where do you rename a workbook and adjust its save location?

Accepted Answer

A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell 
A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell

Question 5

Use a sunburst chart to track the addition and subtraction of values in a sum.

Accepted Answer

A) True 
 B)False

Question 6

Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook?

Accepted Answer

A)  Observe Formula dialog box 
B)  Show Formulas command 
C)  Watch Window 
D)  Automatic Update Window 
A)  Observe Formula dialog box 
B)  Show Formulas command 
C)  Watch Window 
D)  Automatic Update Window

Question 7

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

Accepted Answer

A)  IFERROR 
B)  VLOOKUP 
C)  IF 
D)  RAND 
A)  IFERROR 
B)  VLOOKUP 
C)  IF 
D)  RAND

Question 8

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

Accepted Answer

A) True 
 B)False

Question 9

To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.

Accepted Answer

A) True 
 B)False

Question 10

How do you change the placeholder text that appears on a selected form control?

Accepted Answer

A)  Type the new text. 
B)  Open the Properties dialog box for the control and then change the Title text. 
C)  Link the control to a cell containing the new text. 
D)  Switch to Design mode and then type the new text. 
A)  Type the new text. 
B)  Open the Properties dialog box for the control and then change the Title text. 
C)  Link the control to a cell containing the new text. 
D)  Switch to Design mode and then type the new text.

Question 11

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

Accepted Answer

A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape. 
A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape.

Question 12

Lucy is creating a Solver model to determine the lowest total expenses she would incur producing 10,000 helmets. Where should she specify the limit of 10,000 helmets in the Solver Parameters dialog box?

Accepted Answer

A)  Set Objective box 
B)  By Changing Variable Cells box 
C)  Subject to the Constraints box 
D)  Load/Save box 
A)  Set Objective box 
B)  By Changing Variable Cells box 
C)  Subject to the Constraints box 
D)  Load/Save box

Question 13

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Accepted Answer

A) True 
 B)False

Question 14

Use Goal Seek to specify an output value and work backward to find the input value needed to reach that goal.

Accepted Answer

A) True 
 B)False

Question 15

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 16

To paste only a copied cell's formats, use the Paste Special command.

Accepted Answer

A) True 
 B)False

Question 17

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

Accepted Answer

A) True 
 B)False

Question 18

A scenario is a defined collection of changing cells used to perform a what-if analysis.

Accepted Answer

A) True 
 B)False

Question 19

A Line sparkline displays a green block for increasing values and a red block for declining values.

Accepted Answer

A) True 
 B)False

Question 20

How can you remove the split bars from a worksheet?

Accepted Answer

A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group. 
A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group.

What is the default number of days for Excel change history?

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

Rohan can display the current date in a cell using the TODAY() function.

Where do you rename a workbook and adjust its save location?

Use a sunburst chart to track the addition and subtraction of values in a sum.

Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook?

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.

How do you change the placeholder text that appears on a selected form control?

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

Lucy is creating a Solver model to determine the lowest total expenses she would incur producing 10,000 helmets. Where should she specify the limit of 10,000 helmets in the Solver Parameters dialog box?

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Use Goal Seek to specify an output value and work backward to find the input value needed to reach that goal.

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

To paste only a copied cell's formats, use the Paste Special command.

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

A scenario is a defined collection of changing cells used to perform a what-if analysis.

A Line sparkline displays a green block for increasing values and a red block for declining values.

How can you remove the split bars from a worksheet?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

What is the default number of days for Excel change history?

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

Rohan can display the current date in a cell using the TODAY() function.

Where do you rename a workbook and adjust its save location?

Use a sunburst chart to track the addition and subtraction of values in a sum.

Samira has a workbook containing many worksheets with interconnected formulas. What can she use to display the values of specified cells located throughout the workbook?

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.

How do you change the placeholder text that appears on a selected form control?

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

Lucy is creating a Solver model to determine the lowest total expenses she would incur producing 10,000 helmets. Where should she specify the limit of 10,000 helmets in the Solver Parameters dialog box?

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Use Goal Seek to specify an output value and work backward to find the input value needed to reach that goal.

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

To paste only a copied cell's formats, use the Paste Special command.

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

A scenario is a defined collection of changing cells used to perform a what-if analysis.

A Line sparkline displays a green block for increasing values and a red block for declining values.

How can you remove the split bars from a worksheet?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters