Spreadsheets1

1. When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?

Addition operator

Dovision operator

Equal sign

Substraction sign

2. An advantage of a spreadsheet is the speed of accomplishing what?

Calculating numbers

Grammar checking

Newsletter creating

Searching and retrieving

3. The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 31?

=MAX(A1:A6)

=MIN(A1:A6)

=ROUND(A1:A6)

=SUM(A1:A6)

4. Which function would be used to indicate the smallest value in a range of spreadsheet cells?

COUNT

MAX

MIN

SUM

5. The intersection of a column and row in a spreadsheet is called what?

Cell

Column

Function

Row

6. What specific format would change 29.99 to $29.99?

Currency

Number

Percentage

Scientific

7. What is a statement that performs a calculation in a spreadsheet?

Cell

Formula

Label

Value

8. The cell in which you are currently working is known as what?

Active cell

Cell address

Cell reference

Spreadsheet cell

9. The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?

=MAX(A1:A6)

=MIN(A1:A6)

=AVERAGE(A1:A6)

=SUM(A1:A6)

10. What are the three most common types of charts used to illustrate spreadsheet data?

Bar, line, and pie

Bar, line, and scattergram

Line, pie, and area

Pie, scattergram, and stacked bar

11. Which function would return the same answer as the formula =B2+B3+B4+B5+B6+B7?

=SUM(B2/B7)

=SUM(B2+B7)

=SUM(B2:B7)

=SUM(B2*B7)

12. A mathematical operation that is built into a spreadsheet program to perform shortcut calculations is called what?

Cell

Function

Label

Value

13. What is the vertical portion of a spreadsheet that is identified by a letter?

Cell

Column

Reference

Row

14. The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 2. What function would return the answer 2?

=MAX(A1:A6)

=MIN(A1:A6)

=ROUND(A1:A6)

=SUM(A1:A6)

15. What is the horizontal portion of a spreadsheet that is identified by a number?

Cell

Column

Reference

Row

16. What are cells that need to remain the same when copied?

Absolute

Automation

Relational

Relative

17. A series of dialog boxes used to provide steps in creating a chart is called what?

Chart helper

Chart wizard

Guide master

Wizard maker

18. How is spreadsheet software used for personal use?

Doing language art homework

Keying a personal business letter

Organizing a baseball card collection

Predicting entertainment expenses

19. Repeated pound signs in a spreadsheet cell indicate what?

Column width too narrow

Column width too wide

Row height too narrow

Row height too wide

20. What is the first step in creating a chart or graph?

Choose page setup for orientation

Choose the chart wizard for help

Select print preview to see graph

Select the data you wish to plot

21. Numerical data entered into a spreadsheet is called what?

Formula

Label

Text

Value

22. What are bar charts MOST effectively used to show?

Compare groups of similar data

Present scientific data

Show data as part of a whole

Show changes over a period of time

23. Cells that automatically change when copied are called what?

Absolute

Automation

Relational

Relative

24. What is one advantage of a spreadsheet program?

Answers "what does" questions

Answers "what if" questions

Checks for inaccurate data

Writes formulas automatically

25. What is alphabetical text entered into a spreadsheet?

Formula

Label

Text

Value