Excel Chapter 1: End of Chapter Quiz

Ace your homework & exams now with Quizwiz!

Active Cell

A cell surrounded by a black border and ready to receive data

Quick Analysis Tool

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

Row

A horizontal groups of cells in a worksheet

Column

A vertical groups of cells in a worksheet

Workbook

An Excel file that contains one or more worksheets

Formula Bar

An element in the Excel window that displays the value or formula contained in the active cell is the

Formula

An equation that performs mathematical calculations on values in a worksheet

Cell Address

Another name for a cell reference

Spreadsheet

Another name for a worksheet

Workbook

On startup, Excel displays a new blank

Data

Text or numbers in a cell

Category Axis

The area along the bottom of a chart that identifies the categories of data

General Format

The default format that Excel applies to numbers

Auto Fill

The feature that generated and extends values into adjacent cells based on the values of selected cells

Chart

The graphic representation of data in a worksheet

Cell

The intersection of a column and a row

Fill Handle

The small black square in the lower right corner of a selected cell

Operators

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

Absolute

The type of cell reference that refers to cells by their fixed position in a worksheet

Sparklines

Tiny charts embedded in a cell that give a visual trend summary alongside your data


Related study sets

Mineralogy/Petrology Test 3 INFO

View Set

Environmental science chapter 10 discussion

View Set

Chapter 35: Communication and Teaching with Children and Families

View Set

Emotional, Physical, Sexual, and Financial Abuse

View Set

Lesson 105 - Applied Math, Circuit Theory, Plans & Specs Reading Worksheet

View Set