Scribd
Upload
3 views1 page

MsExcel Practice

The document provides instructions for creating and formatting a Medal Count table in MS-Excel. It includes steps for calculating total medals, finding averages, inserting new rows and columns, and applying formatting. The final table should have borders and a light fill color for the header row.

Uploaded by

manyatasamsukha13
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
3 views1 page

MsExcel Practice

The document provides instructions for creating and formatting a Medal Count table in MS-Excel. It includes steps for calculating total medals, finding averages, inserting new rows and columns, and applying formatting. The final table should have borders and a light fill color for the header row.

Uploaded by

manyatasamsukha13
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

Q1.

Prepare the following table in MS-Excel:

1. Save the worksheet with the name “Medal Count”.

2. Calculate the Total Medals for each country using a formula in column E.

3. Find the Grand Total of Gold, Silver, Bronze and Total Medals using SUM in

E8 cell.

4. In cell A9 type “Average” and find the average for Gold Medals. Copy formula

for Silver, Bronze and Total Medals.

5. Select the column headings (A1:E1), make them Bold and Centre Aligned.

6. Insert a new row between Japan and USA with the details: China 20 15 12

7. Calculate the Total Medals for China in column E.

8. Insert a column before "Country" and add [Link] as column heading with numbers from 1
to 7.

9. Add cells Minimum and Maximum in A10 and A11. Calculate values for Gold, Silver,
Bronze, and Total.

10. Format the table with borders and apply a light fill colour to the header row.

You might also like