Modify the text in the title.
Cell A1.
Text "Math 1080 - Section 3 Assignments"
Insert data from a text file.
Cell A1.
File source Autumn.txt
Tab-delimited
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows Horizontal Axis Labels: "IDs" column in table Series 1: "Zero Scores" column in table.
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Add conditional formatting.
Color Scales: Green –White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Formula Find the average score of all student ids without a zero homework score. Cell L2 Use Function AVERAGEIF Range F7:F29 Criteria: "0" Average_range: "Homework"
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
Add a header and the date for each of the columns (assignments) in the range.
Cell B2.
Text "Date".
Cell Range C2: S2
Text: "22-Aug, 29-Aug,