INTRODUCTION TO EXCEL 2000
PROJECT TWO: FORMULAS, FUNCTIONS AND FORMATTING
To follow the Excel 2000 workshop exercises, you need to have Excel 2000 for Windows or Excel 98 for Mac. If you have an ITSS office server connection, Excel is available to you at no additional charge. You will need to download Excel 2000 in order to perform these exercises.
You will prepare a worksheet using formulas, functions and formatting techniques. You will also make a pie chart.
- Enter Formulas
- Calculate Averages
- Find the highest and lowest numbers in a range
- Change fonts
- Draw borders
- Format numbers
- Change column widths and row heights
- Create a 3-d pie chart on a separate sheet
- Format a pie chart
- Preview a worksheet
- Print a workbook
- Print a section of a worksheet and display and print the formulas in the worksheet using the fit option.
If you are ready to try Project Two, click on the Link below.