why absolute reference is used in spreadsheet

Answers

Answer 1
Answer:

Absolute reference is used especially to keep the value or content of a column or row constant.

Explanation:

Cell referencing is one common and important concept in spreadsheets. A cell reference or cell address is a value, mostly alphanumeric, used to identify a specific cell or cell range in a worksheet.

In spreadsheets such as that of Microsoft - excel - there are basically two types of referencing.

i. relative referencing

ii. absolute referencing

iii. mixed referencing

Relative reference is the default cell reference. When a relative reference is copied and pasted across multiple cells, it changes depending on its relative position. This type of reference is especially useful when there is a need to apply same formula across multiple rows or columns.

Absolute reference, on the other hand, will not change even though it is copied across multiple cells. It is used especially to keep the value or content of a column or row constant.

Mixed reference is a hybrid of the relative and absolute references.


Related Questions

A Key Factor in Controlling Your Anger Is Using Passive behaviour.T/F

Answers

Answer:

The answer is "True".

Explanation:

Assertiveness means that others are encouraged to be open, honest about their thoughts, wishes and feelings so how they can act properly. Assertive behavior: be open and communicate wishes, ideas and feelings, as well as encourage others to do likewise. Please visit our Emotional Regulation page. A major aspect is the ability to control your anger. Once you are quiet or aggressive, work very hard.

When performing the ipconfig command, what does the following output line depict if found in the tunnel adapter settings?
IPv6 Address: 2001:db8:0:10:0:efe:192.168.0.4
a. IPv6 is disabled.
b. The addresses will use the same subnet mask.
c. The network is not setup to use both IPv4 and IPv6.
d. IPv4 Address 192.168.0.4 is associated with the global IPv6 address 2001:db8:0:10:0:efe

Answers

Answer:

d. IPv4 Address 192.168.0.4 is associated with the globe IPv6 address 2001:db8:0:10:0:efe

Explanation:

The adapter setting will be associated with the global IP address. When Ipconfig command is operate the IP address finds the relevant domain and then address will use a different subnet. The network will use both IPv4 and IPv6 subnets in order to execute the command.

In the tunnel adapter settings, when performing the ipconfig command, the given output line depicts: D. IPv4 Address 192.168.0.4 is associated with the global IPv6 address 2001:db8:0:10:0:efe.

What is a tunnel adapter?

A tunnel adapter can be defined as a virtual interface which is designed and developed to encapsulate packets as a form of tunnel or virtual private network (VPN) protocol while sending them over another network interface.

In Computer networking, an output line of "IPv6 Address: 2001:db8:0:10:0:efe:192.168.0.4" in the tunnel adapter settings simply means that an IPv4 Address 192.168.0.4 is associated with the global IPv6 address 2001:db8:0:10:0:efe.

Read more on IP address here: https://brainly.com/question/24812743

Which of the following statement is true? Single choice. (2 Points) Views are virtual tables that are compiled at run time All of the Mentioned Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs Creating views can improve query response time

Answers

Answer:

All of the mentioned views could be looked as an additional layer in the table which enables us to protect intricate or sensitive data based upon our needs.

Explanation:

View is a virtual table which executed a pre compiled query. It is a table in which selective portion of the data can be seen from one or more tables. Queries are not allowed in indexed views and adding column is not possible. Views can be looked as an additional layer in the virtual table which protects sensitive data.

Use the drop-down menus to complete the steps for rearranging the layout of a form.

1. Open the form in
✔ Design
view.

2.
✔ Press Ctrl+A
to highlight all of the fields.

3. Under Form Design Tools, select the
✔ Arrange
tab.

4. Choose the Remove Layout button.

5. Reorder and arrange the layout as desired.

6. Review the changes in the
✔ Layout
view.

7. Click Save.

Just did it.

Answers

Answer:

1. Open the Form

2. Arrange tabs

3. Layout view

4. Reoder and arrange the Layout as desired

5. Press Ctrl + A

6. Choose the remove Layout button

7. Click Save

I am not sure

The complete steps for rearranging the layout of a form are in the order:

1, 2, 3, 4, 5, 6, and 7.

What is a form layout?

A form layout is the arrangement of all elements, components, and attributes of your form and the placement of the form on a specific page.

When rearranging the layout of the form, the steps to take are as follows:

