✓ Board-verified
Accountancy · 2025 · 4 marks
CBSE 2025 · Region 2 · Set 2 · Q33
What is data formatting? What tools are used to format data?
What is data formatting ? What tools are used to format data ?
OR
Explain 'ROUND function of Excel.
Marking-scheme solution
Presenting a data in a form that it becomes easier to read and understand information is
called Data formatting.
Formatting tools are:
(i)
Number formatting It includes adding percentages symbol (%) commas ('), decimal places (.)
etc. data, time, specific values as well as some special formats to a spreadsheet.
(ii)
Special format category: Data (special numbers such as phone numbers, zip codes and social
security numbers which require different format in a certain way) from the category option we
select. Special and from corresponding drop-down box under the locale we select format special
numbers. Appropriate to specific countries.
(iii)
Changing cell colours.
(iv)
Creating custom cell borders.
Q. (b) Explain ‘ROUND’ function……..
Ans.
ROUND is the function to round off a number to specified number of digits the syntax of the
function is ROUND (number, Num_digits) Where
Number is the number to round (preferably fractional number) Num digits specifies the number
of digits to round the Number.
There may be some different situations for Num_digits as follows:
(a)
If Num_digits is greater than $\displaystyle 0$ (Zero) then number is rounded to the specified number of
decimal places.
If Num digits is $\displaystyle 0$, then number is rounded to the nearest digit.
(c)
If Num digits is less than $\displaystyle 0$ than number is rounded to the left of the decimal point.
More from Spreadsheet
- Explain the two syntax forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.