Icc - Excel Part 1

Front 1

A powerful spreadsheet program that allows you to organize data, complete calculations, make decisions, graph data, and create reports.

Back 1

Microsoft Excel

Front 2

What are the four parts to Microsoft Excel?

Back 2

Worksheets, Charts, Databases, and Web Support

Front 3

This is a separate window that enables users to carry out some Excel tasks more efficiently.

Back 3

Task Pane

Front 4

When Excel starts it creates a new blank _______, called Book1.

Back 4

Workbook

Front 5

Each worksheet name on the workbook pages are named at the bottom of the page and displays on the _______.

Back 5

Sheet Tab

Front 6

The column letter above the grid that names the column is called the ______.

Back 6

Column Heading

Front 7

A row number on the left side of the grid names the rows by numbers and is called the _______.

Back 7

Row Heading

Front 8

The basic unit of a worksheet into which you enter Data.

Back 8

Cell

Front 9

A cell is referred to by it's unique address which is the coordinates of the intersecting row and column and is called the _______________.

Back 9

Cell Reference

Front 10

Only one cell at a time is available for you to use to enter data and that cell is called the ___________.

Back 10

Active Cell

Front 11

The active cell reference displays immediately above Column A in the _____.

Back 11

Name Box

Front 12

The horizontal and vertical lines on the worksheet are called ______.

Back 12

Grid-lines

Front 13

The mouse pointer displays as this whenever it is located in a cell on the worksheet.

Back 13

Block Plus Sign

Front 14

The mouse pointer turns into this whenever you move outside the worksheet or when you drag the cell contents between rows and columns.

Back 14

Block Arrow

Front 15

You view the portion of the worksheet displayed on the screen through this.

Back 15

Worksheet Window

Front 16

Below and to the right of the Worksheet Window are three things that can be used to move the window around and view different parts of the active worksheet.

Back 16

Scroll Bars, Scroll Arrows, and Scroll Boxes

Front 17

You can use this to increase or decrease the view of the sheet tabs and is located to the right of the Sheet Tabs at the bottom of the screen.

Back 17

Tab Split Box

Front 18

A _____ is a list of commands.

Back 18

Menu

Front 19

If you point to a command on a menu with an arrow to its right, a ______ displays.

Back 19

Sub-menu

Front 20

When you click a menu name on the menu bar, a _____ displays and lists the most recently used commands.

Back 20

Short Menu

Front 21

The ________ displays or lists ALL of the commands associated with a menu.

Back 21

Full Menu

Front 22

When you move the mouse pointer over a button or box, the name displays below it in a ___________.

Back 22

Screen Tip

Front 23

You can show the two tool-bars on two rows by clicking the _______________ in the Toolbar Options List.

Back 23

Show Buttons on Two Rows Command

Front 24

As you type the data displays in the _______.

Back 24

Formula Bar

Front 25

This displays a brief description of the command selected in a menu, a function of the button, or the Mode of Excel.

Back 25

Status Bar

Front 26

This can be used in place of a calculator to view sums, averages, or other types of totals of a group of numbers on a worksheet.

Back 26

AutoCalculate Area

Front 27

__________ show which keys are engaged.

Back 27

Keyboard Indicators

Front 28

In Excel, any characters containing a letter, hyphen, or space is considered ______.

Back 28

Text

Front 29

The __________ is a blinking vertical line that indicates where the next typed character will be displayed.

Back 29

Insertion Point

Front 30

________ means that the text will be placed at the far left of the cell.

Back 30

Left-Aligned

Front 31

Clicking the ______ completes the entry and clicking the ______ cancels the entry.

Back 31

Enter Box , Cancel Box

Front 32

The ______ works behind the scenes to correct common mistakes when you complete a text entry in a cell.

Back 32

AutoCorrect Feature

Front 33

________ means the text or characters are displayed to the far right of the cell.

Back 33

Right-Aligned

Front 34

The ________ is a convient way to add the numbers in cells together.

Back 34

Sum Function

Front 35

You can use the _______ on the standard toolbar to enter the Sum Function.

Back 35

AutoSum button

Front 36

Excel surrounds the proposed cell to sum with a moving border called a ______.

Back 36

Marquee

Front 37

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

Back 37

Range

Front 38

The cell being copied is called this.

Back 38

Source Area or Copy Area

Front 39

The range of cells receiving the copy is called the _______.

Back 39

Destination Area or Paste Area

Front 40

each adjusted cell reference is called a ______.

Back 40

Relative Reference

Front 41

The _____ is the small black square located in the lower-right corner of the heavy border around an active cell.

Back 41

Fill Handle

Front 42

The heavy border and transparent (blue) background is called the ______.

Back 42

See-Through View

Front 43

This is an alternative to merging cells.

Back 43

Splitting a Cell

Front 44

Excel has several customized format styles called ________ that allow you to format the body of the worksheet.

Back 44

Table Formats

Front 45

This box is located on the left side of the Formula Bar.

Back 45

Name Box