Question 1

Warren has a table that applies fill formatting to every other column, which he finds distracting.How can he remove this formatting?

Accepted Answer

A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column. 
A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column.

Question 2

The predefined colors in a workbook are called the cell styles.

Accepted Answer

A) True 
 B)False

Question 3

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Accepted Answer

A)  Alignment 
B)  Fonts 
C)  Color 
D)  Styles 
A)  Alignment 
B)  Fonts 
C)  Color 
D)  Styles

Question 4

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 5

To enter a typed number into a cell, you can press Tab or Backspace.

Accepted Answer

A) True 
 B)False

Question 6

Lindsay wants to filter a PivotTable to display only June revenue data.Which of the following fields should she add to the Filters area?

Accepted Answer

A)  Revenue 
B)  Month 
C)  Summary 
D)  Filter 
A)  Revenue 
B)  Month 
C)  Summary 
D)  Filter

Question 7

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Accepted Answer

A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function. 
A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function.

Question 8

What type of chart is a Clustered Column - Line chart?

Accepted Answer

A)  Scatter chart 
B)  Combo chart 
C)  Radar chart 
D)  Stacked chart 
A)  Scatter chart 
B)  Combo chart 
C)  Radar chart 
D)  Stacked chart

Question 9

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

Accepted Answer

A)  Limits 
B)  Answer 
C)  Sensitivity 
D)  Scenario 
A)  Limits 
B)  Answer 
C)  Sensitivity 
D)  Scenario

Question 10

The Table Styles gallery includes an option for creating a custom table style.

Accepted Answer

A) True 
 B)False

Question 11

To document a workbook, you can use _____, notes you add to worksheet cells.

Accepted Answer

A)  cell comments 
B)  cell annotations 
C)  cell threads 
D)  cell messages 
A)  cell comments 
B)  cell annotations 
C)  cell threads 
D)  cell messages

Question 12

Shelley has created a table listing the names of her students and their grades on an exam.She wants to display only the students who received a grade of 60.After clicking the Grade filter list arrow, what should she do?

Accepted Answer

A)  Click Sort A to Z. 
B)  Click Select All to clear the checkmarks then click 60. 
C)  Click Number Filters then click Top 10. 
D)  Click 60. 
A)  Click Sort A to Z. 
B)  Click Select All to clear the checkmarks then click 60. 
C)  Click Number Filters then click Top 10. 
D)  Click 60.

Question 13

When you double-click the right border of a column heading, which of the following occurs ?

Accepted Answer

A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry. 
A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry.

Question 14

After creating a macro, how can you make it easier to run for other workbook users?

Accepted Answer

A)  Set the macro to run automatically. 
B)  Assign the macro to a button. 
C)  Display the Developer tab in the workbook. 
D)  Turn off Macro Security protection. 
A)  Set the macro to run automatically. 
B)  Assign the macro to a button. 
C)  Display the Developer tab in the workbook. 
D)  Turn off Macro Security protection.

Question 15

Binay wants to create an X-Y scatter plot.To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following are ways you can share an Excel workbook? Select all the options that apply.

Accepted Answer

A)  Share the workbook on OneDrive. 
B)  Email the workbook as an attachment. 
C)  Save the workbook in the Documents folder on your hard disk. 
D)  Import data from another workbook. 
A)  Share the workbook on OneDrive. 
B)  Email the workbook as an attachment. 
C)  Save the workbook in the Documents folder on your hard disk. 
D)  Import data from another workbook.

Question 17

Which of the following lets you search for a function or select one from a category?

Accepted Answer

A)  Function Arguments dialog box 
B)  clipboard 
C)  formula bar 
D)  Insert Function dialog box 
A)  Function Arguments dialog box 
B)  clipboard 
C)  formula bar 
D)  Insert Function dialog box

Question 18

Sam inserted SmartArt arranged as a horizontal series of shapes.He wants to change the SmartArt to group blocks of information in a pyramid.What should he do?

Accepted Answer

A)  Change the layout. 
B)  Apply a SmartArt style. 
C)  Change the color scheme. 
D)  Align the shapes. 
A)  Change the layout. 
B)  Apply a SmartArt style. 
C)  Change the color scheme. 
D)  Align the shapes.

Question 19

Which of the following is a correction you can apply to a picture?

Accepted Answer

A)  Shadow 
B)  Layout 
C)  Cropping 
D)  Brightness/Contrast 
A)  Shadow 
B)  Layout 
C)  Cropping 
D)  Brightness/Contrast

Question 20

Which of the following elements uses colors to identify how the data is represented in a chart?

Accepted Answer

A)  Gridlines 
B)  Legend 
C)  Chart Title 
D)  Data label 
A)  Gridlines 
B)  Legend 
C)  Chart Title 
D)  Data label

Warren has a table that applies fill formatting to every other column, which he finds distracting.How can he remove this formatting?

The predefined colors in a workbook are called the cell styles.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

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

To enter a typed number into a cell, you can press Tab or Backspace.

Lindsay wants to filter a PivotTable to display only June revenue data.Which of the following fields should she add to the Filters area?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

What type of chart is a Clustered Column - Line chart?

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

The Table Styles gallery includes an option for creating a custom table style.

To document a workbook, you can use _____, notes you add to worksheet cells.

Shelley has created a table listing the names of her students and their grades on an exam.She wants to display only the students who received a grade of 60.After clicking the Grade filter list arrow, what should she do?

When you double-click the right border of a column heading, which of the following occurs ?

After creating a macro, how can you make it easier to run for other workbook users?

Binay wants to create an X-Y scatter plot.To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Which of the following are ways you can share an Excel workbook? Select all the options that apply.

Which of the following lets you search for a function or select one from a category?

Sam inserted SmartArt arranged as a horizontal series of shapes.He wants to change the SmartArt to group blocks of information in a pyramid.What should he do?

Which of the following is a correction you can apply to a picture?

Which of the following elements uses colors to identify how the data is represented in a chart?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Warren has a table that applies fill formatting to every other column, which he finds distracting.How can he remove this formatting?

The predefined colors in a workbook are called the cell styles.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

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

To enter a typed number into a cell, you can press Tab or Backspace.

Lindsay wants to filter a PivotTable to display only June revenue data.Which of the following fields should she add to the Filters area?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

What type of chart is a Clustered Column - Line chart?

After Solver finds a solution, you can generate a(n) _____ report summarizing the target cells, adjustable cells, and constraints.

The Table Styles gallery includes an option for creating a custom table style.

To document a workbook, you can use _____, notes you add to worksheet cells.

Shelley has created a table listing the names of her students and their grades on an exam.She wants to display only the students who received a grade of 60.After clicking the Grade filter list arrow, what should she do?

When you double-click the right border of a column heading, which of the following occurs ?

After creating a macro, how can you make it easier to run for other workbook users?

Binay wants to create an X-Y scatter plot.To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

Which of the following are ways you can share an Excel workbook? Select all the options that apply.

Which of the following lets you search for a function or select one from a category?

Sam inserted SmartArt arranged as a horizontal series of shapes.He wants to change the SmartArt to group blocks of information in a pyramid.What should he do?

Which of the following is a correction you can apply to a picture?

Which of the following elements uses colors to identify how the data is represented in a chart?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters