IL_EX365_2021_11a_ZacharySutton_Report_1
.xlsx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
360
Subject
Computer Science
Date
Dec 6, 2023
Type
xlsx
Pages
15
Uploaded by MegaResolve8522
Zachary Sutton
GE ver. 17.1.0-rc0000
1.
0/1
Correct a formula.
Correct multiple formulas.
In the Tampa worksheet, one or more cells in the range G7:G14 contains an incorrect formula.
Correct a formula.
Correct a formula.
2.
1/1
Update a value in a cell.
3.
1/1
Create a formula using a function.
Create a formula using a function.
Create a formula using a function.
4.
1/1
Create a formula referencing an external workbook.
5.
1/1
Edit a defined name for a cell.
6.
0/1
Create a defined name for a range of cells.
Create a formula without a function.
Copy a formula into a range.
In the Orlando worksheet, one or more cells in the range E7:E14 contains an incorrect formula.
7.
1/1
Remove defined names from a range.
8.
1/1
Create a formula using a function.
Copy a formula into a range.
9.
1/1
Create a formula using a function.
Copy a formula into a range.
10.
1/1
Create a formula using a function.
Copy a formula into a range.
Create a formula using a function.
Copy a formula into a range.
11.
1/1
Create a formula using a function.
12.
1/1
Enter text in a cell.
Use Flash Fill.
Enter a value in a cell.
Use Flash Fill.
Delete a column.
13.
1/1
Create a formula using a function.
Copy a formula into a range.
Create a formula using a function.
14.
2/2
Fill a series using a linear trend.
Fill a series using a growth trend.
Create a formula.
Fill a series using a growth trend.
15.
2/2
Enter text in a cell.
Fill a range using an AutoList.
16.
0/2
Create defined names for a cell.
In the Expansion worksheet, the named ranges for the range B5:B10 have not been set up correctly.
17.
2/2
Create a formula using a function.
18.
2/2
Create a formula using a function.
19.
2/2
Create a formula using a function.
SUBMISSION #1 | SCORE IS: 21
OUT OF 25
Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to cities and other organizations. In an Excel workbook, Darius is tracking the service contracts he manages in Tampa and Orlando. He asks for your help in analyzing the contract data and correcting errors. Go to the Tampa
worksheet. Correct the errors in the worksheet as follows:
a. In cell G6, trace the errors in the formula to identify the cause of the error message. Correct the formula so that the IF function tests whether the contract date (the range named Contract_Tampa) is less than the date in cell B3. If it is, multiply the standard price (cell F6) by the sale price rate (cell G3) and return the result. If it is not, return the standard price (cell F6) in cell G6. b. Copy the formula in cell G6 into the range G7:G14 to fix the errors in that range.
c. In cell G15, use Error Checking to find the formula error, and then correct the formula.
d. Correct the formula error in cell F15.
After entering the equipment code data in the range D6:D14, Darius applied data validation to the range to make sure he and others entered the correct codes. Check for data-entry errors and correct them as follows:
a. Circle invalid data in the worksheet.
b. Change the circled value to 104
to use the correct equipment code.
In the range A18:B23, Darius has created an area for analyzing the service agreements for specific types of equipment. He wants to analyze the sales of substation agreements because they are the most expensive. Create formulas to analyze this data as follows: a. In cell B20, enter a formula using the COUNTIF
function to count the number of substation agreements sold. Use the list of equipment codes (range D6:D14
) as the range and the code for substations (cell I9
) as the criteria in your formula.
b. In cell B21, enter a formula using the AVERAGEIF
function to find the average sale price of a substation agreement. Use the list of equipment codes as the range, the code for substations as the criteria, and the sale prices (range G6:G14
) as the range to average in your formula.
c. In cell B22, use the SUMIF
function to find the total sale price of substation agreements. Use the list of equipment codes as the range, the code for substations as the criteria, and the sale prices as the range to sum in your formula.
In cell B23, Darius wants to display the profit margin for substations, which is contained in another worksheet. Create a formula using an external reference as follows to include the profit margin:
a. Open the workbook Support_EX365_2021_11a_Substations.xlsx
.
b. In cell B23 of the Tampa worksheet, insert a formula that references cell B6
in the Support_EX365_2021_11a_Substations.xlsx workbook.
c. Close the Support_EX365_2021_11a_Substations.xlsx workbook.
Darius has defined a name for cell B23, but wants to change it to one more similar to the text in cell A23. Edit the defined name for cell B23 to use Profit_Margin
as the name. [Mac Hint: Delete the old defined name and create a new defined name.]
Go to the Orlando
worksheet. In the range E6:E14, Darius needs to enter a formula to calculate the expiration dates for the service agreements, which expire after one year. He wants to use a defined name in the formula as he did on the Tampa
worksheet.
Calculate the expiration dates as follows:
a. Examine the formula in cell G6, which uses a defined name to calculate the sale price.
b. Assign the same defined name (
Contract_Orlando
) to the range C6:C14, which resolves the errors in column G.
c. In cell E6, enter a formula without using a function to determine the expiration date by adding 365
to the defined name @Contract_Orlando
. [Hint: To avoid an #SPILL error, enable implicit intersection by placing the This Row specifier (@ character) in front of the defined name.]
d. Fill the range E7:E14 with the formula in cell E6.
The workbook contains a defined name Darius no longer needs.
Delete the defined name invoice_number
(but not the data) from the workbook.
In the range I5:L10, Darius wants to list data about new Orlando customers who have not signed a contract yet. On a separate worksheet named New Clients
, he imported the data, but it did not appear in the correct format. For example, the company names appear in all lowercase, though each name should begin with an uppercase letter.
Examine the imported data on the New Clients
worksheet, and then return to the Orlando
worksheet to incorporate the imported company name data in the range I6:I10 using worksheet references as follows:
a. In cell I6 on the Orlando
worksheet, enter a formula using the PROPER
function to capitalize the first letter in each word in the Company text in cell B3
of the New Clients
worksheet.
b. Fill the range I7:I10 with the formula in cell I6 to show the company names.
The imported contact name data separates the first and last names, but Darius wants to list the full name in one cell. List the first and last names of each contact in a single cell using worksheet references as follows:
a. In cell J6, enter a formula using the CONCAT
function that displays the first name shown in cell C3
of the New Clients
worksheet followed by a space (
" "
), and then the last name shown in cell D3
of the New Clients
worksheet.
b. Fill the range J7:J10 with the formula in cell J6 to list the full names of the remaining contacts.
List the number of years in business and the state where the company is located using worksheet references as follows:
a. In cell K6, enter a formula using the LEFT
function to insert the first 2
characters on the left of cell E3 of the New Clients
worksheet. b. Fill the range K7:K10 with the formula in cell K6.
c. In cell L6, enter a formula using the RIGHT
function to insert the last 2
characters on the right of cell F3
of the New Clients
worksheet. d. Fill the range L7:L10 with the formula in cell L6.
Darius asks you to calculate the total service agreement sales for both offices.
Go to the Summary
worksheet. In cell A4, create a formula using the SUM
function and 3-D references to total cell G15
on the Tampa
worksheet and cell G15
on the Orlando
worksheet.
Next, Darius wants to separate the customer names from their invoice numbers and format the names with the last name first.
Modify the data on the Summary
worksheet as follows:
a. Enter the text Foley, Dean
in cell D5.
b. Select the range D5:D22, and then use the Flash Fill command to automatically enter names into the remaining cells in the range. (
Hint
: You must use the Flash Fill command to receive credit for this step.)
c. Enter the invoice number 2101
in cell B5.
d. Select the range B5:B22, and then use the Flash Fill command to automatically enter invoice numbers into the remaining cells in the range. (
Hint
: You must use the Flash Fill command to receive credit for this step.)
e. Delete column C, which is no longer necessary.
Go to the Projections
worksheet, which includes the income and expenses for the current year. Darius also wants to include projections for next year. First, he asks you to correct the error on the worksheet.
Trace the error in cell F17, which divides the net profit in cell F16 by the total income in cell F5. The formula is correct, but cell F5 needs a value to prevent the error. Correct the error as follows:
a. In cell F17, add the IFERROR
function to the formula.
b. If dividing the net profit (cell F16
) by the total income (cell F5
) results in an error, display "Missing total"
as an error message.
c. Copy the formula in cell F17 to the range B17:E17.
d. In cell F5, enter a formula using the SUM
function to total the Q1–Q4 income amounts (range B5:E5
).
Darius thinks the Tampa and Orlando offices have a good chance of increasing income in the next year. In the range B21:E23, he wants to make three projections based on different assumptions.
Project the quarterly income for Darius as follows:
a. First, determine the income needed in Quarters 2 and 3 to achieve an income of $7,500 in Quarter 4. Project the income in the four quarters by filling the series for the first projection (range B21:E21) with a linear trend.
b. Next, determine the income in Q2–Q4 if it increases by 2 percent each quarter, starting with an income of $6,300.
Project the income in the four quarters by filling the series for the second projection (range B22:E22) based on a growth trend using 1.02
as the step value.
c. Finally, extrapolate the income based on the income in Q4 of the current year and a growth rate of 3 percent.
In cell B23, enter a formula without using a function to reference the total income in Q4 of the current year (cell E5
). Project the income in the four quarters by filling the series for the third projection (range B23:E23) based on a growth trend using 1.03
as the step value.
Darius has prepared the range H1:M17 for detailed projections to complete later. For now, he asks you to enter the expense categories, which he will use in other workbooks.
Build a custom list of categories as follows:
a. Create a custom list by importing the range A4:A17
. b. Enter the text Income
in cell H4, and then use the new AutoList to fill cells H5:H17.
SmartEnergy Services is considering expanding the business to add a third Florida office. Darius asks you to help with the analysis of loan options to fund the expansion.
Go to the Expansion
worksheet, and then create defined names based on the range A5:B10
, using the values in the left column only.
Calculate the monthly payment for Scenario 1 as follows: a. In cell B9, enter a formula using the PMT
function to determine the monthly payment. b. In the formula, use the monthly interest rate (cell B7
) as the rate, the term in months (cell B8
) as the nper, and the loan amount (cell B5
) as the pv. In Scenario 2, Darius wants to make a monthly payment of $13,800 at an annual interest rate of 4.15 percent. He wants to know how much he can borrow on those terms.
Calculate the loan amount for Darius as follows:
a. In cell C5, enter a formula using the PV
function to determine the loan amount.
b. In the formula, use the monthly interest rate (cell C7
) as the rate, the term in months (cell C8
) as the nper, and the monthly payment (cell C9
) as the pmt.
In Scenario 3, Darius wants to know the total amount spent for a loan of $750,000 at an annual interest rate of 3.95 percent and a monthly payment of $15,000. Calculate the future value of the loan for Darius as follows: a. In cell D10, enter a formula using the FV
function to determine the future value.
b. In the formula, use the monthly interest rate (cell D7
) as the rate, the term in months (cell D8
) as the nper, and the monthly payment (cell D9
) as the pmt.
Illustrated Excel 365/2021 | Module 11: SAM Project 1a
Author:
Note
Illustrate
SmartEnergy Services
ANALYZE DATA AND CORRECT FORMULAS
Zachary Sutton
e: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the
ed Excel 365/2021 | Module 11: SAM Project 1a
SmartEnergy Services
Service Agreements - Quarter 1
2/15/2024
87.15%
Contact Name
Sale Price
Dean Foley
2101
1/5/2024
101
1/4/2025
$588.00
$512.44
Rafael Nunez
2557
1/7/2024
104
1/6/2025
$819.00
$713.76
Ahmad Farrah
2254
1/9/2024
104
1/8/2025
$819.00
$713.76
Charlene Ingersoll
2479
2/1/2024
103
1/31/2025
$395.00
$344.24
Lei Song
2086
2/8/2024
102
2/7/2025
$735.00
$640.55
Greg Spahn
2699
3/1/2024
101
3/1/2025
$588.00
$588.00
Ron Remish
2158
3/10/2024
101
3/10/2025
$588.00
$588.00
Kerry Johnson
2265
3/17/2024
104
3/17/2025
$819.00
$819.00
Brianna Gaines
2077
3/21/2024
104
3/21/2025
$819.00
$819.00
Totals
$6,170.00
$5,738.75
Service Agreement Statistics
Substations
Number 4
Average Sale Price
$766.38
Total Sale Price
$3,065.52
Profit Margin
5%
Discount offered for purchases before:
Sale price rate:
Invoice Number
Contract Date
Equipment Code
Expiration Date
Standard Price
Code
Equipment
101
Meters
102
Poles
103
Wires
104
Substations
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
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit.
Remaining Time: 37 minutes, 25 seconds.
* Question Completion Status:
QUESTION 1
When each argument in a function consists of a variable name and a value, we use
arguments.
Default Values
Keyword
Ob.
positional
Oc.
Argument
Od.
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Save
W
DELL
F5
F6
F7
FB
F9
F10
F11
F12
PrtScr
arrow_forward
Select the best answers. The following are all cmdlet/alias/function for viewing the help files of cmdlets, except:
Group of answer choices
MAN
Get-Help
Help
All of the above
arrow_forward
M Gmail
O YouTube
A Maps
S Translate
Create a function named "area" that allows the user to calculate the area of a Rectangle, a Disk
or a Triangle, as shown in the following Python Shell screenshot. Write a main code that keeps
calling the function upon user's approval.
You need to upload your Python file.
Write your own code, cheating will result in a zero grade.
Choose 1: Rectangle, 2: Disk, 3: Triangle: 1
enter height: 4
enter width: 3
Area =
12
do you want to try again? (y/n): y
Choose 1: Rectangle, 2: Disk, 3: Triangle: 2
enter radius: 4
Area =
50.26548245743669
do you want to try again? (y/n): y
Choose 1: Rectangle, 2: Disk, 3: Triangle: 3
enter base: 5
enter perpendicular height: 4
Area =
10.0
do you want to try again? (y/n): n
>>>
Do loft 1-14:06
arrow_forward
Create a webpage that works similar to a Calculator, with the following tasks and the appropriate points:
-Create a webpage that uses JavaScript, similar to a CALCULATOR, either within the HTML page itself or a pop-up window.
-Ask user for the mathematical operation to be performed. You may create your own functions and appropriate conditional statement to facilitate program flow.
-Ask user for two (2) numbers.
-Show result to the user and terminate the program.
arrow_forward
Please, remember to participate in this discussion; post at least once, and respond
to at least two other posts. Do not forget to provide references to support your
posts.
Discuss how to create and invoke a function that returns a value and
passes information by value to a function.
2
arrow_forward
5
DO NOT COPY FROM OTHER WEBSITES
Correct and detailed answer will be Upvoted else downvoted. Thank you!
arrow_forward
WebConnect 3270
Sphinx of Hatsheps...
- Question Completion Status:
Based on this information, complete the code for numbered region 3.
QUESTION 10
("Enter a number:"))
Fill each of the numbered areas so that the code you create asks the user to enter a whole number using the keyboard and
store that number into variable x.
QUESTION 11
if(x<0 or x10):
print("Invalid number! ")
The piece of code above checks whether x is between 0 and 10, If not it prints a text.
Click
arrow_forward
Question - khn.Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
arrow_forward
Using PHP script, create a program that converts decimal into binary, octal, hexadecimal using "functions and arrays". Run the program in any internet browser, user will enter decimal value and will output the binary, octal and hexadecimal of the decimal value.
Reminder: Do not use built in functions for the conversion.
arrow_forward
Hi! I am having trouble with this problem: A personal phone directory contains room for first names and phone numbers for 30 people. Assign names and phone numbers for the first 10 people. Prompt the user for a name, and if the name is found in the list, display the corresponding phone number. If the name is not found in the list, prompt the user for a phone number, and add the new name and phone number to the list. Continue to prompt the user for names until the user enters quit. After the arrays are full (containing 30 names), do not allow the user to add new entries. Save the file as PhoneNumbers.java. Note: Use parallel String arrays to store the names and numbers.)
My code is on the photos.
I need help converting my strings into parallel arrays, as I overlooked that detail when originally doing this. My previous attempts have not worked. Any help would be greatly appreciated!
arrow_forward
please solve all i can't post any more??.
arrow_forward
This task involves creating two scripts, one for each part!
TASK 1
1. Create a Python module named module.py.
2. This module must define four functions:
a. add(a, b)
b. subtract(a, b)
c. multiply(a, b)
d. divide(a, b)
e. Divide must check for division by zero and return an error message if it encounters it.
3. Each function should take two arguments and perform the corresponding mathematical operation. Return the result, don’t print it in the function.
4. Include a main() function that tests these functions with some example inputs. Ensure that you print the results of the function calls here in the main function and provide the appropriate labels.
5. The main() function must only run automatically if the module is being run directly, not when imported.
TASK 2
6. Create another Python script named in the same directory as module.py.
7. This new script must import the module you created in Part 1 of this task.
a. Tip: You import the module with import…
arrow_forward
True/False
store the appropriate boolean in the variable provided
for each of the following statements:
• function_names | basetball_game is a better function name than BasketballGame
• pwd | pwd is a shell command that prints your current working directory
cd | cd is a shell command that lists the files in your current working directory
• relative_paths | relative paths specify location relative to the computer's root directory
script | To execute a script my_script.py from a Jupyter Notebook in the same directory,
the cell would contain !python my_script. py
module | To import a module my_module.py from a Jupyter Notebook in the same directory,
the cell would contain import my_module.py
N # YOUR CODE HERE
I assert function_names is not None
I assert pwd is not None
I assert cd is not None
I assert relative_paths is not None
I assert script is not None
I assert module is not None
arrow_forward
Write a webpage that will do the following:
1) Prompt the user to provide two numbers, take the
input from the user
2) Write a function that will find a return the maximum
of these two numbers
3) Write a function that will display the result of your
calculations in 2)
4) Call only one of the functions, so that both functions
are triggered (but 1 function called another function -
Callback).
arrow_forward
Using C# and Windows Presentation Foundation (WPF), design and implement a standalonedesktop time management application that fulfils the following requirements:1. The user must be able to add multiple modules for the semester. The following data mustbe stored for each module:a. Code, for example, PROG6212b. Name, for example, Programming 2Bc. Number of credits, for example, 15d. Class hours per week, for example, 52. The user must be able to enter the number of weeks in the semester.3. The user must be able to enter a start date for the first week of the semester
The software shall display a list of the modules with the number of hours of self‐study thatis required for each module per week. The number shall be calculated as follows:self-study hours per week?number of credits ? 10number of weeks? class hours per week5. The user must be able to record the number of hours they spend working on a specificmodule on a certain date.6. The software shall display how many hours of self‐study…
arrow_forward
Using C# and Windows Presentation Foundation (WPF), design and implement a standalonedesktop time management application that fulfils the following requirements:1. The user must be able to add multiple modules for the semester. The following data mustbe stored for each module:a. Code, for example, PROG6212b. Name, for example, Programming 2Bc. Number of credits, for example, 15d. Class hours per week, for example, 52. The user must be able to enter the number of weeks in the semester.3. The user must be able to enter a start date for the first week of the semester
4. The software shall display a list of the modules with the number of hours of self‐study thatis required for each module per week. The number shall be calculated as follows:self-study hours per weekൌ number of credits ൈ 10number of weeks െ class hours per week5. The user must be able to record the number of hours they spend working on a specificmodule on a certain date.6. The software shall display how many hours of…
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
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'")
The blue image is an example of how the code should look. The map image is the map your code should…
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.
arrow_forward
Write this using a java script function and test with a mocha or postman to see if it passes the test
arrow_forward
Create a COVID-19 support service application using Python namedCovidSupportSystem that will provide the user with the below options:• Statistics,• Prevention,• Symptoms,• Treatment and Report case
1.1 Under Statistics state how many cases there are in South Africa, China and USA, then askthe user if they would like to see the cases for a different country, if yes, askthem to pick a number between 0 and 9, then pull a country from a list to show
arrow_forward
Write this using a java script function and test with a mocha or postman to see if it passes the test
arrow_forward
Write an interactive program that gives you the option to generate one of the turtle graphics images. The program should prompt the user for a value between 1 and 5 and generate a corresponding turtle graphics image. If the user enters Q or q the program should terminate. If the user enters anything else appropriate error messages should be displayed.
arrow_forward
can u create a javascript file as the instructions in the image please? thank you so much!
arrow_forward
You have more flexibility to implement your own function names and logic in these programs.
The data files you need for this assignment can obtained from:Right-click and "Save Link As..."
HUGO_genes.txt (Links to an external site.)
chr21_genes.txt (Links to an external site.)
Create an output directory inside your assignment4 directory called "OUTPUT" for result files, so that they will not mix with your programs. Output from your programs will be here!
Your program must implement command line options for the infiles it must open, but for testing purposes it should run by default, so if no command line option is passed at the command line, the program will still run. This will help in the grading of your program.
Create a Python Module called called my_io.py - You can use the same code from assignment 3's solution. Put this my_io.py Module in a subdirectory named assignment4 inside your assignment4 top-level directory (see the tree below, and see Lecture 7 on how to implement a…
arrow_forward
You have more flexibility to implement your own function names and logic in these programs.
The data files you need for this assignment can obtained from:Right-click and "Save Link As..."
HUGO_genes.txt (Links to an external site.)
chr21_genes.txt (Links to an external site.)
Create an output directory inside your assignment4 directory called "OUTPUT" for result files, so that they will not mix with your programs. Output from your programs will be here!
Your program must implement command line options for the infiles it must open, but for testing purposes it should run by default, so if no command line option is passed at the command line, the program will still run. This will help in the grading of your program.
Create a Python Module called called my_io.py - You can use the same code from assignment 3's solution. Put this my_io.py Module in a subdirectory named assignment4 inside your assignment4 top-level directory (see the tree below, and see Lecture 7 on how to implement a…
arrow_forward
Q1/ Great a script file solve the following system of three linear equations:
z - 3x + y + 2 = 0
y + 2x + z – 1 = 2
x – 2y +1 = z +1
a) By using the matrix inverse.
b) By using the backslash operator
c) Check the result
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
"In PHP, reusable code can be inserted into every module using which function?"
O include()
30000
O call()
O copy()
O insert()
QUESTION 12
"Is software development testing phase, the first test is done by a developer after changing code or creating new code. What do you call this phase of testing?"
O Development test
booo
O Unit test
O System test
O Integration test
QUESTION 13
"In PHP, if an exception is not caught, a fatal error will be issued with a(n)
O Not found
O System
O Uncaught Exception
O Error
message."
QUESTION 14
Which PHP function replaces some characters with some other characters in a string or arrays?
O find_replace()
Ostr_replace()
O changestr()
O replace()
arrow_forward
This is the program i have been given.
I have to change it to meet the following criteria but can only change the body of the show_flashcard function
# IMPORTANT# Q2 (a)(iii) Make changes only to# -- the docstring for the program as a whole.# -- the docstring of the show_flashcard() function# -- the body of the show_flashcard() function.
def show_flashcard(): """ Show the user a random key and ask them to define it. Show the definition when the user presses return. """ random_key = choice(list(word_list)) print('Define: ', random_key) input('Press return to see the definition') print(word_list[random_key])
# Set up the word_list
word_list = {'black':'noir', 'red':'rouge', 'yellow':'jaune', 'orange':'orange', 'white':'blanc', 'green':'vert'}
# The interactive loop
exit = Falsewhile not exit: user_input = input('Enter s to show a flashcard and q to quit: ') if user_input == 'q':…
arrow_forward
Write this using a java script function and test with a mocha or postman to see if it passes the test
arrow_forward
Sin with Drawline
Call the file: sinDrawline.cpp
Create 2 functions:
1) Degrees2Radians: which has input Degrees, and returns Radians
2) Drawline: which takes two parameters: a character and numRepetitions and prints the character numRepetitions times, followed by a newline
Inside main()
For values between 0 and 360, in 5 degree increments:
calculate and print the value of sin (degrees),
After every 90 degrees, print out a line of 30 dashes (minus signs '-')
Extra information required:
#include <cmath> // for sin function
In order to have the precise format we want:
Put this at the top of main:
cout.setf(ios::fixed);
cout.setf(ios::showpoint); // show decimals even if not needed
cout.precision(5); // show 5 digits to right of decimal
Output is supposed to be (answer) ;
sin(0) = 0.00000
------------------------------
sin(5) = 0.08716
sin(10) = 0.17365
sin(15) = 0.25882
sin(20) = 0.34202
sin(25) = 0.42262…
arrow_forward
1
DO NOT COPY FROM OTHER WEBSITES
Correct and detailed answer will be Upvoted else downvoted. Thank you
arrow_forward
USING PYTHON: Create a function that takes a filename("string") of a PGM image file as input and loads in the image in the file, and returns it as an image matrix.
Rules: Cannot make any input calls in the main body, use basic python (nothing like .shape or .width)
I have attached an example of what the function should do, as well as what the PGM image file looks like.
arrow_forward
Programming in c language
arrow_forward
Q1}A- For the following Polynomials p₁(x)=2x²-x+1, p₂(x)=x²-X.
Write the mat lab command to find 1.the zeros, 2.integation, 3.multiplaction and division
4.value of p₁ at (4),5.drevision
B- Write function program to find the value of x. where x= a-b/n! + a/b*m!.
arrow_forward
3
DO NOT COPY FROM OTHER WEBSITES
Correct and detailed answer will be Upvoted else downvoted. Thank you!
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
- Multiple Attempts Not allowed. This test can only be taken once. Force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit. Remaining Time: 37 minutes, 25 seconds. * Question Completion Status: QUESTION 1 When each argument in a function consists of a variable name and a value, we use arguments. Default Values Keyword Ob. positional Oc. Argument Od. Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save W DELL F5 F6 F7 FB F9 F10 F11 F12 PrtScrarrow_forwardSelect the best answers. The following are all cmdlet/alias/function for viewing the help files of cmdlets, except: Group of answer choices MAN Get-Help Help All of the abovearrow_forwardM Gmail O YouTube A Maps S Translate Create a function named "area" that allows the user to calculate the area of a Rectangle, a Disk or a Triangle, as shown in the following Python Shell screenshot. Write a main code that keeps calling the function upon user's approval. You need to upload your Python file. Write your own code, cheating will result in a zero grade. Choose 1: Rectangle, 2: Disk, 3: Triangle: 1 enter height: 4 enter width: 3 Area = 12 do you want to try again? (y/n): y Choose 1: Rectangle, 2: Disk, 3: Triangle: 2 enter radius: 4 Area = 50.26548245743669 do you want to try again? (y/n): y Choose 1: Rectangle, 2: Disk, 3: Triangle: 3 enter base: 5 enter perpendicular height: 4 Area = 10.0 do you want to try again? (y/n): n >>> Do loft 1-14:06arrow_forward
- Create a webpage that works similar to a Calculator, with the following tasks and the appropriate points: -Create a webpage that uses JavaScript, similar to a CALCULATOR, either within the HTML page itself or a pop-up window. -Ask user for the mathematical operation to be performed. You may create your own functions and appropriate conditional statement to facilitate program flow. -Ask user for two (2) numbers. -Show result to the user and terminate the program.arrow_forwardPlease, remember to participate in this discussion; post at least once, and respond to at least two other posts. Do not forget to provide references to support your posts. Discuss how to create and invoke a function that returns a value and passes information by value to a function. 2arrow_forward5 DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Thank you!arrow_forward
- WebConnect 3270 Sphinx of Hatsheps... - Question Completion Status: Based on this information, complete the code for numbered region 3. QUESTION 10 ("Enter a number:")) Fill each of the numbered areas so that the code you create asks the user to enter a whole number using the keyboard and store that number into variable x. QUESTION 11 if(x<0 or x10): print("Invalid number! ") The piece of code above checks whether x is between 0 and 10, If not it prints a text. Clickarrow_forwardQuestion - khn.Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this linearrow_forwardUsing PHP script, create a program that converts decimal into binary, octal, hexadecimal using "functions and arrays". Run the program in any internet browser, user will enter decimal value and will output the binary, octal and hexadecimal of the decimal value. Reminder: Do not use built in functions for the conversion.arrow_forward
- Hi! I am having trouble with this problem: A personal phone directory contains room for first names and phone numbers for 30 people. Assign names and phone numbers for the first 10 people. Prompt the user for a name, and if the name is found in the list, display the corresponding phone number. If the name is not found in the list, prompt the user for a phone number, and add the new name and phone number to the list. Continue to prompt the user for names until the user enters quit. After the arrays are full (containing 30 names), do not allow the user to add new entries. Save the file as PhoneNumbers.java. Note: Use parallel String arrays to store the names and numbers.) My code is on the photos. I need help converting my strings into parallel arrays, as I overlooked that detail when originally doing this. My previous attempts have not worked. Any help would be greatly appreciated!arrow_forwardplease solve all i can't post any more??.arrow_forwardThis task involves creating two scripts, one for each part! TASK 1 1. Create a Python module named module.py. 2. This module must define four functions: a. add(a, b) b. subtract(a, b) c. multiply(a, b) d. divide(a, b) e. Divide must check for division by zero and return an error message if it encounters it. 3. Each function should take two arguments and perform the corresponding mathematical operation. Return the result, don’t print it in the function. 4. Include a main() function that tests these functions with some example inputs. Ensure that you print the results of the function calls here in the main function and provide the appropriate labels. 5. The main() function must only run automatically if the module is being run directly, not when imported. TASK 2 6. Create another Python script named in the same directory as module.py. 7. This new script must import the module you created in Part 1 of this task. a. Tip: You import the module with import…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