-
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
- what-if 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 double-clicking 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
-
pre-written 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
|
|
