Home Board Paper Solutions Text Book Solutions Articles NCERT Exemplar Solutions NCERT Books

# Class 12th Accountancy 2017 Set1 Delhi Board Paper Solution

Question 23

## Explain the following formatting tools with example :(i) Number formatting(ii) Currency(iii) Percentage(iv) Dates

(i) Number Formatting: This feature allows you to format a cell or range based on certain criteria. It changes the appearance of data and makes it easier to read and understand important numeric information.

(ii) Currency: Excel is equipped to incorporate various currency signs in pictorial form for dollar it uses \$ similarly for other currencies also. If the user instructs the use of the format it will assign a currency format along with entry.

(iii) Percentage: If we enter a value representing a percentage as a whole number followed by the percentage sign without any decimal places, Excel assigns to the cell the percentage format that follows the pattern along with the entry.

(iv) Dates: If we enter a date (dates are values, too) that follows one of the built in excel formats, such as 11-12-2017 or 11-Dec-2017 the program assigns a date format that follows the pattern of the date.