Home > Preview
The flashcards below were created by user
Anonymous
on FreezingBlue Flashcards.

what is excel?
a computerized spreadsheet program

What are filed called in excel?
Workbooks

contains different sheets that are visible on the screen.
 Workbooks
 these sheets are called worksheets

Worksheets are where data can be ____,____, or_____.
entered, manipulated or analyzed

by default, a new workbook contains how many worksheets?
three

What is the maximum number of worksheets a workbook can include?
depends on the amount of available memory on the computer

by default, what is a new workbook named?
Book1, with a file extrension .xlsx

What was the first electronic spreadsheet and when was it introduced?

organized into a grid of rows and columns
worksheet

what is a worksheet also called?
spreadsheet

the intersection of a row and a column
cell

how is a cell named?
according to the column and row in which it is located

on a spreadsheet, ________ are labeled with letters
columns

on a spreadsheet, ________ are labed with numerals
rows

A cell named A1 is in what column and row?

How many columns and rows do each spreadsheet in Excel 2007 contain?
 16,384 columns
 1,048,576 rows
 totals more than 17 billion cells

What are the 3 types of data that can be entered in the cells of a spreadsheet?


labels, characters, words, headings....
text

mathematical entries
formula

used in many different occupations today because of their ease of use
spreadsheets

what are spreadsheets used for?
 budget preparation
 loans
 mortgages
 checking/saving accounts
 sales forecasting
 grade calculations
 bookkeeping
 accounting
 mathematics
 statistics
 real estate
 whatif analysis

Data is entered into what?
an active cell

an active cell is outlined with _____________
a bold rectangle

contains the name of the active cell
name box

where is the context of a cell displayed?
in the formula bar

when data overlaps into another column, what is needed?
a column width adjustment

How can a user adjust the column width automatically?
by doubleclicking the right column heading border

How can the user adjust the column width himself?
by clicking the right border of the column and dragging the border

When a column width is not large enough to display a value, what is displayed?
###### signs

Formula are used to calculate results, what can they include?
 numbers
 cell names
 math operators

What must a formula begin with?
an equal sign

A range of cells can be:
 one cell
 a group of cells
 rectangular array of cells

A1:D1 is a group of cell that include what?
cells A1, B1, C1, and D1

prewritten formulas which are valuable tools in a spreadsheet
functions

what follows a function name?
the argument, the part listed in the parenthesis

(A1:B1) is an example of what?
an argument

can be specific values or cell references, and are separated by commas
arguments

the correct arrangement of a function
syntax

=SUM(A1:B1)calculatesA1+B1 is an example of what?
a function

What are some function names?
 SUM
 AVERAGE
 COUNT
 MIN
 MAX
 PMT
 IF

used to easily sum values
 Autosum icon (looks like an E)
 this is the SUM function

