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