Excel chapter 1 quiz | computer quiz

The excel chapter 1 quiz 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 quiz for Microsoft excel with answers is so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-19

1. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
   1.   IF
   2.   AND
   3.   OR
   4.   NOT
2. Macros are “run” or executed from the ….. menu.
   1.   Insert
   2.   Frmat
   3.   Tools
   4.   Data
3. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
   1.   Insert
   2.   Format
   3.   Tools
   4.   Data
4. Each excel file is called a workbook because
   1.   It can contain text and data
   2.   It can be modified
   3.   It can contain many sheets including worksheets and chart sheets
   4.   You have to work hard to create it
5. Which types of charts can excel produce?
   1.   Line graphs and pie charts only
   2.   Only line graphs
   3.   Bar charts, line graphs and pie charts
   4.   Bar charts and line graphs only
6. How are data organized in a spreadsheet?
   1.   Lines and spaces
   2.   Layers and planes
   3.   Rows and columns
   4.   Height and width
7. What does the VLOOKUP function do?
   1.   Looks up text that contain ‘v’
   2.   Checks whether text is the same in one cell as in the next
   3.   Finds related records
   4.   All of above
8. Gridlines
   1.   May be turned off for display but turned on for printing
   2.   May be turned on or off for printing
   3.   The be turned off for display and printing
   4.   a, b and c
9. You can print only an embedded chart by
   1.   Moving the chart to a chart sheet before you print.
   2.   Formatting the chart before you print
   3.   Selecting the chart before you print
   4.   a and c
10. Which of the following is a correct order of precedence in a formula calculation?
    1.   Multiplication and division, exponential positive and negative value
    2.   Multiplication and division, positive and negative values, addition and subtraction
    3.   Addition and subtraction, positive and negative values, exponentiation
    4.   None of above

 

Excel chapter 1 quiz

This excel chapter 1 quiz 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-chapter-1-quiz

We have published various excel chapter 1 quiz for Microsoft excel with answers, Fundamentals 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!