MS Excel – Part 3

Due: Monday, February 13, 9:00 p.m.

Reminder: When creating a document in the lab, please save it to a USB drive or to your Google Drive account and delete it from the lab computer before you leave.

Instructions:

Before beginning this assignment, go through the tutorial ( sections 17-23.

  1. Download the practice workbook on the D2L webpage called PracticeWorkbookPart3-1.xlsx.
  1. Add the quantity of items in cell B16 by using the SUM formula on cells B3-B15.
  1. In cell B23, use the MAX function to compute the most expensive item in cells C3-15.
  1. In cell B24, use the AVERAGE formula to calculate the average shipping time. You should use the values in the Delivery Time column.
  1. Download the practice workbook on the D2L webpage called PracticeWorkbookPart3-2.xlsx.
  1. Sort the items in the Texlahoma High School section by Last Name.
  1. Sort the items in cells G3-H7 from Smallest to Largest by number of orders.
  1. Select cells A2-E29 and format them as a table (found in the Home tab). Use the table style of your choice.
  1. Download the practice workbook on the D2L webpage called PracticeWorkbookPart3-3.xlsx.
  1. Select all the cells in the table, and insert a 2D chart.
  1. Change the Chart Title to “Book Sales 2008-2012”.
  1. Change the chart style to a style of your choice.
  1. Switch the row and column data so the data is grouped by genre, with columns for each year.
  1. Change the chart type to a line chart. Depending on the chart style you selected, here is what your chart could look like when it is finished:

  1. When you are finished, upload your three practice workbooks to the D2L Dropbox called Using Excel Part 3.

Rubric:

7 points for each of the steps 1-15 above.

Submission:

Upload your completed practice workbook to the D2L Dropbox called MS Excel Part 3.

Please print the 3rd page of this assignment, answer the questions on it, and turn it in to the instructor.

Name: ______

Answer the following questions on Excel formulas:

1. Label the parts of a function:

= SUM (A1:A20)

2. What must come before a function name in a cell for it to properly compute the value?

Nothing

An argument

The function name

An equals sign

3. What characters must surround a list of arguments in a function?

Colons

Parentheses

Spaces

A letter A-Z

4. Which function in excel determines the highest cell value included in the argument list?

SUM

COUNT

MAX

AVERAGE

5. If you don’t know the name of an Excel function, where can you look?

The Formulas tab

The Insert tab

The Data tab

By using Edit -> Find