Scribd
Upload
124 views2 pages

Data Entry and Formatting

The document outlines a series of tasks related to data entry and formatting in Excel, including entering student data, applying formatting, and using basic formulas. It also covers sorting, filtering, creating charts, and applying conditional formatting, as well as practical applications like calculating total costs and saving/exporting workbooks. Additionally, it poses questions about font size changes, chart differences, and sharing methods.

Uploaded by

Prabesh Thapa
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
124 views2 pages

Data Entry and Formatting

The document outlines a series of tasks related to data entry and formatting in Excel, including entering student data, applying formatting, and using basic formulas. It also covers sorting, filtering, creating charts, and applying conditional formatting, as well as practical applications like calculating total costs and saving/exporting workbooks. Additionally, it poses questions about font size changes, chart differences, and sharing methods.

Uploaded by

Prabesh Thapa
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

Data Entry and Formatting

 Q4: Enter the following data in an Excel sheet:

Name Subject Marks


John Math 85
Priya Science 92
Ravi English 78

After entering the data, apply the following formatting:

 Make the headers bold.


 Set the text alignment to center.
 Change the background color of cells containing marks to yellow.

Q5: How can you change the font size of the text in Excel? Perform the action on the student
names.

3. Basic Formulas

 Q6: Using the data entered in Question 4, calculate the sum of marks using the SUM
function.
 Q7: Using the same data, calculate the average marks using the AVERAGE function.

4. Sorting and Filtering

 Q8: Using the student data from Question 4, sort the table in descending order based on
marks.
 Q9: Apply a filter to show only students who scored more than 80.

5. Charts

 Q10: Create a bar chart using the data from Question 4, with the student names on the X-
axis and their marks on the Y-axis.
 Q11: What is the difference between a pie chart and a bar chart? Which chart would be
better to show percentage distribution?

6. Conditional Formatting

 Q12: Use conditional formatting to highlight all students who scored less than 80 in red
and more than 90 in green.
 Q13: How do you remove conditional formatting from a cell?

7. Functions (MAX, MIN, COUNT)

 Q14: Use the MAX function to find the highest mark from the student data.
 Q15: Use the MIN function to find the lowest mark.
 Q16: Count the total number of students using the COUNT function.

8. Practical Application

 Q17: Create a list of 5 products (e.g., pens, notebooks) with their quantities and prices.
Then, create a new column that calculates the total cost for each product (Quantity *
Price).

9. Saving and Exporting

 Q18: How do you save your Excel workbook in PDF format?


 Q19: How can you share an Excel workbook via email?

You might also like