Question 1

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 messagesE) C) and D)
F) A) and D)

Question 2

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)   StylesE) A) and B)
F) A) and C)

Question 3

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)   AverageE) All of the above
F) A) and D)

Question 4

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)   ScenarioE) B) and D)
F) A) and B)

Question 5

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.E) A) and B)
F) All of the above

Question 6

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.E) None of the above
F) All of the above

Question 7

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

Accepted Answer

A) True 
 B)False

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 chartE) A) and C)
F) All of the above

Question 9

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 labelE) C) and D)
F) A) and D)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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)   FilterE) None of the above
F) A) and C)

Question 13

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.E) C) and D)
F) B) and D)

Question 14

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.E) A) and C)
F) None of the above

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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.E) All of the above
F) None of the above

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 boxE) A) and D)
F) All of the above

Question 18

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

Accepted Answer

A)   Shadow
B)   Layout
C)   Cropping
D)   Brightness/ContrastE) A) and B)
F) A) and C)

Question 19

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.E) All of the above
F) C) and D)

Question 20

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.E) B) and C)
F) A) and C)

Exam 7: Excel

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified