Essays /

123456 Essay

Essay preview

ISM003 Managing Information System

Excel Assignment 3 Instructions (Office 2007 ed.)

EXCEL ASSIGNMENT 3: ADVANCED OPERATIONS
Your finished Excel worksheet should be similar to the following sample. Follow the instructions in the following pages and complete the Excel worksheet. Enjoy it!

Page 1 of 9

ISM003 Managing Information System

Excel Assignment 3 Instructions (Office 2007 ed.)

Step 1: Basic controls

Home

Select

You may change the font
and font size here.
Use Arial and font 12.
Click this box to select
the whole worksheet.
You may scale
the view here.

STEP 2: INPUT TEXTS AND DATA

Highlight the cell F2
Select Formulas

Insert Function

Enter the system date in cell F2 using the NOW function.

Page 2 of 9

ISM003 Managing Information System

Excel Assignment 3 Instructions (Office 2007...

Read more

Keywords

1 12 123456 14/03/01 16 2 2007 28 3 4 5 6 7 8 9 a1 a11 a12 a13 a14 a2 a7 a8 a9 across add administr advanc align appli arial assign autosum b b10 b11 b13 b14 b3 b4 b5 b6 b8 b9 background basic box button c c8 calcul categori cell center chan chang click co color column comma complet confer control copi cost custom d data date decim direct dollar done due e e2 e9 ed enjoy enter event exampl excel exercis expens f f1 f11 f14 f2 f3 f4 f6 f8 fill finish fix follow font footer forget format formula front function green handl header highlight home i.e id incom increas indent indirect inform input insert instruct ism003 lab learn left lingnan man manag market may merg mous net number offic ok oper page part plan pleas previous print prorat rang refer revenu review right row sale sampl save scale section select setup sign similar size skill step student style submit system tai text therefor time total tri type use valu view white whole work worksheet write 按比例分配