Open the form in Design View (this means that the form needs adjustment and rearrangement.Press Ctrl+A (this control all function) helps to highlight all the features in the form layout fields.Under Form Design Tools, select the Arrange tab.Choose the Remove Layout button.Reorder and arrange the layout as desired.Review the changes in the Layout view.Click Save.

Learn more about form layout arrangement here:

https://brainly.com/question/9759966

#SPJ2

१८. तलका शीर्षकमा १५० शब्दसम्मको निबन्ध लेख्नुहोस् :
(क) सुशासन र विकास

Answers

Answer:

n

Explanation:

Answer:

kkkkkkkkikkkkkkkkkkkiikkiiii

Using the adjacency matrix implementation, extend the class GraphType (C++) to include

a Boolean EdgeExists operation, which determines whether two vertices are connected by an edge
a DeleteEdge operation, which deletes a given edge.

Create main to test EdgeExists and DeleteEdge operations.

Answers

Answer: What grade work is this i would really like to know?

Explanation:

The following method is intended to return true if and only if the parameter val is a multiple of 4 but is not a multiple of 100 unless it is also a multiple of 400. The method does not always work correctly public boolean isLeapYear(int val) if ((val 4) == 0) return true; else return (val & 400) == 0; Which of the following method calls will return an incorrect response?
A .isLeapYear (1900)
B. isLeapYear (1984)
C. isLeapYear (2000)
D. isLeapYear (2001)
E. isLeapYear (2010)

Answers

Answer:

.isLeapYear (1900) will return an incorrect response

Explanation:

Given

The above method

Required

Which method call will give an incorrect response

(a) will return an incorrect response because 1900 is not a leap year.

When a year is divisible by 4, there are further checks to do before such year can be confirmed to be a leap year or not.

Since the method only checks for divisibility of 4, then it will return an incorrect response for years (e.g. 1900) that will pass the first check but will eventually fail further checks.

Hence, (a) answers the question;

(CO 4 and 5) Create a program that will read in a list of test scores from the user and add them to a list. Ask the user in between each score if they want to continue (y/n). Display all of the scores entered and the total score at the end. Using the code below, put the code in the proper order Sample output: Welcome to the Test Score Program Add score: 88.45 Do you want to continue

Answers

Answer and Explanation:

Using Javascript:

function AddScores(){

Window.alert("Welcome to the Test Score Program");

var ScoreList= new Array();

ScoreList.push(Prompt("Add Score"));

var WhatNext= Confirm("do you want to continue?");

If(WhatNext===true) {

do{

ScoreList.push(Prompt("Add Score"));

}

While(

Confirm("do you want to continue?")===true;);

}

Alert(ScoreList);

Alert(ScoreList.reduce(function(a,b){return a +b};,0);)

}

AddScores();

From the above code in javascript programming language, we have created a list ScoreList and added elements to it using push method of the array object and a do...while loop that checks the condition and then adds the user's input to the array. We then alerted the array to the screen and then summed up the array elements and also alerted to the screen.

Assume that a file contains students’ ids, full names, and their scores (Assignments grade, quizzes grade, Midterm grade, Practical exam grade, and final exam grade) (each column is separated by $). You are required to write a C program to do the following:



• Using the concept of parallel arrays create records for students with above attributes (id, full name, score).(you are not allowed to use structure)

• Ask the user to enter the input file name and read it (suppose that, there are different files you could read data from). Read the data from the file and store it in record for students, which has IDs, Names, and Scores. The IDs should be declared as integers, the Names as a two-dimensional array of characters and the Scores as doubles. Assume that the maximum length of full name of any student is 50 characters. Also, you may assume that there will be No more than a 1000 student records in the file.

• Calculate the final grade as the flowing:

Grade= (Assignment)*15%+(Quizzes) *15%+(Midterm exam) *25%+(Practical Exam)

*10%+(Final) *35% Assuming that data in files are arranged in same order of the above equation with respect to grades



Hint: read form file, calculate the final score, and store it in the record before going to the next step.

• Display the following menu to the user and read the entered choice:

1) Sort data in ascending order according to students’ IDs and then display it.

2) Sort data in ascending order according to students’ names and then display it.

3) Sort data in descending order according to students’ scores and then display it.

Note: After running any of the above menus items, ask the user if he/she would like to save the current result, if so, prompt user to enter file name.

4) Ask the user to enter a student ID and display his score

5) Ask the user to enter a student name and display his score

6) Exit the program











 The program should keep displaying the menu until the user selects to exit from the program.

