ASSIGN 2

 

 

 

 

Spring Semester 1995

Fall Semester 1995

Total 1995

% Inc.

Spring Semester 1996

Fall Semester 1996

Average Cost Per Semester

Projected Total 1996

Tuition-18 hours

 $2,700.00

 $2,920.00

 $5,620.00

20%

 $3,240.00

 $3,504.00

 

 $6,744.00

 

Books-main subject

 $   456.00

 $   395.00

 $   851.00

10%

 $   501.60

 $   434.50

 

 $   936.10

 

Books-additional

 $     85.00

 $   135.00

 $   220.00

10%

 $     93.50

 $   148.50

 

 $   242.00

 

Supplies-general

 $     65.00

 $     80.00

 $   145.00

10%

 $     71.50

 $     88.00

 

 $   159.50

 

Supplies-lab

 $   125.00

 $   100.00

 $   225.00

20%

 $   150.00

 $   120.00

 

 $   270.00

 

Supplies-other

 $     44.00

 $     54.00

 $     98.00

10%

 $     48.40

 $     59.40

 

 $   107.80

 

Lab Fees

 $     90.00

 $     90.00

 $   180.00

20%

 $   108.00

 $   108.00

 

 $   216.00

 

Other

 $     50.00

 $     50.00

 $   100.00

10%

 $     55.00

 $     55.00

 

 $   110.00

 

Totals

 $3,615.00

 $3,824.00

 $7,439.00

 

 $4,268.00

 $4,517.40

 

 $8,785.40

 

 

 

 

 

 

 

 

 

 

 

Book Totals

 

 

 

 

 

 

 

 

Supplies Totals

 

 

 

 

 

 

 

 

Tuition and Fees

 

 

 

 

 

 

 

 

 

 

  1. Give the names
  2. Try selecting the named ranges using the drop-down list in the formula bar.
  3. Enter the formula =today() in cell A1.
  4. Choose Cells... from the Format menu, and use the Format Code d-mmm-yy to format cell A1
  5. Use the Function Wizard button on the toolbar to insert a function into cell D12: Choose the function SUM, then click the Next > button. Enter books95 in the number1 text box, then click Finish.
  6. Enter =sum(supplies95) in cell D13. Add similar formulas for cells I12 and I13.
  7. In cell H2, enter the formula =average(b2:c2, f2:g2).
  8. Copy the formula in H2 to the range H3:H9
  9. Enter the formulas:
  10. Select cell B18, and start the Function Wizard. Choose Logical in the list of function categories, and choose the function name IF. Click Next and enter B16 < 8500 as the logical test. Enter "YES!" as the value_if_true and "NO" as the value_if_false. Click Finish.
  11. Use AutoFormat to format the spreadsheet nicely.
  12. Use the ChartWizard to create pie charts showing how the money in columns D and I is distributed among the categories in column A.
  13. Create a line graph showing how the cost of each category increases from semester to semester.

Answer the following questions:

  1. A collection of cells that you can use in a formula is:
    1. B2..B2
    2. B2:G2
    3. B2:G2,B6
    4. B4+C4,C6
  2. Which of the following is not a valid formula?
    1. =AVERAGE(B2;C2;D4;G4)
    2. =SUM(B2:B8)-AVG(D2:D4)
    3. =SUM(AVG(C3;C4),(AVG F6:F9))
    4. =SUM(SUM(C3:C9,SUM(D3:D9))
  3. Which of the following is not a valid range name?
    1. tuitionandfees95
    2. tuition_1995
    3. tuition fees
    4. tuition&fees
  4. When using the IF conditional statement, you can:
    1. set a condition and get one answer if the condition is true and a second answer if the condition is false
    2. set one condition and one argument to analyze a formula
    3. enter a condition that performs a calculation on a formula
    4. list between two and six arguments that apply to the IF condition
  5. Which of the following could cause the error message #NAME? to be returned as a result?
    1. using too many functions
    2. using the wrong named ranges
    3. using too many parentheses
    4. using the wrong symbols for operators
  6. Which of the following is not part of a chart?
    1. X-axis
    2. title
    3. caption
    4. legend
  7. Which of the following charts represents data in pars as compared to the whole?
    1. line
    2. pie
    3. bar
    4. x-y
  8. Which of the following charts does not come in 3-D?
    1. line
    2. pie
    3. radar
    4. area
  9. Which of the following is not an Excel chart type?
    1. pie
    2. column
    3. HLCO
    4. area

 

Hosted by www.Geocities.ws

1