Question

ber 8 Excel Simulation S&P Enterprises has provided data om the frst three months of the year. The Coeoler has asked you to prepare the Cash Budget ad related Schedules for Expected cash collections and Payments to suppliers Use the information included in the Excel Simulation and the Exce functions described below to complete the task celReterence Budget Dato tab, "B5" was entened the formule would output the result from cel 05, or 1600 in this example Mult-Tab Cell Rederences Allows you so refer to data from snother cell in e seperee tab in the worksheet. When using the muli-teb cel reference, type the equal sign nrst then elck on the ofher tab and then elek On-e cel you want to reference The symex of a cel reference ooks different then nomel cell reference. snce it includes the tab name turrounded by apostrophes and atto an evelamon point before the cell location From the Excel Simuletion below, if in a blank cel on the Schedules and Cesh Budget tab " Budget DeneC7 was entered, the fomula would output the result from cell C7 in the Budget Data tab er 33.750 in this example Besic Math functions Alows you to use the basic math symbols to perform methemetical functions You can use the folowing keys 。plus sign to add-(minus sph to subtract." (asterisk sign to mutom and / (forward siesh to dMde) From the Exce( Simulaton below, if n a blank ee1 on ย·Budget Dota tab."-875-в'W' was ernered the formula woud add the velues from those cells and outun the result or 34.000 in ns exempe using me er er math tymbois the resur would Duput ถา ROproerate answer for its tuncton. SUM function: Allows you to refer to multiple cells and adds all the velues You can add individusl cel references or renges to ubiize this function From the Excel Simuleton below, if ǐาอ blank Ce'*SUM(810 Brt B12r wes entered. the formulo wold output tho resut of adding those three separate cels. or 97% in this esample Smary na bank cei ..SUM8108ar was emered. the form e woud output the same result of adding those ces, escept they are expressed osa 'enge in th" formula, and result would be 97% n this e"ample Allows yo. to refer to data tom anorer ce·in te worksheet Fren Pe Eser. Smeten below. . bane cel er the FORMMLAS リ: | --S S&PEnterprises needs a cash budget for March The following nformatona- x is available Data 4 Actual January and February and expected March sales s Cash sales $ 1,600 $ 3,750 5,100 7 Total Sales <Prev 'ofilií Next pll dx 5 6 7 8

Answer 1