Implement each of the first five menu options as a separate function.

The attached file “data.txt” is for test.

Answers

Thank lord for you please

What is the most efficient way to control the type of information that is included in the .msg file when a user forwards a
contact to another user?
Use the "As an Outlook Contact option.
Create an additional contact with limited information.
o Use the Business Card option.
Create the contact using the XML format.

Answers

Answer: Use the "As an Outlook Contact option.

Explanation:

The most efficient way to control the type of information which will be included in the .msg file when a contact is forwarded to another user by a user is to use the Use the "As an Outlook Contact option.

After clicking on the contact that you want to forward it to, then click on forward, click on contact and click on As an Outlook Contact. You can then complete the email message, after which you'll click on send.

As a basic user of SAP Business One, which feature of the application do you like most?

Answers

Answer:

I like the software most because it is completely for the sales department. I am very satisfied with what this software provides since I work as a sales specialist.

Explanation:

As an internal auditor, I first have to check and make sure the business is going through all reports and operations and that SAP Business One has helped me a lot with reporting features. I'm a huge fan of SAP Business One. And how this software is incredibly fully integrated when an accountancy provider creates a new customer name or adds a new item in every module, and the non-duplicate data feature secures the master data from any duplicate item.

Intuitive sales quotation and sales order functions help salespeople to develop deals that they can conclude. The mobile app adds to the software's usefulness fantastically.

In general, the system has a good monetary value. I would recommend it to everyone involved in the decision-making process and it is my favorite.

Which of the following statements about the relationship between hardware and software is true? a) Hardware can be present in intangible form. b) A flash drive is an example of software. c) Software and hardware can act independently of each other. d) Software consists of instructions that tell the hardware what to do.

Answers

Answer:

C

Explanation:

The statements about the relationship between hardware and software that is true is: D. Software consists of instructions that tell the hardware what to do.

A hardware can be defined as the physical components of an information technology (IT) system that can be seen and touched such as:

RouterSwitchKeyboardMonitorMouse

Conversely, a software refer to a set of executable codes (instructions) that is primarily used to instruct a computer hardware on how it should process data, perform a specific task or solve a particular problem.

In conclusion, a software consist of a set of executable codes (instructions) that tell a computer hardware what to do.

Read more on hardware here: https://brainly.com/question/959479

How does a junction table handle a many-to-many relationship?

by converting the relationship to a one-to-one relationship
by moving the data from the source table into the destination table
by directly linking the primary keys of two tables in a single relationship
by breaking the relationship into two separate one-to-many relationships

Answer: 4
by breaking the relationship into two separate one-to-many relationships

Answers

Answer:

two" (and any subsequent words) was ignored because we limit queries to 32 words.

Explanation:

please mark as brainliest

Answer:

By breaking the relationship into two separate one-to-many relationships

Explanation:

I just did it / edge 2021

Holly the Hacker has a list of 100,000 common passwords. She wants to use this list to break into UNIX-like systems that use a password file with lines consisting of:

Answers

The question is incomplete. The complete question is :

Holly the Hacker has a list of 100,000 common passwords. She wants to use this list to break into UNIX-like systems that use a password file with lines consisting of:

The user's ID in plaintext.

10 bits of randomly chosen "salt," in plaintext.

The user's password, concatenated with the salt, and then encrypted.

There are very many such systems around the world, and Holly plans to steal the password files from as many as she can. The average system has 50 users in its password file.

Holly wants to create a master list of the encrypted versions of all the 100,000 passwords on her list, encrypted with all possible salt values. To create this master list, approximately how many encryptions of a password-concatenated-with-salt would Holly have to perform?

A. 2 million

B. 5 million

C. 100 million

D. 1 million

Solution :

It is given that the hacker, Holly wants break into the  UNIX-like systems using 100,000 common passwords that she has on her list. The system has at an average of 50 users in the password files.

Therefore, to create a master list, Holly have to perform about 50 x 100,000 = 5,000,000 encryptions for the password concatenated-with-salt.

Thus the correct option is option (B).  5 million

Create a method called nicknames that passes an array as a parameter. Inside the method initialize it to hold 5 names of your choice. Use the for each enhanced loop to print the elements of the array.

Answers

Answer:

    //======METHOD DECLARATION=========//          

    //method name: nicknames                                          

    //method return type: void                                            

    //method parameter: an array reference                    

    public static void nicknames(String [] names){      

       //initialize the array with 5 random names              

       names = new String[] {"John", "Doe", "Brian", "Loveth", "Chris"};

       //using an enhanced for loop, print out the elements in the array

       for(String n: names){

           System.out.print(n + " ");

       }

       

    }

Explanation:

The program is written in Java. It contains comments explaining important parts of the code. Kindly go through these comments.

A few things to note.

i. Since the method does not return any value, its return type is void

ii. The method is made public so that it can be accessible anywhere in and out of the class the uses it.

iii. The method is made static since it will most probably be called in the static main method (at least for testing in this case)

iv. The method receives an array of type String as parameter since the names to be stored are of type String.

v. The format of initializing an array manually should follow as shown on line 7. The new keyword followed by the array type (String), followed by the square brackets ([]) are all important.

vi. An enhanced for loop (lines 9 - 11) is a shorthand way of writing a for loop. The format is as follows;

=> The keyword for

=> followed by an opening parenthesis

=> followed by the type of each of the elements in the array. Type String in this case.

=> followed by a variable name. This holds an element per cycle of the loop.

=> followed by a column

=> followed by the array

=> followed by the closing parenthesis.

=> followed by a pair of curly parentheses serving as a block containing the  code to be executed in every cycle of the loop. In this case, the array elements, each held in turn by variable n, will be printed followed by a space.

A complete code and sample output for testing purposes are shown as follows:

==================================================

public class Tester{

    //The main method

    public static void main(String []args){

       

       String [] names = new String[5];

       nicknames(names);

    }

   

  //The nicknames method

    public static void nicknames(String [] names){

       names = new String[] {"John", "Doe", "Brian", "Loveth", "Chris"};

       for(String n: names){

           System.out.print(n + " ");

       }

       

    }

}

==================================================

Output:

John Doe Brian Loveth Chris

NB: To run this program, copy the complete code, paste in an IDE or editor and save as Tester.java

You trained a binary classifier model which gives very high accuracy on thetraining data, but much lower accuracy on validation data. The following maybe true:
a. This is an instance of overfitting.
b. This is an instance of underfitting.
c. The training was not well regularized.
d. The training and testing examples are sampled from different distributions.

Answers

Answer:

a. This is an instance of overfitting.

Explanation:

In data modeling and machine learning practice, data modeling begins with model training whereby the training data is used to train and fit a prediction model. When a trained model performs well on training data and has low accuracy on the test data, then we say say the model is overfitting. This means that the model is memorizing rather Than learning and hence, model fits the data too well, hence, making the model unable to perform well on the test or validation set. A model which underfits will fail to perform well on both the training and validation set.

An entertainment application would most likely do which of the following?
A. allow users to watch popular movies and TV shows
B. connect users with social and business contacts
C. confirm users' travel plans
D. teach users a new language

Answers

Answer:

A is the answer to this question

Answer:

A. allow users to watch popular movies and TV shows

Explanation:

List the four workplace trends discussed in the lecture.













Answer:
The global economy, teamwork, technology, and diversity

Answers

Answer:

Trends in the workplace are constantly evolving and the latest trends are tough to maintain. Ten years ago, employers did not care about open businesses, advantages like ping pong tables and lunches on Fridays, or standing desks and unbounded time off. As times change, however, companies have to adopt trends to increase productivity and employee involvement in the workplace.

Explanation:

Global economy: The global economy refers to the worldwide interconnected economic activities between several countries. These economic activities could impact the countries concerned either positively or negatively.

There are several features in the global economy, for example:

Globalization.International trade.International finance.Global investment.TEAMWORK: "To work together with a group of people to achieve an objective. Teamwork is often an important part of a company, as colleagues often have to work together well and to try their best in all circumstances. Work in a team means that, despite any personal conflicts between people, people will try to cooperate, use their individual abilities, and provide constructive feedback."

It is selfless teamwork. It concentrates on the ultimate objective. Teamwork is based on the idea that the whole exceeds the sum of its components. It's the traditional idea of "one plus one is equal to three." Personalities and the ability to create personal conflicts are different. However, the differences between the members of the team become strengths and goals, if the whole team focuses on doing great work.

TECHNOLOGY: The skills, methods, and processes used to achieve objectives are technology. The technology to use is:

Manufacture products and servicesachieve objectives such as scientific research or sending a moon spaceshipSolve issues like sickness or starvationWe already do things, but easier.

Knowledge of how to do things maybe technology. Embedding machines are examples. This enables others to use the machines without knowing how they function. By taking something, changing it, and producing results, the technological system uses the technology. They are also known as systems of technology.

Developing and using fundamental tools is the simplest form of technology. The discovery of fire and the Revolution made food more readily available. Additional inventions such as the ship and the wheel have helped people and themselves to transport goods. IT, like the printer, the phone, and the internet, has led to Globalization.

DIVERSITY:

Diversity is a range of differences in the human race, ethnicity, sexuality, age, social class, physical capacity or attributes, religious or ethical values systems, nationality, and political faith.

Inclusion is participation and empowerment, which recognize everybody's inherent worth and dignity. An included university supports and promotes the sense of belonging; respects its members' talents, beliefs, backgrounds, and livelihoods. They respect and practice them.

Answer:

The global economy, teamwork, technology, and diversity

Explanation:

design an if-then-else statement or a flowchart with a dual alternative decision structure that displays speed is normal if the speed variable is within the range of 24 to 56. if speed holds a value outside this range, display speed is normal

Answers

Answer:

The if statement is as follows:

if speed>=24 and speed <=56 then

      print "speed is normal"

else

    print "speed is abnormal"

See attachment for flowchart

Explanation:

The condition is straight forward and self-explanatory

This is executed if speed is between 24-56 (inclusive)

if speed>=24 and speed <=56 then

      print "speed is normal"

If otherwise, this is executed

else

    print "speed is abnormal"

Using the celsius_to_kelvin function as a guide, create a new function, changing the name to kelvin_to_celsius, and modifying the function accordingly. Sample output with input: 283.15 10.0 C is 283.15 K 283.15 K is 10.0 C 1 def celsius_to_kelvin value.celsius): value_kelvin 0.0 value_kelvin - value.celsius + 273.15 return value kelvin DIO! 5 7. Your solution goes here 9 value c - 10.0 10 print(value.c, Cis', celsius.to kelvin(value.c), 'K) 12 value floatinput ) 13 print(value, Kis', kelvin_to_celsius(value. ). 'C"> Run

Answers

Answer:

The function is as follows:

def  kelvin_to_celsius(value_kelvin):

   value_celsius = 0.0

   value_celsius = value_kelvin - 273.15

   return value_celsius

Explanation:

This defines the function

def  kelvin_to_celsius(value_kelvin):

This initializes value_celsius to 0

   value_celsius = 0.0

This calculates value_celsius

   value_celsius = value_kelvin - 273.15

This returns the calculated value_celsius

   return value_celsius

A student is conducting an experiment in which he adds an inhibitor to an enzyme-catalyzed reaction that contains alkaline phosphatase. When the student first adds the inhibitor, the reaction rate decreases, however, he can return the reaction rate to normal by adding a large quantity of substrate. What type of inhibitor is the student using, non-competitive or competitive?

Answers

Answer:

competitive

Explanation:

An inhibitor is a substance that hinders the action of an enzyme. An inhibitor may be competitive or non competitive.

A competitive inhibitor is an inhibitor that is very similar to the substrate hence it binds to the enzyme instead of the substrate. A noncompetitive inhibitor binds to a site that is different from the active site. This site is called an allosteric site.

If we look at the experiment described in the question, the reaction rate decreases upon addition of the inhibitor. This effect is reversed by adding a large quantity of substrate.

The implication of this observation is that the enzyme and the inhibitor compete for the active site on the substrate.

Hence the inhibitor is a competitive inhibitor.

Answer:

competitive inhibitor is the students using

space bar in computer​

Answers

Answer: Its the one in the middle the really long thingy it looks like a rectangle

Explanation:

ITS IN THE MIDDLE

1. Write a generic method that compares its 2 arguments using the equals method and returns true if they are equal and false otherwise. Ensure that the name of your method includes your last name.

Answers

Answer:

Explanation:

The following piece of code is written in Java. It creates the method as requested that takes in two generic objects and compares them using the .equals() built in Java method. This method will return True if the objects are identical or False if they are not. A test case is used in the code and the output can be seen in the attached image below.

   public static <T> boolean comparePerez(T a, T b) {

       return a.equals(b);

   }

NO LINKS
Write a C++ program to accept a 5 digit integer and to validate the input based on the following rules.

Rules

1) The input number is divisible by 2. 2) The sum of the first two digits is less than last two digits. if the input number satisfies all the rules, the system prints valid and invalid, otherwise,

