Page 33 - GE 10 Module Crim Midterm

QUIRINO STATE UNIVERSITY

COLLEGE OF PUBLIC SAFETY
Bachelor of Science in Criminology
…harmonizing ideals

Enrichment Activity

In MS Excel, create a SALES DATA REPORT and perform the following:
1. Create a table and maximize the number of columns and rows depending
on your DATA entry; (see the image below)
2. Input the data that is shown at the image below, then;
3. Create a formula that computes the Amount: (Rate/Price x Quantity);
4. Create a formula that computes the TOTAL Sales;
5. Create a formula that computes the Total Amount and Grand total;
6. Create or Insert 2-D Column Charts that display the total Sales of each
Employee;
7. Save the document with a file name: (LastName_FirstName-Midterm)
example (Sabug_William-Midterm) and email it to
william.sabug@qsu.edu.ph

VISION MISSION
The leading center for academic and technological excellence Develop competent and morally upright professionals and generate
and prime catalyst for a progressive and sustainable Quirino appropriate knowledge and technologies to meet the needs of Quirino
Province and Southern Cagayan Valley. Province and Southern Cagayan Valley.

“Molding Minds, Shaping Future”