Excel Parts and Definitions Flashcards
100%
What is a spreadsheet?
A program that displays data (text & numbers) in a table called a worksheet.
Uses of spreadsheet
-Prepares budget
-Financial statements
-Inventory Management
-Create charts
What is a worksheet?
A grid with columns and rows; the term worksheet is used interchangeably with spreadsheet.
Parts of Excel
-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
What is a cell?
The intersection of a row and column
What 3 things can you type into a cell?
-Label (words or letters)
-Values (numbers)
-Formulas (statement that performs a calculation)
What is a cell range?
A group of cells that are closely together.
What are columns?
Vertical arrangements of cells; identified by letters.
What are rows?
Horizontal arrangements of cells; identified by numbers.
What is a Cell Address? (reference)
This is a column letter and row number combination, such as: A1, B2
What is a name box?
Displays the name of the active cell or range
What is a formula bar?
Displays the data or formula stored in the active cell
What is an active cell?
The cell in which you are currently working (normally the cell is surrounded by a black or green border.)
What is a function?
A built-in formula that is a shortcut for common calculations such as addition and average.
What are Operation Symbols?
Instruct the computer as to what mathematical operations to perform.
Operation Symbols
-Addition (+)
-Subtraction (-)
-Multiplication (x)
-Division (/)
What is a column width tool?
Tool that changes the width of the columns on spreadsheet
What is a row height tool?
Tool that changes the height of rows on a spreadsheet
What is the Fill Handle tool?
Used to copy data and formulas to another cell; and create a series
What is Auto Sum Tool?
Automatically creates a formula to add a series of numbers in a spreadsheet
What is a Chart?
Graphic representations used to compare and contrast worksheet data
What is sorting?
Organizing or rearranging data in either ascending (A-Z/smallest to largest) or descending order (Z-A largest to smallest)
Common Formula Errors
-##### (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
