Deck 8: Insert Summary Functions and Create Charts

Question 1

The ________ suggests functions that match the initial characters being entered by a user.

A) AutoSum arrow
B) Formula AutoComplete
C) Formula Preview
D) Formula AutoFill

Answer 1

B

Question 2

A ________ chart is used to illustrate comparisons of related numbers.

A) pie
B) column
C) line
D) scatter

Answer 2

B

Question 3

In a function, the range in parentheses is the ________.

A) argument
B) variable
C) underlying value
D) display value

Answer 3

A

Question 4

When a section of a worksheet displaying numeric values is selected, the ________ appears; this is used to apply conditional formatting or to insert a chart or table based on the selected content.

A) Quick Access Lens button
B) Quick Analysis Lens button
C) Quick Analysis Lens contextual tab
D) Quick Format Lens button

Question 5

The ________ format does not display commas or trailing zeros to the right of a decimal point.

A) Currency
B) General
C) Accounting
D) Percentage

Question 6

A ________ is a group of numbers, text, dates, or time periods that come in succession.

A) chain
B) sequence
C) series
D) succession

Question 7

The number of decimals places and the appearance commas, dollar signs, or other symbols are features of number ________.

A) format
B) style
C) layout
D) alignment

Question 8

The ________ outlines all the cells referenced in a formula.

A) error value
B) range finder
C) error indicator
D) range detector

Question 9

The displayed value of a cell is replaced with a series of # symbols when ________.

A) there is an error in the underlying formula
B) the name of a function is misspelled
C) the column is too narrow to display the entire value
D) a cell in the underlying formula has no value

Question 10

A message that appears in a cell when a formula cannot perform the specified calculations is a(n) ________.

A) error value
B) failure message
C) edit message
D) error indicator

Question 11

Moving between worksheets in a workbook is done by clicking on ________.

A) the title bar
B) the name box
C) a worksheet tab
D) the new option from the Quick Access Toolbar

Question 12

When the function argument is automatically entered by Excel, the argument is ________.

A) a relative reference
B) an absolute reference
C) entered in green text
D) entered in red text

Question 13

The Quick Analysis Lens button appears to the right of ________.

A) a selected range of cells
B) a sheet tab
C) the Name Box
D) the formula bar

Question 14

Which is NOT a category in the Quick Analysis gallery?

A) Formatting
B) Charts
C) AutoSum
D) Tables

Question 15

The ________ is a statistical function that adds a group of values and then divides the result by the number of values in the group.

A) SUM
B) AVERAGE
C) MAX
D) MIN

Question 16

The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.

A) chart border
B) gridline
C) category border
D) axis

Question 17

When the Function AutoComplete list is used to enter the MAX function into an active cell, ________.

A) single-click on the name of the function in the list
B) right-click on the name of the function and click Insert
C) double-click on the name of the function in the list
D) click and drag the name of the function into the active cell

Question 18

Which symbol is the error indicator that appears in a cell having a formula that has broken a rule?

A) green triangle
B) green square
C) red exclamation point
D) yellow caution sign

Question 19

The Excel feature used to automatically adjust column width to the longest column entry is ________.

A) AutoFit
B) AutoComplete
C) AutoAdjust
D) AutoFill

Question 20

A cell that remains the same when it is copied or filled to other cells is a(n) ________.

A) relative cell reference
B) constant cell reference
C) fixed cell reference
D) absolute cell reference

Question 21

The ________ button on the Design tab displays the locations where a title and a legend can be positioned in a chart.

A) Chart Style
B) Change Color
C) Quick Layout
D) Add Chart Elements

Question 22

When Print is clicked from the File tab, the right side of the Print pane is a ________.

A) review of document properties
B) list of possible printers
C) preview of the page to be printed
D) list of Page Setup settings

Question 23

The ________ dialog box is used to relocate a chart to another worksheet.

A) Insert Chart
B) Move Chart
C) Format Chart
D) Chart Elements

Question 24

When the mouse is placed in the column heading between the border of columns B and C and is dragged to the right, column B becomes narrower.

Question 25

A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart ________.

A) caption
B) title
C) legend
D) category label

Question 26

When a fill option is set in the Format Chart Area pane, the fill color is applied to the ________.

A) data marks
B) data labels
C) chart title
D) chart area

Question 27

A formula that attempts to divide by zero displays both an error indicator and an error value.

Question 28

Chart buttons are displayed when the ________ of the chart is clicked.

A) border
B) legend
C) data marker
D) caption

Question 29

Each cell in the blue range finder is represented by a ________, which can be a column, a bar, a dot, a slice of pie, or other appropriate symbol.

A) data point
B) legend character
C) data marker
D) data symbol

