MS Excel and PPT

Excel (1) To refer to a range, two cell addresses will be used, separated by a colon (:). The first cell is the top leftmost cell in the range, and the second is the bottom rightmost cell. (2) There are occasions when the content is too long to be displayed in a cell. A convenient way is to apply AutoFit to columns. For example, select columns A to E by dragging from column heading A to E. Click Format in the Cells group, followed by AutoFit Column Width to automatically adjust the columns' width such that all text are visible. (3) Dollar sign ($) is used for absolute cell reference. Whenever a dollar sign is added, the value after the sign will be fixed and no matter where that formula is copied to, that value will remain unchanged. Powerpoint (1) You can adjust the heading level of a point with the [Tab] key. That means you can either promote or demote a point to your desired heading level. (2) Click to select any one of the three objects Press and hold the [Ctrl] key Click to select the other two objects Right-click on the selection Choose Group, then choose Group again in the sub-menu (3) changes you made in the slide master do not override the changes you made in individual slides