##### Unit I Words

0
Set Details Share
created 8 years ago by kardoin8
9 views
updated 8 years ago by kardoin8
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
1

Worksheet

Electronic grid in which you can perform numeric calculations.

2

Workbook

Excel file that contains one or more worksheets.

3

References to both worksheets and workbooks.

4

Cell

The intersection of a row and a column in an Excel worksheet of a Word table.

5

Active Cell

In an Excel worksheet, the current location of the cell pointer.

6

Cell Pointer

Blue border surrounding the active cell.

7

Specific location of a cell in a worksheet where a column and a row intersect.

8

Name Box

9

Formula Bar

Shows content of selected cell, and is located right above the column headings.

10

Cell Range

Group of cells that share boundaries.

11

Label

Text that describes data in a worksheet.

12

Values

Numeric data that can be used in calculations.

13

In Excel, the boxes containing letters that appear in every column.

14

In Excel, the boxes containing numbers that appear to the left of each row.

15

AutoFit

A feature that automatically adjusts the width of a column or the height of a row to accommodate its widest or tallest entry.

16

Formula

An equation that calculates a new value from existing values. Formulas can contain numbers, mathematical operators, cell references, and built-in equations called functions.

17

Cell Reference

The address of a cell in an Excel worksheet that defines its location in the worksheet by column letter and row number (for example, A1), and that can be used in formulas and functions.

18

Order of Operations (Order of Precedence for Arithmetic Operations)

The order in which Excel calculates a formula; the order of precedence is exponents, multiplication and division, addition and subtraction. Calculations in parentheses are evaluated first.

19

Relative Cell Referencing

In Excel, a cell reference that changes when copied to refer to cells relative to the new location. For example, the formula "=B5*C5" in cell D5 changes to "=B6*C6" when you copy the formula to cell D6.

20

Functions

Prewritten formulas you can use instead of typing a formula from scratch. Each function includes the function name, a set of parentheses, and function arguments separated by commas and enclosed in parentheses.

21

SUM

In Excel, the function used to calculate the total of the arguments.

22

Argument

A value, cell reference, or text used in an Excel function. Commas or a colon separate arguments and parentheses enclose them; for example, AVERAGE(A1,10,5) or SUM(A1:A5).

23

Portrait Orientation

A print setting that positions the document on the page so the page is taller than it is wide.

24

Landscape Orientation

A layout orientation for a document that specifies to print the page so it is wider than it is tall.