Quiz excel 2010 computer quiz

The quiz excel 2010 computer quiz is important for all PSC exams of both assistant and full computer operators. The Public Service Commission (Lok-Sewa Aayog) has also asked up to 12 questions from ms-excel. The excel quiz questions and answers are so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-20

1. A function inside another function is called a ….. function.
   1.   Nested
   2.   Round
   3.   Sum
   4.   Text
2. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
   1.   On the file menu, point to print area, and then click set print area.
   2.   On the file menu, click print, and then click selection under print what
   3.   On the view menu, click custom views, then click add
   4.   All of above
3. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
   1.   On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
   2.   On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
   3.   Apply a selected background color
   4.   All of above
4. Which function calculates your monthly mortage payment?
   1.   PMT (payments)
   2.   NPER (number of periods)
   3.   PV (present value)
   4.   All of above
5. 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?
   1.   Point to speech on the tools menu, and then click show text to speech toolbar.
   2.   Click validation on the data menu
   3.   Point to speech on the tools menu, and then click speech recognition
   4.   All of above
6. Which of the following methods can not be used to enter data in a cell?
   1.   Pressing an arrow key
   2.   Pressing the tab key
   3.   Pressing the Esc key
   4.   Clicking the enter button to the formula bar
7. Which of the following will not set text in selected cells to italics?
   1.   Pressing Ctrl + I on the keyboard
   2.   Using the Tools – Wizard – Web Form menu item
   3.   Using the Format – Cells – Font menu item
   4.   None of the above
8. Which of the following methods cannot be used to edit the content of cell?
   1.   Pressing the Alt key
   2.   Clicking the formula bar
   3.   Pressing F2
   4.   Double clicking the cell
9. Which of the following is not an option in the spelling dialog box?
   1.   Edit
   2.   Ignore
   3.   Ignore all
   4.   Change
10. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
    1.   Edit
    2.   View
    3.   Format
    4.   Tools

 

Quiz excel 2010 for psc exam

This quiz excel 2010 computer quiz contains 10 multiple-choice questions (MCQs) from the Microsoft excel chapter. Each question contains four options in which one is the correct option. Select the correct option by clicking on the "?" button. Your score will appear together.

quiz-excel-2010-computer-quiz

We have published various quiz excel 2010 on excel quiz questions and answers, Fundamental of computer, windows HTML, MS-PowerPoint, Networking, and MS-Excel, etc. Hope you all like these quizzes. If there are mistakes in any question, please comment on the related post. Thanks!