Question 1

Leila has a table listing the number of houses each real estate agent sold, if any, each month.She can use the DCOUNTA function to find the number of agents with sales in June.

Accepted Answer

A) True 
 B)False

Question 2

The Comma Style format adds a comma and a dollar sign to a cell value.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following formulas can you use to find the serial number of the date January 1, 2017?

Accepted Answer

A)  '=DATEVALUE(1-Jan-2017) 
B)  =DATEVALUE(01/1/2017) 
C)  =DATEVALUE(1st Jan, 2017) 
D)  =DATEVALUE(''01/1/2017'') 
A)  '=DATEVALUE(1-Jan-2017) 
B)  =DATEVALUE(01/1/2017) 
C)  =DATEVALUE(1st Jan, 2017) 
D)  =DATEVALUE(''01/1/2017'')

Question 4

Sophia has a table with a column named Sales that lists monthly sales data.To sort the column, she can click the Sales filter list arrow and then click Number.

Accepted Answer

A) True 
 B)False

Question 5

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

Accepted Answer

A) True 
 B)False

Question 6

Bertie wants to show data labels inside a text bubble shape.Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

Accepted Answer

A)  Axis Titles 
B)  Chart Titles 
C)  Legend 
D)  Data Labels 
A)  Axis Titles 
B)  Chart Titles 
C)  Legend 
D)  Data Labels

Question 7

When you format a range as a table, which of the following features does Excel apply to the table? Select all the options that apply.

Accepted Answer

A)  Filter list arrows 
B)  Table style 
C)  Equal column widths 
D)  Total row 
A)  Filter list arrows 
B)  Table style 
C)  Equal column widths 
D)  Total row

Question 8

How can you add a new record to a table? Select all the options that apply.

Accepted Answer

A)  Type data directly below the last row of the table. 
B)  Drag the sizing handle in the lower-right corner of the table. 
C)  Click a row, click the Insert arrow in the Cells group, then click Insert Table Rows Above. 
D)  Press ENTER at the end of any row. 
A)  Type data directly below the last row of the table. 
B)  Drag the sizing handle in the lower-right corner of the table. 
C)  Click a row, click the Insert arrow in the Cells group, then click Insert Table Rows Above. 
D)  Press ENTER at the end of any row.

Question 9

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

Accepted Answer

A)  SUM 
B)  COUNT 
C)  MIN 
D)  VAR 
A)  SUM 
B)  COUNT 
C)  MIN 
D)  VAR

Question 10

When you link an object, you can edit the object separately from the source document.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Nathan wants to analyze a range of values that shows the results of changing a single input value in a formula.What should he create?

Accepted Answer

A)  PivotTable 
B)  Histogram 
C)  Power Pivot table 
D)  One-input data table 
A)  PivotTable 
B)  Histogram 
C)  Power Pivot table 
D)  One-input data table

Question 14

When you select a cell range, the cells must be adjacent to each other.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is true of the Excel spell checker?

Accepted Answer

A)  You can change all instances of a flagged word to a selected suggestion. 
B)  You cannot add words to the spell checker dictionary. 
C)  You must accept all spell checker suggested replacement words. 
D)  For multiple instances of a misspelled word, you must change each one individually. 
A)  You can change all instances of a flagged word to a selected suggestion. 
B)  You cannot add words to the spell checker dictionary. 
C)  You must accept all spell checker suggested replacement words. 
D)  For multiple instances of a misspelled word, you must change each one individually.

Question 16

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 17

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

Accepted Answer

A)  =LOWER(D1) 
B)  =PROPER(D1) 
C)  =UPPER(D1) 
D)  =CONCAT(D1) 
A)  =LOWER(D1) 
B)  =PROPER(D1) 
C)  =UPPER(D1) 
D)  =CONCAT(D1)

Question 18

You use the SUMIFS function to sum ranges with multiple criteria.

Accepted Answer

A) True 
 B)False

Question 19

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Accepted Answer

A) True 
 B)False

Question 20

In formulas, calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

Leila has a table listing the number of houses each real estate agent sold, if any, each month.She can use the DCOUNTA function to find the number of agents with sales in June.

The Comma Style format adds a comma and a dollar sign to a cell value.

Which of the following formulas can you use to find the serial number of the date January 1, 2017?

Sophia has a table with a column named Sales that lists monthly sales data.To sort the column, she can click the Sales filter list arrow and then click Number.

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

Bertie wants to show data labels inside a text bubble shape.Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

When you format a range as a table, which of the following features does Excel apply to the table? Select all the options that apply.

How can you add a new record to a table? Select all the options that apply.

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

When you link an object, you can edit the object separately from the source document.

Which of the following buttons lets you remove chart elements?

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

Nathan wants to analyze a range of values that shows the results of changing a single input value in a formula.What should he create?

When you select a cell range, the cells must be adjacent to each other.

Which of the following is true of the Excel spell checker?

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

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

You use the SUMIFS function to sum ranges with multiple criteria.

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

In formulas, calculations in square brackets are calculated first.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Leila has a table listing the number of houses each real estate agent sold, if any, each month.She can use the DCOUNTA function to find the number of agents with sales in June.

The Comma Style format adds a comma and a dollar sign to a cell value.

Which of the following formulas can you use to find the serial number of the date January 1, 2017?

Sophia has a table with a column named Sales that lists monthly sales data.To sort the column, she can click the Sales filter list arrow and then click Number.

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

Bertie wants to show data labels inside a text bubble shape.Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

When you format a range as a table, which of the following features does Excel apply to the table? Select all the options that apply.

How can you add a new record to a table? Select all the options that apply.

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

When you link an object, you can edit the object separately from the source document.

Which of the following buttons lets you remove chart elements?

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

Nathan wants to analyze a range of values that shows the results of changing a single input value in a formula.What should he create?

When you select a cell range, the cells must be adjacent to each other.

Which of the following is true of the Excel spell checker?

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

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

You use the SUMIFS function to sum ranges with multiple criteria.

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

In formulas, calculations in square brackets are calculated first.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters