Excel 1 Flashcards
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
&
What operators enable you to use specific ranges in calculations
Reference operators
What 2 methods can you do to change the view of the worksheet window
- View tab on the Ribbon
2. View buttons on the status bar
What view shows the worksheet without including headers and footers or rulers
Normal view
What view provides a more accurate view of how a worksheet will look printed
Page layout view
What view displays a reduced view of each page of the worksheet, along with page indicators
Page break preview
What 2 options allow you to see how a worksheet will look when printed
- Page layout tab
2. Print preview
What does the dotted line in the print layout tab signify
The print area for the sheet
What does backstage view do
Let’s you choose the number of copies, printer, etc