Question 1

To view a worksheet without headers, margins, and rulers, use Page Layout view.

Accepted Answer

A) True 
 B)False

Question 2

How can you add a record to the end of a table?

Accepted Answer

A)  Click the last cell of the table and then press ENTER. 
B)  lick the Insert arrow in the Cells group and then click Add Row to End of Table. 
C)  Type data directly below the last row of the table. 
D)  Click the last cell of the table and then press DOWN ARROW. 
A)  Click the last cell of the table and then press ENTER. 
B)  lick the Insert arrow in the Cells group and then click Add Row to End of Table. 
C)  Type data directly below the last row of the table. 
D)  Click the last cell of the table and then press DOWN ARROW.

Question 3

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 4

Applying a layout to a PivotChart using the Quick Layout button does not affect the layout of the corresponding PivotTable.

Accepted Answer

A) True 
 B)False

Question 5

Before importing data into Excel, you can use the Power Query Editor to remove columns.

Accepted Answer

A) True 
 B)False

Question 6

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 
A)  INDEX 
B)  MATCH 
C)  LOOKUP 
D)  ARRAY

Question 7

You can change the language used in the Thesaurus and Spelling features.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

Accepted Answer

A)  MINUTE(G5) 
B)  =MINUTE(G5) 
C)  =MINUTE("10:00:56") 
D)  MINUTE("10:00:56") 
A)  MINUTE(G5) 
B)  =MINUTE(G5) 
C)  =MINUTE("10:00:56") 
D)  MINUTE("10:00:56")

Question 9

Which of the following buttons lets you remove chart elements?

Accepted Answer

A)  Chart Elements button 
B)  Chart Styles button 
C)  Chart Filters button 
D)  Edit Data button 
A)  Chart Elements button 
B)  Chart Styles button 
C)  Chart Filters button 
D)  Edit Data button

Question 10

To find the largest value in a cell range, use the MIN function.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Accepted Answer

A) True 
 B)False

Question 13

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

Accepted Answer

A) True 
 B)False

Question 14

Soledad is working with a worksheet that groups data by quarter. The Quarter 4 details are hidden. She can click the Auto Outline button to display the hidden data.

Accepted Answer

A) True 
 B)False

Question 15

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 16

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

Accepted Answer

A) True 
 B)False

Question 17

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Accepted Answer

A) True 
 B)False

Question 18

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

Accepted Answer

A)  Reset All Page Breaks 
B)  Remove Page Break 
C)  Reset Current Page Break 
D)  Move Page Break 
A)  Reset All Page Breaks 
B)  Remove Page Break 
C)  Reset Current Page Break 
D)  Move Page Break

Question 19

Which of the following items does the Document Inspector check for sensitive information?

Accepted Answer

A)  Formulas 
B)  Tables 
C)  Cell Styles 
D)  Document properties 
A)  Formulas 
B)  Tables 
C)  Cell Styles 
D)  Document properties

Question 20

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Accepted Answer

A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete 
A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete

To view a worksheet without headers, margins, and rulers, use Page Layout view.

How can you add a record to the end of a table?

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

Applying a layout to a PivotChart using the Quick Layout button does not affect the layout of the corresponding PivotTable.

Before importing data into Excel, you can use the Power Query Editor to remove columns.

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

You can change the language used in the Thesaurus and Spelling features.

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

Which of the following buttons lets you remove chart elements?

To find the largest value in a cell range, use the MIN function.

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

To change the contents of a macro, you must use the Record Macro button to step into the macro.

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

Soledad is working with a worksheet that groups data by quarter. The Quarter 4 details are hidden. She can click the Auto Outline button to display the hidden data.

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

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

Which of the following items does the Document Inspector check for sensitive information?

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

To view a worksheet without headers, margins, and rulers, use Page Layout view.

How can you add a record to the end of a table?

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

Applying a layout to a PivotChart using the Quick Layout button does not affect the layout of the corresponding PivotTable.

Before importing data into Excel, you can use the Power Query Editor to remove columns.

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

You can change the language used in the Thesaurus and Spelling features.

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

Which of the following buttons lets you remove chart elements?

To find the largest value in a cell range, use the MIN function.

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

To change the contents of a macro, you must use the Record Macro button to step into the macro.

To edit a comment in a cell, move the pointer over the cell, and then click Edit in the Comment box.

Soledad is working with a worksheet that groups data by quarter. The Quarter 4 details are hidden. She can click the Auto Outline button to display the hidden data.

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

To search for a picture in the Online Pictures dialog box, you enter a format related to your subject of interest .

To provide suggestions to other people using a worksheet, select the cell you want to comment on, then click New Comment on the Review tab and type your comment.

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

Which of the following items does the Document Inspector check for sensitive information?

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters