Exercise for excel output | Exercises Law

EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY SALES MONTH PRICE REVENUE

BACUYAG, KAYCEE ABAD 03-621 Cal-A 50 Oct $ 15.00 $ 750.00

BALIBOL, CLARISSA VARGAS 03-543 Cal-A 20 Oct $ 15.00 $ 300.00

OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.00

PAULE, GRAZIELLE AGUAVIVA 07-882 Cal-A 40 Dec $ 15.00 $ 600.00

PEDRIS, LIZEL MACASINAG 03-459 Cal-A 40 May $ 15.00 $ 600.00

PEñAVERDE, JEROME DELA CRUZ 01-444 Therm-B 30 May $ 35.00 $ 1,050.00

POSTRADO, ANDREA DE RAMOS 07-067 Therm-B 90 April $ 35.00 $ 3,150.00

OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.00

RICAFORT, LAICAMAE 02-555 Therm-B 10 June $ 35.00 $ 350.00

RICAMARA, JILLIANE BUENAVENTURA 07-123 Therm-B 20 Feb $ 35.00 $ 700.00

ROSITA, ZYRA MAE TORRES 09-001 Therm-B 20 March $ 35.00 $ 700.00

OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.00

TARGA, ROAN NAVISES 02-345 Sheet-C 50 Oct $ 20.00 $ 1,000.00

TOLENTINO, JOHN CARLO ZALAMEDA 05-478 Sheet-C 70 Nov $ 20.00 $ 1,400.00

UY, MA. ANGELICA DE PAZ 11-125 Sheet-C 40 April $ 20.00 $ 800.00

VARGAS, JOHN JOROSS JIMENEZ 09-561 Sheet-C 40 April $ 20.00 $ 800.00

YASIS, MARK KENNETH SEMILLA 06-589 Sheet-C 90 June $ 20.00 $ 1,800.00

OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.00

IBASCO, JEFFERLYN 02-467 Mason-D 10 Sept $ 55.00 $ 550.00

DATO, GERLIE 04-533 Mason-D 20 Dec $ 55.00 $ 1,100.00

OSIA, RACHEL MARIE 04-609 Mason-D 60 March $ 55.00 $ 3,300.00

MORANTE, SHANE 05-001 Mason-D 10 July $ 55.00 $ 550.00

VILLAFLOR, KEENLY 08-822 Mason-D 70 June $ 55.00 $ 3,850.00

OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.00

REMOVING DUPLICATES

Above is a sample database that you will use for the following requirements. Note: Make sure to provide a brief explanation/step by step procedure on how you attained your output. (this will be a basis for

the scores of each requirement) Use the answer sheet to for this.

Requirement #1 Identify how many duplicates and unique values are there in the given sample database. Use this same sheet to copy from

the original database and perform the requirement in the copied dataset.

Partial preview of the text

Download Exercise for excel output and more Exercises Law in PDF only on Docsity!

EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY SALES MONTH PRICE REVENUE

REMOVING DUPLICATES

Above is a sample database that you will use for the following requirements. Note: Make sure to provide a brief explanation/step by step procedure on how you att

the scores of each requirement) Use the answer sheet to for this.

Requirement #1 Identify how many duplicates and unique values are there in the given sample database. Use this same sheet to copy from

SORT AND FILTER

AUTOSUM

Requirement #1 Identify how many duplicates and unique values are there in the given sample database. Use this same sheet to copy from

the original database and perform the requirement in the copied dataset.

Requirement #2 From the new data set that you made from requirement number 1, filter the data from largest to smallest based on the

Revenue

Requirement #3 Provide the total sum for each column: Quantity, Revenu and Shipping. Place the total sum at the last cell below each

column and highlight each in YELLOW.

10pts

EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY

REMOVING DUPLICATES OF DATA: Copy the original data so that you wont lose the important information, After

SORT AND FILTERING OF DATA, I used the FORMAT AS TABLE to sort and filter the data needed.

will see the REMOVE-DUPLICATES button then enter it will automatically shows the data needed.

