Excel questions/formulas

Transcribed image text

A utoSave E] 9 v Home Insert Page Layout Day 4 Exercise - Read-Only Formulas Data Review View Automate Help Visio Data Visualizer Add-ins Acrobat Bing Maps People Graph Search Recom mended Charts Robert Fagan RF Comments 16 Share PivotTable Recommended Table P ivotTabIes Tables SmartArt Screenshot v Pictures Shapes Icons 3D Illustrations Get Add-ins My Add-ins v Maps PivotChart Charts (11b Map v Tours Line Column Win/ Sparklines Slicer Timeline Filters Link Links Comment Comments Tex t Box Header & Footer WordArt v Signature Line v E] Object Exercise 3-1: Excel Formulas 3 Follow the instructions to complete each of the sections below. % should be whole amounts and amounts should reflect accounting format. : SUMIF - Using the SUMIF formula, sum the Partners' Capital ending balances as of 3/31/22, based on the commitment amounts below. Refer to the Capita12 tab. 100,000 3-1b: COUNTIF - Using the COUNTIF formila, how many of the investor classes below do we have? Refer to the Capita12 tab. Ready 3-1 Excel Formulas Accessibility: Investigate 3-2 Pivot Tables 3-3 Mail Merge 3-4 Qlik Capita12 JE Report Equation Symbol Symbols 1047 PM 8/6/2023