Question 30

Excel uses rules to check for formula errors.

Question 31

The Chart Elements button displays options for all of these EXCEPT ________.

A) Chart Title
B) Data Labels
C) Chart Caption
D) Legend

Question 32

When an embedded chart is selected and the worksheet is printed, ________.

A) only the source data are printed
B) only the chart is printed
C) both the source data and the chart are printed
D) nothing is printed

Question 33

The range finder is used to verify which cells are used in a formula and to edit formulas.

Question 34

Normal View does NOT display ________.

A) headers and footers
B) gridlines
C) the formula bar
D) row and column headings

Question 35

When the fill handle is used to copy a cell that contains content that is part of a series, the AutoFill feature continues the series in the copy.

Question 36

Both long text entries and long numeric entries are truncated when the column they are in is too narrow or when there is content in the column to the right.

Question 37

Error values and error indicators CANNOT appear in the same cell.

Question 38

In a worksheet, each cell in the blue range finder is a(n) ________.

A) data marker
B) data point
C) legend
D) axis

Question 39

A ________ is a prebuilt chart format that applies an overall visual look to a chart.

A) chart layout
B) chart style
C) chart design
D) chart template

Question 40

The Insert WordArt button is on the ________ tab of the Ribbon.

A) Home
B) Insert
C) Page Layout
D) View

Question 41

When used on a cell containing a number value, the Decrease Decimal button removes decimals from the displayed value and the underlying value.

Question 42

When options are moused over in the Quick Layout gallery, the preview is displayed on the actual chart in the worksheet.

Question 43

The range finder uses different colors to identify sections of a selected range that are used to create different chart elements.

Question 44

Another way to select a range of cells is to use the arrow keys while holding down the [Ctrl] key.

Question 45

By default, Excel displays numbers in General format.

Question 46

Rows and columns of totals are usually included in a column chart.

Question 47

Once inserted into a worksheet, a chart CANNOT be relocated.

Question 48

When there is a change in a cell value in a function argument, the function display value is automatically updated to reflect that change.

Question 49

Design and Layout are the only two tabs on the Chart Tools contextual tab.

Question 50

Headers and footers CANNOT be inserted into a chart sheet.

Question 51

Selecting a chart from the Quick Analysis gallery inserts the chart into the active worksheet.

Question 52

The AutoFill feature does NOT work with statistical functions.

Question 53

A chart can be sized by clicking and dragging on its sizing handles.

Question 54

Chart styles and chart layouts affect the same chart elements and features.

Question 55

Cells containing a sum or average are usually included in the MAX and MIN function argument.

Question 56

When a chart layout is changed, placeholders appear for the elements that have no content.

Question 57

When the AVERAGE function is used, the division operation is NOT visible in the formula bar, as it is part of the predefined function.

Question 58

SUM and AVERAGE are the only functions listed in the options displayed by the AutoSum arrow.

Question 59

A chart type can be changed after a chart is created.

Question 60

When the data cells are below and to the right of the cell containing a function, the function argument is automatically entered.

Question 61

Numbers, text, cell references, and range names are common examples of a function ________.

Question 62

When a cell formula is being edited, pressing the ________ key changes the selected cell reference from relative to absolute.

Question 63

AutoFit is applied to a column by double-clicking on the right border of the column in the ________.

Question 64

Press the ________ key to close the range finder.

Question 65

#DIV/0! is an example of a(n) ________.

Question 66

Percentages displayed with data labels on a pie chart are NEVER rounded.

Question 67

The ________ indicates an absolute cell reference.

Question 68

Clicking the ________ button displays additional decimal values in the active cell.

Question 69

What are the small squares that appear in all four corners of the range finder?

Question 70

The AutoSum button is in the ________ group on the Home tab.

Question 71

When there is a change in the worksheet data, the corresponding chart is updated automatically.

Question 72

A function argument is the cell range that appears in ________.

Question 73

A green triangle in the upper left corner of a cell is a(n) ________.

Question 74

All data labels in a chart can be selected by clicking on one of the data labels.

Question 75

The Wrap Text button is in the Alignment group on the ________ tab.

Question 76

A cell displays a series of ________ when the numeric value displayed is longer than the column width.

Question 77

Text created in WordArt is an object, which can be resized and relocated in the worksheet.

Question 78

If 17.8 is the displayed value in the active cell when the Decrease Decimal button is clicked, the displayed value changes to ________.

Question 79

The ________ function evaluates all values in a range and returns the largest value.

Question 80

If Quarter 1 is the label in cell B2 and the AutoFill handle is used to copy the content of cell B2 through the range C2:E2, what is the content in cell E2 after copying?