1. Each excel file is
called a workbook because :
(a) It can contain text and data
(b) It can be modified
(c) It can contain many sheets including worksheets and chart sheets
(d) You have to work hard to create it
(e) None of these
Ans : (c)
2. Which types of
charts can excel produce?
(a) Line graphs and pie charts only
(b) Only line graphs
(c) Bar charts, line graphs and pie charts
(d) Bar charts and line graphs only
(e) None of these
Ans : (c)
3. How are data
organized in a spreadsheet?
(a) Lines and spaces
(b) Layers and planes
(c) Rows and Columns
(d) Height and width
(e) None of these
Ans : (c)
4. What does the
VLOOKUP function do?
(a) Looks up text that contain ‘v’
(b) Checks whether text is the same in one cell as in the next
(c) Finds related records
(d) All of these
(e) None of these
Ans : (c)
5. Gridlines :
(a) May be turned off for display but turned on for printing
(b) May be turned on or off or printing
(c) The be turned off for display and printing
(d) All of these
(e) None of these
Ans : (d)
6. You can print only
an embedded chart by
(a) Moving the chart to a chart sheet before you print.
(b) Formatting the chart before you print
(c) Selecting the chart before you print
(d) Both (a) and (c)
(e) None of these
Ans : (d)
7. Which of the
following is a correct order of precedence in a formula calculation?
(a) Multiplication and division, exponential positive and negative value
(b) Multiplication and division, positive and negative values, addition and subtraction
(c) Addition and subtraction, positive and negative values, exponentiation
(d) All of these
(e) None of these
Ans : (e)
8. A function inside
another function is called a function
(a) Nested
(b) Round
(c) Sum
(d) Text
(e) None of these
Ans : (a)
9. How should you
print a selected area of a worksheet, if you’ll want to print a different area
next time?
(a) On the file menu, point to print area, and then click set print area.
(b) On the file menu, click print, and then click selection under print what
(c) On the view menu, click custom views, then click add
(d) All of these
(e) None of these
Ans : (b)
10. Your German
supplier still invoices for parts in deutsche marks.
(a) On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
(b) On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
(c) Apply a selected background color
(d) All of these
(e) None of these
Ans : (b)
11. Which function
calculates your monthly mortgage payment?
(a) PMT (payments)
(b) NPER (number of periods)
(c) PV (present value)
(d) All of these
(e) None of these
Ans : (a)
12. If you are
working in English (US), Chinese or Japanese, Excel 2002 can speak data as you
enter it, to help you verify accuracy. How do you activate this feature?
(a) Point to speech on the tools menu, and then click show text to speech toolbar.
(b) Click validation on the data menu
(c) Point to speech on the tools menu, and then click speech recognition
(d) All of these
(e) None of these
Ans : (a)
13. Which of the
following methods cannot be used to enter data in a cell?
(a) Pressing an arrow key
(b) Pressing the tab key
(c) Pressing the Esc key
(d) Clicking the enter button to the formula bar
(e) None of these
Ans : (c)
14. Which of the
following will not set text in selected cells to italics?
(a) Pressing Ctrl + I on the keyboard
(b) Using the Tools – Wizard – Web Form menu item
(c) Using the Format – Cells – Font menu item
(d) All of these
(e) None of these
Ans : (b)
15. Which of the
following methods cannot be used to edit the content of cell?
(a) Pressing the Alt key
(b) Clicking the formula bar
(c) Pressing F2
(d) Double clicking the cell
(e) None of these
Ans : (a)
16. To insert three
columns between columns D and E you would :
(a) Select column D
(b) Select column E
(c) Select columns E, F and G
(d) Select columns D, E, and F
(e) None of these
Ans : (b)
17. To enter
worksheet titles across a range of cell, you must :
(a) Select the cells containing the title text and use the fill handle to center the text across a range of cells
(b) Widen the columns
(c) Select the cells containing the title text and use the fill handle to center the text across a range of cells
(d) Widen the column
(e) None of these
Ans : (a)
18. When integrating
MS-Word and Excel, Word is usually the :
(a) Server
(b) Source
(c) Client
(d) All of these
(e) None of these
Ans : (c)
19. Charts tips can :
(a) Show the formatting of a data label
(b) Show the name of a data series
(c) Show the value of data point
(d) Both (b) and (c)
(e) None of these
Ans : (b)
20. The Name box :
(a) Shows the location of the previously active cell
(b) Appears the left of the formula bar
(c) Appears below the status bar
(d) Appears below the menu bar
(e) None of these
Ans : (b)
21. How do you change
column width to fit the contents?
(a) Single-click the boundary to the left to the column heading
(b) Double click the boundary to the right of the column heading
(c) Press Alt and single click anywhere in the column
(d) All of these
(e) None of these
Ans : (b)
22. When you work
with large worksheets, you may need to :
(a) size the worksheet to fit on the specific number of pages
(b) add and remove page breaks
(c) specify only certain print areas
(d) all of these
(e) None of these
Ans : (d)
23. Hyperlinks cannot
be :
(a) Special shapes like stars and banners
(b) Drawing objects like rectangles ovals
(c) Pictures
(d) All can be hyperlinks
(e) None of these
Ans : (d)
24. You can use the
horizontal and vertical scroll bars to :
(a) Split a worksheet into two panes
(b) View different rows and columns
(c) Edit the contents of a cell
(d) View different worksheets
(e) None of these
Ans : (b)
25. What do we call a
computer program that organizes data in rows and columns of cells? You might
use this type of program to keep a record of the money you earned moving lawns
over the summer.
(a) Spreadsheet program
(b) Database program
(c) Word processor program
(d) Desktop publisher program
(e) None of these
Ans : (a)
No comments:
Post a Comment