Excel 1 End-of-Chapter Quiz

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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

Auto Fill

The intersection of a column and a row.

Cell

Text or numbers in a cell.

Data

An equation that performs mathematical calculations on values in a worksheet.

Formula

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:

Merge & Center

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

Another name for a constant value.

Value

An Excel file that contains one or more worksheets.

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

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

AutoFit

Another name for a cell reference.

Cell address

Anything typed into a cell.

Cell content

The graphic representation of data in a worksheet.

Chart

A vertical group of cells in a worksheet.

Column

Numbers, text, dates, or times of day that you type into a cell.

Constant value

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

Fill handle

Constant values consisting of only numbers.

Number values

A horizontal group of cells in a worksheet.

Row

The labels along the lower border of the Excel window that identify each worksheet.

Sheet tabs

Another name for a worksheet.

Spreadsheet

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

category axis

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

formula bar

The default format that Excel applies to numbers is the:

general format

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

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

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

name box


Kaugnay na mga set ng pag-aaral

Fin 334 Test 3 Concepts Chapter 8 and 9

View Set

Psych Concept Practice Chapter 9, 12, 13

View Set

CHAPTER 9 - HUN 1201 - CENGAGE STUDY QUESTIONS

View Set

Unit 11 - Contactors, Relays, and Overloads

View Set

Employment Discrimination - Pa. Bar

View Set

Quiz: CompTIA Network+ N10-008 Post-Assessment Quiz

View Set