In cell n2, enter a formula using the if function and a structured reference to determine if allison simoneau is eligible for tu
ition remission
1 answer:
Question is incomplete (See complete question below)
In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.
a. The IF function should first determine if the staff member's Service Years is greater than 1. Remember to use a structured reference to the Service Years column.
b. The function should return the text Eligible if the staff member's Service Years is greater than 1.
c. The function should return the text Not Eligible if the staff member's Service Years is not greater than 1.
Answer:
See attachment
Explanation:
Here, the name of the cell is N2.
In order to write the required query, we need to first get a table name.
For the purpose of this query, we'll assume the table name to be STAFF_TABLE.
Taking the above condition into consideration, the formula is as follows;
--- See attachment-----
The above formula test for the conditions listed out above and displays "ELIGIBLE" or "NOT ELIGIBLE", without the quotes depending on the outcome of the condition of SERVICE_YEAR > 1
You might be interested in
<h2>Answer:</h2>
<u />
========= Shape.java ===========
//import the Scanner class
import java.util.Scanner;
public class Shape{
//required fields
private String shape;
private double area;
private double perimeter;
//default constructor
public Shape(){
this.shape = "unknown";
this.area = 0.0;
this.perimeter = 0.0;
}
//constructor with one parameter
public Shape(String shape){
this.setShape(shape);
this.area = 0.0;
this.perimeter = 0.0;
}
//accessors and mutators
public void setShape(String shape){
this.shape = shape;
}
public String getShape(){
return this.shape;
}
public double getPerimeter(){
return this.perimeter;
}
public double getArea(){
return this.area;
}
public void setPerimeter(Scanner scr){
if(this.getShape().equals("circle")){
System.out.println("Enter the radius of the circle");
double radius = scr.nextDouble();
this.perimeter = 2 * 3.142 * radius;
}
else if(this.getShape().equals("rectangle")){
System.out.println("Enter the width");
double width = scr.nextDouble();
System.out.println("Enter the height");
double height = scr.nextDouble();
this.perimeter = 2 * (width + height);
}
else if(this.getShape().equals("square")){
System.out.println("Enter the height or width");
double height = scr.nextDouble();
this.perimeter = 4 * height;
}
else if(this.getShape().equals("unknown")){
System.out.println("You must define a shape first before calculating perimeter");
this.perimeter = 0.0;
}
else {
System.out.println("You must define a shape first before calculating perimeter");
this.perimeter = 0.0;
}
}
public void setArea(Scanner scr){
if(this.getShape().equals("circle")){
System.out.println("Enter the radius of the circle");
double radius = scr.nextDouble();
this.area = 3.142 * radius * radius;
}
else if(this.getShape().equals("rectangle")){
System.out.println("Enter the width");
double width = scr.nextDouble();
System.out.println("Enter the height");
double height = scr.nextDouble();
this.area = width * height;
}
else if(this.getShape().equals("square")){
System.out.println("Enter the height or width");
double height = scr.nextDouble();
this.area = height * height;
}
else if(this.getShape().equals("unknown")){
System.out.println("You must define a shape first before calculating area");
this.area = 0.0;
}
else {
System.out.println("You must define a shape first before calculating area");
this.area = 0.0;
}
}
//Own methods
//1. Method to show the properties of a shape
public void showProperties(){
System.out.println();
System.out.println("The properties of the shape are");
System.out.println("Shape : " + this.getShape());
System.out.println("Perimeter : " + this.getPerimeter());
System.out.println("Area : " + this.getArea());
}
//2. Method to find and show the difference between the area and perimeter of a shape
public void getDifference(){
double diff = this.getArea() - this.getPerimeter();
System.out.println();
System.out.println("The difference is " + diff);
}
}
========= ShapeTest.java ===========
import java.util.Scanner;
public class ShapeTest {
public static void main(String [] args){
Scanner scanner = new Scanner(System.in);
// create an unknown shape
Shape shape_unknown = new Shape();
//get the shape
System.out.println("The shape is " + shape_unknown.getShape());
//set the area
shape_unknown.setArea(scanner);
//get the area
System.out.println("The area is " + shape_unknown.getArea());
//set the perimeter
shape_unknown.setPerimeter(scanner);
//get the perimeter
System.out.println("The perimeter is " + shape_unknown.getPerimeter());
// create another shape - circle
Shape shape_circle = new Shape("circle");
//set the area
shape_circle.setArea(scanner);
//get the area
System.out.println("The area is " + shape_circle.getArea());
//set the perimeter
shape_circle.setPerimeter(scanner);
//get the area
System.out.println("The perimeter is " + shape_circle.getArea());
//get the properties
shape_circle.showProperties();
//get the difference between area and perimeter
shape_circle.getDifference();
}
}
<h2>Sample output:</h2>
The shape is unknown
You must define a shape first before calculating area
The area is 0.0
You must define a shape first before calculating perimeter
The perimeter is 0.0
Enter the radius of the circle
>> 12
The area is 452.448
Enter the radius of the circle
>> 12
The perimeter is 452.448
The properties of the shape are
Shape : circle
Perimeter : 75.408
Area : 452.448
The difference is 377.03999999999996
<h2>Explanation:</h2>
The code above is written in Java. It contains comments explaining important parts of the code. Please go through the code for more explanations. For better formatting, the sample output together with the code files have also been attached to this response.
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark">
java
</span>
<span class="sg-text sg-text--link sg-text--bold sg-text--link-disabled sg-text--blue-dark">
java
</span>