电算化十套模拟 excel试题答案（Computerized ten sets of simulated excel questions answer）.docVIP

电算化十套模拟 excel试题答案（Computerized ten sets of simulated excel questions answer） Computerized ten sets of simulated Excel questions, answers.Txt occasionally to look back, otherwise, always in search of, and do not know what they lost. Men pay for lovers, women pay for relationships, men and women grab money for friends. Men love to see the woman with their eyes, the most vulnerable to beauty, women love to see the man, the most vulnerable to grief torture. Excel operation exercises Exercise 1 1, the cursor is positioned on any cell of the total row Insert rows, and then the data is filled in. 2, B7 is the active cell - click the Sigma on the toolbar when the formula appears in the cell enter, that is, the total number of months. B7 is the active cell, move the cursor to the lower right corner of the cell. When the cursor changes to +, hold the left key, drag to the right H7, and then get the total number of months. 3, the cursor in the H3 - click on the Toolbar FX - selected AVERAGE - -- if the formula bar in the dialog box right: (B3:G3) - range, to obtain the average number of color tv. - H# is the active cell. Move the cursor to the lower right corner of the cell. When the cursor becomes +, hold the left key, drag down to the H6, and then get the average number of the products. 4, select B3:H7 - Format cell number: value (thousandths, decimal 0) ok. 5, select (A1:H1) - click Format Bar merge and center tools; - - cells - font format: red, 20 pounds -- 2 to determine; - selected 7 - line format - align: vertical and horizontal center - to determine. 6, Tools Options View grid line, remove ? 7, select A2:H6 - Insert Chart Step 1 - column graphs and two-dimensional tables; - - next Step 2 - next step Step 3 - fill in the heading complete. Step 4 - insert table. Note: you can skip this step.) Change the coordinate 0 to - method: The cursor pointing to the chart in the 0 - right click - -- digital format axis - select custom - _