Scribd
Upload
3 views3 pages

S. Kavya 115725672001: Ms Excel

The document provides step-by-step instructions for performing calculations in MS Excel, including finding totals, averages, and percentages for student marks. It also demonstrates the Find and Replace feature to change specific text within a worksheet, as well as the Page Setup and Print Options for formatting and printing Excel sheets. Overall, it serves as a guide for basic Excel functionalities and operations.

Uploaded by

srinivasa.g22ug
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
3 views3 pages

S. Kavya 115725672001: Ms Excel

The document provides step-by-step instructions for performing calculations in MS Excel, including finding totals, averages, and percentages for student marks. It also demonstrates the Find and Replace feature to change specific text within a worksheet, as well as the Page Setup and Print Options for formatting and printing Excel sheets. Overall, it serves as a guide for basic Excel functionalities and operations.

Uploaded by

srinivasa.g22ug
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

S.

Kavya
115725672001

MS EXCEL:
Q1 Steps to Find Total, Average and Percentage in MS Excel
1. Open Microsoft Excel.
2. Create a new workbook.
3. Enter the headings: Roll No, Name, MOB, AFM, MM, Elective-I, Elective-II, Total,
Average, Percentage.
4. Enter the given student marks data below the headings.
5. Click on the Total column first cell and apply SUM formula to add all subject marks.
6. Copy the Total formula for all students using fill handle.
7. Click on the Average column first cell and apply AVERAGE formula.
8. Copy the Average formula for all students.
9. Click on the Percentage column first cell and calculate percentage using total marks.
10. Copy the Percentage formula for all students and save the file.

OUTPUT
21. Use Simple excel sheet data and demonstrate the following: Find and
Replace with an example

Demonstration of Find and Replace in MS Excel

Aim:
To demonstrate the Find and Replace option in MS Excel

Emp ID Name Department

101 Ram Kumar Sales

102 Shyam Kumar Sales

103 Manoj Kumar Accounts

Requirement:
Replace the word “Sales” with “Marketing”.
Steps
1. Open Microsoft Excel.
2. Enter the above data in a worksheet.
3. Press Ctrl + H on the keyboard.
4. The Find and Replace dialog box opens.
5. In the Find what box, type Sales.
6. In the Replace with box, type Marketing.
7. Click on Replace All.
8. Click OK and then Close the dialog box.

Result:
The word Sales is replaced with Marketing wherever it appears in the worksheet.

Emp ID Name Department

101 Ram Kumar Marketing

102 Shyam Kumar Marketing

103 Manoj Kumar Accounts


Conclusion:
The Find and Replace feature in MS Excel helps to quickly find specific text and replace it
with new text, saving time and effort.

11. Demonstrate Page Setup options/ Print Options for any of the above
Problems
Steps to Demonstrate Page Setup & Print Options in Excel
1. Open the required Excel sheet.
2. Select the complete data.
3. Click on Page Layout tab.
4. Set Orientation → Landscape.
5. Set Paper Size → A4 and Margins → Normal.
6. Set Scale to Fit → 1 page.
7. Click Print Area → Set Print Area.
8. Click Print Titles and select heading row.
9. Go to File → Print.
10. Check Print Preview and click Print.

You might also like