Text:
This displays cell as normal text.
•
Special:
This is special formats of cell like Zip code, Phone Number
•
Custom:
You can use custom format by using this.
Formatting a Worksheet
Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed
pages in MS Excel have the same margins. You can’t specify different margins for different
pages.
You can set margins by various ways as below
Manual for Laboratory Practices
95
• Choose Page
Layout » Page Setup » Margins drop-down list, you can
select Normal,
Wide, Narrow, or the custom Setting.
Figure 16 Formatting a Worksheet Margin
These options are also available when you choose
File » Print
Figure 17. Formatting a Worksheet Margin
If none of these settings does the job, choose Custom Margins to display the Margins tab of
the Page Setup dialog box, as shown below.
Center on Page
By default, Excel aligns the printed page at the top and left margins. If you want the output to
be centered vertically or horizontally, select the appropriate check box in the Center on Page
section of the Margins tab as shown in above screenshot.
Introduction To Computer Science
96
Figure 18. Formatting a Worksheet Margin
Working with Formula
Formulas are the lifeblood of worksheets.Without formula worksheet will be just simple tabular
representation of data. A formula consists of special code which is entered into a cell. It
performs some calculations and returns a result, which is displayed in the cell.
Formulas use a variety of operators and worksheet functions to work with values and text. The
values and text used in formulas can be located in other cells, which makes changing data easy
and gives worksheets their dynamic nature. For example, you can quickly change the data in a
worksheet and formulas works.
Elements of Formulas:
A formula can consist of any of these elements:
• Mathematical operators, such as +(for addition) and *(for multiplication)
Creating Formula:
For creating formula you need to type in Formula Bar.Formula begins with ‘=’ sign. When
building formulas manually, you can either type in the cell addresses or you can point to
them in the worksheet. Using the Pointing method to supply the cell addresses for formulas
is often easier and more powerful method of formula building. When you are using built-in
functions, you click the cell or drag through the cell range that you want used when defining
the function’s arguments in the Function Arguments dialog box.See below screenshot.
|
