Excel 1 Flashcards
(32 cards)
The spreadsheet is called a _______
Work sheet
What does an electronic spreadsheet program allow you to do
Perform numeric calculations
Individual work sheets are stored in a ________
Work book
What are 5 advantages of using Excel
- Enter data quickly and accurately
- Recalculate data quickly
- Perform what-if analysis
- Create charts
- Share information
What does the name box do
Displays the active cell address
What allows you to enter or edit data in the worksheet
The formula bar
The intersection of a row and a column is called a ______
Cell
What is the cell address
Cells own unique location
The cell in which you are working on is
The active cell
What allows you to switch from sheet to sheet in a workbook
Sheet tabs
What does the status bar do
Provides a brief description of the active command
What does the mode indicator do
Provides additional information about certain tasks
What are equations in a worksheet called
Formulas
What are 3 things you must do when creating calculations in Excel
- Create formulas with care
- Use cell references rather than values
- Determine what calculations will be needed
What do labels contain
Text and numerical info not used in calculations
What is the name for the info that can be used in calculations
Values
What is the name for a built in formula
Function
What is the name for the necessary info in a function
Arguments
What are the 3 ways to edit a cell
- Double click the cell
- Formula bar
- Just start typing
What goes at the start of a formula ?
Equal sign (=) also called the formula prefix
What do arithmetic operations do
Perform mathematical calculations
What do comparison operators do
Compare values for the purpose of true/false
What are these symbols examples of? > < >= <>
Comparison operators
What do text concatenation operators do
Join strings of text in different cells
&
