Quiz 5 review

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Merge and Center

1. A command that joins selected cells in a workbook into one larger cell and centers the contents in the merged cell:

Workbook

1. An Excel file that contains one or more worksheets

Formula

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

Sparklines

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

Auto fit

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

Number Values

11. Constant values consisting of only numbers

Cell Address

12. Another name for a cell reference

Quick Analysis tool

13. 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:

Value

13. Another name for a constant value

Fill Handle

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

Range Finder

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

Chart

15. The graphic representation of data in a worksheet

Cell

3. The intersection of a column and a row

Select all box

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

Sheet Tabs

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

Column

5. A vertical group of cells in a worksheet

Auto Fill

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

Cell Content

7. Anything typed into a cell

Data

8. Text or numbers in a cell

underlying value

8. The data that displays in the Formula Bar is referred to as the:

Constant Value

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

Absolute

9. The type of cell reference that refers to cells by their fixed position in a worksheet

Active Cell

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

Row

A horizontal group of cells in a worksheet

Formula bar

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

Name Box

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

Spreadsheet

Another name for a worksheet.

Category Axis

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

General format

The default format that Excel applies to numbers is the:

Operators

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


Ensembles d'études connexes

CH 3 Resolving International Commercial Disputes

View Set

6.2 A virágzó középkor Magyarországon - Fogalmak

View Set

Subungual Hematoma, Ingrown Toenail

View Set

Chapter 1 Maryland Pre-Licensing

View Set