Excel practical quiz for psc computer exam

The excel practical quiz is important for all psc exam of both assistant and full computer operator. The Public Service Commission (Lok-Sewa Aayog) has also asked more than 8 questions about the ms excel quiz. Excel practical quiz is so useful for preparing PSC Computer exam.

This excel practical 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.

Microsoft Excel MCQ Quiz part-4

1. To center worksheet titles across a range of cells, you must
   1.   Select the cells containing the title text plus the range over which the title text is to be centered
   2.   Widen the columns
   3.   Select the cells containing the title text plus the range over which the title text is to be enfettered
   4.   Format the cells with the comma style
2. How do you delete a column?
   1.   Select the column heading you want to delete and select the Delete Row button on the standard toolbar
   2.   Select the column heading you want to delete and select Insert Delete from the menu
   3.   Select the row heading you want to delete and select Edit>Delete from the menu
   4.   Right click the column heading you want to delete and select delete from the shortcut menu
3. How can you find specific information in a list?
   1.   Select Tools > Finder from the menu
   2.   Click the Find button on the standard toolbar
   3.   Select Insert > Find from the menu
   4.   Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
4. When integrating word and excel, word is usually the
   1.   Server
   2.   Destination
   3.   Client
   4.   Both b and c
5. When a label is too long to fit within a worksheet cell, you typically must
   1.   Shorten the label
   2.   Increase the column width
   3.   Decrease the column width
   4.   Adjust the row height
6. The name box
   1.   Shows the location of the previously active cell
   2.   Appears to the left of the formula bar
   3.   Appears below the status bar
   4.   Appears below the menu bar
7. Comments put in cells are called
   1.   Smart tip
   2.   Cell tip
   3.   Web tip
   4.   Soft tip
8. Which is used to perform what if analysis?
   1.   Solver
   2.   Goal seek
   3.   Scenario Manager
   4.   All of above
9. You can use the horizontal and vertical scroll bars to
   1.   Split a worksheet into two panes
   2.   View different rows and columns edit the contents of a cell
   3.   Edit the contents of a cell
   4.   View different worksheets
10. Multiple calculations can be made in a single formula using
    1.   Standard formulas
    2.   Array formula
    3.   Complex formulas
    4.   Smart formula

 

Excel practical quiz

The excel practical quiz questions with answers are the collection of MCQ sets of Microsoft excel quiz. It is so useful for the psc computer exam of the different sectors. such as Nepal electric authority, Oil corporations, khane pani, Nepal telecom, Different municipality, and state-level exams, etc.

Pivot Tables of Microsoft Excel

PivotTables summarizes large amounts of Excel data from a database that is formatted where the first row contains Heading and the second row contains Categories or Values.

The way the data is summarized is flexible but usually, Pivot Tables will contain values ​​of some or all of the categories.

If you are new to creating Pivot Table, Excel 2013 can analyze your data and recommend Pivot Table for you.

Once you are comfortable with Pivot Tables, you can start from scratch and make your own.

To create a Pivot Table, make sure that your data has column headings or table headers and no blank rows. Click on any cell in the range of cells or tables.

INSERT> Tables> Recommended Pivot Tables

In the Launch Recommended Pivot Tables dialogue box, click on any Pivot table layout to get a preview, then choose the one that works best for you and click OK.

Excel will provide a selection of recommended Pivot Tables for your data. Excel then places the Pivot Table on a new worksheet and shows the field list so that you can rearrange the data according to your needs.

Again, make sure your data has column headings or table headers and no blank rows

We have published various MCQ online computer quizzes on excel practical quiz, MS-PowerPoint, and MS-Access. Hope you all like these quizzes. If there are mistakes in any question, please comment on the related post. Thanks!