 |
1 | |
____ was the first spreadsheet program. |
| | A) | Excel. |
| | B) | VisiCalc. |
| | C) | Access. |
| | D) | Lotus 1-2-3. |
|
|
2 | |
_____ was the first integrated spreadsheet program. |
| | A) | VisiCalc |
| | B) | Lotus 1-2-3 |
| | C) | Excel |
| | D) | Plannercalc |
|
|
3 | |
In Microsoft Excel, a cell is: |
| | A) | Identified by its column letter and row number. |
| | B) | Identified by x and y coordinates on a grid. |
| | C) | Identified by a field marker. |
| | D) | Identified by its row letter and column number. |
|
|
4 | |
The letters across the top of a spreadsheet identify the ______. |
| | A) | Cells. |
| | B) | Columns. |
| | C) | Rows. |
| | D) | Variables. |
|
|
5 | |
What type of information cannot be entered into a cell? |
| | A) | Text. |
| | B) | Clip art |
| | C) | Numbers |
| | D) | Formulas. |
|
|
6 | |
A function is: |
| | A) | A spreadsheet template. |
| | B) | A formula that you create and save for future use. |
| | C) | A group of related cells that are used in a calculation. |
| | D) | A built-in software routine that performs a task. |
|
|
7 | |
Which of following questions could not be answered with a "what if" analysis? |
| | A) | What would happen to a student's average if the student scored an 80 percent on an exam instead of a 60 percent? |
| | B) | What grade will I achieve in the class if I earn a 90 percent on the final exam? |
| | C) | If my interest rate drops from eight to six percent, what will my mortgage payments be? |
| | D) | Which students do not take an active interest in this course? |
|
|
8 | |
If you change a number in a spreadsheet, related formulas are automatically _____. |
| | A) | Deleted |
| | B) | Recalculated |
| | C) | Hidden |
| | D) | None of the above |
|
|
9 | |
A _______ is a group of commands combined into one or two keystrokes: |
| | A) | Function. |
| | B) | Formula. |
| | C) | Add-on software. |
| | D) | Macro. |
|
|
10 | |
Which of the following is not an advanced feature of a spreadsheet? |
| | A) | Linking |
| | B) | Database capabilities |
| | C) | Desktop publishing tools |
| | D) | Defragmenting |
|
|
11 | |
What is not a consideration when choosing a spreadsheet program for the classroom? |
| | A) | Ease of use |
| | B) | Available fonts |
| | C) | Hardware compatibility |
| | D) | Support |
|
|
12 | |
A spreadsheet can be used for all of the following, except: |
| | A) | As a grade book and attendance chart. |
| | B) | To convert numerical data into charts. |
| | C) | To input graphics and clip art within cells. |
| | D) | "What-if" analysis. |
|
|
13 | |
______ is spreadsheet program appropriate for the third-grade level. |
| | A) | AppleWorks. |
| | B) | The Cruncher 2.0. |
| | C) | Microsoft Works. |
| | D) | Excel. |
|
|
14 | |
In its most common configuration, an integrated program includes: |
| | A) | Desktop publishing, spreadsheet and graphics creation. |
| | B) | Word processing, spreadsheet, and desktop publishing. |
| | C) | Word processing, spreadsheet, and database. |
| | D) | Presentation graphics, spreadsheet, and word processor. |
|
|
15 | |
What is the critical difference between a software suite and an integrated program? |
| | A) | Software suites do not feature a clipboard; integrated programs do. |
| | B) | An integrated program requires a more powerful computer than a suite. |
| | C) | It is easier to learn a suite of programs than it is to learn an integrated program. |
| | D) | A software suite is composed of several programs that can be purchased separately; an integrated program does not offer its components separately. |
|