✓ Board-verified
Accountancy · 2025 · 4 marks
CBSE 2025 · Region 2 · Set 3 · Q33
What is data formatting ? What tools are used to format data ?ORExplain 'ROUND function of Excel.
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 f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…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…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.