Please wait...

Accountancy Test - 10
Menu grid icon
Red alarm icon Time Left -
  • Question 1/10
    5 / -1
    Which feature automatically recalculates the whole worksheet if any change is made in a single cell ?
  • Question 2/10
    5 / -1
    By default, text data is ________ aligned in a cell.
  • Question 3/10
    5 / -1
    Each table appears as a spreadsheet grid called
  • Question 4/10
    5 / -1
    What is the address of the second cell in an MS Excel worksheet, considering cell numbering in a row-wise order?
  • Question 5/10
    5 / -1

    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)

  • Question 6/10
    5 / -1
    In a spreadsheet, everything is stored in little boxes called
  • Question 7/10
    5 / -1
    Which of the following symbols is used to enter a formula in an MS-Excel cell?
  • Question 8/10
    5 / -1

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

    =FLOOR(14, 4)

  • Question 9/10
    5 / -1

    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 _____.

  • Question 10/10
    5 / -1
    Which of the following programs enables you to calculate numbers related to rows and columns?
Close button icon
User Profile
-

Answered - 0

Un-answered - 10

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
Mockers logo Get latest Exam Updates
& Study Material Alerts!
No, Thanks
Arrow pointer icon
Click on Allow to receive notifications
Notification bell icon ×
Open Now