Test 1 B Flashcards Preview

Excel > Test 1 B > Flashcards

Flashcards in Test 1 B Deck (19):
1

Header

Information that appears in the top margin of each printed page. it often includes summary information such as the filename and the data.

2

Print Titles

Information that appears on every printed page.

3

Banded Rows

Displays alternate rows in an Excel table with different fill colors.

4

Footer

Information that is printed in the bottom margin of each printed page.

5

Table Style

Formats the entire table as a single unit.

6

Margin

The space between the page content and the edges of the page.

7

Conditional Format

Applies formatting only when a cells value meets a specified condition.

8

Legend

A key that shows each color used in the worksheet and what it means, so others know why certain cells are highlighted.

9

Absolute Reference

Remains fixed when the cell formula is copied to a new location and has $ signs in front of the column letter and the row number.

10

Relative Reference

Interpreted in relation to the location of the cell containing the formula.

11

Required Arguments

in bold, are needed for the function to return a value.

12

Arguments

The numbers, text or cell references used by the function to return a value.

13

Optional Arguments

These are not required for the function to return a value.

14

SUM Function

Returns the sum of the values in the range.

15

MIN Function

Returns the minimum value in the range.

16

MAX Function

Returns the maximum value in the range.

17

Mixed Reference

Contains an absolute row or an absolute column.

18

Syntax

A set of rules for every function to follow.

19

Nested

When you place a function inside of another function.