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".
The correct answer is D. All of the methods listed above are ways of inserting new sheets into a workbook.
B. Border. It borders the outer page.
Task view is the option that you would not see on a Windows 10 Start menu, whereas if you click the Windows button, you can see tiles with different applications, all of your apps in the form of tiles you can distribute according to your own taste, and power button where you can choose whether you want to shut down your computer, put it to sleep, or log out.
I will hope this helps :p