14. Emelia is very concerned about safety and has conducted a study to determine how many bike helmets were replaced at each loc
ation last year. She wants to include the survey results in this spreadsheet. Switch to the Helmets Per Location worksheet. Open the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook, and then switch back to Helmets Per Location worksheet. Link the data to the Helmets Per Location worksheet as described below: a. In cell C3 of the Helmets Per Location worksheet, create a formula without using a function that contains a relative reference to cell D2 of the 2019 Damaged Helmet Survey worksheet in the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook. b. In the Helmets Per Location worksheet, copy the formula in cell C3 to the range C4:C5 without copying the formatting. c. Close the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook and switch back to the Helmets Per Location worksheet.
2 answers:
Answer:
Explanation:
Known Variables A = max Daily Rentals
X = Damaged helmets %
lets find the formula to calculate Helmets per location :taking 1st row as an example.
412 = B - (B*13/100)
412 = (100B-13B)/100
412*100 = 87B
B= 412*100/87
Hence, the generic formula becomes : B= A*100/(100-X)
Applying the same formula for each row and then using ROUND function of excel to round off the digits
=ROUND(number,digits) where number is the number you would like to round off and the digits is the number of decimal digits for it to round off. Since we want natural numbers in our example, we will be using digits as 0.
Explanation:
See attached pictures also.
You might be interested in
Answer:
Here is the Hello class:
public class Hello { //class name
private String name; //to store the name
public Hello (String names) //parameterized constructor
{ name = names; }
public void English() { //method to greet user in english
System.out.print("Hello "); //displays Hello on output screen
System.out.print(name); //displays user name
System.out.println("!"); } //displays exclamation mark symbol
public void Spanish(){ //method to greet user in spanish
System.out.print("Hola "); //displays Hello on output screen
System.out.print(name); //displays user name
System.out.println("!"); } //displays exclamation mark symbol
public void French() { //method to greet user in french
System.out.print("Bonjour "); //displays Hello on output screen
System.out.print(name); //displays user name
System.out.println("!"); } } //displays exclamation mark symbol
Explanation:
Here is the HelloTester class:
import java.util.Scanner; //to accept input from user
public class HelloTester { //class name
public static void main (String[]args) { //start of main method
String name; //to store the name of user
Scanner input = new Scanner(System.in); //creates Scanner class object
System.out.println("Enter name?" ); //prompts user to enter name
name = input.nextLine(); //scans and reads the name from user
Hello hello = new Hello(name); //creates Hello class object and calls constructor by passing name
hello.English(); //calls English method using object hello to greet in english
hello.Spanish(); //calls Spanish method using object hello to greet in spanish
hello.French(); } } //calls French method using object hello to greet in french
The output of the program is:
Enter name? user Hello user! Hola user! Bonjour user!
The screenshot of the program along with its output is attached.
