Basic operation of Office Excel

A key summary, select all points and Total score column, with shortcut key alt+=, you can achieve the sum. Figure:

Delete duplicate records, copy the records, open the data column, and select Delete duplicates. Effect as shown:

Method/Step 2

Repeat count, first the cursor select a blank bar, select the data bar, open the merge calculation

Select the first item "Count", the second selection area, use the mouse to draw the computed area, select the first row, the leftmost column, OK.

Get date format data, select the data, right-click on, select Set cell, select Number-General, as shown:

Method/Step 3

Mark failed. Select the Fraction area, select Start, open Find and select, open Find, as shown

Input *, click to find all, detected data, click Values arranged in ascending order, then select to 59 select the first score 41 press SHIFT, and then select all the failing grades. Turn this dialog box off and select the A (red) icon to turn red for failing grades. As shown