Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

mainly need help on Step on steps 4-9 Hint You are looking for the formula that gives you the initial current grade. Do a reference

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
mainly need help on Step on steps 4-9
Hint You are looking for the formula that gives you the initial current grade. Do a reference cell to that formula \begin{tabular}{|l|l|} \hline \begin{tabular}{l} Step \\ \hline 9 \end{tabular} & Do a 2-variable data table with the final exam grade and the exira credit points that would show the range of grades. \\ \hline Hint You will have to figure out which is the row yariahle and which is the column variable. Remember that you are trying to find the INPUTS into the FORMULA that the reference cell (the one you put in A31) uses. [You should have used the C column final grade for the previous instructions, so the inputs would be in the C column.]) \\ \hline 10 & Change the format of the cells inside the data table to percent with zero decimal places. Apply the conditional format using the Green - Yellow - Red Color Scale. \\ \hline 11 Save and close WhatiF-DataTable-GoalSeek xilsx. Exit Excel. Submit your files as directed. \end{tabular} Hint You are looking for the formula that gives you the initial current grade. Do a reference cell to that formula \begin{tabular}{|l|l|} \hline \begin{tabular}{l} Step \\ \hline 9 \end{tabular} & Do a 2-variable data table with the final exam grade and the exira credit points that would show the range of grades. \\ \hline Hint You will have to figure out which is the row yariahle and which is the column variable. Remember that you are trying to find the INPUTS into the FORMULA that the reference cell (the one you put in A31) uses. [You should have used the C column final grade for the previous instructions, so the inputs would be in the C column.]) \\ \hline 10 & Change the format of the cells inside the data table to percent with zero decimal places. Apply the conditional format using the Green - Yellow - Red Color Scale. \\ \hline 11 Save and close WhatiF-DataTable-GoalSeek xilsx. Exit Excel. Submit your files as directed. \end{tabular}

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

A Comprehensive Guide To Information Security Management And Audit

Authors: Rajkumar Banoth, Gugulothu Narsimha, Aruna Kranthi Godishala

1st Edition

1032344431, 978-1032344430

More Books

Students also viewed these Accounting questions