Accountancy Tes...

Which feature automatically recalculates the whole worksheet if any change is made in a single cell ?

By default, text data is ________ aligned in a cell.

Each table appears as a spreadsheet grid called

What is the address of the second cell in an MS Excel worksheet, considering cell numbering in a row-wise order?

Let's say the contents of cells A1, A2, B1 and B2 are 0, 0, a, and 0 respectively. What will be the output of the following Microsoft Excel formula?

= COUNT (A1 : B2)

In a spreadsheet, everything is stored in little boxes called

Which of the following symbols is used to enter a formula in an MS-Excel cell?

What is the value of the following MS-Excel function?

=FLOOR(14, 4)

In a Microsoft Excel worksheet:

i) Cells A1 and A2 contain 6 and 4 respectively.

ii) Cells B1 and B2 contain 3 and 2 respectively.

iii) Cell A3 contains the formula =$A$1 + A2.

iv) The formula in cell A3 is copied to cell B3.

The value displayed in cell B3 will be _____.

Which of the following programs enables you to calculate numbers related to rows and columns?