Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribedimage text in transcribed

\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

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

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions