Mod 170: Office 2013

Front 1

Range

Back 1

A series of two or more adjacent cells in a column or row or a rectangular group of cells.

Front 2

SUM Function

Back 2

Adds all of the numbers in a range if cells.

Front 3

Fill Handle

Back 3

Is the small black square located in the lower-right corner of the heavy border around the active cell.

Front 4

Relative Reference

Back 4

An address or pointer that changes when the target item is moves or the relationship to it has changed.

Front 5

Bold

Back 5

An entry in a cell to emphasize it or make it stand out from the rest of the worksheet.

Front 6

Merging Cells

Back 6

Involves creating a single cell by combining two or more selected cells.

Front 7

Document Properties

Back 7

Also known as metadata, can include information such as the project author, title, subject, and keywords.

Front 8

Keyword

Back 8

Is a word or phrase that further describes the document.

Front 9

Insert Mode

Back 9

Excel inserts the character and moves all characters to the right of the typed character one position to the right.

Front 10

Overtype Mode

Back 10

Excel replaces the character to the right of the insertion point.

Front 11

Function

Back 11

Is a prewritten formula that is built into Excel.

Front 12

Order of Operations

Back 12

When more than ine arithmetic operator is involves in a formula, Excel follows the same basic order of operations that you use in algebra.

Front 13

Point Mode

Back 13

Allows you to select cells for use in a formula by using a mouse.

Front 14

AVERAGE Function

Back 14

Sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Front 15

MAX Function

Back 15

Displays the highest value in a range of cells.

Front 16

MIN Function

Back 16

Determines the lowest number in a range of cells.

Front 17

Range Finder

Back 17

Used to check which cells are referenced in the formula assigned to the active cell. Allows you to make immediate changes to the cells referenced in a formula.

Front 18

Conditional Formatting

Back 18

Let's you applt formatting that appears only when the value in a cell meets conditions that you specify.

Front 19

Formula Bar

Back 19

Displays the data or formula stored in the active cell.

Front 20

Best Fit

Back 20

Means the width of a column will be increased or decreased so that the widest entry will fit in the column.

Front 21

Page Layout View

Back 21

Allows you to create or modify a worksheet while viewing how it will look in printed format.

Front 22

Excel

Back 22

A powerful spreadsheet program that allows users to organize data, complete calculations, make decisiins, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

Front 23

Worksheet

Back 23

Allows users to enter, calculate, manipulate, and analyze data such as numbers and text.

Front 24

Workbook

Back 24

Is like a notebook. A collection of worksheets.

Front 25

Cell Reference

Back 25

Thw coordinates of the intersection of a column and row.