Microsoft Word And Excel Practice Test: Quiz!

Reviewed by Samy Boulos
Samy Boulos, MSC, Computer Science |
Computer Expert
Review Board Member
With over 25 years of expertise, Samy is a seasoned Senior Technology Consultant. His extensive background spans diverse areas such as software development, data migration, Apple and Office 365 integration, computer helpdesk support, data engineering, and cloud computing. A dedicated professional, Samy combines technical proficiency with a strategic mindset, ensuring optimal solutions for complex technological challenges. His wealth of experience positions him as a reliable and knowledgeable consultant in navigating the ever-evolving landscape of IT and technology.
, MSC, Computer Science
Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Haroldkym
H
Haroldkym
Community Contributor
Quizzes Created: 1 | Total Attempts: 10,302
Questions: 35 | Attempts: 10,323

SettingsSettingsSettings
Microsoft Word And Excel Practice Test: Quiz! - Quiz

Have you practiced MS office well? Do you understand it well? Try this Microsoft Word and Excel Practice quiz and see if you know the concepts well or not. Microsoft Office has got a lot of software in it. If you know Word and Excel well and wish to practice its concepts, try them here. All the best for a perfect score on this quiz. If you find the quiz interesting, do share it with others for MS Word and Excel practice.


Questions and Answers
  • 1. 

    Which of the following is word processing software?

    • A.

      Microsoft Word

    • B.

      Microsoft Excel

    • C.

      Microsoft Internet Explorer

    • D.

      Microsoft Windows Explorer

    Correct Answer
    A. Microsoft Word
    Explanation
    Microsoft Word is a word processing software because it is specifically designed for creating, editing, and formatting text-based documents. It provides various features such as spell check, grammar check, formatting options, and templates that are essential for word processing tasks. Microsoft Excel is a spreadsheet software, Microsoft Internet Explorer is a web browser, and Microsoft Windows Explorer is a file management software, none of which are specifically designed for word processing. Therefore, Microsoft Word is the correct answer.

    Rate this question:

  • 2. 

    Where should you save your computer files?

    • A.

      On the desktop

    • B.

      On your flash drive or personal account

    • C.

      Anywhere you like

    • D.

      In the memory card

    Correct Answer
    B. On your flash drive or personal account
    Explanation
    Saving computer files on a flash drive or personal account is recommended because it provides a secure and portable storage solution. Storing files on the desktop can lead to clutter and potential loss if the computer crashes. Saving files on a memory card may not be practical for all computers, and storing them anywhere you like can lead to disorganization and difficulty in locating files later. Using a flash drive or personal account ensures that files are easily accessible and can be backed up or transferred to different devices if needed.

    Rate this question:

  • 3. 

    When the text automatically goes onto the next line, this is called?

    • A.

      Page wrap

    • B.

      Page wrap

    • C.

      Word wrap

    • D.

      Text wrapping

    Correct Answer
    D. Text wrapping
    Explanation
    Text wrapping refers to the automatic adjustment of text to fit within the width of a given space, such as a page or a text box. When the text reaches the end of a line, it automatically moves to the next line, ensuring that all the text is visible and readable. This term is commonly used in word processing and text editing software. Therefore, the correct answer is text wrapping.

    Rate this question:

  • 4. 

    When entering a lot of text in capitals, you should use the

    • A.

      Enter key

    • B.

      Big letter key

    • C.

      All caps key

    • D.

      Caps lock key

    Correct Answer
    D. Caps lock key
    Explanation
    When entering a lot of text in capitals, you should use the Caps lock key. This key allows the user to type in all capital letters without having to hold down the shift key for each letter. It toggles the keyboard to type in all uppercase until it is turned off. Therefore, using the Caps lock key is the most efficient way to enter a large amount of text in capital letters.

    Rate this question:

  • 5. 

    Left justify is the same as

    • A.

      Align over one space

    • B.

      Align next

    • C.

      Align left

    • D.

      Align all

    Correct Answer
    C. Align left
    Explanation
    Left justify is the same as align left. This means that the text or content is aligned to the left margin or edge of the page or container. It ensures that the left edge of each line of text is aligned in a straight line, while the right edge may be uneven or ragged. This is a common alignment used in documents, paragraphs, and tables to create a neat and organized appearance.

    Rate this question:

  • 6. 

    The steps to place a page break into a document are

    • A.

      Right-click, insert break

    • B.

      On the menu bar, click insert, break, page break, click ok

    • C.

      Click in front of the paragraph and hit enter until it reaches the next page.

    • D.

      None of the above

    Correct Answer
    B. On the menu bar, click insert, break, page break, click ok
    Explanation
    To place a page break into a document, you need to go to the menu bar and click on "insert". Then, select "break" and choose "page break" from the options. Finally, click "ok" to confirm the page break insertion. This method ensures that the document is divided into separate pages at the desired location.

    Rate this question:

  • 7. 

    To move the text to the right side of the page, you would use

    • A.

      Align left

    • B.

      Align over one space

    • C.

      Align-right

    • D.

      Align top

    Correct Answer
    C. Align-right
    Explanation
    To move the text to the right side of the page, you would use "align-right". This command aligns the text to the right margin of the page, allowing it to be positioned on the right side.

    Rate this question:

  • 8. 

    To save a file under a different name, you should use

    • A.

      Save as

    • B.

      Save

    • C.

      Save all

    • D.

      Save new

    Correct Answer
    A. Save as
    Explanation
    To save a file under a different name, the correct option is "save as". This feature allows the user to specify a new name or location for the file being saved, while keeping the original file intact. It is commonly used when creating a copy of a file with modifications or when wanting to save a file with a different name or format. The "save" option would simply overwrite the existing file with any changes made, while "save all" typically refers to saving multiple files at once. "Save new" is not a standard option in most software applications.

    Rate this question:

  • 9. 

    You would use the indent option when

    • A.

      You are in the middle of a document

    • B.

      You are at the end of the document

    • C.

      You are starting a new paragraph

    • D.

      You are anywhere in the paragraph

    Correct Answer
    C. You are starting a new paragraph
    Explanation
    The indent option is used when starting a new paragraph. It helps to visually distinguish the beginning of a new paragraph from the rest of the text. By indenting the first line of a paragraph, it creates a clear separation and makes the text more organized and easier to read.

    Rate this question:

  • 10. 

    To send the same document addressed to 10 different people, you should use

    • A.

      Multiple merge

    • B.

      Mail merge

    • C.

      Merge

    • D.

      None of the above

    Correct Answer
    B. Mail merge
    Explanation
    To send the same document addressed to 10 different people, you should use mail merges. Mail merges allow you to create personalized documents by merging a template with a data source, such as a list of recipients. This way, you can easily customize each document with the recipient's name, address, and other relevant information without having to manually create each one separately. By using mail merges, you can save time and effort while ensuring that each recipient receives a personalized document.

    Rate this question:

  • 11. 

    To ensure that you do not lose all of your files, you should always make a

    • A.

      Backup copy

    • B.

      Back down

    • C.

      Back over

    • D.

      Back under

    Correct Answer
    A. Backup copy
    Explanation
    To ensure that you do not lose all of your files, you should always make a backup copy. This means creating a duplicate or additional copy of your files in a separate location or storage device. By doing so, you have a safeguard in case your original files are lost, damaged, or accidentally deleted. Having a backup copy ensures that you can easily restore your files and prevent any potential data loss or disruption.

    Rate this question:

  • 12. 

    To control where a page should end, you can always insert a

    • A.

      Hard page break

    • B.

      End page break

    • C.

      Merge page break

    • D.

      None of the above

    Correct Answer
    A. Hard page break
    Explanation
    A hard page break is used to control where a page should end in a document. It is a formatting command that forces the content after the break to start on a new page. This is useful when you want to ensure that specific content or sections start on a fresh page, such as starting a new chapter or keeping a table or image together on a single page. The other options mentioned (end page break, merge page break, none of the above) do not exist or are not commonly used terms in this context.

    Rate this question:

  • 13. 

    Landscape mode is when the paper is

    • A.

      Taller than it is wider

    • B.

      Wider than it is taller

    • C.

      Smaller than normal

    • D.

      Bigger than normal

    Correct Answer
    B. Wider than it is taller
    Explanation
    Landscape mode refers to the orientation of a document or image where the width is greater than the height. In this mode, the paper is positioned horizontally, providing a wider view. This orientation is commonly used for displaying wide or panoramic content, such as photographs, charts, or presentations, as it allows for a better visual representation of the information.

    Rate this question:

  • 14. 

    The ____ is an area in the top margin of each page in a document where you can insert text or graphics.

    • A.

      Headnote

    • B.

      Top margin

    • C.

      Footer

    • D.

      Header

    Correct Answer
    D. Header
  • 15. 

    The default font in Word is

    • A.

      Arial

    • B.

      Comic Sans MS

    • C.

      Times New Roman

    • D.

      Courier

    Correct Answer
    C. Times New Roman
    Explanation
    The default font in Word is Times New Roman. This means that when you open a new document in Word, the text will be automatically set in Times New Roman font unless you change it to a different font.

    Rate this question:

  • 16. 

    To find alternative words with the same/similar meaning, use the

    • A.

      Spell checker

    • B.

      Thesaurus

    • C.

      Grammar Checker

    • D.

      Editor

    Correct Answer
    B. Thesaurus
    Explanation
    The Thesaurus is a tool that can be used to find alternative words with the same or similar meaning. It is a reference book or an online resource that provides synonyms and antonyms for words. By using a thesaurus, one can expand their vocabulary and find different ways to express themselves. It is a valuable tool for writers, students, and anyone looking to enhance their language skills.

    Rate this question:

  • 17. 

    To move a block of text, you would use

    • A.

      Cut and copy

    • B.

      Copy and paste

    • C.

      Cut and paste

    • D.

      Move block

    Correct Answer
    C. Cut and paste
    Explanation
    To move a block of text, you would use "Cut and paste". This involves selecting the desired text and cutting it from its current position, then pasting it into the desired location. This action effectively removes the text from its original place and relocates it to a new location. The other options, such as "Copy and paste" and "Copy and cut", do not involve removing the text from its original position, but rather create a duplicate or copy of the text in the new location. "Move block" is not a standard term or action used for moving text.

    Rate this question:

  • 18. 

    Before copying text, you must first

    • A.

      Move the text

    • B.

      Delete the text

    • C.

      Highlight the text

    • D.

      Copy the text

    Correct Answer
    C. Highlight the text
    Explanation
    To copy text, you must first highlight the text. This involves selecting the desired text by clicking and dragging the cursor over it. Once the text is highlighted, you can then proceed to copy it by using the appropriate keyboard shortcut or right-clicking and selecting the "Copy" option.

    Rate this question:

  • 19. 

    To see how a spreadsheet will print out, you should use

    • A.

      Page overview

    • B.

      Page preview

    • C.

      Page break

    • D.

      Look at the page

    Correct Answer
    B. Page preview
    Explanation
    To see how a spreadsheet will print out, you should use the "page preview" option. This feature allows you to view the spreadsheet exactly as it will appear when printed, including the layout, formatting, and any page breaks that have been set. It provides a preview of the printed version, giving you a chance to make any necessary adjustments or corrections before actually printing the document.

    Rate this question:

  • 20. 

    What programming aspect does Microsoft Excel have that allows the user to employ a wide variety of numerical methods?

    • A.

      Java

    • B.

      Python

    • C.

      Visual Basic for Applications

    • D.

      C++

    Correct Answer
    C. Visual Basic for Applications
    Explanation
    Microsoft Excel has a programming aspect, Visual Basic for Applications (VBA), which allows the user to employ a wide variety of numerical methods. This feature can be used for tasks such as solving differential equations of mathematical physics and then reporting the results back to the spreadsheet.

    Rate this question:

  • 21. 

    In Excel, what is the following symbol used for in a formula.... +

    • A.

      Multiplying

    • B.

      Dividing

    • C.

      Adding

    • D.

      Subtracting

    Correct Answer
    C. Adding
    Explanation
    The plus symbol (+) is used for adding in a formula in Excel. It is used to perform the arithmetic operation of addition between two or more values. When the plus symbol is included between values or cell references in a formula, Excel will add those values together and return the sum as the result.

    Rate this question:

  • 22. 

    In Excel, what is the following symbol used for in a formula.... /

    • A.

      Division

    • B.

      Multiplying

    • C.

      Adding

    • D.

      Subtracting

    Correct Answer
    A. Division
    Explanation
    The symbol "/" in Excel is used for division in a formula. It indicates that the value before it should be divided by the value after it. For example, if you have a formula "=A1/A2", it means that the value in cell A1 should be divided by the value in cell A2. This allows you to perform mathematical calculations and obtain the quotient or result of the division operation.

    Rate this question:

  • 23. 

    If cell A1 has the formula =2*6, what is displayed in the cell?

    • A.

      -4

    • B.

      8

    • C.

      12

    • D.

      26

    Correct Answer
    C. 12
    Explanation
    The formula in cell A1 is =2*6, which means that it multiplies 2 by 6. The result of this calculation is 12. Therefore, the value displayed in cell A1 is 12.

    Rate this question:

  • 24. 

    If cell A1 has the formula =6/2, what is displayed in the cell?

    • A.

      12

    • B.

      4

    • C.

      3

    • D.

      6

    Correct Answer
    C. 3
    Explanation
    The correct answer is 3 because the formula in cell A1 is dividing 6 by 2, which equals 3. Therefore, the result of this calculation is displayed in cell A1.

    Rate this question:

  • 25. 

    Which of the following is formatted to 2 decimal places?

    • A.

      26

    • B.

      1.26

    • C.

      26.0000

    • D.

      26.000

    Correct Answer
    B. 1.26
    Explanation
    The number 1.26 is formatted to 2 decimal places because it has two digits after the decimal point. The other options either have no decimal point or have more than two digits after the decimal point.

    Rate this question:

  • 26. 

    The SUM function allows us to calculate numbers much faster.

    • A.

      False; it actually takes much longer to use the SUM function.

    • B.

      True; this is much quicker than creating formulas from scratch.

    Correct Answer
    B. True; this is much quicker than creating formulas from scratch.
    Explanation
    The given answer is true because using the SUM function is indeed faster than creating formulas from scratch. The SUM function allows us to quickly add up a range of numbers without having to manually input each number and create a formula. This saves time and effort, making it a quicker option for calculating numbers.

    Rate this question:

  • 27. 

    When you save an Excel workbook, what is the extension at the end of the filename?

    • A.

      .xlt

    • B.

      .xox

    • C.

      .xls

    • D.

      .html

    Correct Answer
    C. .xls
    Explanation
    When you save an Excel workbook, the extension at the end of the filename is .xls. This extension stands for "Excel Spreadsheet" and is the default file format used by Microsoft Excel. It indicates that the file is a spreadsheet created and saved in Excel. Other extensions mentioned in the options (.xlt, .xox, .html) are not commonly used for Excel workbooks and do not represent the default file format.

    Rate this question:

  • 28. 

    Which of the following is spreadsheet software?

    • A.

      Microsoft Word

    • B.

      Microsoft Excel

    • C.

      Microsoft Access

    • D.

      Microsoft PowerPoint

    Correct Answer
    B. Microsoft Excel
    Explanation
    Microsoft Excel is spreadsheet software because it is a program that allows users to create, manipulate, and analyze data in the form of spreadsheets. It provides a grid of cells organized in rows and columns, where users can input and perform calculations on data. Excel also offers various features such as formulas, charts, and graphs, making it a powerful tool for data management and analysis.

    Rate this question:

  • 29. 

    Which of the following is the correct cell address in Excel?

    • A.

      A1

    • B.

      Cell1

    • C.

      Row1

    • D.

      1A

    Correct Answer
    A. A1
  • 30. 

    Bold, italic, underline, and alignment is _____ options.

    • A.

      Excel options only

    • B.

      Shared options

    • C.

      Formatting options

    • D.

      Tool options

    Correct Answer
    C. Formatting options
  • 31. 

    To keep table headings visible, you can use:

    • A.

      Hold panes

    • B.

      Line panes

    • C.

      Freeze panes

    • D.

      Spreadsheet panes

    Correct Answer
    C. Freeze panes
    Explanation
    Freeze panes is a feature in spreadsheet software that allows users to keep certain rows or columns visible while scrolling through a large table. By freezing panes, users can ensure that the table headings remain visible at all times, providing a reference for the data being viewed. This feature is particularly useful when working with large datasets or when analyzing data that spans multiple pages.

    Rate this question:

  • 32. 

    Which is the correct formatting of a formula?

    • A.

      (A2+E3)

    • B.

      =+(A2+E4

    • C.

      =(A2+B4)

    • D.

      =A2+B4

    Correct Answer
    D. =A2+B4
    Explanation
    The correct formatting of a formula is "=A2+B4". In this format, the equal sign at the beginning indicates that it is a formula. The cell references A2 and B4 are separated by the plus sign, indicating that the values in those cells should be added together. This format follows the standard syntax for formulas in most spreadsheet software.

    Rate this question:

  • 33. 

    The values in cells A1 to A5 are all 10.  If we used the Auto SUM function, what is the value of =SUM(A1:A5)?

    • A.

      5

    • B.

      50

    • C.

      500

    • D.

      100

    Correct Answer
    B. 50
    Explanation
    The Auto SUM function adds up the values in a range of cells. In this case, the range is A1 to A5, and all the values in those cells are 10. Therefore, the sum of 10 + 10 + 10 + 10 + 10 is 50.

    Rate this question:

  • 34. 

    It is possible to insert an image into a spreadsheet.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    In most spreadsheet software, it is indeed possible to insert an image into a spreadsheet. This can be done by selecting the appropriate option or tool within the software and choosing the desired image file to be inserted. Once inserted, the image can be resized, positioned, and formatted as needed within the spreadsheet.

    Rate this question:

  • 35. 

    The alphabets in the spreadsheet are

    • A.

      Columns

    • B.

      Rows

    • C.

      Both

    • D.

      None

    Correct Answer
    A. Columns
    Explanation
    The alphabets in the spreadsheet are referred to as columns. In a spreadsheet, data is organized in a grid format with columns running vertically and rows running horizontally. Each column is labeled with a letter to identify it, such as A, B, C, etc. Therefore, the correct answer is columns.

    Rate this question:

Samy Boulos |MSC, Computer Science |
Computer Expert
With over 25 years of expertise, Samy is a seasoned Senior Technology Consultant. His extensive background spans diverse areas such as software development, data migration, Apple and Office 365 integration, computer helpdesk support, data engineering, and cloud computing. A dedicated professional, Samy combines technical proficiency with a strategic mindset, ensuring optimal solutions for complex technological challenges. His wealth of experience positions him as a reliable and knowledgeable consultant in navigating the ever-evolving landscape of IT and technology.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 17, 2024
    Quiz Edited by
    ProProfs Editorial Team

    Expert Reviewed by
    Samy Boulos
  • Jan 11, 2009
    Quiz Created by
    Haroldkym
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.