Example 1:

Enter a value: 11222

Output: Input number is valid

Example 2:

Enter a value: 1234

Output: Input number is invalid​

Answers

Answer:

#include <iostream>

#include <string>

#include <regex>

using namespace std;

int main()

{

   cout << "Enter a 5-digit number: ";

   string number;

   cin >> number;

   bool valid = regex_search(number, regex("^\\d{4}[02468]$"));

   if (valid) {

       valid = stoi(number.substr(0, 1)) + stoi(number.substr(1, 1))  

           < stoi(number.substr(3, 1)) + stoi(number.substr(4, 1));

   }

   cout << number << (valid ? " is valid" : " is invalid");

}

Explanation:

Regular expressions can do all of your checking except for the sum of digits check. The checks are i.m.o. easiest if you don't treat the input as a number, but as a string with digits in it.

The regex means:

^ start of string

\d{4} exactly 4 digits

[02468] one of 0, 2, 4, 6 or 8 (this is what makes it even)

$ end of string

Design a class named largeIntegers such that an object of this class can store an integer of any number of digits. Add operations to add, subtract, multiply, and compare integers stored in two objects. Also add constructors to properly initialize objects and functions to set, retrieve, and print the values of objects. Write a program to test your class. g

Answers

Answer:

Here the code is given as follows,

Explanation:

Code:

import java.util.Scanner;

//created class named largeintegers

class largeintegers{

   //class can hold a long number

   long number;

   //constructor to set number

  largeintegers(long number){

      this.number=number;

  }

  //getNumber method to get number

  long getNumber(){

      return number;

  }

  //below are some basic operations

  long addition(long num1,long num2){

       return num1+num2;

   }

   long subtract(long num1,long num2){

       return num1-num2;

   }

   long multiply(long num1,long num2){

       return num1*num2;

   }

   boolean compare(long num1,long num2)

   {

       return num1>num2;

   }

  public static void main(String[] args) {

      //declared to long numbers

      long number1,number2;

      //scanner class to take user input

      Scanner sc= new Scanner(System.in);

      //taking input numbers

      System.out.println("Enter a Number ");

      number1=sc.nextLong();

      System.out.println("Enter 2nd Number :");

      number2=sc.nextLong();

      //created two objects

      largeintegers object=new largeintegers(number1);

      largeintegers object2=new largeintegers(number2);

      //displaying two numbers

      System.out.println("Entered Numbers ");

      System.out.println(object.getNumber());

      System.out.println(object2.getNumber());

      //calling basic methods using created objects

      System.out.println("Some Operations on Given two Numbers ");

      System.out.println("Addition:"+object.addition(object.getNumber(), object2.getNumber()));

      System.out.println("Subtraction:"+object.subtract(object.getNumber(), object2.getNumber()));

      System.out.println("Multiplication:"+object.multiply(object.getNumber(), object2.getNumber()));

      System.out.println("Comparison:");

      if(object.compare(object.getNumber(), object2.getNumber())==true)

      {

          System.out.println("First Number is Greater than Second Number ");

      }

      else

      {

          System.out.println("Second Number is Greater than First Number ");

      }

      sc.close();

  }

}

Output:-

What does internet prefixes WWW and HTTPs stands for?

Answers

Answer:

World Wide Web - WWW

Hypertext Transfer Protocol (Secure) - HTTPS

Explanation:

WWW means that the source and content is available to the whole world. Regarding what browser or registrar you have, the content will appear. HTTPS means Hypertext Transfer Protocol Secure. This means that it is a safe way to send info from a web system. I hope I helped you!

Write a python program that will accept monthly salary amounts greater than zero but less

than or equal to 400,000.00 until the user enters the character ‘e’. After the user

enters the character ‘e’, calculate the net pay of all salaries by deducting income tax at

a rate of 25%, pension of 5% and housing contribution of 2% from each salary

entered. Additionally, print the number of salaries that were entered in the program

along with the number of salaries that exceed 300,000.00

write a python program
The English alphabet has 26 letters starting from A and ending with Z. If we map the

first 26 numbers i.e 1 through to 26 to each letter in the alphabet, we could encode

messages using numbers. For example, 123 could be represented as ‘ABC’ and 26 could

be the letter ‘Z’. Write a program that accepts 10 integers from the user ranging from 1

- 26. After accepting the values, the program should determine and print the

corresponding letters.​

