Home
Flashcards
Preview
Excel
Home
Get App
Take Quiz
Create
Formula
An equation in a worksheet that calculates a results.
Ribbon
contains the word tabs each tab on the ribbon includes buttons for command related to editing and formatting documents.
Worksheet
is contained in a file called a workbook
Organize Data
Sorting data in ascending or descending order; list products or customer names, or prioritizing orders by date.
Analyze Data
Creating data summaries and short lists using Pivot tables or Auto-filters Exam: making a list of customers based on their income.
Templates
Predesigned formatted files.
Name Box
Displays the active Cell address...A 1
Formula Bar
This is were you enter or edit data in a worksheet
Cell Pointer
is a dark rectangle the outlines the cell you are working in this is also called the active cell
Sheet Tabs
located below the worksheet grid, lets you switch from sheet to sheet in a workbook
Status Bar
is located at the bottom of the Excel window. A brief description of the active command or task.
Range
A selection of two or more cells such as B:5 B:14
Labels
Are entries that contain text and numerical information not used in calculation. Helps you identify data in worksheet rows and columns.
Function
is a built in formula; it includes the argument.
Arguements
The information necessary to calculate an answer, as well as a cell reference and other unique information.
Page Layout Review
Provides a more accurate view of how a worksheet will look when printed.
Fill Handle
copy cell contents to adjacent cells +
Normal
select a cell range; indicates ready mode.
Formula Prefix
starts with a equal sign
Cell
In intersection of a column and a row
Workbook
File consisting of one or more worksheets
Normal View
Direction in which contents of page will print.
Orientation
Default in which contents of page will print.
Complex Formula
Is one that uses more than one arithmetic operator. It uses a formula that can calculate addition,multiplication and division.
Conditional Formatting
A type of cell formatting that changes based on the cell's value or the outcome.
Author
cassandrawood
ID
207555
Card Set
Excel
Description
Microsoft
Updated
2013-03-16T03:08:37Z
Home
Flashcards
Preview