Futureheights Training & Consultant Pvt. Ltd (Set-3)

40 Questions | Total Attempts: 48

SettingsSettingsSettings
Please wait...
Futureheights Training & Consultant Pvt. Ltd (Set-3)


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 END column of the end row of the working worksheet
    • A. 

      CTRL + HOME

    • B. 

      CTRL + END

    • C. 

      ALT + HOME

    • D. 

      ALT + END

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

      ++

    • B. 

      =

    • C. 

      -

    • D. 

      %

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

      A1

    • B. 

      1

    • C. 

      1A

    • 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 Questions 
    1. Formula for calculating the Total Price as sum of Science, Maths & Computers for each Customer 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 Questions 
    1. Formula for calculating the Discount @ 5% for each customer and display them in column G
    • A. 

      F2/ 5% and then drag

    • B. 

      =F2* 5% and then drag

    • C. 

      =G2*5% and then drag

    • D. 

      –AVG(C1:D1)

  • 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. 

      .docx

    • B. 

      .wor

    • C. 

      .doc

    • D. 

      Both a & c

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

      Word

    • B. 

      Equation

    • C. 

      Comment

    • 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/Ribbon shows  paragraph option-​
    • A. 

      Home

    • B. 

      View

    • C. 

      Page layout

    • D. 

      None of the above

  • 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. 
    What is the function of Ctrl + I in Ms-Word
    • 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 to the selected text

  • 17. 
    Why headers and footers used in MS –Word
    • 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. 
    Which is the correct keyboard short cut for line Spacing
    • A. 

      CTRL + 1

    • B. 

      CTRL + 4

    • C. 

      CTRL + 8

    • D. 

      CTRL + 9

  • 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. 
    Which is the correct keyboard shortcut for Paste
    • A. 

      CTRL + C

    • B. 

      CTRL + D

    • C. 

      CTRL + V

    • D. 

      CTRL + X

  • 21. 
    Before Sending email I should,
    • A. 

      Read mail twice

    • B. 

      Check spellings

    • C. 

      Check Subject

    • D. 

      All of the above

  • 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. 
    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

Back to Top Back to top