Answer:
apply a filter by age with a value more than 20
Explanation:
First, we must create the spreadsheet with the fields student, age, grade level, major and minor.
For example:
If we want to create a filter, we must mark headings with the left click, then we must go to the tab Home --> at the section Editing, click in Sort & filter then Filter.
We must click in the field Age --> number filters --> greater than 20.
Answer:
Written in Python
name = input("Name: ")
wageHours = int(input("Hours: "))
regPay = float(input("Wages: "))
if wageHours >= 60:
->total = (wageHours - 60) * 2 * regPay + 20 * 1.5 * regPay + regPay * 40
else:
->total = wageHours * regPay
print(name)
print(wageHours)
print(regPay)
print(total)
Explanation:
The program is self-explanatory.
However,
On line 4, the program checks if wageHours is greater than 60.
If yes, the corresponding wage is calculated.
On line 6, if workHours is not up to 60, the total wages is calculated by multiplying workHours by regPay, since there's no provision for how to calculate total wages for hours less than 60
The required details is printed afterwards
Note that -> represents indentation
We can import Scanner from Java.utils.Scanner to pull in text entered in the console.
public static void main(String[] args) {
Scanner sc = new Scanner(System.in);
String password = "";
do {
System.out.print("Enter your password: ");
password = sc.nextLine();
if(!password.equals("pals") {
System.out.println(\nIncorrect Password. Try again.");
}
} while(!password.equals("pals");
Ur answer is: a-half-inch