AutoSave) Bus 2410 Fall 2021 Project 4 - Search Shaun Harshall AH Filc : Home Insert Drav Page Layout Forrnilas Data Review View Help Share Comments Genela X Cut [copy 3 Format Painter 1 AA === By Wrap Text ===Merge & Center SEX H Inser. Delele Format 27 O Posle @ Analyze Data BIU Autosum Z Fill Sort & Find & Clear Filter Salat Litirs Conditional Formal da Cell Formatting Table Sylns Sale! $% 42.99 38 Sover Clipboard -ort Alignment F Number CS: Analysis Scler 515 J la D j K L M N P 1 V Budget - Using Excel Choose and Match Functions 2 3 4 Budget Year 03 04 Put formulas in the yellow cells only and do not change the tarmular in the collir elk. 01 OZ Tatal ! E 6 4 AcctNum Account 5030 Office supplies 9040 Marketing 5042 Irade shoes 5052 Postage SAS Telephone 5054 Internet 5055 Travel 9056 Meals 5057 Entertainment D D D Prlar Year Actuals 92 03 Q4 345 682 6046 3,969 4,2014 10.486 D 1.952 2,426 125 268 392 S52 300 500 500 395 2.592 1,595 156 71 252 627 870 553 01 279 1,479 0 112 002 500 1,105 143 619 Total Method 2,127 Zora 19.1.98 zoro 10.986 Zero 4.6US Zero 2.319 Zerc 2.000 Zero 5.527 Zero 827 Zero 2.579 Zero Inc (dec) Var % 12,127) EININ 115,698) INUX (10.896) ILUX 4,05 ILLU 2.215) -I0002 (2.000) -100.0% 5,627) -100.0% 1827) -200.05 12,679) -200.05 O 9 10 11 12 13 11. 151 BA Toll 5.144 11.187 11.167 21.979 12,478 50,768 0 150,75815096 These methods are used in the Drop Down list in Column Methods Soresd PY Match PV Decrease Zero This is called Data Validation 17 19 19 2012 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 3: 31 30 39 -Choose Lese_runr to return value in the list of values. LwCHOOSE la lectate alta 254 values and the indexe For sale, il value the value are the days of the CHOOSE returns one of the keys when a number selweer 1 and 7 is used as index_nuri. CHOOSElindex_nuni, value1, [value2], ...) The only difference in our use of Cheese is that we willrot be putting in an index rum but instead will be using the March function to give us a rumber such as 1,2,3.....etc =Match The MATCH function cards for a specified item in a range of cols, and the returns the relative position of that item in the range. For example, if the range A1:43 contains the values 5,25 and 38, then the formula -MATCH75,41:43. turn the number, because 25 in the second item in the range MATCHookup_value, lookup_array) MATCHitre word in columns ils position in the Method lable, cell addresses olhe Method Table Methods Spread PY - Spread the previous year tota in column Hover the four querer in columns, KL, M. Match PY - Take what is in columns D, E, F, G and put that number in calumrad, KLM Decrease - Take the amount: in columns D, E, , Gand multay them by.. to decreacte amounts by ten percent. Then put these numbers in coms J, K, L, M Zero Putzero into columns. K, L, M In order to use itese two function together in ore function this is the format that you will be using =CHOOSE MATC-lookup_value, lookup_array I.Spred PY, Match P7 Decrease ze o This farmula wal d go into calls to Ma and then all the way down ta row 13. Thali is what your araw'era in cacho-tre columns Qi ta 04 should look like. Cower Sheet Choose & Match Mookup & Match Scatter pilot R Squared Investment Derisinin Rasd, 25+ Type here to search O 5C Mostly cloudy 0 LG 12:42 PM 20124 11 0 AutoSave) Bus 2410 Fall 2021 Project 4 - Search Shaun Harshall AH Filc : Home Insert Drav Page Layout Forrnilas Data Review View Help Share Comments Genela X Cut [copy 3 Format Painter 1 AA === By Wrap Text ===Merge & Center SEX H Inser. Delele Format 27 O Posle @ Analyze Data BIU Autosum Z Fill Sort & Find & Clear Filter Salat Litirs Conditional Formal da Cell Formatting Table Sylns Sale! $% 42.99 38 Sover Clipboard -ort Alignment F Number CS: Analysis Scler 515 J la D j K L M N P 1 V Budget - Using Excel Choose and Match Functions 2 3 4 Budget Year 03 04 Put formulas in the yellow cells only and do not change the tarmular in the collir elk. 01 OZ Tatal ! E 6 4 AcctNum Account 5030 Office supplies 9040 Marketing 5042 Irade shoes 5052 Postage SAS Telephone 5054 Internet 5055 Travel 9056 Meals 5057 Entertainment D D D Prlar Year Actuals 92 03 Q4 345 682 6046 3,969 4,2014 10.486 D 1.952 2,426 125 268 392 S52 300 500 500 395 2.592 1,595 156 71 252 627 870 553 01 279 1,479 0 112 002 500 1,105 143 619 Total Method 2,127 Zora 19.1.98 zoro 10.986 Zero 4.6US Zero 2.319 Zerc 2.000 Zero 5.527 Zero 827 Zero 2.579 Zero Inc (dec) Var % 12,127) EININ 115,698) INUX (10.896) ILUX 4,05 ILLU 2.215) -I0002 (2.000) -100.0% 5,627) -100.0% 1827) -200.05 12,679) -200.05 O 9 10 11 12 13 11. 151 BA Toll 5.144 11.187 11.167 21.979 12,478 50,768 0 150,75815096 These methods are used in the Drop Down list in Column Methods Soresd PY Match PV Decrease Zero This is called Data Validation 17 19 19 2012 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 3: 31 30 39 -Choose Lese_runr to return value in the list of values. LwCHOOSE la lectate alta 254 values and the indexe For sale, il value the value are the days of the CHOOSE returns one of the keys when a number selweer 1 and 7 is used as index_nuri. CHOOSElindex_nuni, value1, [value2], ...) The only difference in our use of Cheese is that we willrot be putting in an index rum but instead will be using the March function to give us a rumber such as 1,2,3.....etc =Match The MATCH function cards for a specified item in a range of cols, and the returns the relative position of that item in the range. For example, if the range A1:43 contains the values 5,25 and 38, then the formula -MATCH75,41:43. turn the number, because 25 in the second item in the range MATCHookup_value, lookup_array) MATCHitre word in columns ils position in the Method lable, cell addresses olhe Method Table Methods Spread PY - Spread the previous year tota in column Hover the four querer in columns, KL, M. Match PY - Take what is in columns D, E, F, G and put that number in calumrad, KLM Decrease - Take the amount: in columns D, E, , Gand multay them by.. to decreacte amounts by ten percent. Then put these numbers in coms J, K, L, M Zero Putzero into columns. K, L, M In order to use itese two function together in ore function this is the format that you will be using =CHOOSE MATC-lookup_value, lookup_array I.Spred PY, Match P7 Decrease ze o This farmula wal d go into calls to Ma and then all the way down ta row 13. Thali is what your araw'era in cacho-tre columns Qi ta 04 should look like. Cower Sheet Choose & Match Mookup & Match Scatter pilot R Squared Investment Derisinin Rasd, 25+ Type here to search O 5C Mostly cloudy 0 LG 12:42 PM 20124 11 0