MS Excel MCQs

32. The auto calculate feature

A. Can only add values in a range of cells
B. Provides a quick way to view the result of an arithmetic operation on a range of cells
C. Automatically creates formulas and adds them to a worksheet
D. A and C
✅ The correct answer is option B.

39. You can use drag-and-drop to embed excel worksheet data in a word document

A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above
✅ The correct answer is option A.

40. Rounding errors can occur

A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
✅ The correct answer is option A.

Scroll to Top