Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help - Sot the data in ceils A2. C31, by Current Belary, from high lo low Copy the tormule in E2 down, through Eas.
please help - Sot the data in ceils A2. C31, by Current Belary, from high lo low Copy the tormule in E2 down, through Eas. - Save dscument as Module 2 Mastery Exercise 2.1 .1 Rubcie for Module 3 Mastery Everche a.1.1: - 02 contarine afproprate viococue findion is pointsy : 02 copied down nuough 091 (2 poita) - E2 copied down tirough E31 (2 poinds) N21 fx \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline & Employee & Department & Current Salary & Raise & New Salary & \\ \hline & oung & Sales & 52,550 & & & \\ \hline & onhogen & Marketing & 44,750 & & & \\ \hline & ohnston & Marketing & 44,250 & & & \\ \hline & Nebb & Finance & 42,750 & & 8 & \\ \hline & Nelch & Finance & 42,000 & & & \\ \hline & Davies & Finance & 41,500 & & & \\ \hline & Gardner & Marketing & 41,000 & & & \\ \hline & Wayne & Finance & 40,500 & & & \\ \hline & Hughes & Production & 39,000 & & & \\ \hline 1 & Pettit & Finance & 38,000 & & & 8 \\ \hline 12 & Moynihan & Production & 36,000 & & & \\ \hline 13 & Foster & Sales & 34,750 & & & 1 \\ \hline 14 & Mandolo & Production & 34,450 & & & \\ \hline 15 & Spencer & Marketing. & 33,750 & & & \\ \hline 16 & McWhorter & Finance & 33,575 & & & \\ \hline 17 & Shettler & Production & 33,250 & & & \\ \hline 18 & Loury & Finance & 32,750 & & & \\ \hline 19 & Carmona & Production & 31,500 & & & \\ \hline 20 & Atherton & Sales & 29,750 & & & \\ \hline 21 & Shapiro & Sales & 27,750 & & & \\ \hline 22 & Young & Finance & 27,500 & & & \\ \hline 23 & Sheffler & Sales & 27,250 & & & \\ \hline 24 & Woodward & Marketing & 26,500 & & & \\ \hline 25 & Bailey & Sales & 25,750 & & & \\ \hline 26 & Bishop & Finance & 25,500 & 8 & & \\ \hline 27 & Guardola & Marketing & 25,000 & & & \\ \hline 28 & Merriwether & Production & 24,000 & & & \\ \hline 29 & Bennett & Finance & 22,750 & & & \\ \hline 30 & Powers & Marketing & 22,000 & & & \\ \hline 31 & Fogerty & Sales: & 21,600 & & & \\ \hline \end{tabular} \begin{tabular}{|l|c|} \hline \multicolumn{1}{|c|}{ Department } & Raise % \\ \hline Finance & 5.5% \\ \hline Marketing & 1.0% \\ \hline Production & 4.0% \\ \hline Sales & 2.5% \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started