Application Software - University of Kentucky：应用软件-肯塔基大学.pptVIP

* A contiguous range is single rectangular block of cells. A non-contiguous range consists of two or more separate non-adjacent ranges. The cells within a range are specified by indicating the diagonally opposite corners, typically the upper-left and lower-right corners of the rectangle. For example, B4:I4. is a range of cells starting with cell B4 and ending with cell I4. * Even though there are multiple ways to edit data in a cell, most users will select one method and stay with it. * * The basic statistical functions include the following: AVERAGE calculates the average of a range of numbers. MIN calculates the minimum value in a range. MAX calculates the maximum value in a range. COUNT counts the number of values within a range. MEDIAN finds the midpoint value in a range. COUNTA function counts the number of cells in a range that are not blank. * The NOW function also updates automatically. The Function AutoComplete will provide a drop-down list of known options from which to select. * The user clicks on the cell and uses the fill handle to repeat the content. * When you copy a formula containing a relative cell reference over multiple columns, the column letter changes. When you copy a formula containing relative cell reference down multiple rows, the row number changes. Mixed cell reference is a formula that contains both relative and absolute cell references. Remember, formulas should always be based on cell references. * The tilde (~) key is created by holding down the Shift key while pressing the button to the left of the number 1 on the keyboard. To toggle back to displaying values, simply press the Ctrl key followed the tilde key again. * * To freeze columns and rows: 1. Select the cell below the row(s) and to the right of the column(s) you want to freeze. 2. Click the View tab and click Freeze Panes in the Window group. You can freeze both rows and columns or just the top row or the first column. You can also unfreeze the rows and/or c