Assignment for the
Excel course
Assignment:
Application of excel skills
Instructions:
1. Open a new Excel spreadsheet.
2. Complete the following tasks using Excel functions and formulas.
3. Save your spreadsheet and submit it for evaluation.
Assignment:
Application of excel skills
Tasks:
a. Create a column of numbers from 1 to 10.
b. In the adjacent column, calculate the square of each number using a formula.
c. Calculate the average of the squared numbers.
d. Create a bar chart to represent the original numbers and their squares.
e. Add a trendline to the chart to show the trend of the squared numbers.
f. Create a new sheet within the same workbook.
g. Copy and paste the original column of numbers from the first sheet to the new sheet.
h. Sort the numbers in ascending order.
i. Calculate the sum of the sorted numbers.
j. Save your Excel file with a descriptive name.
Assignment:
Application of excel skills
Evaluation Criteria:
a. Correctness of formulas and functions used.
b. Accuracy of calculations.
c. Proper formatting of the chart.
d. Inclusion of a trendline.
e. Accuracy of sorting and summing the numbers on the new sheet.
f. This test assesses basic Excel skills such as data entry, formula usage, chart creation,
sorting, and basic data analysis.