Maill LTE 5:57 PM * 43% + a mycourses.msstate.edu Mississippi State University D

Question

Maill LTE 5:57 PM * 43% + a mycourses.msstate.edu Mississippi State University Department of Civil and Environmental Engineering Fall 2018 CE1001 Intro to Civil and Environmental Engineering Excel Assignment 2 Microsoft Excel: Formulas, Charts & Formatting Directions: Complete the following reading assignments and assigned problems from the Microsoft Excel book. In Excel, place each problem on a new sheet and label that sheet with the problem number. Type the instructions/given information of each problem on Excel Spreadsheet using a text box. Include all subheadings (a., b., etc) for each problem. For subheadings that do not require a numerical answer just write "Completed". Be sure to include all calculations. Your answers will be graded AS WELL AS your tabular calculations and format. Remember the CEE Dept. homework format (add a Header). Submit your work through MyCourses as an Excel file, not a Word File. Title the file ..Your Net ID . CE 1001-2018-Excel Assignment #". Where needed, be sure to properly label tables, graphs, axes, and display units. Review the PowerPoint Slides on Assignment (Formulas, Charts & Formatting) Read Chapters: 2 and 7 Task 1: i. Reconstruct the worksheet containing student exam scores as shown below in Excel: FRAGE aArrange the students alphabetically by name.

Explanation / Answer

sum formula in excel: - =SUM(B2:D2) and mouse hover on E column plus symbol will appers drag down up to total rows

Average : - =AVERAGE(B2:B8) and mouse hover on E column plus symbol will appers drag down up to total columns

Sort the students : Goto Data Section in the toolbar

step2:click on sort

step3: select sort by column name student

stpe4:select sorty values

step5:click ok

data will be sorted

Student Exam1 Exam2 Final Exam OverallScore Davis 95 73 89 257 Graham 72 76 69 217 Jones 98 95 89 282 Meyers 55 62 75 192 Richardson 92 55 65 212 Thomas 91 77 77 245 Williams 66 59 61 186 AVERAGE 81.28571 71 75 227.2857143

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.