Cis Test 3

Front 1

____ can contain any combination of letters, numbers, spaces, and any other special characters

Back 1

Text Entries

Front 2

____ can include only the digits 0-9 and any of the special characters

Back 2

Number Entries

Front 3

The ____ feature makes some basic assumptions about the text you are typing and, based on theses assumptions, automatically corrects it.

Back 3

AutoCorrect

Front 4

____ locates misspelled words, duplicate words, and capitalization irregularities in the active worksheet and proposes the correct spelling

Back 4

Spelling Checker

Front 5

____is supplied with the program

Back 5

Main Dictionary

Front 6

You can create a ___ to hold words you commonly use but that are not included in the main dictionary.

Back 6

Custom Dictionary

Front 7

___ are words with similar meaning.

Back 7

Synonyms

Front 8

___ are words with an opposite meaning

Back 8

Antonyms

Front 9

An entry that is copied leaves the original, called the ____, and inserts a duplicate at a new location called the ____

Back 9

Source or Copy Area
Destination
or Paste Area

Front 10

A ___ is an equation that performs a calculation on data contained in worksheet.

Back 10

Formula

Front 11

The resulting value from formulas is a ___ value because it can change if the data it depends on changes.

Back 11

Variable

Front 12

An ____ is a symbol that specifies the type of numeric operation to perform (+ , -, /, *)

Back 12

Operator

Front 13

A ____ is a cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula.

Back 13

Relative Reference

Front 14

A ___ is a prewritten formula that performs certain types of calculations automatically.

Back 14

Function

Front 15

An ___ is the data the function uses to perform the calculation.

Back 15

Argument

Front 16

When a number in the reference cell in a formula changes, Excel automatically ____ all formulas that are dependent upon the changed value.

Back 16

Recalculates

Front 17

A ___ also known as a ____, is a set of characters with a specific design

Back 17

Font/Typeface

Front 18

___ fonts have a flair at the base of each letter that visually leads the reader to the next level.

Back 18

Serif

Front 19

____ fonts do not have a flair at the base of each letter.

Back 19

Sans Serif

Front 20

____ is the height and width of the character, measure in Points.

Back 20

Size

Front 21

One ___ equals about 1/72 inch.

Back 21

Point

Front 22

___ change the appearance of numbers on screen and when printed, without changing the way the number is stored or used in calculations.

Back 22

Number Formats

Front 23

A ___ consists of a combination of formats that have been named and that can be quickly applied to a selection.

Back 23

Style

Front 24

A ___ is a non-text element or object, such as a drawing or picture, that can be added to a document.

Back 24

Graphic

Front 25

An ___ is an item that can be sized, moved, and manipulated.

Back 25

Object

Front 26

A ___ is part of the Excel workbook.

Back 26

Drawing Object

Front 27

A ___ is an illustration such as a scanned photograph.

Back 27

Picture

Front 28

A ___ is a visual representation of data that is used to convey information in an easy-to-understand and attractive manner.

Back 28

Chart

Front 29

The ___, also called the category axis, is the bottom boundary line of the chart and is used to label the data being charted.

Back 29

X-Axis

Front 30

The left boundary line of the chart is the ___, also called the Value Axis

Back 30

Y-Axis

Front 31

In 3-D charts there can also be an additional axis, called the ___, which allows you to compare data within a series more easily.

Back 31

Z-Axis

Front 32

A ___ is a graphic object that is created using charting feature included in Excel.

Back 32

Chart Object

Front 33

An ___ becomes part of the sheet in which it is inserted and is saved as part of the worksheet when you save the workbook file.

Back 33

Embedded Chart

Front 34

A ___ is two or more objects that behave as a single object when moved or sized.

Back 34

Group

Front 35

____ provide additional information about a data marker.

Back 35

Data Labels

Front 36

A ___ is a line or several lines of text that appear at the top of a page just above the top margin line.

Back 36

Header

Front 37

A ___ is a line or several lines of text that appear at the top of a page just above the top margin line.

Back 37

Footer

Front 38

An ___ is a cell or range reference in a formula whose location does not change when the formula is copied.

Back 38

Absolute Reference

Front 39

A cell reference can also be a ____.

Back 39

Mixed Reference

Front 40

Each sheet in a workbook can be assigned a descriptive ___ to help identify the contents in the sheet.

Back 40

Sheet Name

Front 41

The ___ feature makes entering a series of heading easier by logically repeating and extending the series.

Back 41

AutoFill

Front 42

The formula contains a ____ consisting of the name of the sheet, followed by an exclamation point and the cell or range reference.

Back 42

Sheet Reference

Front 43

A ____ consists of the names of the beginning and ending sheets enclosed in quotes and separated by a colon.

Back 43

3-D Reference

Front 44

The ____ feature helps you quickly find specific information and automatically replaces it with new information.

Back 44

Find and Replace

Front 45

The ___ feature allows you to divide a worksheet window into sections, making it easier to view different parts of the worksheet at the same time

Back 45

Split Window