Question 1

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following Excel features finds a numeric solution to a problem involving several input values?

Accepted Answer

A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek 
A)  Solver 
B)  PivotTable 
C)  one-variable data table 
D)  Goal Seek

Question 3

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

Accepted Answer

A) True 
 B)False

Question 4

A _____ is the appearance and shape of letters, numbers, and special characters.

Accepted Answer

A)  symbol 
B)  font 
C)  point 
D)  keyword 
A)  symbol 
B)  font 
C)  point 
D)  keyword

Question 5

Which of the following functions can you use to locate information in a table?

Accepted Answer

A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP 
A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP

Question 6

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

Accepted Answer

A)  WordArt 
B)  Screenshot 
C)  Picture 
D)  SmartArt 
A)  WordArt 
B)  Screenshot 
C)  Picture 
D)  SmartArt

Question 7

Charlie created a pie chart that displays number values in data labels.How can he change the values to show dollar amounts?

Accepted Answer

A)  Change the number format of the data labels to Currency. 
B)  Change the number format of the source data to Currency. 
C)  Change the placement of the data labels to Best Fit. 
D)  Change the Value setting to Currency. 
A)  Change the number format of the data labels to Currency. 
B)  Change the number format of the source data to Currency. 
C)  Change the placement of the data labels to Best Fit. 
D)  Change the Value setting to Currency.

Question 8

Which of the following methods copies an existing worksheet within the same workbook?

Accepted Answer

A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location. 
A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location.

Question 9

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Accepted Answer

A) True 
 B)False

Question 10

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following can you apply to change the fill of a data series? Select all the options that apply.

Accepted Answer

A)  Texture 
B)  Color 
C)  WordArt 
D)  Shape style 
A)  Texture 
B)  Color 
C)  WordArt 
D)  Shape style

Question 12

How can you create a single PivotTable to analyze data from two tables?

Accepted Answer

A)  Create the PivotTable using Power Pivot. 
B)  Use the same name for each table. 
C)  Create a measure to link the tables. 
D)  Group the tables. 
A)  Create the PivotTable using Power Pivot. 
B)  Use the same name for each table. 
C)  Create a measure to link the tables. 
D)  Group the tables.

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

What happens when you drag a table's sizing handle to the right?

Accepted Answer

A)  You add a column to the table. 
B)  You delete a column from the table. 
C)  You increase the width of the table without adding columns. 
D)  You add a row to the end of the table. 
A)  You add a column to the table. 
B)  You delete a column from the table. 
C)  You increase the width of the table without adding columns. 
D)  You add a row to the end of the table.

Question 15

The spell checker flags your company's name as a misspelling.Which of the following will stop the spell checker from flagging later occurrences in the document?

Accepted Answer

A)  Change All 
B)  Change 
C)  Ignore Once 
D)  Ignore All 
A)  Change All 
B)  Change 
C)  Ignore Once 
D)  Ignore All

Question 16

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

Accepted Answer

A)  Column chart 
B)  Line chart 
C)  Pie chart 
D)  Area chart 
A)  Column chart 
B)  Line chart 
C)  Pie chart 
D)  Area chart

Question 17

If you turn on the Track Changes legacy feature, it can keep track of editing changes made in a workbook.

Accepted Answer

A) True 
 B)False

Question 18

When you want to know the position of an item in a range, you can use the LOOKUP function.

Accepted Answer

A) True 
 B)False

Question 19

When you switch rows and columns in a chart, Excel updates the legend at the same time.

Accepted Answer

A) True 
 B)False

Question 20

What can you do to share a workbook with other Office 365 users only?

Accepted Answer

A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive. 
A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive.

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

A _____ is the appearance and shape of letters, numbers, and special characters.

Which of the following functions can you use to locate information in a table?

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

Charlie created a pie chart that displays number values in data labels.How can he change the values to show dollar amounts?

Which of the following methods copies an existing worksheet within the same workbook?

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

Which of the following can you apply to change the fill of a data series? Select all the options that apply.

How can you create a single PivotTable to analyze data from two tables?

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

What happens when you drag a table's sizing handle to the right?

The spell checker flags your company's name as a misspelling.Which of the following will stop the spell checker from flagging later occurrences in the document?

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

If you turn on the Track Changes legacy feature, it can keep track of editing changes made in a workbook.

When you want to know the position of an item in a range, you can use the LOOKUP function.

When you switch rows and columns in a chart, Excel updates the legend at the same time.

What can you do to share a workbook with other Office 365 users only?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

To remove duplicate values from an Excel worksheet, click the Remove Duplicates button in the Data Tools group on the Data tab.

Which of the following Excel features finds a numeric solution to a problem involving several input values?

To check your workbook for features that assist people with disabilities, you can use the Ability Checker.

A _____ is the appearance and shape of letters, numbers, and special characters.

Which of the following functions can you use to locate information in a table?

What can you insert to communicate information as a collection of shapes arranged in a list or cycle?

Charlie created a pie chart that displays number values in data labels.How can he change the values to show dollar amounts?

Which of the following methods copies an existing worksheet within the same workbook?

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

Which of the following can you apply to change the fill of a data series? Select all the options that apply.

How can you create a single PivotTable to analyze data from two tables?

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

What happens when you drag a table's sizing handle to the right?

The spell checker flags your company's name as a misspelling.Which of the following will stop the spell checker from flagging later occurrences in the document?

Which type of chart would you create to compare expenses in each department as a percentage of all expenses?

If you turn on the Track Changes legacy feature, it can keep track of editing changes made in a workbook.

When you want to know the position of an item in a range, you can use the LOOKUP function.

When you switch rows and columns in a chart, Excel updates the legend at the same time.

What can you do to share a workbook with other Office 365 users only?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters