Solution :
Step 1:
Open the excel exploring_e07_grader_h1_Apartment.xlsx and save it as exploring_e07_grader_h1_Apartment_LastFirst.
Step 2:
At cell G8 in the Summary worksheet, insert the date function to the number of Years since remodel:
Compute the difference between the years 1/1/2018 value in the cell H2 and the Last remodel date present in cell F8 which returns the number of days.
Then, divide the resultant by 365 days to get the answer in the form of years.
The formula to compute the number of years since remodel at cell G8 is,
=($H$2 - F8)/365.25
Copy the function used in the cell G8 to the cells G9:G57.
Step 3:
At cell H8 in the Summary worksheet, insert the function to compute the pet deposit.
Condition to check is whether the number of rooms that is at Cell C8 is greater than or equal to 2 and it is remodel less than 10 years ago.
If the condition is true, then pet deposit cost is $275 present at cell H4.
Otherwise the pet deposit cost is $200 present at cell H5.
So, the formula to apply at cell H8 is,
=IF(AND(C8>=2, G8<$H$3), $H$4, $H$5)
Step 4:
At cell I8 in the Summary worksheet, insert the function to display Need to Remodel:
Condition to check is whether the apartment is unoccupied depending on the cell E8(“Yes” or “No”) and last remodeled that is cell G8 is greater than 10 years (cell H3).
If the condition is true, then display as “No Change”.
Otherwise display as “Need to Remodel”.
So, the formula to apply at Cell I8 is,
=IF(_AND(_E8="No", G8>$H$3), "Need to Remodel", "No Change")
Step 5:
Copy the functions used in the cells H8:I8 to the cell range H9:I57.
Step 6:
At cell B3, to display the rental price:
By using Index function look up for the rental price present in Column D and check for the match of cell B2 with respective the Column Range A8:A57.
Syntax for INDEX function is:
=INDEX(Array, Row number, Column number)
Syntax for MATCH function is:
=MATCH(Loop up, Loop up array, Match type)
So, the function to be inserted at cell B3 is,
=INDEX($D$8:$D$57, MATCH(B2, $A$8:$A$57,0))
What is the primary purpose of the destination address?
Choose 1 answer:
It helps the router know where to send the packet.
B
It helps the receiving computer reassemble the packets.
It tells the router where the packet came from.
D
It helps the sending computer know how long to wait before retrying.
It prevents the packet from being intercepted by cybercriminals.
Answer:
The answer to this question is given below is the explanation section.
Explanation:
"A" option is correct
It helps the router know where to send the packet.
There is a new security patch for the operating system on your personal computer. You are worried that the patch will stop your computer from working efficiently. What should you do?
Answer:
There is a new security patch for the operating system on your personal computer and the process that make it work efficiently is discussed below in details.
Explanation:
Patching is a method to restore a vulnerability or a defect that is recognized after the release of an application or software. Newly published patches can fix a virus or a security defect can assist to improve applications with new characteristics, fix a security vulnerability. Software updates are necessary because they usually incorporate critical patches to safety holes.
1. Very short questions.(any four) 14)
a. Write down the working principle of a computer.
Answer:
The answer is below
Explanation:
Computer System is widely known for its ability to perform its functions faster by giving out information.
The computer system operation follows certain principles, some of which are:
1. It makes use of the OPERATING SYSTEM to link the hardware and the software together, without it, the computer system is useless.
2. It works with INPUT DEVICES such as keyboards or stylus. Without input devices, there is no way humans can communicate with the computer system
3. It works with OUTPUT DEVICES such as monitors and speakers. Without output devices, there is no way computers can communicate or give back information to humans.
4. It works with the NETWORK such as LAN or WIFI to provides the sharing of data files to other users or computers. Without the network, the computer system can only work within certain spaces, with no way to share data or files with others far away.
Match the term to the following definition. The exclusive legal right to
print, publish, perform, film, or record literary, artistic, or musical material,
and to authorize others to do the same?*
O Miranda Rights
O Coding
O Digital Footprint
O Copyright
---------------------- use of the Internet to access programs and data on computers that are not owned and managed by the user often using large data centers
Answer:
Cloud computing
Explanation:
Cloud computing is an information technology term that describes the process of using and applying online or internet services to access, and store data, including networking databases, and other data on computers.
It generally involves saving and accessing personal data and files created online (usually large data centers) without necessarily saving it on the PC hard drive.
Hence, in this case, thé correct answer is "Cloud Computing."
Discuss the factors which cause imbalance in the environment.
Explanation:
Several factors cause imbalances in our environment today. Some of the main factors include;
pollutiondeforestationglobal warmingPollution: This occurs in various forms; either in the form of air pollution arising from the disposal of harmful chemical substances into our atmosphere, water pollution which reduces the amount of safe drinking water animals and humans need for survival, and soil pollution.
Deforestation: this is the deliberate removal of trees from our environment. Trees are vital for providing the sufficient amount of oxygen needed for our survival. Sadly, as the tree population is reduced, it causes imbalances in the environment; as there were would insufficient fresh air.
Global warming: this is a rapid change in the temperature of our planet. For some areas, it is rising temperatures, while for others, it is falling temperatures. In either case, they cause weather imbalances in the environment.
Which comparison operator is valid for greater than or equal to?
>
>=
=>
What will you see on the next line?
>>>myList = [5, 6, 10, 6, 32]
>>> myList.remove(6)
>>> myList
Answer:
[5, 10, 6, 32]
Explanation:
What myList.remove(6) will do is remove the first 6 it will encounter. It will cycle through the list like the following:
5 != 6 next element
6 = 6 remove
hope i helped :D
Answer: 5, 10, 6, 32
Explanation: got it right on edgen
........ manages the function of all the hardware and other software used in the computer.
Answer:
The answer to this question is given below is in the explanation section.
Explanation:
manages the function of all the hardware and other software used in the computer:
operating system is defined as a system software that manages computer hardware and software resources and provide common services for computers programs.All application software computer programs requires an operation system to function. operating system controls computer hardware run the computer programs and organize file.
CPU:
central processing unit that bring the instruction from memory to be executed and decodes.
Storing device:
Any hardware that can hold information temporarily and permanently. we distinguish two type of storage: as primary storage device and a secondary storage device.
Example:
Magnetic storage device:hard drive,floppy diskette etc.optical: Blu-ray disc,CD Rom disc.Flash memory device:memory card memory sick,ssd
Hardware:
Hardware include the physical features,which are every part that you can either see or touch, for example monitor,case,keyboard,mouse and printer.
Software:
The part which activate the physical components called software. it includes the features that resposible for directing the work to the hardware.
For a custom App uploaded to Microsoft Teams, if an organization wants to disallow users from updating the settings of the custom tab, which attribute name must be set to false in the manifest file
Answer:
canUpdateConfiguration
Explanation:
The user experience con be refined by enabling users to rename, modify, reconfigure, a channel or group tab by setting as true the property of the canUpdateConfiguration manifest file attribute
In the app, what takes place with regards to the content following the event of a tab removal can be specified by the inclusion of a removal options page and have a value set for the setSettings() configuration removeUrl property.
The attribute name which must be set to "false" i the manifest file to prevent users from updating the settings of the custom tab is:
canUpdateConfiguration
When a custom App which was uploaded to Microsoft Teams and an organization wants to prevent users from changing the settings in the custom tab, then they would have to lock it from the canUpdateConfiguration manifest.
What this does is restrict user access from changing the settings of the custom tab and if this wants to be reversed, then the value of the attribute name would be changed to true, because it is a Boolean function.
Read more about custom tab here:
https://brainly.com/question/18761530
Determining Correct Date Function What function text would you use to put today's date and time in a cell? 0 =TODAYO =NOWO O NOWO) O TODAYO
The function text that would you use to put today's date and time in a cell is B. =NOW()
What is a Time and Date Function?This refers to the command that is given to a computer in order for it to render the correct time and date in a given cell.
Hence, we can see that from the answer choices, the best one that factors in both TIME AND DATE is =NOW() which is option B while option A is for the function that shows only the current date.
Read more about date functions here:
https://brainly.com/question/19416819
#SPJ1
The letters after the name of a file indicate who created the file.
O True
O False
You are writing a program using the Java language. Which of the following is a requirement of Java syntax?
Each statement must use sentence case.
Each statement must use the name of the program.
Each statement must begin with an operator symbol.
Each statement needs to end in a semicolon.
Answer:
The answer to this question is given below in the explanation section.
Explanation:
"D" option is correct
"Each statement needs to end in a semicolon."
semicolon must use in program.without semicolon program doesn't accept.so each statement needs to end in a semicolon.
ou want to configure the NTP daemon to receive time from pool.ntp.org. What entry should you place in the /etc/ntp.conf file?
Answer:
server pool.ntp.org
Explanation:
Use the drop-down menu to complete the steps for editing a conditional formatting rule.
On the ___ tab, click the ___ group. On the Styles drop-down list, click ______. In the dialog box, select the rule, and click ________. Make the changes to the rule and click ok.
Answer:
The answer to this question is given below in the explanation section.
Explanation:
In excel you can formate excel sheet/column/row based on some condition.
you can specifiy these conditions while working on an excel sheet. It will help you to highlight certain information in the excel sheet.
Basically, you can use the rules to specify certain conditions, and based on that condition result, the cell/column or row gets highlighted with a certain color format, etc. However, you can create a new rule and modify the existing rules also.
As in the given question, you can implement this by going through the following steps.
On the Home tab, click the Conditional Formatting group. On the Styles drop-down list, click Manage Rules. In the dialog box, select the rule, and click Edit. Make the changes to the rule and click ok.
Answer:
home
styles
conditional formatting
manage rules
Explanation:
Which of the following is an example of a sales promotion?
Answer:
bird power bird power bird power
Explanation:
cause ik
Smart art can be used to create that highlight relationships between two items
Answer:
The answer to this question is given below in this explanation section.
Explanation:
A smart Art graphic is a visual representation of your information and ideas.you create one by choosing a layout this fits your message.Some layouts specific kind of information,while other simply enhance the appearance of a bulleted list.
You can create a smart graphic in excel power point,word,or in an email message in outlook.The smart button is one the insert tab and developing on your screen size,may look like.
Other office program do not allow for smart art art graphic creation,but you can copy and paste smart graphics as image into those programs.As part of this process,when you are prompted to choose a type such as process hierarchy,or relationship.A type is similar to a category of smart art graphic,and each type contains several different layouts.
Because you can quickly and easily switch layouts,try different layouts until you find the one that best illustrate your message.
is "b" the answer here?
What is the scope of leftCharacter?
def rhyme(word):
leftCharacter = word[0]
if leftCharacter != 'd':
return 'd' + word[1:]
else:
return 'f' + word[1:]
def poem():
print("Enter Q to quit.")
userWord = input("Enter a word: ")
while userWord != 'Q' and userWord != 'q':
rhymeWord = rhyme(userWord)
print(rhymeWord)
userWord = input("Enter a word: ")
# the main part of your program that calls the function
poem()
the entire program
rhyme
poem
the main part of your program that calls the function
Answer:
Rhymeword
Explanation:
edge 2020
Answer:
The scope of leftCharacter is rhyme. I hope this helps you out. Have a wonderful and safe day. <3<3<3
Explanation:
what are the advantages of using ICT jn our society?
Answer:
Communication - Speed / time – money can be saved because it's much quicker to move information around. With the help of ICT it has become quicker and more efficient. 2. Globalization - Video conferencing saves money on flights and accommodation.
Explanation:
hope this helped
Answer:
ICT has made global social and cultural interaction very easy. We now live in an interdependent global society, where people can interact and communicate swiftly and efficiently. News and information can now be transmitted in minutes. Individuals can easily stay in contact with members of their families who reside in other countries or make new friends across the world.
What can make an online interface difficult to use?
Answer:
their is a lot miscomsuptions
Explanation:
The difficulty experienced by online interface users simply arises from the design principles associated with the structure of the interface.
The design of an online interface is best kept as simple as possible rather than a complicated user interface which becomes very difficult to navigate. Another problem associated with design the use of overlapping textures or structures which often makes the user interface a whole lot more complicated.Hence, the difficulty arising from using an online interface stems from the design.
Learn more : https://brainly.com/question/19117781
Randomly choose rock, paper, or scissors for the computer
Ask the user to choose rock, paper, or scissors
Compare the computer’s choice to the player’s choice
Announce whether the computer or the human won
( In python.)
import random
computer_choice = random.choice(["rock", "paper", "scissors"])
user_choice = input("rock, paper, or scissors? ")
if computer_choice == user_choice:
print("It's a draw!")
elif user_choice == "rock" and computer_choice == "scissors":
print("You win!")
elif user_choice == "paper" and computer_choice == "rock":
print("You win!")
elif user_choice == "scissors" and computer_choice == "paper":
print("You win!")
else:
print("The computer wins!")
I wrote my code in python 3.8. I hope this helps.
An online game is played with two dice. In this context, explain what is meant by decomposition.
Answer:
The answer to this question is given below in the explanation section.
Explanation:
This question is about desinging a game that is played with two dice and gets or shows their value to the player.
The dice value is random, and it can be between one and six. So, you need to generate two numbers between 1 and 6. You may also need to display the numbers
The main part of this program is that you need to know the numbers to limit or restrict what the user may do next while playing.
That's most of the first level of decomposition for solving a problem. In decomposition, you need to keep decomposing (breaking) the problem into smaller pieces, thinking outline of the program and deciding what objects, functions, variables, and logic you're going to implement in the coding.
You areYou are a member of the application development organization for a small but rapidly growing software company that produces patient billing applications for doctors' offices. During work on the next release of your firm's first and only software product, you discover a small programming glitch in the current release that could pose a security risk to users. The probability of the problem being discovered is ɔw, but, if it is exposed, the potential impact on your firm's 100 or so customers could be substantial: Hackers could access private patient data and change billing records. The problem will be corrected in the next release, scheduled to come out in three months, but you are concerned about what should be done for the users of the current release. The problem has come at the worst possible time. The firm is currently seeking approval for a $10 million loan to raise enough cash to continue operations until revenue from the sales of its just
Answer:
Following are the solution to this question:
Explanation:
Please find the complete question in the attached file.
It will obtain as much information about this matter as necessary even before the conference. It includes its gravity or probability of risk, various cases in the entire event, the possible solutions to the issues, as well as the consequences for parties involved in each potential answer, and Only at conferences, it may clarify to my boss that the explanation for the problem and also in details. It will be doing everything possible and try not to conceal the details but highlight the problem.
What do you mean by computer. Write it use
A computer is a machine that can be instructed to carry out sequences of arithmetic or logical operations automatically via computer programming. Modern computers have the ability to follow generalized sets of operations, called programs. These programs enable computers to perform an extremely wide range of tasks
python exercise grade 10
Write a program that displays a number with its digit reversed. Generalize the program so that
the number can be one, two, or three digits. The program stops when users enters 0
Enter a number: 123
The reversed digit is: 321
Enter a number: 1
The reversed digit is: 1
Enter a number: 34
The reversed digit is: 43
Enter a number: 0
while True:
num = int(input("Enter a number: "))
if num == 0:
break
first = num // 100
second = (num // 10) - (first * 10)
third = (num - (first * 100)) - (second * 10)
reversed_digit = (third * 100) + (second * 10) + first
if 9 < num < 100:
reversed_digit = reversed_digit // 10
elif num < 10:
reversed_digit = reversed_digit//100
print("The reversed digit is:",reversed_digit)
I wrote my code in python 3.8. I hope this helps.
Complete the sentence to state a fact about procedural programming.
Another name for procedural programming Is
Answer:
Procedural programming is also referred to as imperative programming. Procedural programming languages are also known as top-down languages.
Answer:
imperative programming
Explanation:
Match the terms with the appropriate definition.
software used to type, edit, format,
1. CAD
and print text
software used to make calculations
2. spreadsheet
software used to create technical
3. word processor
drawings
software used to create a slide
4. presentation software
show
software that organizes a collection
5. database
of information
Answer:
GPS
Global Positioning System or a receiver that transmits precise location, direction, local time and speed by use of a system of satellites
image-editing software
also known as graphics software, this software enables a person to change or create visual images on a computer
Portable Document Format used to send documents electronically
presentation software
software that allows you to create slide show presentations
Explanation:
Image-editing software - software used to enhance photographs
word processor - software used to type, edit, save, and print text
presentation software - software used to create a slideshow
spreadsheet - software used to make calculations
database - software that organizes a collection of information
Why is local hosting not suitable for a public website?
Answer:
Because its only available to the host
Explanation:
python exercise grade 10
Write a program that finds the largest in a series of numbers entered by the user. The program
must prompt the user to enter numbers one by one. When the user enters 0 or a negative
number, the program must display the largest nonnegative number entered:
Enter a number: 60
Enter a number: 38.3
Enter a number: 4.89
Enter a number: 100.62
Enter a number: 75.2295
Enter a number: 0
The largest number entered was 100.62
Notice that the numbers aren’t necessarily integers
nums = []
while True:
num = float(input("Enter a number: "))
if num <= 0:
break
nums.append(num)
print("The largest number entered was",max(nums))
I wrote my code in python 3.8. I hope this helps.