an application you use to perform numeric calculations and to analyze and present numeric data
what is Electronic Spreadsheet-
100
the electronic spreadsheet you work in
What is Worksheet
100
this is the file that the worksheet is contained in
What is Workbook
100
any time you use a worksheet to ask the question “what if?” you are performing this type of analysis
What is What-if analyze
100
Templates- predesigned formatted files
What is Templates-
200
displays the active cell address
What is Name box
200
Formula bar- allows you to enter or edit data in the worksheet
What is Formula bar
200
are labeled alphabetical and can contain a total of 16,384 columns
What is Columns
200
Row- labeled numerically and can contain a total of 1,048
What is Row
200
- the intersection of a column and a row; can contain text, numbers, formulas, or a combination of all three
What is Cell
300
Cell pointer- a dark rectangle that outlines the cell in which you are working
What is Cell pointer
300
Active cell- the cell in which you are working
What is Active cell
300
- below the worksheet grid let you switch from sheet to sheet in a workbook. By default, workbook file contains three worksheets, but you can have as many as 255
What is Sheet tab
300
Scroll bar- use these to move around in a document that is too large to fit on the screen at once
What is Scroll bar
300
Status bar- located at the bottom of the Excel window; provides a brief description of the active command or task in progress
What is Status bar
400
Mode indicator- the bottom-left corner of the status bar provides additional information about certain tasks
What is Mode indicator
400
Range- selection of two or more cells such as B5:B14; you select a range when you want to perform an action on a group of cells at once, such as moving them or formatting them
What is Range- selection
400
Labels-entries that contain text and numerical information not used in calculations; help you identify data in worksheet rows and columns
What is Labels-
400
Values- numbers, formulas, and functions that can be used in calculations
What is Values
400
- a built-in formulas; includes the arguments as well as cell references and other unique information
What is Function
500
- an application you use to perform numeric calculations and to analyze and present numeric data
What is Electronic Spreadsheet
500
the electronic spreadsheet you work in
What is Worksheet-
500
this is the file that the worksheet is contained in
What is Workbook
500
- any time you use a worksheet to ask the question “what if?” you are performing this type of analysis