Excel quiz questions with answers pdf | computer quiz

The excel quiz questions with answers pdf computer quiz are 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 Microsoft excel quiz questions and answers are so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-21

1. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
   1.   Edit
   2.   Format
   3.   Tools
   4.   Data
2. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
   1.   Edit
   2.   Insert
   3.   Format
   4.   Tools
3. Which of the following is not a worksheet design criterion?
   1.   Efficiency
   2.   Auditability
   3.   Description
   4.   Clarity
4. To copy cell contents using drag and drop, press the
   1.   End key
   2.   Shift key
   3.   Esc key
   4.   None of above
5. If you press …., the cell accepts your typing as its contents.
   1.   Enter
   2.   Ctrl + Enter
   3.   TAB
   4.   Insert
6. The autofill feature
   1.   Extends a sequential series of data
   2.   Automatically adds a range of cell values
   3.   Applies a boarder around selected cells
   4.   None of above
7. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
   1.   F3
   2.   F5
   3.   F7
   4.   F11
8. you can use the formula palette to
   1.   format cells containing numbers
   2.   create and edit formulas containing functions
   3.   entered assumptions data
   4.   copy a range of cells
9. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data changed?
   1.   Format Report
   2.   Pivot Table
   3.   Refresh Data
   4.   Show Detail
10. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
    1.   Formula
    2.   Field
    3.   Data
    4.   Query

 

Excel quiz questions with answers pdf

This excel quiz questions with answers pdf 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.

excel-quiz-questions-with-answers-pdf

We have published various excel quiz questions with answers pdf on Microsoft 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!