Card Set Information
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?
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?
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?
What must a formula begin with?
an equal sign
A range of cells can be:
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