Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9. Cell G10 contains the number of hours worked. Write the formula that would be used to display 'Overtime' if the hours are over 40
9. Cell G10 contains the number of hours worked. Write the formula that would be used to display 'Overtime' if the hours are over 40 and 'Regular' if the hours are 40 or less. 10. Repeat #9 displaying 'Overtime' if the hours are over 40, 'Regular' if the hours are 40, and 'Part Time' if the hours are less than 40. 11. List 6 relational operators used in an Excel If function. They represent equal to, less than, less than or equal to, greater than, greater than or equal to, and not equal to. 12. Cells C10 through C25 contain the name of items purchased. Cells D10 through D25 contain the value of items purchased. Cell C5 contains the sales tax percentage. Write the formula that would be used in cell E10 and copied through E25 to calculate the total price of each item including sales tax
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started