Top 1000+ Solved Important Computer MCQs For Competitive Exams part-1 MCQ Questions Answer
Q. 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
Q. A function inside another function is called a function
a. Nested
b. Round
c. Sum
d. Text
e. None of these
Q. 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 are
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
Q. 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
Q. 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
Q. 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
Q. 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
Q. 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
Q. 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
Q. To enter worksheet s 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
Q. When integrating MS-Word and Excel,Word is usually the :
a. Server
b. Source
c. Client
d. All of these
e. None of these
Q. 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
Q. 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
Q. 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
Q. 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