Trivia Quiz: How Much Do You Know About Microsoft Office, Excel And Windows?

19 Questions | Total Attempts: 25

SettingsSettingsSettings
Please wait...
Trivia Quiz: How Much Do You Know About Microsoft Office, Excel And Windows?

How Much Do You Know About Microsoft Office, Excel, And Windows? If you use Microsoft on your computer, you should be conversant with the applications that help you create documents of different types and view them too. In this quiz, you can get to see how conversant you are with some of them. Do give it a try and answer the quiz as best as you can.


Questions and Answers
  • 1. 
    The two default directories within Windows where one would normally find all user files and documents are:
    • A. 

      "C:\ Drive" and My Computer

    • B. 

      Program Files and User Files

    • C. 

      My Pictures and My Music

    • D. 

      My Documents and Desktop

    • E. 

      All of the above

  • 2. 
    Proper sequence by which to shut down a computer:
    • A. 

      Unplug the power cord from the back of the workstation.

    • B. 

      Click on Start, Program Files, Programs, then click "Stop All."

    • C. 

      Press the power button on the front of the workstation.

    • D. 

      Ctrl + Alt + Delete, then choose "Power Off" from one of the options.

    • E. 

      Click on Start, Shut Down, then click Shut down from the drop-down dialog box.

  • 3. 
    What is the correct way find Microsoft Word in Windows?
    • A. 

      Go to Programs, Start, then click on Microsoft Office, then choose Word.

    • B. 

      Go to My Computer, click on the "C:\" drive, then press the Enter key. When this is opened, you should see the icon for Word. Click on that.

    • C. 

      Click on Start, click on Programs, expand Programs until the full list of applications is displayed. There, in the list, is Microsoft Word along with the other Office applications.

    • D. 

      Click on Search, then Find, then type in the name of the application.

    • E. 

      Ask the IS Manager.

  • 4. 
    True or False:  To insert a new sheet into an Excel workbook between Sheet 2 and Sheet 3, you would right-click on Sheet 2 and select Insert from the options menu.
    • A. 

      True

    • B. 

      False

  • 5. 
    True or False: To quickly copy formulas from one cell to another, you would use Formula Painter.
    • A. 

      True

    • B. 

      False

  • 6. 
    A group of cells that have been highlighted would be considered a Range of cells or a cell Range, which has a Range Address.  If a cell's Range started at the very first cell, and ended at G7, what would be its Range Address?
    • A. 

      G1:G7

    • B. 

      G7;C2

    • C. 

      A1-G7

    • D. 

      A7+G7

    • E. 

      None of the above

  • 7. 
    True or False:  To add borders to a cell or a range of cells, you would click on Format, Cells, then click on the Alignment tab.
    • A. 

      True

    • B. 

      False

  • 8. 
    True or False: When starting a new Excel workbook, it is best NOT to save it on your hard drive.
    • A. 

      True

    • B. 

      False

  • 9. 
    Which Microsoft Office application would you use to create a company memo?
    • A. 

      Power Point

    • B. 

      Outlook

    • C. 

      Excel

    • D. 

      Word

    • E. 

      Access

  • 10. 
    Which of these describes a valid formula?
    • A. 

      A1:G7=SUM

    • B. 

      =A1;G7(SUM)

    • C. 

      A1+G7

    • D. 

      =SUM(A1-G7)

    • E. 

      None of the above

  • 11. 
    To change the alignment of text within a cell, you can choose either to click on Format, Cells, then the Alignment tab or you can change the text alignment from the Formatting tool bar. (Select all that apply)
    • A. 

      No, you can only change text alignment from the Format menu.

    • B. 

      Yes, these are two of the ways that you can format the text.

    • C. 

      Yes, but this will also affect the result of a formula.

    • D. 

      No, you shouldn't align the text to anything but the default set for Excel.

    • E. 

      Changing the text alignment will affect the alignment of surrounding cells.

  • 12. 
    Can I use Microsoft Excel to create a letter?
    • A. 

      Yes

    • B. 

      No

  • 13. 
    Which of the following statements is true? (Select all that apply)
    • A. 

      An Excel workbook can not contain more than one worksheet.

    • B. 

      Text can be rotated in a cell.

    • C. 

      There are at least three ways in which the contents of a cell can be copied then pasted into another cell.

    • D. 

      Populated cells (containing either a border, text or number) that are outside of the print range will be automatically adjusted into the page when printing.

    • E. 

      The only downside to Excel is that it does not have a "spell check" function.

  • 14. 
    Adjusting the margins on a worksheet can allow more cells to fit within a printed area. Select the best answer.
    • A. 

      No, your only choice is to use the "Fit to page" option when printing.

    • B. 

      Yes, so long as you tell Excel to fit the contents of the cells outside of the print range into the printed area.

    • C. 

      Yes. You can do this by clicking on Print Preview, click on Margins, then click and drag the margins toward the outside of the page.

    • D. 

      No.

    • E. 

      Yes.

  • 15. 
    True or False: You can't copy an Office document or spreadsheet and paste it into the same directory as the original.
    • A. 

      True

    • B. 

      False

  • 16. 
    Can a single worksheet be inserted into an entirely different workbook?
    • A. 

      Yes

    • B. 

      No

  • 17. 
    Choose the correct process by which new rows can be inserted into a worksheet:
    • A. 

      Select the column or columns into which you would like to add rows, then right-click and choose Insert from the list of options.

    • B. 

      Select the row or rows into which you would like to add columns, then right-click and choose Insert from the list of options.

    • C. 

      Right click on the cells into which you would like to add a row, then choose Insert from the list of options.

    • D. 

      Right click on the row or rows, select Insert from the list of options.

    • E. 

      Right click on the sheet you would like to insert new cells, then choose Add from the list of options.

  • 18. 
    Can you insert images into an Excel worksheet?
    • A. 

      Yes

    • B. 

      No

  • 19. 
    Select the processes by which one would cut the contents of one cell or cells and paste into another cell or cells: (Select all that apply)
    • A. 

      Highlight the populated cell or cells, right click and choose Copy, then right click and choose Paste into the cell or cells of your choice.

    • B. 

      Highlight only the first cell within a range of cells, click on Cut from the toolbar then highlight the other cells and click on Paste from the toolbar.

    • C. 

      Press 'ctrl + x' in the populated cell or cells, then 'ctrl + v' into the empty cell or cells.

    • D. 

      Right click on the cell or cells in question, then choose Cut; right click on the empty cell or cells then choose Paste.

    • E. 

      You can't cut and paste data from one cell to another, since the formula will not be copied over in the process.