Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/31

Click to flip

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