BACUYAG, KAYCEE ABAD 03-621 Cal-A 50 Oct $ 15.00 $ 750.
BALIBOL, CLARISSA VARGAS 03-543 Cal-A 20 Oct $ 15.00 $ 300.
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.
PAULE, GRAZIELLE AGUAVIVA 07-882 Cal-A 40 Dec $ 15.00 $ 600.
PEDRIS, LIZEL MACASINAG 03-459 Cal-A 40 May $ 15.00 $ 600.
PEñAVERDE, JEROME DELA CRUZ 01-444 Therm-B 30 May $ 35.00 $ 1,050.
POSTRADO, ANDREA DE RAMOS 07-067 Therm-B 90 April $ 35.00 $ 3,150.
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.
RICAFORT, LAICAMAE 02-555 Therm-B 10 June $ 35.00 $ 350.
RICAMARA, JILLIANE BUENAVENTURA 07-123 Therm-B 20 Feb $ 35.00 $ 700.
ROSITA, ZYRA MAE TORRES 09-001 Therm-B 20 March $ 35.00 $ 700.
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.
TARGA, ROAN NAVISES 02-345 Sheet-C 50 Oct $ 20.00 $ 1,000.
TOLENTINO, JOHN CARLO ZALAMEDA 05-478 Sheet-C 70 Nov $ 20.00 $ 1,400.
UY, MA. ANGELICA DE PAZ 11-125 Sheet-C 40 April $ 20.00 $ 800.
VARGAS, JOHN JOROSS JIMENEZ 09-561 Sheet-C 40 April $ 20.00 $ 800.
YASIS, MARK KENNETH SEMILLA 06-589 Sheet-C 90 June $ 20.00 $ 1,800.
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.
IBASCO, JEFFERLYN 02-467 Mason-D 10 Sept $ 55.00 $ 550.
DATO, GERLIE 04-533 Mason-D 20 Dec $ 55.00 $ 1,100.
OSIA, RACHEL MARIE 04-609 Mason-D 60 March $ 55.00 $ 3,300.
MORANTE, SHANE 05-001 Mason-D 10 July $ 55.00 $ 550.
VILLAFLOR, KEENLY 08-822 Mason-D 70 June $ 55.00 $ 3,850.
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A 70 Nov $ 15.00 $ 1,050.
$ 12.
$ 12.
$ 12.
$ 12.
$ 12.
$ 10.
$ 10.
$ 12.
$ 10.
$ 10.
$ 10.
$ 12.
$ 10.
$ 10.
$ 10.
$ 10.
$ 10.
$ 12.
$ 15.
$ 15.
$ 15.
$ 15.
$ 15.
$ 12.
BACUYAG, KAYCEE ABAD 03-621 Cal-A
BALIBOL, CLARISSA VARGAS 03-543 Cal-A
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A
PAULE, GRAZIELLE AGUAVIVA 07-882 Cal-A
PEDRIS, LIZEL MACASINAG 03-459 Cal-A
PEñAVERDE, JEROME DELA CRUZ 01-444 Therm-B
POSTRADO, ANDREA DE RAMOS 07-067 Therm-B
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A
RICAFORT, LAICAMAE 02-555 Therm-B
RICAMARA, JILLIANE BUENAVENTURA 07-123 Therm-B
ROSITA, ZYRA MAE TORRES 09-001 Therm-B
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A
TARGA, ROAN NAVISES 02-345 Sheet-C
TOLENTINO, JOHN CARLO ZALAMEDA 05-478 Sheet-C
UY, MA. ANGELICA DE PAZ 11-125 Sheet-C
VARGAS, JOHN JOROSS JIMENEZ 09-561 Sheet-C
YASIS, MARK KENNETH SEMILLA 06-589 Sheet-C
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A
IBASCO, JEFFERLYN 02-467 Mason-D
DATO, GERLIE 04-533 Mason-D
OSIA, RACHEL MARIE 04-609 Mason-D
MORANTE, SHANE 05-001 Mason-D
VILLAFLOR, KEENLY 08-822 Mason-D
OBLIFIAS, MONICA JIMENEZ 05-999 Cal-A
Oct $ 15.00 $ 750.00 $ 12. SALES MONTH PRICE REVENUE SHIPPING
Oct $ 15.00 $ 300.00 $ 12.
Nov $ 15.00 $ 1,050.00 $ 12.
Dec $ 15.00 $ 600.00 $ 12.
May $ 15.00 $ 600.00 $ 12.
May $ 35.00 $ 1,050.00 $ 10.
April $ 35.00 $ 3,150.00 $ 10.
Nov $ 15.00 $ 1,050.00 $ 12.
June $ 35.00 $ 350.00 $ 10.
Feb $ 35.00 $ 700.00 $ 10.
March $ 35.00 $ 700.00 $ 10.
Nov $ 15.00 $ 1,050.00 $ 12.
Oct $ 20.00 $ 1,000.00 $ 10.
Nov $ 20.00 $ 1,400.00 $ 10.
April $ 20.00 $ 800.00 $ 10.
April $ 20.00 $ 800.00 $ 10.
June $ 20.00 $ 1,800.00 $ 10.
Nov $ 15.00 $ 1,050.00 $ 12.
Sept $ 55.00 $ 550.00 $ 15.
Dec $ 55.00 $ 1,100.00 $ 15.
March $ 55.00 $ 3,300.00 $ 15.
July $ 55.00 $ 550.00 $ 15.
June $ 55.00 $ 3,850.00 $ 15.
Nov $ 15.00 $ 1,050.00 $ 12.
VILLAFLOR, KEENLY 08-822 Mason-D EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY
OSIA, RACHEL MARIE 04-609 Mason-D
POSTRADO, ANDREA DE RA07-067 Therm-B
YASIS, MARK KENNETH SEM06-589 Sheet-C
TOLENTINO, JOHN CARLO 05-478 Sheet-C
DATO, GERLIE 04-533 Mason-D
OBLIFIAS, MONICA JIMENEZ05-999 Cal-A
PEñAVERDE, JEROME DELA01-444 Therm-B
TARGA, ROAN NAVISES 02-345 Sheet-C
UY, MA. ANGELICA DE PAZ 11-125 Sheet-C
VARGAS, JOHN JOROSS JIM09-561 Sheet-C
BACUYAG, KAYCEE ABAD 03-621 Cal-A
RICAMARA, JILLIANE BUEN 07-123 Therm-B
ROSITA, ZYRA MAE TORRES09-001 Therm-B
PAULE, GRAZIELLE AGUAVI 07-882 Cal-A
PEDRIS, LIZEL MACASINAG 03-459 Cal-A
IBASCO, JEFFERLYN 02-467 Mason-D
MORANTE, SHANE 05-001 Mason-D
RICAFORT, LAICAMAE 02-555 Therm-B
BALIBOL, CLARISSA VARGA 03-543 Cal-A
June $ 55.00 $ 3,850.00 $ 15. SALES MONTH PRICE REVENUE SHIPPING
March $ 55.00 $ 3,300.00 $ 15.
April $ 35.00 $ 3,150.00 $ 10.
June $ 20.00 $ 1,800.00 $ 10.
Nov $ 20.00 $ 1,400.00 $ 10.
Dec $ 55.00 $ 1,100.00 $ 15.
Nov $ 15.00 $ 1,050.00 $ 12.
May $ 35.00 $ 1,050.00 $ 10.
Oct $ 20.00 $ 1,000.00 $ 10.
April $ 20.00 $ 800.00 $ 10.
April $ 20.00 $ 800.00 $ 10.
Oct $ 15.00 $ 750.00 $ 12.
Feb $ 35.00 $ 700.00 $ 10.
March $ 35.00 $ 700.00 $ 10.
Dec $ 15.00 $ 600.00 $ 12.
May $ 15.00 $ 600.00 $ 12.
Sept $ 55.00 $ 550.00 $ 15.
July $ 55.00 $ 550.00 $ 15.
June $ 35.00 $ 350.00 $ 10.
Oct $ 15.00 $ 300.00 $ 12.
$ 24,400.00 $ 235.

Exercise for excel output, Exercises of Law

Related documents

Partial preview of the text

Download Exercise for excel output and more Exercises Law in PDF only on Docsity!

EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY SALES MONTH PRICE REVENUE

REMOVING DUPLICATES

Above is a sample database that you will use for the following requirements. Note: Make sure to provide a brief explanation/step by step procedure on how you att

the scores of each requirement) Use the answer sheet to for this.

Requirement #1 Identify how many duplicates and unique values are there in the given sample database. Use this same sheet to copy from

SORT AND FILTER

AUTOSUM

Requirement #1 Identify how many duplicates and unique values are there in the given sample database. Use this same sheet to copy from

the original database and perform the requirement in the copied dataset.

Requirement #2 From the new data set that you made from requirement number 1, filter the data from largest to smallest based on the

Revenue

Requirement #3 Provide the total sum for each column: Quantity, Revenu and Shipping. Place the total sum at the last cell below each

column and highlight each in YELLOW.

10pts

10pts

10pts

EMPLOYEE NAME EMPLOYEE ID PRODUCT QUANTITY

SORT AND FILTERING OF DATA, I used the FORMAT AS TABLE to sort and filter the data needed.