Computer Skills: How Well Do You Know About MS Office And Email? Trivia Quiz

40 Questions | Total Attempts: 83

SettingsSettingsSettings
Please wait...
Computer Skills: How Well Do You Know About MS Office And Email? Trivia Quiz

This trivia quiz is on Computer Skills. How Well Do You Know About MS Office And Email? Ms. Office is the most common use mode of communication for emails when it comes to most organizations, and people need to know about using the application correctly at the workplace. How about you give it a shot and learn something!


Questions and Answers
  • 1. 
    Ramesh Ahuja wants to store data of his monthly visits to schools over the last financial year. Which of the Office application is most suitable for this purpose?
    • A. 

      MS word

    • B. 

      Outlook

    • C. 

      MS Excel

    • D. 

      None of the above

  • 2. 
    Mention the shortcut key combinations used for navigating to the top of the worksheet
    • A. 

      CTRL + HOME

    • B. 

      CTRL + END

    • C. 

      ALT + HOME

    • D. 

      ALT + END

  • 3. 
    Which symbol always comes before an Excel formula? 
    • A. 

      A common

    • B. 

      An equal sign

    • C. 

      Two times plus sign

    • D. 

      A percentage sign

  • 4. 
    Address of second cell in a worksheet is
    • A. 

      C2

    • B. 

      2

    • C. 

      2C

    • D. 

      None of the above

  • 5. 
    You can automatically adjust the size of text in a cell if they do not fit in width by
    • A. 

      Double clicking on the right border of column header

    • B. 

      From Format choose Columns and then Autofit Selection

    • C. 

      From Format Cells dialog box mark Shrink to fit check box

    • D. 

      All of above

  • 6. 
    Based on the spreadsheet given below answers the below QuestionsFormula for calculating the Total Marks as sum of Science, Maths & Computers for each student and display them in column F-
    • A. 

      =SUM(A2+B2+C2+D2)

    • B. 

      =SUM(A1:E2)

    • C. 

      =SUM(C2+D2+E2)

    • D. 

      SUM(C2+D1+E2)

  • 7. 
    Based on the spreadsheet given below answers the below QuestionsFormula for calculating the average marks for each student and display them in column G
    • A. 

      =AVERAGE(C1:E2)

    • B. 

      =AVERAGE(C2:E2)

    • C. 

      =AVERAGE(C1:E2)

    • D. 

      –AVG(C2:E2)

  • 8. 
    Click on the right option to freeze a column-
    • A. 

      View- freeze first column

    • B. 

      Data- freeze column

    • C. 

      Insert- freeze

    • D. 

      Home – freeze

  • 9. 
    Merge cells option can be applied from 
    • A. 

      Format Cells dialog box Alignment Tab

    • B. 

      Formatting toolbar

    • C. 

      Both of above

    • D. 

      None of above

  • 10. 
    Long text can be broken down into many lines within a cell. You can do this through 
    • A. 

      Wrap Text in Format >> Cells

    • B. 

      Justify in Edit >> Cells

    • C. 

      Text Wraping in Format >> Cells, Layout tab

    • D. 

      All of above

  • 11. 
    The file type _____ indicates the file is a Word document
    • A. 

      .msw

    • B. 

      .wor

    • C. 

      .wrd

    • D. 

      .doc

  • 12. 
    Using Find command in Word, we can search?
    • A. 

      Word

    • B. 

      Formats

    • C. 

      Story

    • D. 

      All of the above

  • 13. 
    By default, on which page the header or the footer is printed?
    • A. 

      on first page

    • B. 

      On alternate page

    • C. 

      On every page

    • D. 

      None of the above

  • 14. 
    Which menu in MSWord can be used to change character size and typeface?
    • A. 

      View

    • B. 

      Tools

    • C. 

      Format

    • D. 

      Data

  • 15. 
    Which key should be pressed to start a new paragraph in MS-Word?
    • A. 

      Down Cursor Key

    • B. 

      Enter Key

    • C. 

      Shift + Enter

    • D. 

      Ctrl + Enter

  • 16. 
    • A. 

      It converts selected text into the next larger size of the same font

    • B. 

      It adds a line break to the document

    • C. 

      It makes the selected text bold

    • D. 

      It applies Italic formatting t the selected text

  • 17. 
    • A. 

      To enhance the overall appearance of the document

    • B. 

      To mark the starting of a page

    • C. 

      To make large document more readable

    • D. 

      To allow page headers and footers to appear on document when it is printed

  • 18. 
    • A. 

      Insert- watermark

    • B. 

      Page layout- watermark

    • C. 

      Home – watermark

    • D. 

      None of the above

  • 19. 
    There can be many ways to insert page number in a document. Which of the following lets you insert page number
    • A. 

      Page number from Insert menu

    • B. 

      Footnote from Insert menu

    • C. 

      Page Setup from file menu

    • D. 

      Both a & b

  • 20. 
    • A. 

      CTRL + C

    • B. 

      CTRL + D

    • C. 

      CTRL + E

    • D. 

      CTRL + W

  • 21. 
    Before Sending very large  attachments I should,
    • A. 

      Compress them up( Zip them)

    • B. 

      Send all attachments without compressing them

    • C. 

      Don’t attach them

    • D. 

      Send them in two separate email

  • 22. 
    How Quickly Should I reply to an email?
    • A. 

      As soon as I can

    • B. 

      I don’t have to reply

    • C. 

      When I get around

    • D. 

      Doesn’t matter

  • 23. 
    Why shouldn’t I type emails in all CAPS?
    • A. 

      It makes you look lazy

    • B. 

      It shows arrogant

    • C. 

      Its shows you are yelling.

    • D. 

      All of the above

  • 24. 
    If you don't want to type your name at the end of every email you send, what you can you do instead?
    • A. 

      Don't sign at all .. people know who the email is from thanks to your return email address

    • B. 

      Only sign emails to business associates, but you can exclude this step with friends and family

    • C. 

      Create a signature that will attach to every email you send

    • D. 

      None of the above

  • 25. 
    To attach a file what do you click on?
    • A. 

      Paper clip

    • B. 

      Insert

    • C. 

      New

    • D. 

      Format

  • 26. 
    What is the most important thing I should do with every e-mail?
    • A. 

      Spell check, use full sentence structure and use proper grammar

    • B. 

      Have a nice greeting: Hi, Hello, etc

    • C. 

      Include signature

    • D. 

      All of the above

  • 27. 
    • A. 

      Your boss and his boss

    • B. 

      Only those people who need to know

    • C. 

      The whole world

    • D. 

      Family members

  • 28. 
    Which is the correct format for a signature
    • A. 

      Name| designation| company address | Phone number| email id

    • B. 

      Designation| Name| company address | Phone number| email id

    • C. 

      Email id | Name| company address | Phone number|

    • D. 

      None of the above

  • 29. 
    • A. 

      Be long

    • B. 

      Be short

    • C. 

      Be indented

    • D. 

      None of the above

  • 30. 
    Netiquette suggests a business email should be replied within a business day.
    • A. 

      Correct

    • B. 

      Incorrect

    • C. 

      Don’t reply until you get a call

    • D. 

      None of the above

  • 31. 
    What is internet? 
    • A. 

      A single network

    • B. 

      A vast collection of different networks

    • C. 

      Interconnection of local area networks

    • D. 

      None of the mentioned

  • 32. 
    Software which allows user to view the webpage is called ___
    • A. 

      Website

    • B. 

      OS

    • C. 

      Internet browser

    • D. 

      None of the above

  • 33. 
    Which of the follow is a valid website address?
  • 34. 
    What is the full form of RAM?
    • A. 

      Random access Memory

    • B. 

      Random Allotted Memory

    • C. 

      Read Access Memory

    • D. 

      None of the above

  • 35. 
    • A. 

      Home page

    • B. 

      Backend page

    • C. 

      None of the above

    • D. 

      Start page

  • 36. 
    Keyboard short cut for refreshing computer
    • A. 

      F5

    • B. 

      F4

    • C. 

      F3

    • D. 

      F2

  • 37. 
    What happens if we press ALT + TAB
    • A. 

      It shows all open word doucments

    • B. 

      It shows all open files

    • C. 

      It opens up start menu

    • D. 

      None of the above

  • 38. 
    Which is not a browser?
    • A. 

      Internet Explorer

    • B. 

      Mozilla

    • C. 

      Google Chrome

    • D. 

      MS Excel

  • 39. 
    Which is not an Operating System?
    • A. 

      MS office

    • B. 

      Windows 7

    • C. 

      Linux

    • D. 

      Macintosh

  • 40. 
    Which is new release of Microsoft for Operating System?
    • A. 

      Windows 8.1

    • B. 

      Windows 8

    • C. 

      Windows 8.2

    • D. 

      Windows 7