K5 B D E G H I J K L AVERAGE VALUE OF EACH SALE (ROUNDED TO WHOLE NUMBER) 2 3 RANK, BASED ON TOTAL VALUE OF SALES TOTAL VALUE OF SALES EMPLOYEE-ID DEPARTMENT GENDER RANK STORE 4 5 6 7 8 9 10 11 12 13 EMP-1007 MALE 33 REGULAR ST-103 OUTDOORS 37 $749 EMP-1009 FEMALE 33 MANAGER ST-103 GROCERIES 32 $1,359 EMP-1012 FEMALE 36 TRAINER ST-102 ELECTRONICS 46 $1,273 EMP-1021 | MALE 48 REGULAR ST-101 ELECTRONICS 39 $1,476 EMP-1030 MALE 48 REGULAR ST-103 OUTDOORS 39 1,425 EMP-1034 MALE 36 REGULAR ST-103 ELECTRONICS 32 $1,451 EMP-1037 MALE 47 TRAINER ST-102 CLOTHING 41 $950 EMP-1043 MALE 30 REGULAR ST-101 CLOTHING 50 $1,361 EMP-1045 MALE 37 TRAINER ST-101 ELECTRONICS 47 $602 EMP-1055 MALE 27 REGULAR ST-101 GROCERIES 33 $1,028) EMP-1064 MALE 30 REGULAR ST-101 GROCERIES 49 $1,054 EMP-1069 FEMALE 35 REGULAR ST-102 CLOTHING 31 $840 EMP-1075 FEMALE 40 PROBATION ST-102 CLOTHING 38 $1,412 EMP-1085 MALE 47 PROBATION ST-102 ELECTRONICS 37 51,131 EMP-1093 49 MANAGER ST-102 OUTDOORS 40 $1,343 EMP-1097 MALE 26 MANAGER ST-103 CLOTHING 33 $1,224 EMP-1105 FEMALE 40 REGULAR ST-101 GROCERIES 46 $1,213 FMP-1111 41 REGULAR ST-102 ICLOTHING 34 $999 14 15 16 17 18 19 20 21 22 Use the data provided in the left-most table to complete the worksheet, filling in each of the blue shaded cell with a FORMULA that will calculate the correct answer. Make sure you copy your formule all the way down to the row where there is a marker to stop Format values appropriately (monetary values should be represented as currency, percentages as percentage formats, only relevent number of decimals should be shown, etc.) If it is not posible to calculate a particular value, use an if function to avoid the calculation and place a hyphen ("") in the cell instead. DO NOT USE THE FERRORI) FUNCTION ANSWER THESE QUESTIONS BY COMPOSING FORMULASN THSCOLUMN COMPLETE THESE ARES sacrtable roue he done with som heter throughout HOW MANY EMPLOYEES DO YOU HAVE HOW MANY EMPLOYEES GROCERIES OUTDOORS ELECTRONICS CLOTHING WHAT IS THE AVERAGE NUMBER OF SALES ACROSS ALL EMPLOYEES FEMALE MALE WHAT IS THE AVERAGE VALUE OF INDIVIDUAL SALES ACROSS ALL EMPLOYEES WHAT IS THE AUTRAGE AGE OF ALL MALE EMPLOYEES HOW MANY EMPLOYEES GROCERIES OUTDOORS ELECTRONICS CLOTHIN WHAT IS THE AVERAGE AGE OF ALL CLOTHING DEPARTMENT EMPLOYEES ST.102 11.10 1.103 WHAT IS THE TOTAL NUMBER OF ELECTRONICS DEPARTMENT SALES WHAT IS THE SUM OF THE TOTAL VALUES OF ELECTRONES DEPARTMENT SALES HOW MANY MANAT DO YOU HAVE HOW MANY EMPLOYEES 1.100 31.101 ST.100 FEMALE WHAT PERCENTAGE OF YOUR EMPLOYEES WORKINTHE OUTDOORS DEEMITMENT HOW MANY EMPLOYEES ST-103 7.301 HOW MANY MANAGERS DO YOU HAVE ST.33 FEMALE MALE WHAT PERCENTAGE OF YOUR EMPLOYEES WORK IN THE OUTDOORS DEPARTMENTS WHAT IS THE TOTAL VALUE OF ALL SALES FOR STORE ST-2013 WHAT PERCENTAGE OF ALL EMPLOYEES PORATION REGULAR TRAINER WHAT IS THE SUM OF THE TOTAL VALUES OF ALL CLOTHING SALES FOR STORES-2012 UANAGER GROCERIES OUTDOORS WHAT IS THE TOTAL VALUE OF ALL CLOTHING SALES Y REGULAR EMPLOYEES TO STORES-2013 CLOTHING WHAT IS THE BATIO OF MALE TO FEMALE EMPLOYEES AT STORE IT.2001 alternatieve calle BUM OF TOTAL SALES CORAL BANON REGULAR TRAINER MANAGER HOW MANY FEMALE EMPLOYEES HAVE MORE THAN 1000 IN TOTAL TALES commer 1000 DO NOT then GROCERIES OUTDOORS ELECTRONICS CLOTHING WHAT IS THE AVERAGE VALUE OF INDIVIDUAL SALES AT STORE ST-101 AVERAGE OF AGE OUTDOOR ELECTRONICS GROCERIES CLOTHING The delegado WHAT IS THE AVERAGE AGE OHALL EMPLOYEES WITH THE BANK OF REGULAR ST-103 ST-103 ST103 K5 B D E G H I J K L AVERAGE VALUE OF EACH SALE (ROUNDED TO WHOLE NUMBER) 2 3 RANK, BASED ON TOTAL VALUE OF SALES TOTAL VALUE OF SALES EMPLOYEE-ID DEPARTMENT GENDER RANK STORE 4 5 6 7 8 9 10 11 12 13 EMP-1007 MALE 33 REGULAR ST-103 OUTDOORS 37 $749 EMP-1009 FEMALE 33 MANAGER ST-103 GROCERIES 32 $1,359 EMP-1012 FEMALE 36 TRAINER ST-102 ELECTRONICS 46 $1,273 EMP-1021 | MALE 48 REGULAR ST-101 ELECTRONICS 39 $1,476 EMP-1030 MALE 48 REGULAR ST-103 OUTDOORS 39 1,425 EMP-1034 MALE 36 REGULAR ST-103 ELECTRONICS 32 $1,451 EMP-1037 MALE 47 TRAINER ST-102 CLOTHING 41 $950 EMP-1043 MALE 30 REGULAR ST-101 CLOTHING 50 $1,361 EMP-1045 MALE 37 TRAINER ST-101 ELECTRONICS 47 $602 EMP-1055 MALE 27 REGULAR ST-101 GROCERIES 33 $1,028) EMP-1064 MALE 30 REGULAR ST-101 GROCERIES 49 $1,054 EMP-1069 FEMALE 35 REGULAR ST-102 CLOTHING 31 $840 EMP-1075 FEMALE 40 PROBATION ST-102 CLOTHING 38 $1,412 EMP-1085 MALE 47 PROBATION ST-102 ELECTRONICS 37 51,131 EMP-1093 49 MANAGER ST-102 OUTDOORS 40 $1,343 EMP-1097 MALE 26 MANAGER ST-103 CLOTHING 33 $1,224 EMP-1105 FEMALE 40 REGULAR ST-101 GROCERIES 46 $1,213 FMP-1111 41 REGULAR ST-102 ICLOTHING 34 $999 14 15 16 17 18 19 20 21 22 Use the data provided in the left-most table to complete the worksheet, filling in each of the blue shaded cell with a FORMULA that will calculate the correct answer. Make sure you copy your formule all the way down to the row where there is a marker to stop Format values appropriately (monetary values should be represented as currency, percentages as percentage formats, only relevent number of decimals should be shown, etc.) If it is not posible to calculate a particular value, use an if function to avoid the calculation and place a hyphen ("") in the cell instead. DO NOT USE THE FERRORI) FUNCTION ANSWER THESE QUESTIONS BY COMPOSING FORMULASN THSCOLUMN COMPLETE THESE ARES sacrtable roue he done with som heter throughout HOW MANY EMPLOYEES DO YOU HAVE HOW MANY EMPLOYEES GROCERIES OUTDOORS ELECTRONICS CLOTHING WHAT IS THE AVERAGE NUMBER OF SALES ACROSS ALL EMPLOYEES FEMALE MALE WHAT IS THE AVERAGE VALUE OF INDIVIDUAL SALES ACROSS ALL EMPLOYEES WHAT IS THE AUTRAGE AGE OF ALL MALE EMPLOYEES HOW MANY EMPLOYEES GROCERIES OUTDOORS ELECTRONICS CLOTHIN WHAT IS THE AVERAGE AGE OF ALL CLOTHING DEPARTMENT EMPLOYEES ST.102 11.10 1.103 WHAT IS THE TOTAL NUMBER OF ELECTRONICS DEPARTMENT SALES WHAT IS THE SUM OF THE TOTAL VALUES OF ELECTRONES DEPARTMENT SALES HOW MANY MANAT DO YOU HAVE HOW MANY EMPLOYEES 1.100 31.101 ST.100 FEMALE WHAT PERCENTAGE OF YOUR EMPLOYEES WORKINTHE OUTDOORS DEEMITMENT HOW MANY EMPLOYEES ST-103 7.301 HOW MANY MANAGERS DO YOU HAVE ST.33 FEMALE MALE WHAT PERCENTAGE OF YOUR EMPLOYEES WORK IN THE OUTDOORS DEPARTMENTS WHAT IS THE TOTAL VALUE OF ALL SALES FOR STORE ST-2013 WHAT PERCENTAGE OF ALL EMPLOYEES PORATION REGULAR TRAINER WHAT IS THE SUM OF THE TOTAL VALUES OF ALL CLOTHING SALES FOR STORES-2012 UANAGER GROCERIES OUTDOORS WHAT IS THE TOTAL VALUE OF ALL CLOTHING SALES Y REGULAR EMPLOYEES TO STORES-2013 CLOTHING WHAT IS THE BATIO OF MALE TO FEMALE EMPLOYEES AT STORE IT.2001 alternatieve calle BUM OF TOTAL SALES CORAL BANON REGULAR TRAINER MANAGER HOW MANY FEMALE EMPLOYEES HAVE MORE THAN 1000 IN TOTAL TALES commer 1000 DO NOT then GROCERIES OUTDOORS ELECTRONICS CLOTHING WHAT IS THE AVERAGE VALUE OF INDIVIDUAL SALES AT STORE ST-101 AVERAGE OF AGE OUTDOOR ELECTRONICS GROCERIES CLOTHING The delegado WHAT IS THE AVERAGE AGE OHALL EMPLOYEES WITH THE BANK OF REGULAR ST-103 ST-103 ST103