Tech Tools for Business Exam #1 Chapter 1-3

The MIN function calculates the arithmetic mean of a range of cells.

Which of the following cancels a formula before it is completed?

A custom AutoFilter provides fewer options for how rows display.

Which of the following statements is not accurate for clearing cell contents?

When you insert a new column, you must select the column AFTER where you want the new column to appear.

Formulas ALWAYS begin with an "=" sign.

Ascending order sorts data alphabetically from Z to A.

A dependent is a cell that contributes to the formula results.

Which displays a data hierarchical view w/ different sized & colored rectangles & sub-rectangles to compare group sizes

Both Sunburst & TreeMap chart illustrates hierarchical data using colored circles to represent divisions & subdivisions.

Which of the following cell addresses will change when it is copied?

If the formula in cell D10 is =D8+D9+D10. Which of the following terms describes the error?

Which of the following statements is not true when exporting data via the clipboard?

Use the following acronym to help remember the order of mathematical operations: Please Excuse My Dear Aunt Sally.

When you select contiguous source data, the Quick Analysis button appears in the lower-right corner of the selection.

Which of the following is not true about filters?

Which of the following is not a chart element?

A combo chart includes four chart types such as a line chart, column chart, pie chart, and area chart.

To answer "Where is this value coming from?" which tool would you use?

Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?

A duplicate row is a record in a table that has the same data in one or more columns.

By default, how does Excel align values in a cell?

The first row of a criteria range must include all the column names from the worksheet data.

You can create a default chart object by selecting the data and and pressing the "Create Chart" button.

What is another name for rows that alternate fills or borders?

To explode all the slices in a pie chart, select a data point.

The SUM function adds or totals the values in a cell range.

What do AutoFilter arrows replace when you scroll down in a table with many records?

Which of the following is not true about range names?

When used in a cell reference, the dollar sign ($) and the exclamation point (!) are identifiers.

What do pie charts graph?

Which of the following chart elements is a small line or marker on an axis to guide in reading values?

Which text file uses a character, such as a comma or a tab, to separate the fields?

You can view the page layout from the status bar at the bottom of the Excel worksheet.

How does Excel treat criteria entered on different rows?

To show a payment as a positive value, type a plus sign (+) before the loan amount in the worksheet.

Which of the following does not describe the Fill Handle and creating a series?

Which of the following chart types displays the frequency of multiple data series relative to a center point?

Which of the following is the file extension added to an Excel workbook?

A pie chart displays trends in data overtime, emphasizing the rate of change.