jam

Information Systems for Business – IS312

EXCEL Assignment – Part 1Instructions

Situation:

This assignment coversa variety ofbasic EXCEL functions and processes that are commonly used in business.

The following conventionswill be used below:

· Specific cells will be referred to by the column and row number.

For example: Cell N3 contains the word “Points” and cell N5 contains “5”.

· Fields in a workbook will be referred to using the following convention:

· worksheet.tab.field or the abbreviated version tab.field, where

worksheetis the filename

tab is the name of the worksheet tab

field is the name of a specific field. In some cases, this may be a cell number(s).

Example: SOLines.Qty refers to the SOLines spreadsheet tab and Qty refers to the Qty column on that tab.

This is a standard notation.

Assignment:

NOTE: Follow the sequence of activities as they are listed below. In some cases, earlier tasks have to be done before later tasks can be done.

1. Sequence Numbering

Assigning sequence numbers to spreadsheet rows is often helpful.

Sequence numbers identify specific rows. Unlike spreadsheet row numbers, sequence numbers appear in the data and are printed when the spreadsheet is printed.

Rows can be re-sequenced for various purposes; the sequence number allows the spreadsheet to be restored to its original sequence.

2. Formatting:

· Rows 9 & 10:

Enter the data indicated and center the content in cells I9 and I10.

· Rows 12 through 26 – Formatting Numbers and Dates

· Format the data in cells I13 through I18.

· Answer the questions in H19 and H20 in I19 and I20 respectively.

· Copy the date in cell I22 into cells I23 through I26 and format as requested.

Note: Transaction timestamps include both date and time.

NOTE: In subsequent exercises, format dates as mm/dd/yyyy (the traditional US date format).

· Explicit Calculation and Date Calculations

· Calculations reside in cells and are only visible by highlighting the cell containing the calculation, which can’t be done with a printed copy of a spreadsheet.

Put your calculation in an adjacent cell to provide a way for readers to quickly see your formulas.

· Answer the questions in cells H34 H35 and H36 in cells I34, I35 and I36.

· Cell Format

· Follow the instructions in cells H39 through H44

Put your answers in cells I39 through I42 and in cells H44 and I44 combined.

· Page Layout

· Add a Header and a Footer to the spreadsheet.

Put the information specified in cell I48 in the Header and the information specified in I49 in the Footer, with page numbering centered in the Footer. Replace the “?” with the Number of Pages function.

NOTE: In this course, ALWAYS page number as shown in I49.

· Follow the instructions in cells F52, F54, F55 and F56.

NOTE: Keep the instruction in cell C58 in mind as you complete this assignment. Some text that you enter will not be readily visible if you do not expand the cell height.

NOTE: In this course, ALWAYS put a Header and a Footerin your spreadsheets.

Adopt this practice as your own. Recipients of your spreadsheets will be impressed. This practice will favorable set you apart from the competition.

To SUBMIT this assignment,

UPLOAD the EXCEL spreadsheetinto Canvas for grading.

Grading:

The number of points per task appears in column N.

© Jerald Savin, 2018. Page 2 of