1.A worksheet range is?
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 worksheets
2. Which of the following will return the Maximum value of the cells between C19 to C29 in MS Excel?
A. =Maximum(C19:C29) B. =Max(C19:C29) C. =Max(C19 to C29) D. MS Excel can’t do this task.
3. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Pressing Ctrl +Home B. Pressing Home C. Pressing Shift + Home D. Pressing Alt + Home
4. Which of the following symbols is used to write a formula in MS Excel?
A. = B. + C. ( D. @
5. To select a column the easiest method is to……
A. Double click any cell in the column B. Drag from the top cell in the column to the last cell in the column C. Click the column heading D. Click the column label
6. When you put a formula in a cell and the cell displays ####### ? It means -
A. Excel does not recognize text contained in the Formula
B. A Cell reference is invalid C. Contents cannot be displayed correctly as the column is narrow
D. Invalid Column
7. A typical MS Excel worksheet has_________ number of columns.
A. 128 B. 16834 C. 512 D. 1024
8. When you enter a formula in a cell and the cell displays #NAME? It means -
A. Excel does not recognize the text contained in the Formula B. Invalid Column
C. Contents cannot be displayed correctly as the column is narrow D. A cell reference is invalid
9. In MS Excel which of the following is not an example of a value?
A. 350 B. May 10, 2001 C. 57% D. Serial Number 50771
10. All worksheet formula in MS Excel ‒
A. Manipulate values B. Manipulate labels C. Return a formula result D. Use the addition operator
11. Which of the following is spreadsheet software?
a.MS- Word b. MS- Excel c. Microsoft Internet Explorer d. Microsoft Windows Explorer
12. You can edit a cell by ‒ a.Clicking the Edit button b. Double clicking the cell to edit it in-place √ c.Selecting Edit>Edit Cell from the menu
d. None of above
13. To hold row and column titles in place so that they do not scroll away from view when scrolling a Excel worksheet, we make use of – Freeze panes command
14. Getting data from a cell located in a different sheet is called …
a.Accessing b.Referencing √ c.Functioning d.Updating
15. When you copy a formula
2. Which of the following will return the Maximum value of the cells between C19 to C29 in MS Excel?
A. =Maximum(C19:C29) B. =Max(C19:C29) C. =Max(C19 to C29) D. MS Excel can’t do this task.
3. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Pressing Ctrl +Home B. Pressing Home C. Pressing Shift + Home D. Pressing Alt + Home
4. Which of the following symbols is used to write a formula in MS Excel?
A. = B. + C. ( D. @
5. To select a column the easiest method is to……
A. Double click any cell in the column B. Drag from the top cell in the column to the last cell in the column C. Click the column heading D. Click the column label
6. When you put a formula in a cell and the cell displays ####### ? It means -
A. Excel does not recognize text contained in the Formula
B. A Cell reference is invalid C. Contents cannot be displayed correctly as the column is narrow
D. Invalid Column
7. A typical MS Excel worksheet has_________ number of columns.
A. 128 B. 16834 C. 512 D. 1024
8. When you enter a formula in a cell and the cell displays #NAME? It means -
A. Excel does not recognize the text contained in the Formula B. Invalid Column
C. Contents cannot be displayed correctly as the column is narrow D. A cell reference is invalid
9. In MS Excel which of the following is not an example of a value?
A. 350 B. May 10, 2001 C. 57% D. Serial Number 50771
10. All worksheet formula in MS Excel ‒
A. Manipulate values B. Manipulate labels C. Return a formula result D. Use the addition operator
11. Which of the following is spreadsheet software?
a.MS- Word b. MS- Excel c. Microsoft Internet Explorer d. Microsoft Windows Explorer
12. You can edit a cell by ‒ a.Clicking the Edit button b. Double clicking the cell to edit it in-place √ c.Selecting Edit>Edit Cell from the menu
d. None of above
13. To hold row and column titles in place so that they do not scroll away from view when scrolling a Excel worksheet, we make use of – Freeze panes command
14. Getting data from a cell located in a different sheet is called …
a.Accessing b.Referencing √ c.Functioning d.Updating
15. When you copy a formula
1.Excel erases the original copy of the formula
2.Excel adjusts cell references in the newly copied
formula √
3.Excel adjusts absolute cell references
4.Excel doesn’t adjust relative cell references
Tags
Fundamental