Excel Chapter 1 Quiz A Questions

An element in the excel window that displays the value of formula contained in the active cell is the

Formula bar

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

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

active cell

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

auto fill

An excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is

autofit

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

category axis

The default format that excel applies to numbers is the

general format

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

operations

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

A feature that outlines cells in color to indicate which cells are used in a formula is called

range finder

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

select all box

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

sparklines

The data that displays in the formula bar is referred to as the

underlying value