CPST
Card Set Information
Author:
Anonymous
ID:
52524
Filename:
CPST
Updated:
2010-11-30 21:58:48
Tags:
Final
Folders:
Description:
Using Excel
Show Answers:
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?
VisiCalc
1979
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?
column A
row 1
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?
Value
Text
Formula
numerical entries
values
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