IL_EX_3_Revenue_ZacharySutton_Report_2

.xlsx

School

Northern Arizona University *

*We aren’t endorsed by this school

Course

120

Subject

Computer Science

Date

Dec 6, 2023

Type

xlsx

Pages

4

Uploaded by MegaResolve8522

Report
Zachary Sutton GE ver. 17.0.1-rc0000 1. Create formulas. 5/5 Create a formula. 5/5 Copy a formula into a range. 6/6 Apply a cell style. 6/6 2. Created a formula. 6/6 Copy a formula into a range. 6/6 3. Created a formula. 6/6 Copy a formula into a range. 6/6 4. Create a formula using a function. 6/6 5. Create a formula using a function. 6/6 Change the number format. 6/6 Change the number format. 6/6 Change a number format. 6/6 6. Created a formula using a function. 6/6 Apply a cell style. 6/6 7. Insert a shape. 6/6 8. Update a value in a cell. 6/6 SUBMISSION #2 | SCORE IS: 100 OUT OF 100 Enter a Formula Using the Quick Analysis Tool Build a Logical Formula with the IF Function Build a Logical Formula with the AND Function Round a Value with a Function Build a Statistical Formula with the COUNTA function Enter a Date Function Work with Equation Tools Control Worksheet Calculations Illustrated Excel 365/2021 | Module 3: Textbook Project
Zachary Sutton JCL Talen 2/24/2025 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Revenue New York $ 34,305 $ 30,731 $ 27,938 $ 37,467 $ 130,441 Los Angeles $ 10,954 $ 40,937 $ 21,971 $ 24,513 $ 98,375 Miami Beach $ 10,621 $ 47,200 $ 24,596 $ 11,614 $ 94,031 Chicago $ 35,609 $ 29,798 $ 48,737 $ 44,708 $ 158,852 Seattle $ 44,594 $ 45,186 $ 46,174 $ 13,921 $ 149,875 Houston $ 43,331 $ 37,250 $ 19,544 $ 40,013 $ 140,138 Boston $ 22,879 $ 12,300 $ 16,514 $ 42,119 $ 93,812 Philadelphia $ 19,984 $ 38,768 $ 11,102 $ 47,482 $ 117,336 Toronto $ 15,868 $ 46,942 $ 42,394 $ 16,177 $ 121,381 Vancouver $ 17,502 $ 19,488 $ 48,411 $ 36,260 $ 121,661 Target % increase 15% # of NA Offices 10 $ 122,590 Average Year Revenue
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help