Question

Create two worksheets of Croma Store sales for the month of September in year 2020 and 2021 with the Invoice No., Customer Name, Product, Quantity, and Price. Create a Pivot table for the above data with minimum 15 entries. Add a new record using form and sort your data alphabetically. • Consolidate your data into a sheet Make chart for the above Data. (Chart of your choice) Write down the steps in a word document. ​

Answer 1

Answer:

the month of September in year 2020 and 2021 with the invoice