Question

How many number styles are provided by MS EXCEL 2010

Answer 1

With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.

A Style can consist of settings for up to six different attributes −

Number format

Font (type, size, and color)

Alignment (vertical and horizontal)

Borders

Pattern

Protection (locked and hidden)

Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically

Answer 2

GENERAL

NUMBER

CURRENCY

ACCOUNTING

DATE

TIME

PERCENTAGE

FRACTION

SCIENTIFIC

TEXT

SPECIAL

CUSTOM