Question 1

Which of the following are true about entering a function using the Insert Function dialog box? Select all the options that apply .

Accepted Answer

A)  You open the dialog box by typing "function" in the formula bar. 
B)  You can use the search tool in the Insert Function dialog box to find a function. 
C)  You can select a category to explore functions by type. 
D)  You can use the Insert Function dialog box to insert a function based on nearby formulas. 
A)  You open the dialog box by typing "function" in the formula bar. 
B)  You can use the search tool in the Insert Function dialog box to find a function. 
C)  You can select a category to explore functions by type. 
D)  You can use the Insert Function dialog box to insert a function based on nearby formulas.

Question 2

When you move a chart to a new worksheet, you must also move the data source.

Accepted Answer

A) True 
 B)False

Question 3

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

Accepted Answer

A)  Top Values filter 
B)  Advanced filter 
C)  Logical filter 
D)  Multicolumn filter 
A)  Top Values filter 
B)  Advanced filter 
C)  Logical filter 
D)  Multicolumn filter

Question 4

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

Accepted Answer

A) True 
 B)False

Question 5

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

Accepted Answer

A) True 
 B)False

Question 6

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value.In order to do so, he will type the formula =A1-B1 in an empty cell.

Accepted Answer

A) True 
 B)False

Question 7

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

Accepted Answer

A)  The Undo button on the Quick Access toolbar 
B)  The Cancel button on the Formula bar 
C)  The Enter button on the Formula bar 
D)  The Save button on the Quick Access toolbar 
A)  The Undo button on the Quick Access toolbar 
B)  The Cancel button on the Formula bar 
C)  The Enter button on the Formula bar 
D)  The Save button on the Quick Access toolbar

Question 8

Why is it necessary to use care when inserting worksheet cells?

Accepted Answer

A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy. 
A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy.

Question 9

Sparklines can be small, simple column charts that show data trends for adjacent cells.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is true about adding cell borders?

Accepted Answer

A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines. 
A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines.

Question 11

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell.How should she make this change in cell A5?

Accepted Answer

A)  Right-click the cell, then click Clear Contents on the shortcut menu. 
B)  Click the cell, then click the Clear button in the Editing group. 
C)  Click the cell, then click the Underline button in the Font group. 
D)  Right-click the cell, then click Remove Hyperlink on the shortcut menu. 
A)  Right-click the cell, then click Clear Contents on the shortcut menu. 
B)  Click the cell, then click the Clear button in the Editing group. 
C)  Click the cell, then click the Underline button in the Font group. 
D)  Right-click the cell, then click Remove Hyperlink on the shortcut menu.

Question 12

Which dialog box do you use to change the user name?

Accepted Answer

A)  Preferences dialog box 
B)  Account dialog box 
C)  Customize Status Bar dialog box 
D)  Options dialog box 
A)  Preferences dialog box 
B)  Account dialog box 
C)  Customize Status Bar dialog box 
D)  Options dialog box

Question 13

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

Accepted Answer

A) True 
 B)False

Question 14

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following are ways to format the appearance of a slicer? Select all the options that apply.
A) Slicer caption
B) Slicer size
C) Button order
D) Slicer style

Accepted Answer

The answer of Which of the following are ways to...

Question 16

When you enter a value in a worksheet cell, it is automatically left-aligned.

Accepted Answer

A) True 
 B)False

Question 17

Your worksheet is too wide to fit on one page in portrait orientation.What is the best way to fix this problem?

Accepted Answer

A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape. 
A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape.

Question 18

Ariana wants to compare data on different worksheets in a workbook named Financials.Which of the following buttons can she use on the View tab to open an instance of the Financials workbook?

Accepted Answer

A)  New Window 
B)  Arrange All 
C)  Split 
D)  Switch Windows 
A)  New Window 
B)  Arrange All 
C)  Split 
D)  Switch Windows

Question 19

To enter your name in the lower right corner of a worksheet page, you can _____.

Accepted Answer

A)  Use a button on the Header and Footer Tools Design tab. 
B)  Type your name in the Header and Footer Elements group. 
C)  Type your name in the lower right cell of the worksheet. 
D)  Select the right footer text box and type your name. 
A)  Use a button on the Header and Footer Tools Design tab. 
B)  Type your name in the Header and Footer Elements group. 
C)  Type your name in the lower right cell of the worksheet. 
D)  Select the right footer text box and type your name.

Question 20

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

Which of the following are true about entering a function using the Insert Function dialog box? Select all the options that apply .

When you move a chart to a new worksheet, you must also move the data source.

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value.In order to do so, he will type the formula =A1-B1 in an empty cell.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

Why is it necessary to use care when inserting worksheet cells?

Sparklines can be small, simple column charts that show data trends for adjacent cells.

Which of the following is true about adding cell borders?

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell.How should she make this change in cell A5?

Which dialog box do you use to change the user name?

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Which of the following are ways to format the appearance of a slicer? Select all the options that apply. A) Slicer caption B) Slicer size C) Button order D) Slicer style

When you enter a value in a worksheet cell, it is automatically left-aligned.

Your worksheet is too wide to fit on one page in portrait orientation.What is the best way to fix this problem?

Ariana wants to compare data on different worksheets in a workbook named Financials.Which of the following buttons can she use on the View tab to open an instance of the Financials workbook?

To enter your name in the lower right corner of a worksheet page, you can _____.

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Which of the following are true about entering a function using the Insert Function dialog box? Select all the options that apply .

When you move a chart to a new worksheet, you must also move the data source.

What type of filter should you use when you want to display records that meet And conditions and Or conditions?

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value.In order to do so, he will type the formula =A1-B1 in an empty cell.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

Why is it necessary to use care when inserting worksheet cells?

Sparklines can be small, simple column charts that show data trends for adjacent cells.

Which of the following is true about adding cell borders?

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell.How should she make this change in cell A5?

Which dialog box do you use to change the user name?

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

Which of the following are ways to format the appearance of a slicer? Select all the options that apply. A) Slicer caption B) Slicer size C) Button order D) Slicer style

When you enter a value in a worksheet cell, it is automatically left-aligned.

Your worksheet is too wide to fit on one page in portrait orientation.What is the best way to fix this problem?

Ariana wants to compare data on different worksheets in a workbook named Financials.Which of the following buttons can she use on the View tab to open an instance of the Financials workbook?

To enter your name in the lower right corner of a worksheet page, you can _____.

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters