to activate the previous cell in a pre-selected range, pressa. the Alt keyb. the Tab keyc. the Enter keyd. none of aboveWhen the formula bar is activated, you can seea. The Edit Formula buttonb. The Cancel buttonc. The Enter buttond. All of aboveIn a worksheet you can press Shift+Space to select entirea. Worksheetb. Rowc. Columnd. a, b, and cwhen you print preview a worksheeta. … [Read more...]

101. You can zoom a worksheet a. With the mouse pointer in Print Preview b. With the zoom button on the Print Preview toolbar c. With the Zoom command on the view menu d. All of the above 102. You can not link Excel worksheet data to a Word document a. With the right drag method b. With a hyperlink c. With the copy and paste special commands … [Read more...]

91. 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 92. A worksheet range is a a. A command used for data modeling b. A range of values such as from 23 to 234 c. A group of cells d. A group of … [Read more...]

81. Which of the following is an absolute cell reference? a. !A!1 b. $A$1 c. #a#1 d. A1 82. What symbol is used before a number to make it a label? a. “ (quote) b. = (equal) c. _ (underscore) d. ‘ (apostrophe) 83. Which symbol must all formula begin with? a. = b. + c. ( d. 84. Which of the following formulas is not … [Read more...]

71. Documentation should include a. Destination and users of the output data b. Source of input data c. Information on the purpose of the workbook d. All of the above 72. Files created with Lotus 1-2-3 have an extension a. DOC b. XLS c. 123 d. WK1 73. To delete an embedded objects, first a. Double click the object b. Select the … [Read more...]