Question 1

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

Accepted Answer

Formula AutoComplete suggests functions that match the initial characters being entered by a user.

Question 2

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

Accepted Answer

Column charts are commonly used to compare related data or to show data trends over time. They are easy to read and interpret, making them useful for presentations and reports. Pie charts are useful for showing proportions of a whole, line charts are used to show trends over time, and scatter charts are used to show the relationship between two variables. However, neither of these is specifically designed for comparing related numbers, making the column chart the best choice for this purpose.

Question 3

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

Accepted Answer

The range in parentheses in a function is the argument of the function, which are the inputs that the function operates on.

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.

Accepted Answer

The Quick Analysis Lens button appears when a section of a worksheet displaying numeric values is selected. It is used to apply conditional formatting or to insert a chart or table based on the selected content.

Question 5

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

Accepted Answer

The General format displays numbers without any specific formatting, so it does not include commas or trailing zeros. The Currency and Accounting formats include commas and/or specified numbers of decimal places, while the Percentage format multiplies the number by 100 and adds a percentage sign.

Question 6

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

Accepted Answer

The answer of A ________ is a group of numbers,...

Question 7

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

Accepted Answer

The number of decimal places and appearance of symbols are part of number formatting. Choice B (style) can refer to broader aspects of design and presentation, but does not specifically relate to numbers. Choices C (layout) and D (alignment) refer to the arrangement and positioning of elements on a page, but do not directly relate to the formatting of numbers.

Question 8

The ________ outlines all the cells referenced in a formula.

Accepted Answer

The range finder outlines all the cells referenced in a formula, making it easy to see which cells are contributing to the result.

Question 9

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

Accepted Answer

The # symbols are displayed when the column is too narrow to display the entire value in the cell.

Question 10

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

Accepted Answer

An error value, such as #DIV/0! or #VALUE!, appears in a cell when a formula cannot perform the specified calculations. It indicates an error in the formula or the data. The other options (B, C, and D) do not accurately describe the message that appears in a cell when there's an error in the formula.

Question 11

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

Accepted Answer

Moving between worksheets in a workbook is done by clicking on a worksheet tab. The worksheet tabs are located at the bottom of the Excel window and display the name of each worksheet in the workbook. By clicking on a tab, you can switch between worksheets to access and edit their contents.

Question 12

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

Accepted Answer

When Excel automatically enters a function argument, it typically uses a relative reference, meaning the reference will change relative to the position where the formula is copied.

Question 13

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

Accepted Answer

The Quick Analysis Lens button appears to the right of a selected range of cells. When you select a range of cells, the Quick Analysis Lens button appears to the bottom right of the selected range. Clicking on this button opens up a drop-down menu that gives you quick access to various formatting and analysis options for your data.

Question 14

Which is NOT a category in the Quick Analysis gallery?

Accepted Answer

The Quick Analysis gallery in Excel includes categories for Formatting, Charts, Tables, and other options, but there is no category specifically for AutoSum. However, AutoSum can be accessed from the Home tab in the Editing group.

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.

Accepted Answer

The function that fits the given explanation is AVERAGE, which calculates the average or mean value of a group of numbers. The other options do not involve dividing the sum of values by the number of values, or do not give any indication of calculating an average value.

Question 16

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

Accepted Answer

The axis is the line that borders the chart plot border area and is used as a frame of reference for measurement. Gridlines and category borders are also lines used in a chart, but they do not border the chart plot border area. The chart border is the overall border of the entire chart.

Question 17

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

Accepted Answer

Double-clicking on the name of the MAX function in the Function AutoComplete list will add the function to the active cell.

Question 18

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

Accepted Answer

A green triangle appears in the top-left corner of a cell to indicate an error in a formula or a potential issue with the cell's content in spreadsheet applications like Excel.

Question 19

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

Accepted Answer

AutoFit is the feature in Excel that allows the user to automatically adjust column width to fit the longest entry in the column. AutoComplete is a feature that suggests text based on previously entered data. AutoAdjust and AutoFill are not valid features in Excel.

Question 20

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

Accepted Answer

An absolute cell reference remains the same when it is copied or filled to other cells. This is denoted by adding a dollar sign before the column letter and row number ($A$1). Relative cell references, on the other hand, change when they are copied or filled to other cells. Constant cell references and fixed cell references are not commonly used terms in Excel.

Quiz 8: Insert Summary Functions and Create Charts