Excel Chapter 1B

Ace your homework & exams now with Quizwiz!

Select All Box

A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.

Switch Row/ Column

A charting command to swap the data over the axis- data being charted on the vertical axis will move to the horizontal axis and vice versa.

Show Formulas

A command that displays the formula in each cell instead of the resulting value.

Value Axis

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the Y-axis.

Worksheet Grid Area

A part of the Excel window that displays the columns and rows that intersect to form the worksheet's cells.

Picture Element

A point of light measured in dots per square inch on a screen, 64 pixels equals 8.43 characters, which is the average number of characters that will fit in a cell in an Excel worksheet using the default font.

SUM Function

A predefined formula that adds all the numbers in a selected range of cells.

Number Format

A specific way in which excel displays numbers in a cell.

Sparkline

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

Quick Analysis Tool

A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.

Recommended Charts

An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you selected.

Range Finder

An Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.

X-Axis

Another name for the horizontal (category) axis.

Y-Axis

Another name for the vertical (value) axis.

Workbook-Level Buttons

Buttons at the far right of the ribbon tabs that minimize or restore a displayed workbook.

Sheet Tab Scrolling Button

Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.

Number Values

Constant values consisting of only numbers.

Relative Cell Reference

In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.

Underlying Value

The data that displays in the Formula Bar.

Underlying Formula

The formula entered in a cell and visible only on the Formula Bar.

Operators

The symbol with which you can specify the type of calculation you want to perform in an Excel formula.

Range

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.


Related study sets

Novare Physical Science Ch. 5 Objectives

View Set

NSG 246 Test 2 - Neuro/Eyes&Ears/Seminar

View Set

CH35 Dysrhythmias, Lewis Hypertension BANK chp 32

View Set

MKTG 409 EXAM 4: Marketing Channels and Supply Chain

View Set