Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
33 Cards in this Set
- Front
- Back
An excel spread sheat is used for what |
to store, display, manipulate numbers |
|
Define Workbook |
The excel data file composed of one or more worksheets |
|
Define Worksheet |
collection of cells, organized in columns, rows. Columns identified with letters, rows with numbers |
|
define Cell |
uniquely identified unit of storage, |
|
define a range |
a group of selected cells, |
|
what shape is a range |
always a rectangle |
|
In excel rows are identified with _______and columns with _________ |
rows- numbers columns- letters |
|
how do you format borders in a range |
1. home tab 2. font icon 3. borders |
|
what would 09821 look like formatted as a date |
11/20/1926 |
|
09821 formatted as a number with two decimal places |
98.21 |
|
what would 09821 look like formatted as a percentage |
9821.00% |
|
what would 09821 look like formatted as a zip code |
09821 |
|
what are the 4 most popular charts used in excel |
pie, line, bar, column |
|
how can you change the type of chart |
clicking a new chart |
|
what does #REF! mean |
pasted formula too close to edge of worksheet, or deleted a a cell that is part of the formula |
|
what does ######## mean |
number too large for column width |
|
what does #VALUE mean |
text is in a math formula |
|
What does #NAME mean |
typo in the formula |
|
name the differnt excel cursors |
1. Column resizer cursor 2. mouase hovering over fill line 3. repositioning cursor |
|
what is a group of cells hilighted in the shape of a rectangle |
range |
|
the auto sum greek letter is called |
sigma |
|
What is the first rule of sorting data |
highlight all your data |
|
What is the second rule of sorting data |
verify checkbox for my data has headings |
|
In excel formats are applied to |
cells |
|
What happens when you click and drag on the fill handle |
copy cell contents, or fill cell with series, depending on cell contents |
|
If change tracking is turned on for a document, what must be done to remove all the information from the file |
accept or reject the information |
|
list the 4 formats that require section breaks |
1. origins 2. Columns 3. Header and footer 4. margin |
|
list steps to sort names alphabetically |
a. select range b. data tab c. sort command d. decide sorting order |
|
why would te error #REF! appear after a column was deleted |
a column was a part of the formula |
|
while typing, the error #NAME appears. Why |
there is a pyto in the formula |
|
how to fix an ######## error |
widen the cell, adjust the numbers |
|
which chart is best for showing several categories |
pie |
|
which chart is best in showing data over a few years |
line |