COMP 105 Midterm
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is
AutoFit
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
Excel table
The function that retrieves and then displays the date and time from your computer is the
NOW function
The process of moving within a worksheet or workbook
Navigate
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
Quick Analysis Tool
On startup, Excel displays a new blank
Workbook
The type of cell reference that refers to cells by their fixed position in a worksheet is
absolute
The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is
auto fill
The area along the bottom of a chart that identifies the categories of data is the
category axis (x-axis)
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a
data bar
An element in the Excel window that displays the value or formula contained in the active cell is the
formula bar
An element of the Excel window that displays the name of the selected cell, table, chart, or object is the
name box
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are
operators
A feature that outlines cells in color to indicate which cells are used in a formula is called
range finder
The process of arranging data in a specific order based on the value in each field is called
sort
Tiny charts embedded in a cell that give a visual trend summary alongside your data are
sparklines
A cell surrounded by a black border and ready to receive data is the
active cell
The default format that Excel applies to numbers is the
general format
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the
select all box
The data that displays in the Formula Bar is referred to as the
underlying value