what is excel?
a computerized spreadsheet program
What are filed called in excel?
contains different sheets that are visible on the screen.
- 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?
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
what is a worksheet also called?
the intersection of a row and a column
how is a cell named?
according to the column and row in which it is located
on a spreadsheet, ________ are labeled with letters
on a spreadsheet, ________ are labed with numerals
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....
used in many different occupations today because of their ease of use
what are spreadsheets used for?
- budget preparation
- checking/saving accounts
- sales forecasting
- grade calculations
- 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
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?
Formula are used to calculate results, what can they include?
- 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
what follows a function name?
the argument, the part listed in the parenthesis
(A1:B1) is an example of what?
can be specific values or cell references, and are separated by commas
the correct arrangement of a function
=SUM(A1:B1)-calculatesA1+B1 is an example of what?
What are some function names?
used to easily sum values
- Autosum icon (looks like an E)
- this is the SUM function