Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
21. Documentation should include
- destination and users of the output data
- source of input data
- a printout of the worksheets in the workbook
- all of above
22. Which of the following is not a worksheet design criterion?
- efficiency
- auditibility
- description
- clarity
23. To center worksheet titles across a range of cells, you must
- select the cells containing the title text and use the fill handle to center the text across a range of cells
- widen the columns
- select the cells with the comma style
- none of the above
24. You can use the formula palette to
- format cells containing numbers
- create and edit formulas containing functions
- enter assumptions data
- copy a range of cells
25. To active the previous cell in a preselected range, press
- the ALT key
- the TAB key
- the ENTER key
- none of the above
26. You can select a single range of cells by
- clicking the upper-left cell in a group of cells and then pressing the SHIFT key while clicking the lower-right cell in a group of cells
- pressing the CTRL key while dragging over the desired cells
- pressing the SHIFT key and an arrow key
- dragging over the desired cells
27. Rounding errors can occur
- when you use multiplication, division, or exponentiation in a formula
- when you use addition and subtraction in a formula
- because excel uses hidden decimal places in computation
- none of the above
28. The AutoCalculate feature
- can only add values in a range of cells
- provides a quick way to view the results of an arithmetic operation on a range of cells
- automatically creates formulas and adds them to a worksheet
- all of above
29. Which of the following is a correct order of precedence in a formula calculation?
- multiplication and division, exponentiation, positive and negative values
- multiplication and division, positive and negative values, addition and subtraction
- addition and subtraction, positive and negative values, exponentiation
- none of the above