文件探索微软office.pdfVIP

Objectives • n for effective workbook and worksheet design • Explore the Excel Window • En nd edit cell data • Use AutoFill • Dis y cell formulas • Manage worksheets 2 Objectives ( ) • Manage worksheets • Manage columns and rows • Select, move, copy and paste • Apply alignment and font options • Apply number formats • Select page setup options • Print a workbook 3 Introduction to Spreadsheets • A spreadsheet is an electronic file used to organize related data and perform calculations • If data is altered, formulas automatically recalculate results 4 Worksheets and Workbooks • A worksheet is a spreadsheet that contains formulas, values, text, and visual aids • A workbook is a file containing related worksheets 5 Sample Completed Worksheet 6 nning Structure of Worksheets • State the purpose of the worksheet • Decide what input values are needed – An input area is a range of cells containing values • Decide what outputs are needed – An output area is a range of cells containing results • Assign the worksheet inputs and results – Use rows and columns 7 nning Structure of Worksheets • Enter the labels, values, and formulas • Format the numerical values • Format the descriptive titles and labels • the worksheet • Save the completed workbook