211. Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 0.57
D. Serial Number 50771
✅ The correct answer is option D.
MS Office
212. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
✅ The correct answer is option D.
213. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
✅ The correct answer is option B.
214. All worksheet formula
A. Manipulate values
B. Manipulate labels
C. Return a formula result
D. Use the addition operator
✅ The correct answer is option C.
215. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
✅ The correct answer is option B.
216. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
✅ The correct answer is option C.
217. When you want to insert a blank embedded excel object in a word document you can
A. Click the object command on the insert menu
B. Click the office links button on the standard toolbar
C. Click the create worksheet button on the formatting toolbar
D. Click the import excel command on the file menu
✅ The correct answer is option A.
218. You can select a single range of cells by
A. 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
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
✅ The correct answer is option D.
219. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl + Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
✅ The correct answer is option A.
220. What symbol is used before a number to make it a label?
A. ” ( quote )
B. = ( equal )
C. _ ( underscore )
D. ‘ ( apostrophe )
✅ The correct answer is option D.