Chapter 1 Quiz Excel

Text or numbers in a cell Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Data

On startup, Excel displays a new: document grid workbook

workbook

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is: AutoFit Range finder Quick Analysis tool

AutoFit

The intersection of a column and a row. Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Cell

Anything typed into a cell Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Cell Content

Another name for a cell reference. Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Cell address

The graphic representation of data in a worksheet Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Chart

A vertical group of cells in a worksheet. Workbook Spreadsheet Cell Sheet tabls Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Column

The small black square in the lower right corner of a selected cell. Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Fill handle

Constant values consisting of only numbers Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Number values

A feature 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 is called: Auto Fit Range Finder Quick Analysis tool

Quick Analysis tool

A feature that outlines cells in color to indicate which cells are used in a formula is called: Range finder Auto Fit Quick Analysis tool

Range finder

A horizontal group of cells in a worksheet Workbook Spreadsheet Cell Sheet tabls Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Row

Another name for a constant value. Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Value

An excel file that contains one or more worksheets Workbook Spreadsheet Cell Sheet tabls Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Workbook

The type of cell reference that refers to cells by their fixed position in a worksheet is: exponentiation relative absolute

absolute

The area along the bottom of a chart that identifies the categories of data is the: data point category axis value axis

category axis

An element in the Excel window that displays the value or formula contained in the active cell is the: formula bar status bar name box

formula bar

The default format that Excel applies to numbers is the: comma format accounting format general format

general format

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the: name box formula bar status bar

name box

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are: data points operators pixels

operators

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the: select all box name box split box

select all box

Tiny charts embedded in a cell that give a visual trend summary alongside your data are: embedded charts sparklines chart styles

sparklines

The data that displays in the Formula Bar is referred to as the: constant value underlying value formula

underlying value

Numbers, text, dates, or times of day that you type into a cell Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Constant value

The labels along the lower border of the Excel window that identify each worksheet. Workbook Spreadsheet Cell Sheet tabls Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Sheet tabs

Another name for a worksheet. Workbook Spreadsheet Cell Sheet tabls Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Spreadsheet

An equation that performs mathematical calculations on values in a worksheet Workbook Spreadsheet Cell Sheet tabs Column Row Cell Content Data Constant Value Formula Number Values Cell Address Value Fill Handle Chart

Formula

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is: AutoComplete fill handle Auto Fill

Auto Fill

A cell surrounded by a black border and ready to receive data is the: active cell reference cell address cell

active cell