MICROSOFT EXCEL

Question 1

program that displays data (text and numbers) in a table called a worksheet

Answer 1

Spreadsheet

Question 2

• grid with columns & rows
• Is used interchangeably with spreadsheet

Answer 2

Worksheet

Question 3

intersection of a row and column

Answer 3

Cell

Question 4

3 Things you can put in a cell

Answer 4

Label- words or letters
Value- number
Formula- statement that performs a calculation

Question 5

group of cells that are closely together

Answer 5

Cell range

Question 6

vertical arrangements of cells; identified by letters

Answer 6

Columns

Question 7

horizontal arrangement of cells, identified by numbers

Answer 7

Rows

Question 8

tab that identifies each open worksheet in a spreadsheet program, located in the lower left corner of the screen

Answer 8

Worksheet tab

Question 9

column letter and row number combination, such as A1, B2

Answer 9

Cell Address (Reference)

Question 10

displays the data or formula stored in the active cell

Answer 10

Formula Bar

Question 11

the cell in which you are currently working (normally the cell is surrounded by a black border)

Answer 11

Active Cell

Question 12

a built-in formula that is a shortcut for common calculations such as addition and average

Answer 12

Function

Question 13

instruct the computer as to what mathematical operations to perform

Answer 13

Operation Symbols

Question 14

Operation Symbols

Answer 14

Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)

Question 15

Orders of Operations

Answer 15

PEMDAS

Question 16

tool that changes the width of the columns on a spreadsheet

Answer 16

Column Width Tool

Question 17

tool that changes the height of rows on a spreadsheet

Answer 17

Row Height Tool

Question 18

used to copy data & formulas to another cell; and create a series

Answer 18

Fill Handle Tool

Question 19

automatically creates a formula to add a series of numbers in a spreadsheet

Answer 19

Auto Sum Tool

Question 20

graphic representations used to compare & contrast worksheet data

Answer 20

Chart

Question 21

organizing or rearranging data in either ascending or descending order

Answer 21

Sorting

Question 22

Sorting

Answer 22

Sort Ascending
Sort Descending

Question 23

Uses of Spreadsheet

Answer 23

Prepare budgets
Financial statements
Inventory management
Create charts

Question 24

Occurs when column is not wide enough to display the contents of the cell

Answer 24

(Railroad Tracks Error)

Question 25

Occurs when the cell reference is not valid because the cell may have been deleted or pasted over incorrectly

Answer 25

#REF!

Question 26

Occurs when a misspelling has occured in a function name

Answer 26

#NAME

Question 27

EXCEL

Answer 27

Is the MS Office Application program used for creating spreadsheets

Question 28

Use to enter all sorts of data and perform financial, mathematical, or statistical calculations

Answer 28

EXCEL

Question 29

is composed of a number of worksheets (could be more than 200)

Answer 29

Excel file or a workbook

Question 30

each tab represents a different worksheet in the workbook

Answer 30

Sheet tabs

Question 31

is the selected cell, and has a thicker black border around it

Answer 31

The Active Cell

Question 32

displays the active cell address or the name of the selected cell, range, or object

Answer 32

Name Box

Question 33

displays the data or formula stored in the active cell

Answer 33

Formula Bar

Question 34

PARTS OF EXCEL

Answer 34

Excel file or a workbook Sheet tabs Active Worksheet Row Headers Column Headers The Active Cell The Name Box Formula Bar