Excel Unit A Flashcards
studying
Contain text and numerical information not used in calculations.
Labels
Are numbers formulas and functions that can be used in calculations.
Values
Program allows you to perform numeric calculations.
Electronic Spreadsheet
Spreadsheet.
Worksheet
Individual worksheets are stored in, which is the excel file.
Workbook
Any time you use a worksheet to ask the question “what if “?.
What-if analysis
Used to create new worksheets quickly.
Templates
The intersection of a column and a row.
Cell
Every cell has its own unique location.
Cell Address
Displays the active cell address.
Name Box
Allows you to enter or edit data in the worksheet.
Formula Bar
Contains a grid of columns and rows.
Worksheet Window
Is a dark rectangle that outlines the cell you are working in.
Cell Pointer
The cell you are working in.
Active Cell
Lets you switch from sheet to sheet in a workbook.
Sheet Tabs
Provides a brief description of the active command or task progress.
Status Bar
Provides additional information about certain tasks.
Mode Indicator
You select a range when you want to perform an action on a group of cells at once such as moving them or flattening them.
Range
Is an equation in a worksheet use cell references rather than values determine what calculations will be needed.
Formula
The information necessary to calculate an answer as well as cell references and other unique information.
Arguments
Is a built-in formula.
Function
You can change the contents of an active cell at any time.
Edit
Is a feature you can use to automatically save your work as often as possible.
Auto Recover
Formulas in an excel worksheet start with the equal sign.
Formula Prefix
Indicate what type of calculation you want to perform on the cells ranges or values.
Calculator Operators
Which perform mathematical calculations.
Arithmetic Operators
Which join strings of text in different cells.
Text Concatenation Operators
Which enable you to use ranges in calculations.
Reference Operators
Shows the worksheet without including certain details like headers and footers or tools like rulers and a page number indicator its great for creating and editing a worksheet but may not be detailed enough when you want to put the finishing touches on a document.
Normal View
Provides a more accurate view of how a worksheet will look when printed.
Page Layout
Options on the page layout tab to fit a large amount of data on a single page without making changes to individual margins and to turn gridlines and column/row heading on and off.
Scale to fit
