Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

One of the benefits of Excel is the ability to use formulas and functions. 1. Discuss the differences between formulas and functions. Pick a function

image text in transcribed

One of the benefits of Excel is the ability to use formulas and functions. 1. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Review your classmates' posts to make sure that you're not duplicating formulas or functions already discussed. Using the following scenarios, discuss how you would apply the Excel function:s or create a formula to solve the scenario. Be specific! o You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. o You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50. o You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Commercial Printing IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304133753, 978-1304133755

More Books

Students also viewed these Accounting questions