Answer:
Following are the solution to this question:
Explanation:
Some of the data is missing in the question, which is defined in the attached file. Please find it.
Follows are the formula which is used in the question:
- EmployeeAnalysis Worksheet IF(C5>49,"Certified","Not Certified")
- Transactions Worksheet IF(F10="No","",0.07)
In the first condition, it checks "C5" is greater than 49 if the condition is true, it will give "Certified" otherwise, it will give "Not Certified".
In the second condition, it checks "F10" is equal to "No" if the condition is true, it will give a blank or space otherwise, it will give "0.07".
Answer:
- var today = new Date();
- var dateComp = [];
- dateComp[0] = today.getDate();
- dateComp[1] = today.getMonth();
- dateComp[2] = today.getFullYear();
-
- switch(dateComp[1]){
- case 0:
- console.log("Jan " + dateComp[0] + "," + dateComp[2])
- break;
- case 1:
- console.log("Feb " + dateComp[0] + "," + dateComp[2])
- break;
- case 2:
- console.log("Mar " + dateComp[0] + "," + dateComp[2])
- break;
- case 3:
- console.log("Apr " + dateComp[0] + "," + dateComp[2])
- break;
- case 4:
- console.log("May " + dateComp[0] + "," + dateComp[2])
- break;
- case 5:
- console.log("Jun " + dateComp[0] + "," + dateComp[2])
- break;
- case 6:
- console.log("Jul " + dateComp[0] + "," + dateComp[2])
- break;
- case 7:
- console.log("Aug " + dateComp[0] + "," + dateComp[2])
- break;
- case 8:
- console.log("Sept " + dateComp[0] + "," + dateComp[2])
- break;
- case 9:
- console.log("Oct " + dateComp[0] + "," + dateComp[2])
- break;
- case 10:
- console.log("Nov " + dateComp[0] + "," + dateComp[2])
- break;
- case 11:
- console.log("Dec " + dateComp[0] + "," + dateComp[2])
- break;
- }
Explanation:
The solution code is written in JavaScript.
Firstly, create a Date object (Line 1). The date object will automatically capture the current date and time.
Next create an array dateComp to hold the day, month and year (Line 3 -5). We use the getDate method to get current day, getMonth method for current month and getFullYear method for current year.
This is important to note that the getMonth method will return the value range from 0 - 11 with the Jan is represented as 0, Feb is 1 and so forth. Presume we intend to display the date using the format "month day, year", we can create a switch structure to check the month value which is range from 0 to 11. If month value is 0, generate string Jan + current day + "," + current year. We generate the date string based on different switch cases (7 - 44). We shall see the output similar to the date string as shown below:
Apr 12,2020
First select or highlight the rows or columns that you want to change the font color<span>. You can hold the ctrl key while select </span>multiple cells<span>. After, selecting you can now </span>change the font color<span> of everything you selected.</span>
"flat file"
A simple database program whose records have no relationship to one another<span>single</span>
Answer:
me me me me me me me me me me mw
Explanation:
I hope I can help you
