Spreadsheet Study Guide

About this set

Created by:

sherryfleming  on September 20, 2011

Subjects:

computer applications, spreadsheets

Classes:

Keyboarding/Technology

Log in to favorite or report as inappropriate.
Pop out
No Messages

You must log in to discuss this set.

Spreadsheet Study Guide

active cell
the cell you are currently working on (it outlined with a dark box)
1/24
Preview our new flashcards mode!

Study:

Cards

Speller

Learn

Test

Scatter

Games:

Scatter

Space Race

Tools:

Export

Copy

Combine

Embed

Order by

Terms

Definitions

active cell the cell you are currently working on (it outlined with a dark box)
auto sum a formula that will add a column of numbers
cell address the column letter and the row number of a cell
cell each individual box on the spreadsheet
column the vertical reference on the spreadsheet (indicated by a letter)
Microsoft Excel the name of the spreadsheet software that we use in class
fill handle The dot at the bottom of each cell while it is active
formula always starts with an "=" sign and performs the calculations for each cell
label words, numbers, figures that will not be used for calculations.
row the horizontal reference on the spreadsheet
(indicated by a number)
selecting to highlight a set of cells
worksheet one page of a spreadsheet
sheet tabs tabs that identify the worksheets in a workbook
spreadsheet a grid that organizes data
value a number that can be used for calculations
workbook several worksheets
= starts a formula
+ symbol used to add numbers in a spreadsheet
- symbol used to subtract numbers in a spreadsheet
* symbol used to multiply numbers in a spreadsheet.
/ symbol used to divide numbers in a spreadsheet
labels, values, formulas 3 kinds of data in a spreadsheet
spreadsheet uses budgets, taxes, inventories, grades
=SUM(B2:B8) What function would return the same answer as the formula =B2+B3+B4+B5+B6+B7+B8?

First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

Set Champions

Scatter Champion

12.6 secs by Derrikrose 

Space Race Champion

58,930 points by Derrikrose 

Speller Champion

100% correct by Derrikrose 

Completed “Learn” mode

imtheking2447 , Derrikrose , cupcae01