Answers

It won't save the answer. Maybe I can give it to you in the comment.

You can message me if you want. I cannot post the answer in the comment too:(

calculateAverageSalary(filename): Returns the average salary of all employees rounded down to 2 decimal points highestHireMonth(filename): Returns the month (integer) during which most hires were made over the years getMonth(date): Helper function to extract and return the month number from a date given as a string input of format MM/DD/YY. Return type should be an int.

Answers

Answer:

An extract from the answer is as follows:

for i in salary:

 total_salary+=float(i)

 count+=1  

return round(total_salary/count,2)

def getMonth(date):

ddate = []

for i in date:

 ddate.append(i.split('/')[0])

mode = int(max(set(ddate), key=ddate.count))

return mode  

def highestHireMonth(filename):

month = []

See explanation for further details

Explanation:

Given

Attachment 1 completes the question

The complete answer could not be submitted. So, I've added it as an attachment.

See attachment 2 for program source file which includes the main method.

Comments are used to explain difficult lines

Output each floating-point value with two digits after the decimal point, which can be achieved as follows:
print('{:.2f}'.format(your_value))
(1) Prompt the user to input a wall's height and width. Calculate and output the wall's area (integer). (Submit for 2 points).
Enter wall height (feet):
12
Enter wall width (feet):
15
Wall area: 180 square feet
(2) Extend to also calculate and output the amount of paint in gallons needed to paint the wall (floating point). Assume a gallon of paint covers 350 square feet. Store this value in a variable. Output the amount of paint needed using the %f conversion specifier. (Submit for 2 points, so 4 points total).
Enter wall height (feet):
12
Enter wall width (feet):
15
Wall area: 180 square feet
Paint needed: 0.51 gallons
(3) Extend to also calculate and output the number of 1 gallon cans needed to paint the wall. Hint: Use a math function to round up to the nearest gallon. (Submit for 2 points, so 6 points total).
Enter wall height (feet):
12
Enter wall width (feet):
15
Wall area: 180 square feet
Paint needed: 0.51 gallons
Cans needed: 1 can(s)
(4) Extend by prompting the user for a color they want to paint the walls. Calculate and output the total cost of the paint cans depending on which color is chosen. Hint: Use a dictionary to associate each paint color with its respective cost. Red paint costs $35 per gallon can, blue paint costs $25 per gallon can, and green paint costs $23 per gallon can. (Submit for 2 points, so 8 points total).
Enter wall height (feet):
12
Enter wall width (feet):
15
Wall area: 180 square feet
Paint needed: 0.51 gallons
Cans needed: 1 can(s)
Choose a color to paint the wall:
red
Cost of purchasing red paint: $35
1 import math
2
3 # Dictionary of paint colors and cost per gallon
4 paint_colors = {
5 'red': 35,
6 'blue': 25,
7 'green': 23
8 }
9
10 # FIXME (1): Prompt user to input wall's width
11 # Calculate and output wall area
12 wall_height = int(input('Enter wall height (feet):\n'))
13 print('Wall area:')
14
15 # FIXME (2): Calculate and output the amount of paint in gallons needed to paint the wall
16
17 # FIXME (3): Calculate and output the number of 1 gallon cans needed to paint the wall, rounded up to nearest integer
18
19 # FIXME (4): Calculate and output the total cost of paint can needed depending on color
20

Answers

Answer:

The modified program in Python is as follows:

import math

paint_colors = {'red': 35,'blue': 25,'green': 23}

wall_height = int(input('Enter wall height (feet):\n'))

wall_width = int(input('Enter wall width (feet):\n'))

area = wall_height*wall_width

print('Wall area:',area,'square feet')

paint_needed = area/350.0

print('Paint needed: {:.2f} gallons'.format(paint_needed))

print('Cans needed:',round(paint_needed),'can(s)')

color = input("Choose a color to paint the wall: ")

print("Cost of purchasing", color, "paint: $",paint_colors[color])

Explanation:

The italicized are given from the question [unchanged]

import math

paint_colors = {'red': 35,'blue': 25,'green': 23}

wall_height = int(input('Enter wall height (feet):\n'))

This gets input for width

wall_width = int(input('Enter wall width (feet):\n'))

Calculate the wall area

area = wall_height*wall_width

Print the calculated wall area

print('Wall area:',area,'square feet')

Calculate the amount of paint needed

paint_needed = area/350.0

Print the amount of paint needed to 2 decimal places

print('Paint needed: {:.2f} gallons'.format(paint_needed))

Print the amount of can needed to nearest integer

print('Cans needed:',round(paint_needed),'can(s)')

Prompt user for color of paint [here, we assume the user input is correct]

color = input("Choose a color to paint the wall: ")

Prints the corresponding amount for the color

print("Cost of purchasing", color, "paint: $",paint_colors[color])

In the tiger exhibit at the zoo each of 24 tigers eat 26 lb of food each day how much pounds of food do tigers consume in a week?? answer this as fast as you can!!

Answers

Answer:

182 pounds of food

Explanation:

Other Questions
What is the value of h(2)?0 -20 -11O 3Need help fast!!! What does stage 4 show?A. A young female cone with fertilized eggs matures into a seedcone.B. A spore divides and grows into a pollen grain using mitosis.C. Young male cones produce spores using meiosis.D. A seed that contains an embryo plant grows into a young pinetree. ASAP PLZ PLZ PLZ PLZZZZZZ Type SSS, SAS, ASA, SAA, or HL tojustify why the two larger triangles arecongruent. HELP ITS 50points ! A person weighs 60 kg. The area under the foot of the person is 150 cm2. Find the pressure exerted on the ground by the person. (Take g 10m/s2) These words from Chief Justice John Marshall's opinion in the 1803 case of Marbury v. Madison are inscribed on the U.S. Supreme Court building. How does this statement relate to the function of the judicial branch and its place within our three-branch system of government? Why do you think this idea was important enough to have it displayed at the Supreme Court? If we did not have an independent, impartial judicial branch, who might be responsible for saying what the law is, and why might that be problematic? Someone Help if they can ASAP! Which detail from "Thomas Edison: The Master of Improvement supports the big-picture idea of the passage? During strenuous exercise, lactic acid fermentation begins because the muscle cells are not getting enoughwaterglucoseoxygenATP How will you calculate it's surface area? The figure below shows parallelograms ABCE, PQRS, and TNLM on a coordinate plane. Points S, P, Q, and Rare midpoints of ABCE T, N, L, and Mare midpoints of PQRSWrite the equation of line ML. Show your work. im in need of help for this problem (listing BRAINLIST and giving points) :) Dave Bowers collects U.S. gold coins. He has a collection of 49 coins. Some are $10 coins, and the rest are $20 coins. If the face value of the coins is $690, how many of each denomination does he have?How many $10 coins does he have?How many $20 coins does he have? PLEASE HELPPPPPP FINDING CIRCUMFERENCE AND AREA OF A CIRCLE Ex:3 help me pleaseeeeeee U.S.-based Myva Foods Inc. is expanding its business to the Asian market. Which of the following will NOT be effective in the company's efforts to expand to international markets?A) paying close attention to the cultural differences between Myva's home country and the host countries.B) finding new ways to blend the Four Ps of the marketing mix in the new market by making an effort to understand the local culture.C) applying the same marketing mix Myva uses in the U.S.market to the Asian market.D) putting more effort into planning strategies for the international markets,even though it has experienced success in the U.S.market. Galaxy Corp. is considering opening a new division to make iToys that it expects to sell at a price of $15,250 each in the first year of the project. The company expects the cost of producing each iToy to be $6,700 in the first year; however, it expects the selling price and cost per iToy to increase by 3.00% each year.Based on the preceding information and rounding dollar amounts to the nearest whole dollars, the company expects the selling price in the fourth year of the project to be_______ , and it expects the cost per unit in the fourth year of the project to be _______.Which of the following statements about inflations effect on net present value (NPV) is correct?A. When the selling price and cost per unit are expected to increase at the same rate, forgetting to take inflation into account in a capital budgeting analysis will typically cause the estimated NPV to be lower than the true NPV.B. When the selling price and cost per unit are expected to increase at the same rate, you do not need to take inflation into account when performing a capital budgeting analysis. Help ASAP 100 PTS!!!! Describe how to determine the average rate of change between x = 1 and x = 3 for the function f(x) = 3x3 + 1. Include the average rate of change in your answer. Please show all work and explain it thourougly. If X + Y means X is the brother of Y, X - Y means X is the sister of Y, and X * Y means X is the father of Y, then which of the following means that C is the son of M? (1) M-N * C + F (2) F-C + N * M (3) N +M-F * C (4) M * N-C + F (5) M-N+F * C