[go: up one dir, main page]
Scribd
Upload
43 views3 pages

Microsoft Excel Basics: Create & Save Workbook

This document provides steps to create a basic workbook in Microsoft Excel to track shopping items and amounts. It instructs the user to open Excel, type item names in one column and amounts in another, bold column headers, save the file as "Shopping List", then open it again to add a serial number column before saving and closing the workbook. The steps introduce basic Excel functions like entering text and numbers, formatting, inserting columns, and saving files.

Uploaded by

Nikita Agrawal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
43 views3 pages

Microsoft Excel Basics: Create & Save Workbook

This document provides steps to create a basic workbook in Microsoft Excel to track shopping items and amounts. It instructs the user to open Excel, type item names in one column and amounts in another, bold column headers, save the file as "Shopping List", then open it again to add a serial number column before saving and closing the workbook. The steps introduce basic Excel functions like entering text and numbers, formatting, inserting columns, and saving files.

Uploaded by

Nikita Agrawal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Practice Activity 1: Getting Started with Microsoft Excel

Objective: In this activity, you will:

- Create a workbook and type in text in


- Save the workbook
Note: Type the Green text in the workbook you create.

Step 1: Open Microsoft Excel. Click Start > All Programs > Microsoft Applications > Microsoft Excel 2003®.

Step 2: Select the cells – A1, B1 and type the following text:

Items Amount

Use the button on the toolbar to bold the text in these cells.

Step 3: Type the following text under the Items column (A2, A3, A4, and A5):

Biscuits

Pencil

Juice

Chocolates

Wafers

You have entered the list of items purchased.

1
Step 4: Type the following numbers under the Amount column (B2, B3, B4, and B5):

40

15

25

50

25

You have entered the price for each item purchased.

Step 5: Save your spreadsheet. Use the button on the toolbar or keyboard shortcut Ctrl + S and
name the file Shopping List. Tip: Pay attention to where the document is being saved so you can easily retrieve it
later.)

Step 6: Close the workbook by clicking icon in the top-right corner of the screen.

Step 7: Open the workbook from the location where you saved it. Insert a new column for Serial Numbers.

Select Cell –A1. Click the Insert menu and then click the Columns option. A new column is created. Type the
following text:

S.No

Use the button on the toolbar to bold the text in this cell.

2
Step 8: Type the following numbers under the S.No column (A2, A3, A4, and A5):

Step 8: Save the workbook again and close it .

You might also like