Scribd
Upload
12 views4 pages

Creating and Navigating Excel Worksheets

The document outlines an experiment aimed at teaching students how to create a new worksheet in Excel, enter various types of data, save the worksheet, and navigate using keyboard shortcuts and menus. It includes objectives, software requirements, a theoretical overview of Excel worksheets, a step-by-step procedure for data entry, and navigation techniques. The experiment concludes with a successful demonstration of creating and managing a worksheet with different data types.

Uploaded by

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

Creating and Navigating Excel Worksheets

The document outlines an experiment aimed at teaching students how to create a new worksheet in Excel, enter various types of data, save the worksheet, and navigate using keyboard shortcuts and menus. It includes objectives, software requirements, a theoretical overview of Excel worksheets, a step-by-step procedure for data entry, and navigation techniques. The experiment concludes with a successful demonstration of creating and managing a worksheet with different data types.

Uploaded by

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

Experiment: How do you create a new worksheet and enter data (text, dates, and alphanumeric

values) into it? Perform an experiment by creating a worksheet, entering data into various cells,
saving the worksheet, and navigating through it using keyboard shortcuts and menus.

1. Aim

To learn how to create a new worksheet, enter different types of data (text, dates, numbers, and
alphanumeric values), save the worksheet, and navigate through it using keyboard shortcuts and
menus.

2. Objectives

By the end of this experiment, students will be able to:

1. Create a new worksheet in Excel.

2. Enter text, numeric, alphanumeric, and date values.

3. Save and reopen the worksheet.

4. Navigate through cells using keyboard shortcuts.

5. Use menus and mouse to move across the worksheet.

3. Software Requirements

 Microsoft Excel / Google Sheets / LibreOffice Calc

 A computer system with basic operating system

4. Theory

4.1 Excel Worksheet

A worksheet consists of rows and columns forming cells. Each cell has an address (e.g., A1, B3).

4.2 Types of Data Entered in Excel

1. Text (Labels):
Example → “Name”, “City”, “Product A”

2. Numbers:
Example → 120, 4.5, 8000

3. Dates:
Example → 12/11/2024, 01-Jan-2025

4. Alphanumeric Values:
Example → A101, ID20, MKT45
5. Procedure

Step 1: Create a New Worksheet

1. Open Microsoft Excel.

2. Click File → New → Blank Workbook.


A new worksheet will appear.

Step 2: Enter Various Types of Data

Enter the following data into cells:

Cell Data Type Value

A1 Text Student Name

B1 Text Course

A2 Text Poonam

B2 Alphanumeric CS101

A3 Text Rahul

B3 Alphanumeric EC102

A4 Text Meera

B4 Alphanumeric ME103

C1 Date 01-Jan-2025

C2 Date 12-Jan-2025

C3 Date 15-Jan-2025

C4 Date 20-Jan-2025

D1 Numeric 85

D2 Numeric 90

D3 Numeric 78

D4 Numeric 88

Step 3: Save the Worksheet

1. Click File → Save As.

2. Select folder location.

3. Give a filename (e.g., Student_Data.xlsx).


4. Click Save.

Step 4: Navigating Through Worksheet

Using Keyboard Shortcuts

Action Shortcut

Move right → Arrow

Move left ← Arrow

Move up ↑ Arrow

Move down ↓ Arrow

Go to first cell (A1) Ctrl + Home

Go to last used cell Ctrl + End

Ctrl + Page
Move to next sheet
Down

Move to previous sheet Ctrl + Page Up

Edit selected cell F2

Save file Ctrl + S

Using Menus / Mouse

1. Click any cell to move the cursor.

2. Use scroll bars (vertical/horizontal) to navigate.

3. Use Home → Find & Select → Go To to jump to a specific cell.

6. Observation Table

Data Type Example Entered Cell Address

Text Student Name A1

Alphanumeric CS101 B2

Date 01-Jan-2025 C1

Numeric 85 D1

7. Result

A worksheet was successfully created, various data types were entered, the file was saved, and
movement across the worksheet using keyboard shortcuts and menus was demonstrated.

You might also like