Question 1

To access data from an external data source so you can use it in Excel, you create a data query.

Accepted Answer

A) True 
 B)False

Question 2

To return a true value if any one of multiple conditions is true, use the IF function.

Accepted Answer

A) True 
 B)False

Question 3

AutoComplete can extend any data pattern involving dates, times, numbers, and text.

Accepted Answer

A) True 
 B)False

Question 4

Kevin formatted the values in a PivotTable by selecting the values and then clicking the Accounting Number Format button on the Home tab. When he changed the layout of the PivotTable, he lost the number formatting. Which dialog box should he use instead?

Accepted Answer

A)  Format Cells dialog box 
B)  Value Field Settings dialog box 
C)  PivotTable Format dialog box 
D)  Value Properties dialog box 
A)  Format Cells dialog box 
B)  Value Field Settings dialog box 
C)  PivotTable Format dialog box 
D)  Value Properties dialog box

Question 5

You use the Evaluate Formula dialog box to enter a formula that uses a financial function.

Accepted Answer

A) True 
 B)False

Question 6

A predesigned combination of formats, such as font size and color, is called a cell default.

Accepted Answer

A) True 
 B)False

Question 7

To change the color of cell content, you use the ________ color list arrow.

Accepted Answer

A)  Cell 
B)  Text 
C)  Pattern 
D)  Font 
A)  Cell 
B)  Text 
C)  Pattern 
D)  Font

Question 8

Which of the following is an unacceptable name for an Excel table?

Accepted Answer

A)  Employee_Tbl 
B)  _SalesTable 
C)  (Customers) 
D)  ProductTable 
A)  Employee_Tbl 
B)  _SalesTable 
C)  (Customers) 
D)  ProductTable

Question 9

A(n) hierarchy is an organization of fields that start with the most general and go down to the most specific.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following techniques can you use to remove hyperlink from a cell?

Accepted Answer

A)  Click the Clear button on the Home tab and then click Remove Hyperlink. 
B)  Click the Delete button on the Home tab and then click Remove Hyperlink. 
C)  Right-click the hyperlink and then click Restore on the shortcut menu. 
D)  Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu. 
A)  Click the Clear button on the Home tab and then click Remove Hyperlink. 
B)  Click the Delete button on the Home tab and then click Remove Hyperlink. 
C)  Right-click the hyperlink and then click Restore on the shortcut menu. 
D)  Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu.

Question 11

Jamal bought $100,000 worth of equipment for his business. Which function can he use to calculate the equal amounts of value the equipment will lose each year?

Accepted Answer

A)  DB 
B)  SLN 
C)  NPV 
D)  CUMDB 
A)  DB 
B)  SLN 
C)  NPV 
D)  CUMDB

Question 12

What would you choose as X in the given series of clicks to calculate formulas automatically: File

Accepted Answer

A)  Formulas 
B)  Proofing 
C)  Language 
D)  Advanced 
A)  Formulas 
B)  Proofing 
C)  Language 
D)  Advanced

Question 13

Stacey filtered a table on the Product Type field and now wants to filter on the Price field instead. What should she do next?

Accepted Answer

A)  Click a filter button and then click Price. 
B)  Clear the filter from the table. 
C)  Use a Number filter. 
D)  Sort by the Price field. 
A)  Click a filter button and then click Price. 
B)  Clear the filter from the table. 
C)  Use a Number filter. 
D)  Sort by the Price field.

Question 14

Esther wants to accept track changes in a file. To do this, she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab. She then clicks Accept to accept the track change. What can X in the procedure be?

Accepted Answer

A)  Next 
B)  Delete 
C)  Previous 
D)  New Comment 
A)  Next 
B)  Delete 
C)  Previous 
D)  New Comment

Question 15

To compare data from different categories where the values are indicated by the height of the data series, select a Stock chart on the Recommended Charts tab in the Insert Chart dialog box.

Accepted Answer

A) True 
 B)False

Question 16

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Accepted Answer

A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function 
A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function

Question 17

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

Accepted Answer

A)  Change the shading and border colors of the cells. 
B)  Filter the table. 
C)  Change the table style. 
D)  Convert the table to a range. 
A)  Change the shading and border colors of the cells. 
B)  Filter the table. 
C)  Change the table style. 
D)  Convert the table to a range.

Question 18

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Accepted Answer

A) True 
 B)False

Question 19

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Accepted Answer

A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip. 
A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip.

Question 20

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

Accepted Answer

A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

To access data from an external data source so you can use it in Excel, you create a data query.

To return a true value if any one of multiple conditions is true, use the IF function.

AutoComplete can extend any data pattern involving dates, times, numbers, and text.

Kevin formatted the values in a PivotTable by selecting the values and then clicking the Accounting Number Format button on the Home tab. When he changed the layout of the PivotTable, he lost the number formatting. Which dialog box should he use instead?

You use the Evaluate Formula dialog box to enter a formula that uses a financial function.

A predesigned combination of formats, such as font size and color, is called a cell default.

To change the color of cell content, you use the ________ color list arrow.

Which of the following is an unacceptable name for an Excel table?

A(n) hierarchy is an organization of fields that start with the most general and go down to the most specific.

Which of the following techniques can you use to remove hyperlink from a cell?

Jamal bought $100,000 worth of equipment for his business. Which function can he use to calculate the equal amounts of value the equipment will lose each year?

What would you choose as X in the given series of clicks to calculate formulas automatically: File

Stacey filtered a table on the Product Type field and now wants to filter on the Price field instead. What should she do next?

Esther wants to accept track changes in a file. To do this, she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab. She then clicks Accept to accept the track change. What can X in the procedure be?

To compare data from different categories where the values are indicated by the height of the data series, select a Stock chart on the Recommended Charts tab in the Insert Chart dialog box.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

To access data from an external data source so you can use it in Excel, you create a data query.

To return a true value if any one of multiple conditions is true, use the IF function.

AutoComplete can extend any data pattern involving dates, times, numbers, and text.

Kevin formatted the values in a PivotTable by selecting the values and then clicking the Accounting Number Format button on the Home tab. When he changed the layout of the PivotTable, he lost the number formatting. Which dialog box should he use instead?

You use the Evaluate Formula dialog box to enter a formula that uses a financial function.

A predesigned combination of formats, such as font size and color, is called a cell default.

To change the color of cell content, you use the ________ color list arrow.

Which of the following is an unacceptable name for an Excel table?

A(n) hierarchy is an organization of fields that start with the most general and go down to the most specific.

Which of the following techniques can you use to remove hyperlink from a cell?

Jamal bought $100,000 worth of equipment for his business. Which function can he use to calculate the equal amounts of value the equipment will lose each year?

What would you choose as X in the given series of clicks to calculate formulas automatically: File

Stacey filtered a table on the Product Type field and now wants to filter on the Price field instead. What should she do next?

Esther wants to accept track changes in a file. To do this, she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab. She then clicks Accept to accept the track change. What can X in the procedure be?

To compare data from different categories where the values are indicated by the height of the data series, select a Stock chart on the Recommended Charts tab in the Insert Chart dialog box.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

Mia inserted a plain table in a worksheet. She wants to change the black borders and white fill to make the table more attractive and easier to use. What is the quickest way for her to change the appearance of the table?

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters