Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help im not the best at excel. begin{tabular}{|c|c|} hline 1. & begin{tabular}{l} Adjust column width until all column headers are correctly visible (don't waste
Help im not the best at excel.
\begin{tabular}{|c|c|} \hline 1. & \begin{tabular}{l} Adjust column width until all column headers are correctly visible (don't \\ waste unnecessary space in the column width). \end{tabular} \\ \hline 2. & \begin{tabular}{l} Likewise adjust row height for row's data to be correctly visible And don't \\ waste unnecessary space in the row height. Every row's height should be \\ the same \end{tabular} \\ \hline 3. & \begin{tabular}{l} Insert and copy Test2's Column data now in column O to be in between \\ Test1 (Column G) and Test3 (Column H). Once Test 2 is in it's proper spot \\ between Test1 and Test3 delete everything to do with Test2 from column \\ O. Column O should be blank once done with this step. \end{tabular} \\ \hline 4. & \begin{tabular}{l} Add your name (first name only) as a last entry at the bottom of the list of \\ students and give yourself 3 different test grades (of your liking). Decide \\ weather you have the Prerequis ite or not and fil that data in column J. \end{tabular} \\ \hline 5. & Find out the Average for each student. Round off the Average test grades \\ \hline 6. & \begin{tabular}{l} Highlight cells C14, D14, and E14, right-click your mouse, select format \\ cells, Choose the Alignment tab, in the "Text control" section Click the \\ Merge cells check box, click OK. Font type should be Calibri and Size \\ should be 16. \end{tabular} \\ \hline 7. & \begin{tabular}{l} You know what to do for "Number of entered grades". Follow steps on \\ above \#6 step. \end{tabular} \\ \hline 8. & Insert two rows below your entered name and grades row. \\ \hline 9. & \begin{tabular}{l} In column L figure out if the students passed. The passing grade will be 70 \\ for our Final test question. If the student had an average grade of 70 or \\ greater then Pass should be marked for that student in its corresponding \\ cell in column L otherwise Fail should be marked. \end{tabular} \\ \hline 10. & \begin{tabular}{l} In column K the student will Pass if the student has an average of 70 or \\ greater AND has met the prerequisite for the class (there should be a yes \\ for that student in the corresponding J cell for that student) otherwise if \\ the student is missing any of those conditions the student should get a \\ mark of Fail \end{tabular} \\ \hline 11. & \begin{tabular}{l} In all formula cases fill the formula (once correct) down the column to all \\ entered stud ents. \end{tabular} \\ \hline 12. & \begin{tabular}{l} Insert a column chart to reflect the student's name and grade \\ information. Change Title to a proper Title (fo llow nam ing convention) \end{tabular} \\ \hline 13. & \begin{tabular}{l} Listed formulas on column A are there to assist you in working through \\ this question. You may or may not need all of them. Once done, delete \\ all... Column A should be containing your student data. Copy all and paste \\ beginning at cell A1. \end{tabular} \\ \hline 14. & Delete sheet 3 and rename Sheet1 = Formulas; Sheet2 = Query \\ \hline 15. & \begin{tabular}{l} For a Bonus +2-points... Center column headers and student names. Add \\ font color (2) of them and you may change the font type. Make Column \\ headers Bold and Underlined. \end{tabular} \\ \hline \end{tabular}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