Question 1

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is true when you delete a cell?

Accepted Answer

A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab. 
A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab.

Question 3

By default, Excel records which type of cell references in a macro?

Accepted Answer

A)  absolute 
B)  relative 
C)  mixed 
D)  hidden 
A)  absolute 
B)  relative 
C)  mixed 
D)  hidden

Question 4

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Accepted Answer

A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button 
A)  Shape Fill 
B)  Shape Effects 
C)  Shape Outline 
D)  More button

Question 5

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 6

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Accepted Answer

A) True 
 B)False

Question 7

Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?

Accepted Answer

A)  Add a border. 
B)  Apply a shape effect. 
C)  Decrease the decimal places shown on each axis. 
D)  Increase the font size. 
A)  Add a border. 
B)  Apply a shape effect. 
C)  Decrease the decimal places shown on each axis. 
D)  Increase the font size.

Question 8

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Accepted Answer

A)  '=IF(B2>=60, "Pass", "Fail") 
B)  =IF(B2 
C)  =IF(B2 = 60, "Pass", "Fail") 
D)  =IFERROR(IF((B2 >= 60, "Pass", "Fail")) 
A)  '=IF(B2>=60, "Pass", "Fail") 
B)  =IF(B2 
C)  =IF(B2 = 60, "Pass", "Fail") 
D)  =IFERROR(IF((B2 >= 60, "Pass", "Fail"))

Question 9

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?

Accepted Answer

A)  Switch the rows and columns. 
B)  Apply a Quick Layout. 
C)  Select the data series and then press DEL. 
D)  Right-click the data series and then click Hide. 
A)  Switch the rows and columns. 
B)  Apply a Quick Layout. 
C)  Select the data series and then press DEL. 
D)  Right-click the data series and then click Hide.

Question 10

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

Accepted Answer

A) True 
 B)False

Question 11

A _____ is a graphic object you can use to filter data in a PivotTable.

Accepted Answer

A)  Field list 
B)  Filter list 
C)  Slicer 
D)  Driller 
A)  Field list 
B)  Filter list 
C)  Slicer 
D)  Driller

Question 12

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

Accepted Answer

A) True 
 B)False

Question 13

To show a comment attached to the active cell, move the pointer over the cell.

Accepted Answer

A) True 
 B)False

Question 14

A one-input data table shows the result of varying one input value.

Accepted Answer

A) True 
 B)False

Question 15

An error message is displayed in cell B10 of Paul's worksheet. If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

Accepted Answer

A)  precedents 
B)  scope 
C)  inconsistencies 
D)  constraints 
A)  precedents 
B)  scope 
C)  inconsistencies 
D)  constraints

Question 16

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 17

Luke is working with a table filtered to show only some records. What can he do to display all the records in the table?

Accepted Answer

A)  Reapply the filter. 
B)  Clear the filter. 
C)  Change the table format. 
D)  Apply a new filter. 
A)  Reapply the filter. 
B)  Clear the filter. 
C)  Change the table format. 
D)  Apply a new filter.

Question 18

You can use an XML map to import and export PDF data, a format often used for storing and exchanging data.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following Excel features do you use to highlight the cells used to calculate a formula?

Accepted Answer

A)  Data Validation 
B)  Trace Error 
C)  Watch window 
D)  Scenario Manager 
A)  Data Validation 
B)  Trace Error 
C)  Watch window 
D)  Scenario Manager

Question 20

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she do?

Accepted Answer

A)  Mark as the workbook as final. 
B)  Encrypt the workbook with a password. 
C)  Protect the current sheet. 
D)  Protect the workbook structure. 
A)  Mark as the workbook as final. 
B)  Encrypt the workbook with a password. 
C)  Protect the current sheet. 
D)  Protect the workbook structure.

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

Which of the following is true when you delete a cell?

By default, Excel records which type of cell references in a macro?

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

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?

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

A _____ is a graphic object you can use to filter data in a PivotTable.

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

To show a comment attached to the active cell, move the pointer over the cell.

A one-input data table shows the result of varying one input value.

An error message is displayed in cell B10 of Paul's worksheet. If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

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

Luke is working with a table filtered to show only some records. What can he do to display all the records in the table?

You can use an XML map to import and export PDF data, a format often used for storing and exchanging data.

Which of the following Excel features do you use to highlight the cells used to calculate a formula?

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she do?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

Which of the following is true when you delete a cell?

By default, Excel records which type of cell references in a macro?

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

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?

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

Ben moved a chart to a chart sheet, but now the axis labels are too small. What can he do to make them easier to read?

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Dana created a column chart showing four quarters of data, but she no longer wants to display the Quarter 1 data series. How can she quickly remove it?

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

A _____ is a graphic object you can use to filter data in a PivotTable.

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

To show a comment attached to the active cell, move the pointer over the cell.

A one-input data table shows the result of varying one input value.

An error message is displayed in cell B10 of Paul's worksheet. If he traces the formula _____, he can identify the cells that contribute to the formula in cell B10.

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

Luke is working with a table filtered to show only some records. What can he do to display all the records in the table?

You can use an XML map to import and export PDF data, a format often used for storing and exchanging data.

Which of the following Excel features do you use to highlight the cells used to calculate a formula?

Loralie wants to protect her Excel spreadsheet using a password to prevent others from accessing data in it. What should she do?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters