Microsoft Excel Unit 1 Objectives Open Microsoft Excel

  • Slides: 14
Download presentation
Microsoft Excel Unit 1

Microsoft Excel Unit 1

Objectives Open Microsoft Excel Navigate within a spreadsheet Create and save a new worksheet

Objectives Open Microsoft Excel Navigate within a spreadsheet Create and save a new worksheet Enter data into cells Edit and delete data

Microsoft Excel Online spreadsheet program Produce professional-looking documents Perform numeric calculations quickly and accurately

Microsoft Excel Online spreadsheet program Produce professional-looking documents Perform numeric calculations quickly and accurately Financial calculations Scientific calculations List management tasks Show charts

Spreadsheets Enter data quickly and accurately Recalculate data easily Perform what-if analysis Change the

Spreadsheets Enter data quickly and accurately Recalculate data easily Perform what-if analysis Change the appearance of information Create charts Share information with other users Create new worksheets from existing ones

Common Business Uses Maintain values Represent values graphically Create reports to summarize data Organize

Common Business Uses Maintain values Represent values graphically Create reports to summarize data Organize data Analyze data Create what-if data scenarios

Your Turn Starting Microsoft Excel 1. 2. Double-Click Microsoft Office on your desktop. Double-Click

Your Turn Starting Microsoft Excel 1. 2. Double-Click Microsoft Office on your desktop. Double-Click

Identifying Parts of Microsoft Excel

Identifying Parts of Microsoft Excel

Menu Bar Address Bar Active Cell Formula Bar Column Headings Row Headings Toolbar Scroll

Menu Bar Address Bar Active Cell Formula Bar Column Headings Row Headings Toolbar Scroll Bars Cell Sheet Tabs Task Bar

Workbook File created to store your data May contain up to 255 worksheets

Workbook File created to store your data May contain up to 255 worksheets

Worksheet Grid that defines rows and columns Rows are numbered from 1 to 65,

Worksheet Grid that defines rows and columns Rows are numbered from 1 to 65, 536 Columns are labeled from A to Z, then AA to AZ, BA to BZ, and so on (up to column IV) Cell – intersection of row and column

Cell Each A 1 has a unique cell reference is the intersection of column

Cell Each A 1 has a unique cell reference is the intersection of column A and row 1 Active cell – cell that appears outlined with a thick border

Your Turn Exercise 1 -1 Open and Edit a Workbook 1. Start Microsoft Excel

Your Turn Exercise 1 -1 Open and Edit a Workbook 1. Start Microsoft Excel by clicking the Microsoft Office folder on your desktop. 2. Double-click the Excel icon. 3. Click on the file in Canvas to open the file. 4. Click the File menu (Office button) in the top left of your screen.

Your Turn Exercise 1 -1 Open and Edit a Workbook 5. Save the worksheet

Your Turn Exercise 1 -1 Open and Edit a Workbook 5. Save the worksheet as Computer Systems 1. 1. 6. Click Cell A 5. 7. Press the right arrow key to move to cell D 5. 8. Press the down arrow key to move to cell D 6. 9. Press the HOME key and the cell pointer moves to the beginning of row 6. 10. Press the END key and press the right arrow key .

Your Turn Exercise 1 -1 Open and Edit a Workbook 11. Press and hold

Your Turn Exercise 1 -1 Open and Edit a Workbook 11. Press and hold the END key and press the down arrow key. The cell pointer moves to the last row that contains data 12. Press and hold the CTRL key and press the HOME key. The pointer moves to cell A 1. 13. Press and hold the CTRL key and press the END key. The pointer moves to the last cell that contains data (H 8) 14. Close the workbook.