List of top Accountancy Questions on Spreadsheet

Explain the term 'cell referencing' in an electronic spreadsheet.

Null value is the special value which represents:

The software of computerised accounting system can be used for any size of business and type of organization as it enables changing the volume of data processing in tune with the change in the size of business. Which feature of Computerised Accounting System is being highlighted in above lines?

A piece of information shown in a graph which is assigned to the data series is known as:

State the advantages of ‘Pivot Table’ report.

Name the error which occurs when Excel doesn’t recognize a ‘Text’ formula. Give any two solutions to correct it.

What is data formatting? What tools are used to format data?

Explain ‘ROUND’ function of Excel.

Which function can be used as an alternate to the ‘IF’ function for elaborate test and why? Give the meaning of its types with their syntax.