1. You can provide one-click use of your favorite Excel tools by adding them to the
Title bar
Quick access toolbar
Fromula bar
Fast action toolbar
2. A workbook that has "compatibility mode" added to the end of its name is one that
may be opened by all brands of spreadsheet software
has had all of its calculations confirmed as "compatible"
is an older MS Excel file format
is usable for many purposes
3. In MS Excel 2010 and later, a workbook may be saved in the (select all that apply)
.xlsx file format
.pdf file format
.xls file format
4. An MS Excel workbook is a
a file
spreadsheet where calculations are done
book the teaches how to work with a spreadsheet
one page of a spreadsheet
5. An MS Excel worksheet is a (select all that apply)
matrix lettered columns and numbered rows
collection of one or more worksheets
database of lettered columns and numbered rows
database of numbered columns and letters rows
6. In MS Excel, text data may consist of (select all that apply)
alphabetic characters (a-z, A-Z)
numeric characters (0-9) and an optional period
other characters (for example: ?, ", &, #)
7. In MS Excel, numeric data may consist of
alphabetic characters (a-z, A-Z)
numeric characters (0-9) and an optional period
special characters (for example: ?, ", #, &)
all of the above
answers 1 & 2
8. The cell reference A1 is a
Absolute reference
Mixed (relative row, absolute column) reference
Mixed (absolute row, relative column) reference
Relative reference
9. The cell reference $A1 is a
Absolute reference
Mixed (relative row, absolute column) reference
Mixed (absolute row, relative column) reference
Relative reference
10. The cell reference $A$1 is a
Absolute reference
Mixed (relative row, absolute column) reference
Mixed (absolute row, relative column) reference
Relative reference
11. Use "Save As"
everytime you save a file
only the first time you save a file. After that you must use "Save"
- never use "Save As" - always use "Save"
the first time you save a file and anytime after that you want to change its name, location or type
12. The file-type of a file
is indicated by the file's extension
must be either .xls or .xlsx
can be changed by editing the file's extension
will automatically change if you open the file in a different program than the one that created it
13. A digital signature
is a fancy font that looks like you signed it by hand
records the number of times a document has been accessed
restricts access to those who know the signature
demonstrates the authenticity of a digital message or document
14. The fill handle (select all that apply)
is in the lower right-hand side of a cell or an area
may be used to fill cells with data
may be used to clear cells
15. To adjust a cell range in a formula (select all that apply)
edit the Formula bar
drag the cell range border
select the cells for new range
16. A syntax error in a formula may be the results of (select all that apply)
a typographical error
incorrect cell reference
using the wrong formula
17. Formula auditing
is used by accountants
is used by the IRS
is a color-coded editing system
all of the above
answers 1 & 2
18. In MS Excel cell references may be (select all that apply)
relative
absolute
mixed
19. An absolute reference
adjusts when you copy a formula
does not adjust when you copy a formula
contains one relative and one absolute reference
all of the above
answers 1 & 2
20. A relative reference
adjusts when you copy a formula
does not adjust when you copy a formula
contains one relative and one absolute reference
all of the above
answers 1 & 2
21. A mixed reference
adjusts when you copy a formula
does not adjust when you copy a formula
contains one relative and one absolute reference
all of the above
answers 1 & 2