How I can find Correct Format for Excel Formulas

64. How to Find the Correct Format for Excel Formulas
65. How I can Easily Insert Rows or Columns in Excel
66. How to Previewing Charts in Grayscale

64. Find the Correct Format for Excel Formulas
You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007, start by typing the first few characters of the formula (for example, an equal sign and then a letter) to view a list of available formulas. Excel 2007 makes it easy to see all the available types of formulas; the enhanced tooltips in the 2007 Office system provide a detailed explanation of each formula.

65. Easily Insert Rows or Columns in Excel
With a Microsoft Office Excel document open, you can insert extra rows and columns by holding down the SHIFT key while you grab a cell by its handle and drag it. Excel will insert as many cells as needed

66. Previewing Charts in Grayscale
You can preview your charts in Microsoft Office Excel before you print.
1. Open the file that you want to print, click the Office button, point to Print, and then click Print
Preview.
2. On the Print Preview ribbon, click Page Setup, click Sheet, and then click Black and white. The
preview will be in grayscale so that you can evaluate whether the contrast is good enough to distinguish the lines, bars, and columns.

0 Comments: