IL_EX_3_Revenue_ZacharySutton_Report_2
.xlsx
keyboard_arrow_up
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
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
Related Questions
#
arrow_forward
• Use a while loop
• Use multiple loop controlling conditions
• Use a boolean method
• Use the increment operator
• Extra credit: Reuse earlier code and call two methods from main
Details:
This assignment will be completed using the Eclipse IDE. Cut and paste your code from Eclipse into the Assignment text window.
This is another password program. In this case, your code is simply going to ask for a username and password, and then check the input against four users. The program will give the user three tries to input the correct username-password combination.
There will be four acceptable user-password combinations:
• alpha-alpha1
• beta-beta1
• gamma-gamma1
• delta - delta1
If the user types in one of the correct username-password combinations, then the program will output: "Login successful." Here are a couple of example runs (but your code needs to work for all four user-password combinations):
Username: beta
Type your current password: beta1
Login successful.
Username: delta
Type…
arrow_forward
help finish the code of the provided code.
arrow_forward
Please add flowchart.
Start the code:
def convert_km_to_miles( km ):
Function -- convert_km_to_miles
Converts kilometers to miles. Absolute Value
Parameters:
km (float) -- the original distance in kilometers
Returns a float value representing the original distance converted
to miles
return abs(km * 0.621371)
def convert_miles_to_km( miles ):
Function -- convert_miles_to_km
Converts distance from miles to kilometers. Absolute value
Parameters:
miles (float) -- the original distance in miles
Returns a float value representing the original distance converted
to kilometers
return abs(miles 1.60934)
The United States is one of the last countries to still use the imperial system and miles for
measuring distance.
One software conversion error between US and metric measurements sent a $125 million NASA
probe to its fiery death in Mars' atmosphere (Links to an external site.).
The starter code given includes two functions that convert between metric and imperial values
for distance (kilometers…
arrow_forward
#1. Airplane Seating Assignment. Write a C# Windows App that can be used to assign seats for a
commercial airplane. The airplane has 13 rows, with 6 seats in each row. Rows 1 and 2 are first class,
rows 3 to 7 are business class, and rows 8 to 13 are economy class. Your program prompts the user to
enter the following input: Design the form to accept the user input.
a. Personal Information (Complete Name, Address, Contact #, Passport #)
b. Ticket type (first class, business class or economy class - look for the fares for each ticket type)
c. Click Desired seat from the seating plan.
Note: Design your form displaying the seating plan in the following format. Put also appropriate
titles/headings.
ABCDE F
Row 1
.• x* X X
Row 2
* X* X .X
Row 3
* X X X
Row 4
X * X X
Row 5
*x X*
Row 6
*x *
* X
Row 7
X X
Row 8
* XX X.
Row 9
X X X X
Row 10
• X X XX
.• x• x •
Row 12 ** x x* x
Row 13 ** *x*
Row 11
Here * indicates that the seat is available; X indicates that the seat has been assigned.
d. For…
arrow_forward
python
arrow_forward
first image shows the output needed, second image tells about how to solve the question. some functions are provided below. please add the code in functions below and create more functions according to question. solve in python3 version.
# Hangman Game
# -----------------------------------# Helper code# You don't need to understand this helper code,# but you will have to know how to use the functions# (so be sure to read the docstrings!)import randomimport string
WORDLIST_FILENAME = "words.txt"
# Responses to in-game events# Use the format function to fill in the spacesresponses = [ "I am thinking of a word that is {0} letters long", "Congratulations, you won!", "Your total score for this game is: {0}", "Sorry, you ran out of guesses. The word was: {0}", "You have {0} guesses left.", "Available letters: {0}", "Good guess: {0}", "Oops! That letter is not in my word: {0}", "Oops! You've already guessed that letter: {0}",]
def choose_random_word(all_words):…
arrow_forward
3.) Create a subroutine called WherePutMe that asks the user for a row number and column
letter then places the 2,2 position of a selection into that cell. (HINT: Make sure that you
select a selection before running the sub!)
HINT: If x is an integer and is equal to 7 and y is a string and equal to "B". you can place z
into cell B7 by: Range(y & x) = z. Hope this helps.
arrow_forward
Ch: Color and Grayscale Levels
3. A user can set color-table entries in a PHIGS application program with the function a) setColourRepresentation (ws, ci, colorptr) b) setColorRepresentation (ws, ci, colorptr) c) setColour (ws, ci, colorptr) d) setColourRepresentation ()
arrow_forward
Write a code to the attached photo using Console.WriteLine.
arrow_forward
1. Create and initialize a variable that stores the following value: 17.5
2. Create and initialize a variable that stores the following value: 100
3. Create and initialize a variable that stores the following value: "Student"
4. Create and initialize a variable that stores the following value: "L"
arrow_forward
Assignment Name
JavaScript Concepts III
Assignment Filename
lastname-circleArea.html (replace lastname with your last name).
area.js
Assignment Description
This assignment demonstrates the following concepts: JavaScript Functions
Assignment Instructions
Write a JavaScript program that calculates the area of a circle:
Write a function that calculates the area of a circle given the radius.
Formula: Math.PI * (radius * radius)
Your program code should contain appropriately named variables.
Use documentation to identify various components of your program.
Call the function once and pass a radius value of 10.75 to it.
Use the starter files and complete the logic to satisfy the instructions.
To access the files, download and save the circleArea.zip folder attached to this assignment.
Then unzip the compressed folder to reveal the included files: circleArea.html and area.js. Be sure that the two files are in the same folder. Then write your code in the area.js…
arrow_forward
File math.html contains a form that has to be processed with a PHP program that you will write. Perform the following tasks:
1. Show the name of your PHP program and your name in the form.
2. Replace the fixed + sign in the form with a textbox, so that the user can enter + or -.
3. Write and test a PHP program that will do the following:
a. Validate that the operation in the textbox corresponds to the operation selected by the radio button in the operation radio button group.
b. Validate that the operands are integers with values corresponding to the selection in the grade radio button group.
c. Check that the result entered by the user is a correct integer. If so, send a message to the browser and ask for another submission of the form. If not, send to browser an error message and request resubmission of the form.
d. Keep track of the number of correct and incorrect answers of the user during the session and include both in the messages that acknowledge a correct result or…
arrow_forward
The PHP var dump() function is used to
Select one:
O a. returns
the value of a variable
b. returns
the data type of a variable
O c.returns
the data type, value, and name of a variable
O d.returns
the data type and value of a variable
arrow_forward
Develop a C# Windows Form Application that allows users to do all of the following.
a. Draw the following shapes: The Location of the Shape depends on the users
Mouse Down OR up.
1.
a. Drawing the following shape using mouse left
b. Drawing the following shape using mouse right
arrow_forward
PYTHON PROGRAMMING!!
EXTRA CONSTRAINT: MAKE SURE THAT THE CODE ACCEPTS THE INPUT ON THE IMAGE AND OUTPUTS THE RESULT ON THE IMAGE AS WELLYou find yourself in a top-secret mission to infiltrate and disable the nuclear missile silos of a terrorist organization threatening to destroy any country that refuses to surrender. Fortunately, an ally double agent was able to successfully hijack the launch system used by the terrorists. However, in order to not get found out, they could not disable the system outright but they were able to infect the system with an undetectable virus that stops all processes of the system was activated.
Through a secure line, the double agent gives you the instructions in order to activate the virus and stop all missiles from firing:
In the trash can nearest the main computer, you should be able to get a crumpled piece of paper with a grid of random numbers printed onto it. You will know that it is the right piece of paper if there are the same number of rows and…
arrow_forward
Python
arrow_forward
i have this c code its a bouncing ball game and it has a paddle to make the ball bounce back but it is not working. how to fix it?
#include <stdio.h>#include <stdlib.h>#include <time.h>
// Define constants for the screen size and ball velocity.#define SCREEN_WIDTH 60#define SCREEN_HEIGHT 20#define BALL_VELOCITY 1#define CENTER
// Variables to keep track of position and speed of ballint x = 0;int y = 100;int x_speed = 5;int y_speed = 5;// Variables to keep track of paddleint x_paddle = 250, y_paddle = 370;int paddle_width_half = 40;// score keepingint score = 0;int width;int key;int LEFT;int RIGHT;int keyPressed;int keyCode;
// Called every re-draw, defaul 30 times per secondvoid draw() {
// Update position by adding speedx = x + x_speed;y = y + y_speed;if (y < 0)y_speed = -y_speed;if (x > width || x < 0)x_speed = -x_speed;
// Check if keys are pressedif (keyPressed) {if (keyCode == RIGHT || key == 'd') {// Move paddle rightx_paddle = x_paddle + 8;}else if…
arrow_forward
.Rprofile - the first chunk of code executed
arrow_forward
Homework
Instructions: For each Exercise below, write your code in an IDE and run your code within the
IDE as well. Once you have satisfied the Exercise requirements, paste your code below under
the corresponding Exercise.
Exercise 1:
Create a temperature conversion program! To convert from Fahrenheit to Celsius or
Celsius to Fahrenheit.
●
●
●
Convert C to F (Formula): temp = (1.8* temp) + 32.0;
Convert F to C (Formula): temp = (temp-32) / 1.8;
HINT: what does every temperature have? (number and unit right?)
arrow_forward
Need help with all answer
arrow_forward
Create a Python app based on the given image.
arrow_forward
o Page 636, Question 14.12(25%)
Write a temperature conversion application that converts from Fahrenheit
to Celsius. The Fahrenheit temperature should be entered from the
keyboard (via a JTextField). A JLabel should be used to display the
converted temperature. Use the following formula for the conversion:
5
Celcius
x (Farenheit – 32)
arrow_forward
* :In Matlab the command logical of (and) is represented by
No one of them
and
Which of the following command is true to represent the following polynomial
equation: y=8-3x
y=[8 ;-3] O
y=[8 -3] O
y=l-3 8] O
y=[8 :-3] O
*:The name MATLAB is
Mathmatic Lab
Mathmatic Labortary
No one of them
Matrix Labortary
arrow_forward
Please do not give solution in image format thanku
Software Engineering:
Project Description:
Sentiment Analysis System for Images, In this project, we will be creating an Sentiment Analysis system that utilizes machine learning to efficiently analyze people's feelings using their images. Then we will build a web application that is allowing users to upload an image and make a decision about whether it is positive, negative, or neutral.
I need the following (please in details and clearly):
A) Context models (The whole System)B) Use case modeling (At least four of your system features or activities)C) Class diagrams1. Classes and associations (The whole System)2. Class diagram (At least four of your system activities)D) Sequence diagram (At least four of your system activities)
Thank you!
arrow_forward
Direction: Answer the following, write your answer in a word document and convert it to pdf file.
1. Create a program that prompt user to input two numbers and displays the six types of relationships for the two inputted numbers.
2. Create a program that applies the concept of login form using logical operators.
Username = 25
Password = 12
Sample output:
Enter username: 25
Enter password: 12
"You are successfully login"
while if wrong input the message is "you are not allowed to login"
3. Create a program that prompt user to input a value for variable a then displays the value of the following assignment operators such as +=, --, *=, /=, %=. int a, b, c
Sample output
Enter a value for a = 3;
Enter a value for b= 3;
The value of c = a is:
The value of c =+a is:
The value of c =-a is:
The value of c ="a is:
The value of c =/a is:
The value of c =%a is:
arrow_forward
Design a module named timesTen. The module should accept an Integer argument. When the module is called, it should display the product of its argument multiplied times 10.
arrow_forward
Plus x: A first function
Assign y with 5 plus x.
Ex: If x is 2, then y is 7. If x is 19, then y is 24.
Note: Some challenge activities require completing a function (as above), or writing a new function. You can create test calls to the function in the "Code to call your function" window, then press "Run". Try appending this call to that window: IncreaseValue(9)
When done writing and testing your function, press "Submit for Assessment", which will automatically apply various test calls to your function.
arrow_forward
Q1- Command used to display
the value of variable x.
O displayx
O disp(x)
disp x
vardisp('x')
arrow_forward
uppose you have a certain amount of money in a savings account that earns compoundmonthly interest, and you want to calculate the amount that you will have after a specificnumber of months. The formula, which is known as the future value formula, is:F=P×(1+i)tThe terms in the formula are as follows:o F is the future value of the account after the specified time period.o P is the present value of the account.o i is the monthly interest rate.o t is the number of months.Write a program that prompts the user to enter the account’s present value, monthlyinterest rate, and the number of months that the money will be left in the account. Theprogram should pass these values to a function named futureValue that returns thefuture value of the account, after the specified number of months. The program shoulddisplay the account’s future value.
i attached the screenshot of the output so the output should look like that.
the coding should be in c++
arrow_forward
terminal - using the vi Lab2_3.sh Write a shell script that takes three parameters (integers) and displays the median number. If the number of parameters is not three, it should display “Just three numbers please”. If there are two numbers with the same value, it should display “Sorry median here does not mean anything”
arrow_forward
python
The intent of this program is to manage a set of contacts. Each contact will have data associated with it:
Id – number/integer
First Name – string
Last Name – string
Age – number/integer
Phone Number – string
Email – string
Anything else you’d like to add to make yours unique (can result in extra credit)
Gender – character or string (m/f/o)
Twitter ID, Facebook Id, etc
You must allow the customer to do the following actions on the contact list:
List all contacts
Add contact
Delete contact
Edit contact
Exit program
You should leverage a database (PostgreSQL) to save everything to the DB and read from it.
You should use classes for this assignment. This means you should have two classes:
Contact – all the attributes/properties described above with appropriate constructor. Methods:
Add (constructor - __init__(p_id, p_fname, p_lname, p_age, p_phone, p_email, p_gender)
Edit
Contact List (contact_list) – built on Python list (or creating one within the constructor), you…
arrow_forward
In order for a player to navigate your game, you will need to develop a function or functions using Python script. Your function or functions should do the following:
Show the player the different commands they can enter (such as “go North”, “go West”, and “get [item Name]”).
Show the player’s status by identifying the room they are currently in, showing a list of their inventory of items, and displaying the item in their current room.
You could make these separate functions or part of a single function, depending on how you prefer to organize your code.
#Sample function showing the goal of the game and move commands def show_instructions(): #print a main menu and the commands print("Dragon Text Adventure Game") print("Collect 6 items to win the game, or be eaten by the dragon.") print("Move commands: go South, go North, go East, go West") print("Add to Inventory: get 'item name'") #In this solution, the player’s status would be shown in a separate function. #You may organize your…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Related Questions
- #arrow_forward• Use a while loop • Use multiple loop controlling conditions • Use a boolean method • Use the increment operator • Extra credit: Reuse earlier code and call two methods from main Details: This assignment will be completed using the Eclipse IDE. Cut and paste your code from Eclipse into the Assignment text window. This is another password program. In this case, your code is simply going to ask for a username and password, and then check the input against four users. The program will give the user three tries to input the correct username-password combination. There will be four acceptable user-password combinations: • alpha-alpha1 • beta-beta1 • gamma-gamma1 • delta - delta1 If the user types in one of the correct username-password combinations, then the program will output: "Login successful." Here are a couple of example runs (but your code needs to work for all four user-password combinations): Username: beta Type your current password: beta1 Login successful. Username: delta Type…arrow_forwardhelp finish the code of the provided code.arrow_forward
- Please add flowchart. Start the code: def convert_km_to_miles( km ): Function -- convert_km_to_miles Converts kilometers to miles. Absolute Value Parameters: km (float) -- the original distance in kilometers Returns a float value representing the original distance converted to miles return abs(km * 0.621371) def convert_miles_to_km( miles ): Function -- convert_miles_to_km Converts distance from miles to kilometers. Absolute value Parameters: miles (float) -- the original distance in miles Returns a float value representing the original distance converted to kilometers return abs(miles 1.60934) The United States is one of the last countries to still use the imperial system and miles for measuring distance. One software conversion error between US and metric measurements sent a $125 million NASA probe to its fiery death in Mars' atmosphere (Links to an external site.). The starter code given includes two functions that convert between metric and imperial values for distance (kilometers…arrow_forward#1. Airplane Seating Assignment. Write a C# Windows App that can be used to assign seats for a commercial airplane. The airplane has 13 rows, with 6 seats in each row. Rows 1 and 2 are first class, rows 3 to 7 are business class, and rows 8 to 13 are economy class. Your program prompts the user to enter the following input: Design the form to accept the user input. a. Personal Information (Complete Name, Address, Contact #, Passport #) b. Ticket type (first class, business class or economy class - look for the fares for each ticket type) c. Click Desired seat from the seating plan. Note: Design your form displaying the seating plan in the following format. Put also appropriate titles/headings. ABCDE F Row 1 .• x* X X Row 2 * X* X .X Row 3 * X X X Row 4 X * X X Row 5 *x X* Row 6 *x * * X Row 7 X X Row 8 * XX X. Row 9 X X X X Row 10 • X X XX .• x• x • Row 12 ** x x* x Row 13 ** *x* Row 11 Here * indicates that the seat is available; X indicates that the seat has been assigned. d. For…arrow_forwardpythonarrow_forward
- first image shows the output needed, second image tells about how to solve the question. some functions are provided below. please add the code in functions below and create more functions according to question. solve in python3 version. # Hangman Game # -----------------------------------# Helper code# You don't need to understand this helper code,# but you will have to know how to use the functions# (so be sure to read the docstrings!)import randomimport string WORDLIST_FILENAME = "words.txt" # Responses to in-game events# Use the format function to fill in the spacesresponses = [ "I am thinking of a word that is {0} letters long", "Congratulations, you won!", "Your total score for this game is: {0}", "Sorry, you ran out of guesses. The word was: {0}", "You have {0} guesses left.", "Available letters: {0}", "Good guess: {0}", "Oops! That letter is not in my word: {0}", "Oops! You've already guessed that letter: {0}",] def choose_random_word(all_words):…arrow_forward3.) Create a subroutine called WherePutMe that asks the user for a row number and column letter then places the 2,2 position of a selection into that cell. (HINT: Make sure that you select a selection before running the sub!) HINT: If x is an integer and is equal to 7 and y is a string and equal to "B". you can place z into cell B7 by: Range(y & x) = z. Hope this helps.arrow_forwardCh: Color and Grayscale Levels 3. A user can set color-table entries in a PHIGS application program with the function a) setColourRepresentation (ws, ci, colorptr) b) setColorRepresentation (ws, ci, colorptr) c) setColour (ws, ci, colorptr) d) setColourRepresentation ()arrow_forward
- Write a code to the attached photo using Console.WriteLine.arrow_forward1. Create and initialize a variable that stores the following value: 17.5 2. Create and initialize a variable that stores the following value: 100 3. Create and initialize a variable that stores the following value: "Student" 4. Create and initialize a variable that stores the following value: "L"arrow_forwardAssignment Name JavaScript Concepts III Assignment Filename lastname-circleArea.html (replace lastname with your last name). area.js Assignment Description This assignment demonstrates the following concepts: JavaScript Functions Assignment Instructions Write a JavaScript program that calculates the area of a circle: Write a function that calculates the area of a circle given the radius. Formula: Math.PI * (radius * radius) Your program code should contain appropriately named variables. Use documentation to identify various components of your program. Call the function once and pass a radius value of 10.75 to it. Use the starter files and complete the logic to satisfy the instructions. To access the files, download and save the circleArea.zip folder attached to this assignment. Then unzip the compressed folder to reveal the included files: circleArea.html and area.js. Be sure that the two files are in the same folder. Then write your code in the area.js…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education