Computer Archives

1971. Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit > Delete Sheet

B. Select the sheet then choose Format > Sheet > Hide

C. Both of above

D. None of above

✅ The correct answer is option A.

1972. Which of the following is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

✅ The correct answer is option B.

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.

1974. Which of the following option is not available in Paste Special dialog box?

A. Add

B. Subtract

C. Divide

D. SQRT

✅ The correct answer is option D.

1975. Which elements of a worksheet can be protected from accidental modification?

A. Contents

B. Objects

C. Scenarios

D. All of the above

✅ The correct answer is option D.

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.

1977. Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

✅ The correct answer is option D.

1978. In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

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

1980. How do you display current date and time in MS Excel?

A. Date ()

B. Today ()

C. Now ()

D. Time ()

✅ The correct answer is option C.