MS Excel MCQs

Which function will you use to enter current time in a woksheet cell ?

1. =time()
2. =nowtime()
3. =now()
4. =currentTime()

how many sheets are there in the Excel workbook by default?

1. 2
2. 3
3. 4
4. 5

When a row of data is to be converted into columns

1. Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK
2. Copy the cells in column then choose Paste Special, then click Transpose and OK
3. Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK
4. none

Comments can be added to cells using ____

1. Data > Comments
2. Home > Comments
3. Insert > Comment
4. none

In a computer spreadsheet, each cell contains a?

1. Label
2. value
3. formula
4. *All of these*

in MS excel 2016, which of the following can be used to split windows into two?

1. Format > Window
2. View > Window> Spilt
3. Window > Spilt
4. View > Spilt

What is active cell in MS-Excel ______?

1. Rectangular box
2. Pointer
3. Nearing point of view
4. None of the above

You can use the formula palette to

1. Enter assumptions data
2. Create and edit formula containing functions
3. Format cells containing numbers
4. none

In MS Excel to add two cells (A1 and A2) togather you use the following formula

1. = add(A1+A2)
2. = A1+A2
3. = together A1:A2
4. None of these