Question 1 to 8

The American River Financial Corporation (ARFC) is a financial services company headquartered in Sacramento, California. It has two main offices in New York City and Los Angles, plus satellite offices in Texas. You are taking a deep look at ARFC's financials, with the goal of helping ARFC respond to an exponential grow in revenues and client accounts. You begin your review of ARFC's financials by opening the ARFC workbook. Your first task is to analyze and summarize the New York office's commissions. 1. On the New York worksheet, you name the following ranges: a. Transactions Transaction and limit the scope to this sheet. b. Commissions Commission and limit the scope to this sheet. c. Transaction Codes Code and limit the scope to this sheet. 2. On row 23, you add a label Total and a column conclusion. 3. In F4:F7, you use a specific function and range name to count each transaction in E4:E7 4. In G4:G7, you use a specific function and range name to total commissions for each transaction in E4:E7 5. In H4:H7, you use a specific function and range name to average commissions for each transaction in E4:E7 6. On row 8, you add a label Total and an appropriate column conclusion for each category. 7. Provide personalized worksheet formatting that is consistent with standard worksheet protocols. 8. Ensure the worksheet is formatted and AutoFit/Best Fit according to worksheet protocols.Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Verdana (Body) 11 AA ab Wrap Text v General Insert 2 x AY - O. x Delete v Paste BIU Y Av Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Ideas Formatting as Table Styles [Format Sensitivity Q v Filter Select B27 X A B C D E F G H I J K L M N O P Q R S T American River Financial Corporation N H New York Commission Transactio Comission Transactio Transaction Numbe Commission Commissio 3 ns n Code Summary Summary 4 PET $ 2,385 1711 MRI 5 CTF $ 1,857 1457 CTF 6 PET $ 1,850 1491 RBP 7 MRI $ 1,640 1759 PET 8 CTF $ 2,207 1764 RBF $ 1,467 1304 10 RBP $ 1,442 11 RBP $ 817 1504 12 CTF $ 1,217 1583 13 RBP $ 852 1660 14 CTF $ 2,010 1068 15 MRI $ 1,622 1073 16 CTF $ 1,267 1325 17 RBP $ 892 1494 18 MRI $ 1,110 1647 19 CTF $ 1,317 1239 20 MRI $ 1,617 1645 21 RBP $ 892 1700 22 CTF $ 3,098 1767 23 24 25 26 27 28 29 40 41 New York Los Angles Sacramento Projection Accounts Texas NewTxOff Managers BONUS + IT + 100%