Excel Parts and Definitions

Question 1

What is a spreadsheet?

Answer 1

A program that displays data (text & numbers) in a table called a worksheet.

Question 2

Uses of spreadsheet

Answer 2

-Prepares budget
-Financial statements
-Inventory Management
-Create charts

Question 3

What is a worksheet?

Answer 3

A grid with columns and rows; the term worksheet is used interchangeably with spreadsheet.

Question 4

Parts of Excel

Answer 4

-Title bar
-Workbook Name
-Menus
-Ribbon
-Formula Bar
-Cells (which contain data for values)
-Worksheet
-Worksheet Tabs
-Workbook
-Status Bar
-Row Headings (with row numbers)
-Column Headings (Letters)
-Name box

Question 5

What is a cell?

Answer 5

The intersection of a row and column

Question 6

What 3 things can you type into a cell?

Answer 6

-Label (words or letters)
-Values (numbers)
-Formulas (statement that performs a calculation)

Question 7

What is a cell range?

Answer 7

A group of cells that are closely together.

Question 8

What are columns?

Answer 8

Vertical arrangements of cells; identified by letters.

Question 9

What are rows?

Answer 9

Horizontal arrangements of cells; identified by numbers.

Question 10

What is a Cell Address? (reference)

Answer 10

This is a column letter and row number combination, such as: A1, B2

Question 11

What is a name box?

Answer 11

Displays the name of the active cell or range

Question 12

What is a formula bar?

Answer 12

Displays the data or formula stored in the active cell

Question 13

What is an active cell?

Answer 13

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

Question 14

What is a function?

Answer 14

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

Question 15

What are Operation Symbols?

Answer 15

Instruct the computer as to what mathematical operations to perform.

Question 16

Operation Symbols

Answer 16

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

Question 17

What is a column width tool?

Answer 17

Tool that changes the width of the columns on spreadsheet

Question 18

What is a row height tool?

Answer 18

Tool that changes the height of rows on a spreadsheet

Question 19

What is the Fill Handle tool?

Answer 19

Used to copy data and formulas to another cell; and create a series

Question 20

What is Auto Sum Tool?

Answer 20

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

Question 21

What is a Chart?

Answer 21

Graphic representations used to compare and contrast worksheet data

Question 22

What is sorting?

Answer 22

Organizing or rearranging data in either ascending (A-Z/smallest to largest) or descending order (Z-A largest to smallest)

Question 23

Common Formula Errors

Answer 23

-##### (Railroad Tracks Error)
occurs when the column is not wide enough to display the contents of the cell
-#REF!
occurs when the cell reference is not valid because the cell may have been deleted or pasted over incorrectly
-#NAME?
occurs when a misspelling has occurred in a function name