31. Comments can be added to cells using A. Edit > Comments B. Insert > Comments C. File > Comments D. View > Comments ✅ The correct answer is option B.
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.
33. To edit in an embedded excel worksheet object in a word document A. Use the excel menu bar and toolbars inside the word application B. Edit the hyperlink C. Edit the data in a excel source application D. Use the word menu bar and toolbars ✅ The correct answer is option A.
34. The Chart wizard term data categories refers to; A. A chart plot area B. A horizontal axis C. The organization of individual values with a chart’s data series D. The data range that supply chart data ✅ The correct answer is option B.
35. A typical worksheet has ________ number of columns. A. 128 B. 256 C. 1024 D. 16384 ✅ The correct answer is option D.
36. Status indicators are located on the A. Vertical scroll bar B. Horizontal scroll bar C. Formula bar D. Standard toolbar ✅ The correct answer is option C.
37. You want to track the progress of the stock market on a daily basis. Which type of chart should you use? A. Pie chart B. Row chart C. Line chart D. Column chart ✅ The correct answer is option C.
38. You can enter which types of data into worksheet cells? A. Labels, values, and formulas B. Labels and values but not formulas C. Values and formulas but not labels D. Formulas only ✅ The correct answer is option A.
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.