1970. Which of the cell pointer indicates you that you can make selection?
A. Doctor’s symbol (Big Plus)
B. Small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
✅ The correct answer is option A.
1973. Which of the cell pointer indicates that you can fill series?
A. Doctor’s symbol (Big Plus)
B. Small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
✅ The correct answer is option B.
1976. Which is not the function of “Edit, Clear” command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
✅ The correct answer is option C.
1979. Which of the cell pointer indicate that you can move the content to other cell?
A. Doctor’s symbol (Big Plus)
B. Small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
✅ The correct answer is option C.
1983. MS Excel provides the default value for step in Fill Series dialog box
A. 0
B. 1
C. 5
D. 10
✅ The correct answer is option B.
1986. The Name box on to the left of formula bar
A. Shows the name of workbook currently working on
B. Shows the name of worksheet currently working on
C. Shows the name of cell or range currently working on
D. None of above
✅ The correct answer is option C.
1989. The shortcut key Ctrl + R is used in Excel to
A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above
✅ The correct answer is option C.
1992. The Delete key of keyboard is assigned to which command in Excel?
A. Edit > Clear > Contents
B. Edit > Clear > All
C. Edit > Delete
D. All of above
✅ The correct answer is option A.
1994. What will be the output if you format the cell containing 5,436.8 as ‘#,##0.00’ ?
A. 5430
B. 5436.80
C. 5436.8
D. 6.8
✅ The correct answer is option B.
1996. Where can you change automatic or manual calculation mode in Excel?
A. Double CAL indicator on status bar
B. Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button
C. Both of above
D. None of above
✅ The correct answer is option B.