Create quiz in proprofs through excel | computer quiz

The create quiz in proprofs through excel 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 ms excel online quiz are so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-23

1. If you need a text to show vertically in a cell. How will you achieve this?
   1.   Choose Vertical on Text alignment in Format Cells dialog box
   2.   Choose 90 Degrees in Orientation of Format Cells dialog box
   3.   Choose Distributed from the Vertical drop down list of Format Cells dialog box
   4.   Choose Center Across Selection from Horizontal combo box in Format Cells dialog box
2. Can you set 0.5 inch left indentation for a cell in Excel?
   1.   Excel does not have indentation feature
   2.   You can specify indentation only if you turn the rulers on
   3.   Indentation can be set from Format Cells dialog box
   4.   The indentation can be specified only when printing
3. You can automatically adjust the size of text in a cell if they do not fit in width by
   1.   Double clicking on the right border of column header
   2.   From Format choose Columns and then Autofit Selection
   3.   From Format Cells dialog box mark Shrink to fit check box
   4.   All of above
4. Formatting a cell in Currency, you can specify
   1.   Decimal Places
   2.   Currency Symbol
   3.   Both of above
   4.   None of above
5. Formatting a cell in Number format you can’t set
   1.   Decimal Places
   2.   Use 1000 separator
   3.   Negative numbers
   4.   Currency Symbol
6. What is entered by the function =today()
   1.   The date value for the day according to system clock
   2.   The time value according to system clock
   3.   Today’s date as Text format
   4.   All of above
7. Which function will you use to enter current time in a woksheet cell?
   1.   =today()
   2.   =now()
   3.   =time()
   4.   =currentTime()
8. Special category of Number tab in Format Cells dialog box can be used to apply formats like
   1.   Zip Code
   2.   Phone Number
   3.   Both of above
   4.   None of above
9. Merge cells option can be applied from
   1.   Format Cells dialog box Alignment Tab
   2.   Formatting toolbar
   3.   Both of above
   4.   None of above
10. Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
    1.   from Fromat >> Cells
    2.   from Format >> Autoformat
    3.   from Table >> Autoformat
    4.   All of above

 

Create quiz in proprofs through excel

This create quiz in proprofs through excel 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.

create-quiz-in-proprofs-through-excel

We have published various create quiz in proprofs through excel on ms excel online quiz, 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!

x