Excel chapter 1 end of chapter quiz | computer quiz

The excel chapter 1 end of chapter quiz computer quiz is important for all PSC exam 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 skill quiz linkedin are so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-17

1. What term refers to a specific set of values saved with the workbook?
   1.   Range
   2.   Scenario
   3.   Trend line
   4.   What-if analysis
2. Got functions? No? You need the insert function dialog box. How do you get it?
   1.   Right click a cell and then click insert
   2.   Click the insert menu and then click function
   3.   Type = in a cell
   4.   All of the above
3. Which of the following describes how to select all the cells in a single column?
   1.   Right click on column and select Pick from list
   2.   Use data – text to columns menu item
   3.   Left click on the gray column title button
   4.   Pressing Ctrl + A on the keyboard
4. when you use the fill effects in the format data series dialog box, you can not
   1.   rotate text on the chart
   2.   select a fore ground color
   3.   select a pattern
   4.   select a background color
5. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
   1.   Rows and columns
   2.   Headings
   3.   Speed
   4.   None
6. Which of the following is not a basic step in creating a worksheet?
   1.   Save the workbook
   2.   Modify the worksheet
   3.   Enter text and data
   4.   Copy the worksheet
7. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
   1.   Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
   2.   Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
   3.   Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
   4.   All of above
8. To insert three columns between columns D and E you would
   1.   Select column D
   2.   Select column E
   3.   Select columns E, F and G
   4.   Select columns D, E, and F.
9. To center worksheet titles across a range of cell, you must
   1.   Select the cells containing the title text and use the fill handle to center the text across a range of cells
   2.   Widen the columns
   3.   Select the cells containing the title text and use the fill handle to center the text across a range of cells
   4.   Widen the column
10. When integrating Ms-Word and Excel, Word is usually the
    1.   Server
    2.   Source
    3.   Client
    4.   None

 

Excel chapter 1 end of chapter quiz

This excel chapter 1 end of chapter 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.

We have published various excel chapter 1 end of chapter quiz on microsoft excel skill quiz linkedin, 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!

excel-chapter-1-end-of-chapter-quiz