test1_sol - Computer First Test Name 1 Open an Excel file...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Computer # : First Test (2/25/2011) Name: 1. Open an Excel file and name it according to the instructions above, then save it to the TEMP folder on the C Drive. Make sure it has four separate worksheets and name them Prob1, Prob2, Prob3, and extra . Place your full name in Cell A1 of the Prob1 worksheet. You are the industrial engineer assigned to develop a forecast each month. Show your knowledge of Excel (this is not a VBA problem and it is not an optimization problem) by typing the following in the Prob1 worksheet. The key features of the spreadsheet are listed below the figure, where the word “Month” appears in Cell B3. a. Column headers (row 3) are bold and centered. b. Formulas should be entered into D4:D7 such that i. The value of D4 should equal C4. ii. The values in D5:D7 are according to the formula F t+1 = D t + (1- ) F t . iii. If more months of data are entered, the formulas should stay correct with a “fill down”. c.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

test1_sol - Computer First Test Name 1 Open an Excel file...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online