Question 15 . Question : ( TCO 3 ) After creating a chart , you can change the chart type by using _____. Page Layout tab / Chart Options button Design tab / Change Chart Type button Data tab / Chart Changer tool You cannot change the chart . 1 . ============================================== BIS 155 Week 2 DQ Formulas and Functions
For more course tutorials visit www . uophelp . com
Home , Insert , and Page Layout . Chart , Type , and Formulas . Data , Review , and Data .
Question 15 . Question : ( TCO 3 ) After creating a chart , you can change the chart type by using _____. Page Layout tab / Chart Options button Design tab / Change Chart Type button Data tab / Chart Changer tool You cannot change the chart . 1 . ============================================== BIS 155 Week 2 DQ Formulas and Functions
For more course tutorials visit www . uophelp . com
One of the benefits of Excel is the ability to use formulas and functions . 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 / functions already discussed . Using the following scenarios , discuss how you would apply the Excel functions or create a formula to solve the scenario . Be specific ! You wish to calculate the commission on sales . The commission is 6 % on all sales that are at least 20 % above cost . 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 . 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 . Please feel free to add other , unique mathematical challenge questions to the discussion , and let us work together to figure out how you might calculate it .