Question 1

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Accepted Answer

A) True 
 B)False

Question 2

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use. Which option can she select to make the PivotTable more compact?

Accepted Answer

A)  Summarize Values By 
B)  Do Not Show Subtotals 
C)  Change Subtotal Style 
D)  Collapse Subtotals 
A)  Summarize Values By 
B)  Do Not Show Subtotals 
C)  Change Subtotal Style 
D)  Collapse Subtotals

Question 3

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Accepted Answer

A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5 
A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5

Question 4

Which of the following is true about deleting a worksheet row?

Accepted Answer

A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row. 
A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.

Question 5

When you insert a table, it is organized into rows of data called _____.

Accepted Answer

A)  fields 
B)  headers 
C)  records 
D)  bands 
A)  fields 
B)  headers 
C)  records 
D)  bands

Question 6

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

Accepted Answer

A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook. 
A)  Refresh the PivotChart. 
B)  Change the PivotChart layout. 
C)  Change the data source of the PivotChart. 
D)  Update the links in the workbook.

Question 7

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

Accepted Answer

A) True 
 B)False

Question 8

When you cut or copy a cell, it is cut or copied to which of the following?

Accepted Answer

A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard 
A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard

Question 9

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 
A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators

Question 10

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 11

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Accepted Answer

A) True 
 B)False

Question 12

How can you remove the split panes 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.

Question 13

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Accepted Answer

A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle 
A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle

Question 14

A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

Accepted Answer

A)  =IF(B2>=60, C2>=60) 
B)  =OR(B2>=60, C2>=60) 
C)  =AND(B2>=60, C2>=60) 
D)  =NOT(OR(B2>=60, C2>=60)) 
A)  =IF(B2>=60, C2>=60) 
B)  =OR(B2>=60, C2>=60) 
C)  =AND(B2>=60, C2>=60) 
D)  =NOT(OR(B2>=60, C2>=60))

Question 15

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 16

You can use Forecast Sheet to project future data based on past trends.

Accepted Answer

A) True 
 B)False

Question 17

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following objects contains VBA code that determines its behavior?

Accepted Answer

A)  Form control 
B)  ActiveX command button 
C)  Shape from the Shapes gallery 
D)  Icon from the Icons gallery 
A)  Form control 
B)  ActiveX command button 
C)  Shape from the Shapes gallery 
D)  Icon from the Icons gallery

Question 19

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

Accepted Answer

A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table 
A)  macro, 
B)  Flash Fill list 
C)  custom AutoFill list 
D)  Quick Table

Question 20

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

Accepted Answer

A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page 
A)  Rows to repeat at the top of the worksheet 
B)  Print area to select 
C)  Columns to repeat at the left of the worksheet 
D)  Amount to rotate the titles so they fit on the page

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use. Which option can she select to make the PivotTable more compact?

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Which of the following is true about deleting a worksheet row?

When you insert a table, it is organized into rows of data called _____.

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

When you cut or copy a cell, it is cut or copied to which of the following?

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

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

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

How can you remove the split panes from a worksheet?

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

You can use Forecast Sheet to project future data based on past trends.

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

Which of the following objects contains VBA code that determines its behavior?

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

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

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

The subtotals in Chastity's PivotTable make the PivotTable too large and difficult to use. Which option can she select to make the PivotTable more compact?

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Which of the following is true about deleting a worksheet row?

When you insert a table, it is organized into rows of data called _____.

If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?

In the Visual Basic Editor, comments appear in green and begin with an apostrophe.

When you cut or copy a cell, it is cut or copied to which of the following?

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

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

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

How can you remove the split panes from a worksheet?

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

A student's scores in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns FALSE if the student has passed and TRUE if the student has failed?

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

You can use Forecast Sheet to project future data based on past trends.

In the VBA Editor, the Code window displays the VBA code of every recorded macro.

Which of the following objects contains VBA code that determines its behavior?

Liam often types the names of the 12 offices where his company does business. He wants to be able to enter the first office name, then drag the fill handle to enter the other office names. What should he create?

Eleanor wants to print the titles that appear in rows 2 and 3 of her worksheet. What does she need to specify in the Page Setup dialog box?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters