COMP Midterm

¡Supera tus tareas y exámenes ahora con Quizwiz!

Column

A vertical group of cells in a worksheet

C. formula bar

An element in the Excel window that displays the value or formula contained in the active cell is the: A. name box B. status bar C. formula bar

Number Values

Constant values consisting of only numbers

B. workbook

On startup, Excel displays a new blank: A. document B. workbook C. grid

Constant value

Text or numbers in a cell

C. category axis

The area along the bottom of a chart that identifies the categories of data is the: A. data point B. value axis C. category axis

C. underlying value

The data that displays in the Formula Bar is referred to as the: A. constant value B. formula C. underlying value

Chart

The graphic representation of data in a worksheet

Sheet Tabs

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

Fill Handle

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

B. operators

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are: A. pixels B. operators C. data points

A. absolute

The type of cell reference that refers to cells by their fixed position in a worksheet is: A. absolute B. relative C. exponentiation

B. sparklines

Tiny charts embedded in a cell that give a visual trend summary alongside your data are: A. embedded charts B. sparklines C. chart styles

B. select all box

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the: A. name box B. select all box C. split box

A. active cell

A cell surrounded by a black border and ready to receive data is the: A. active cell B. address cell C. reference cell

B. Quick Analysis tool

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: A. AutoFit B. Quick Analysis tool C. range finder

C. range finder

A feature that outlines cells in color to indicate which cells are used in a formula is called: A. AutoFit B. Quick Analysis tool C. range finder

Row

A horizontal group of cells in a worksheet

A. AutoFit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is: A. AutoFit B. Quick Analysis tool C. range finder

Workbook

An Excel file that contains one or more worksheets

A. name box

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the: A. name box B. status bar C. formula bar

Formula Worksheet

An equation that performs mathematical calculations on values in a worksheet

Cell Address

Another name for a cell reference

Value

Another name for a constant value

Spreadsheet

Another name for a worksheet

Cell Content

Anything typed into a cell

Data

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

C. general format

The default format that Excel applies to numbers is the: A. comma format B. accounting format C. general format

B. Auto Fill

The feature that generates and extends values into adjacent cells based on the values of selected cells is: A. AutoComplete B. Auto Fill C. fill handle

Cell

The intersection of a column and a row


Conjuntos de estudio relacionados

AP Spanish Lang Lectura 2.1 Google, un médico virtual...

View Set

UNIT: BANKING, FINANCIAL INSTITUTIONS, AND INSURANCE

View Set

Accounting Changes - Overview 3.2 Retrospective

View Set

𝙀𝙑𝙀𝙍𝙔𝙈𝘼𝙉: KINDRED AND COUSIN (317-390)

View Set

Chapter 15 Polymorphism and Virtual Functions

View Set

French 1 - (1-2) Lesson 1A, Culture

View Set

Research Methods for the Behavioral Sciences, Ch. 12, Final Exam Review

View Set