Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
31 Cards in this Set
- Front
- Back
active cell
|
cell ready for data entry
|
|
alignment
|
When data is entered into a cell, labels will align on the left and values will align on the right.
|
|
Cell
|
Intersection of a row and a column and identified by a cell reference
|
|
Cell range
|
A selected group of cells that form a rectangle
|
|
Cell Reference
|
The column letter and the row number. Example: B12
|
|
Column
|
Identified by letters that appear at the top of the spreadsheet. (Vertical)
|
|
Formula
|
Equations with symbols for math operations. A formula begins with an equals sign. Example= B6+B7+B8+B9
|
|
Function
|
Special formulas that do not use operations to calculate a result. I.E. a shortcut formula. Example: =Sum(A6:A9)
|
|
Label
|
text, symbol, date, or number not used in calculations
|
|
Rows
|
identified by numbers that appear at the left of the spreadsheet. (Horizontal)
|
|
Spreadsheet
|
a program that allows you to use rows and columns of data to mange, predict, and present information
|
|
value
|
a number entered into a spreadsheet cell that will be used for calculations
|
|
types of cell formatting
|
general, number, currency, percentage, text, comma, date
|
|
printing options
|
(file, Page Setup): Portrait, Landscape, With/without gridlines, With/without row and column headings
|
|
basic spreadsheet functions
|
addition, subtraction, multiplication, division
|
|
data types
|
labels (left default alignment), data expressed in words, symbols, dates, or numbers not used in calculations; values (right default alignment, data expressed in numbers; formulas (algebraic format of formulas)
|
|
alternate input devices
|
PDA, Tablet PC, Speech Recognition, virtual keyboard
|
|
keyboard or menu commands
|
mouse, arrow keys, enter
|
|
personal/home uses
|
budget, check book, car loans, grades, investments
|
|
business uses
|
payrolls, budgeting, investments, inventory costs, loan payments
|
|
spreadsheet applications
|
budgets, checkbook, product prices, payroll, financial statements, profit/loss statements, company bids
|
|
textbox
|
_____________ is movable resizable container for text or graphics
|
|
linked object
|
_______ ______ maintains connection b/w two files
|
|
source file
|
______ ________ is created in and destination file it’s inserted into
|
|
external reference
|
reference to cell or range of cells on sheet in another Excel workbook, or reference to defined name in another workbook
|
|
linking
|
__________ reference to cell or range of cells on sheet in another Excel workbook, or reference to defined name in another workbook
|
|
linked objects
|
use ______ ________ when u want information in destination file to be updated as source data changes
|
|
embedded object
|
use ________ _________ when you don’t want to update the copied data as it changes in the source file
|
|
linked object
|
linked to source file
|
|
embedded object
|
no connection to source file
|
|
source file
|
updates the linked object
|