计算机excel技巧（Computer Excel skills）.docVIP

计算机excel技巧（Computer Excel skills） 91. (1) use the function to calculate the average score of each gate, and ask to keep two decimal places. The cursor on the average number of the first B14 -- insert - function (or directly click on the toolbar button function) -- common function -- AVERAGE -- determine - in Number1 input B3:B13 (the default is B3:B13 if you do not need to input) - sure Move the mouse to the lower right corner of the check box to make it a solid cross - hold down the left mouse button and drag to the right - E14 - release Select the average number of the line - right - - set the cell format - Digital - - value - - the number of decimal places - 2 - to determine (2) the results will be larger or equal to 85 in bold and double underline. The selected subjects -- format -- conditional formatting -- in the pop-up dialog box -- the cell value is greater than or equal to - - behind a 85 - input format -- bold -- double underline -- -- Determination of determination 92. (1) calculate the value by formula, and format the data in the same format as the price Click on the edit bar = enter C2*D2 in the edit bar - OK Move the mouse to the lower right corner of the black box to make a solid cross - hold the left button and drag it down to the end (2) copy the data of the title worksheet 1995-12-31 to Sheet2, and rename Sheet2 to end of 1995 data. Select all data on the date 1995-12-31 - copy - click Sheet2 - paste Move the mouse over the Sheet2 - right - Rename - enter the data at the end of 1995 93. (1) set the title to boldface, word 24, and merge and center from C1 to H1. With C1 H1 to select black - click in the toolbar button font, and middle name -- set in the toolbar (2) set all numerical formats to currency, thousandths, and leave two decimal places. Select the cells of all numbers -- right in the selected area -- set the cell format -- currency -- the number of decimal places -- 2 -- make sure 94. (1) of the amount column width is set to 15. Select the