Excel - Ch 4

Question 1

The process of keeping rows/columns visible on screen at all times

Answer 1

Freezing

Question 2

Freezes columns & rows to right/bottom of active cell

Answer 2

Freeze Panes

Question 3

Freezes top row

Answer 3

Freeze Top Row

Question 4

Freezes first column

Answer 4

Freeze First Column

Question 5

Indicates where data will start on another printed page

Answer 5

Page Break

Question 6

Indicates where automatic page breaks will occur

Answer 6

Blue Dashed Lines

Question 7

Indicates where manual page breaks have been inserted

Answer 7

Solid Blue Lines

Question 8

Range of cells that will print (can be set); use this function to print titles on every page

Answer 8

Print Area

Question 9

Sequence in which pages are printed; default is top-left section, bottom-left section, top-right section, bottom-right section

Answer 9

Print Order

Question 10

Structured range that contains refined data organized in a method that increases the capacity to manage

Answer 10

Table

Question 11

The organization method used to manage multiple data points within a data set (names, grades, contact info, etc.)

Answer 11

Data Structure

Question 12

Individual piece of data (such as names); each should represent the smallest possible unit of data (First & Last names separated); enables you to manipulate data in a variety of ways for output

Answer 12

Field

Question 13

A collection of related data about one entity (represented across full row in a table)

Answer 13

Record

Question 14

Control fill colour of header row & rows of records; can change to certain colour schemes

Answer 14

Table Styles

Question 15

Displays header row (field names) when checked

Answer 15

Header Row

Question 16

Displays a total row at the bottom of a table

Answer 16

Total Row

Question 17

Applies a different format to the first column so that row headings stand out

Answer 17

First Column

Question 18

Applies a different format to the last column so it stands out (like a grand total)

Answer 18

Last Column

Question 19

Displays alternate fill/not-filled format

Answer 19

Banded Rows/Columns

Question 20

A tag or use of a table element (such as field heading) as a reference in a formula

Answer 20

Structured Reference

Question 21

The use of field headings without row references in a structured formula

Answer 21

Unqualified reference

Question 22

Structured formula that includes references that include a table name (must be used if you want to use table data in a formula outside of table boundaries)

Answer 22

Fully Qualified Structured Reference

Question 23

Process of arranging records by the value of one or more fields within a table (not limited to just tables)

Answer 23

Sorting

Question 24

Sorting Styles:

Answer 24

Text (A - Z or Z - A)
Dates (Oldest - Newest or Newest - Oldest)
Values (Largest - Smallest or Smallest - Largest)
Colour (Cell Colour or Font Colour)

Question 25

Process of specifying conditions to display only records that meet certain conditions

Answer 25

Filtering (Text, Number, Custom)

Question 26

Applies special formatting to highlight or emphasize cells that meet certain conditions (sales goal, grades below standard, etc.)

Answer 26

Conditional Formatting

Question 27

Displays below the last row of records in an Excel Table, enables you to display summary statistics (sum of values)

Answer 27

Total Row

Question 28

=SUBTOTAL(function_num,ref1...) ; (ref1 = range of cells)

Answer 28

Calculates on aggregate value (totals or averages)

Question 29

- Text Contains - Duplicate Values - Highlight Cell Rules - Top/Bottom Rules - Colour Scales (Gradient) - Data Bars - Icon Sets

Answer 29

Types of Conditional Formatting

Question 30

Highlight cells that meet certain conditions (fill colours, font colours, borders)

Answer 30

Highlight Cell Rules

Question 31

Format to highlight top # value amounts

Answer 31

Top/Bottom Rules

Question 32

Apply gradient/solid fill bar which width of part represents the current cells value w/ different colours

Answer 32

Data Bars

Question 33

Format cells w/ different colours based on relative values of cell

Answer 33

Colour Scale

Question 34

Symbols/signs that classify data into 3, 4, 5 categories

Answer 34

Icon Sets