Card Set Information
An equation in a worksheet that calculates a results.
contains the word tabs each tab on the ribbon includes buttons for command related to editing and formatting documents.
is contained in a file called a workbook
Sorting data in ascending or descending order; list products or customer names, or prioritizing orders by date.
Creating data summaries and short lists using Pivot tables or Auto-filters Exam: making a list of customers based on their income.
Predesigned formatted files.
Displays the active Cell address...A 1
This is were you enter or edit data in a worksheet
is a dark rectangle the outlines the cell you are working in this is also called the active cell
located below the worksheet grid, lets you switch from sheet to sheet in a workbook
is located at the bottom of the Excel window. A brief description of the active command or task.
A selection of two or more cells such as B:5 B:14
Are entries that contain text and numerical information not used in calculation. Helps you identify data in worksheet rows and columns.
is a built in formula; it includes the argument.
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.
copy cell contents to adjacent cells +
select a cell range; indicates ready mode.
starts with a equal sign
In intersection of a column and a row
File consisting of one or more worksheets
Direction in which contents of page will print.
Default in which contents of page will print.
Is one that uses more than one arithmetic operator. It uses a formula that can calculate addition,multiplication and division.
A type of cell formatting that changes based on the cell's value or the outcome.