Microsoft Word And Excel Practice Test: Quiz!
-
To ensure that you do not lose all of your files, you should always make a
-
Backup copy
-
Back down
-
Back over
-
Back under
-
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.
(185).jpg "Microsoft Word And Excel Practice Test: Quiz! - Quiz")
Quiz Preview
- 2.
To move the text to the right side of the page, you would use
-
Align left
-
Align over one space
-
Align-right
-
Align top
Correct Answer
A. Align-rightExplanation
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:
-
- 3.
If cell A1 has the formula =2*6, what is displayed in the cell?
-
-4
-
8
-
12
-
26
Correct Answer
A. 12Explanation
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:
-
- 4.
If cell A1 has the formula =6/2, what is displayed in the cell?
-
12
-
4
-
3
-
6
Correct Answer
A. 3Explanation
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:
-
- 5.
Which of the following is word processing software?
-
Microsoft Word
-
Microsoft Excel
-
Microsoft Internet Explorer
-
Microsoft Windows Explorer
Correct Answer
A. Microsoft WordExplanation
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:
-
- 6.
To save a file under a different name, you should use
-
Save as
-
Save
-
Save all
-
Save new
Correct Answer
A. Save asExplanation
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:
-
- 7.
In Excel, what is the following symbol used for in a formula.... /
-
Division
-
Multiplying
-
Adding
-
Subtracting
Correct Answer
A. DivisionExplanation
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:
-
- 8.
The SUM function allows us to calculate numbers much faster.
-
False; it actually takes much longer to use the SUM function.
-
True; this is much quicker than creating formulas from scratch.
Correct Answer
A. 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:
-
- 9.
In Excel, what is the following symbol used for in a formula.... +
-
Multiplying
-
Dividing
-
Adding
-
Subtracting
Correct Answer
A. AddingExplanation
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:
-
- 10.
Left justify is the same as
-
Align over one space
-
Align next
-
Align left
-
Align all
Correct Answer
A. Align leftExplanation
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:
-
- 11.
Which of the following is spreadsheet software?
-
Microsoft Word
-
Microsoft Excel
-
Microsoft Access
-
Microsoft PowerPoint
Correct Answer
A. Microsoft ExcelExplanation
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:
-
- 12.
Which of the following is the correct cell address in Excel?
-
A1
-
Cell1
-
Row1
-
1A
Correct Answer
A. A1 -
- 13.
When entering a lot of text in capitals, you should use the
-
Enter key
-
Big letter key
-
All caps key
-
Caps lock key
Correct Answer
A. Caps lock keyExplanation
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:
-
- 14.
To see how a spreadsheet will print out, you should use
-
Page overview
-
Page preview
-
Page break
-
Look at the page
Correct Answer
A. Page previewExplanation
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:
-
- 15.
It is possible to insert an image into a spreadsheet.
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 16.
Before copying text, you must first
-
Move the text
-
Delete the text
-
Highlight the text
-
Copy the text
Correct Answer
A. Highlight the textExplanation
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:
-
- 17.
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)?
-
5
-
50
-
500
-
100
Correct Answer
A. 50Explanation
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:
-
- 18.
The ____ is an area in the top margin of each page in a document where you can insert text or graphics.
-
Headnote
-
Top margin
-
Footer
-
Header
Correct Answer
A. Header -
- 19.
When you save an Excel workbook, what is the extension at the end of the filename?
-
.xlt
-
.xox
-
.xls
-
.html
Correct Answer
A. .xlsExplanation
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:
-
- 20.
Landscape mode is when the paper is
-
Taller than it is wider
-
Wider than it is taller
-
Smaller than normal
-
Bigger than normal
Correct Answer
A. Wider than it is tallerExplanation
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:
-
- 21.
To send the same document addressed to 10 different people, you should use
-
Multiple merge
-
Mail merge
-
Merge
-
None of the above
Correct Answer
A. Mail mergeExplanation
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:
-
- 22.
To find alternative words with the same/similar meaning, use the
-
Spell checker
-
Thesaurus
-
Grammar Checker
-
Editor
Correct Answer
A. ThesaurusExplanation
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:
-
- 23.
Bold, italic, underline, and alignment is _____ options.
-
Excel options only
-
Shared options
-
Formatting options
-
Tool options
Correct Answer
A. Formatting options -
- 24.
The steps to place a page break into a document are
-
Right-click, insert break
-
On the menu bar, click insert, break, page break, click ok
-
Click in front of the paragraph and hit enter until it reaches the next page.
-
None of the above
Correct Answer
A. On the menu bar, click insert, break, page break, click okExplanation
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:
-
- 25.
You would use the indent option when
-
You are in the middle of a document
-
You are at the end of the document
-
You are starting a new paragraph
-
You are anywhere in the paragraph
Correct Answer
A. You are starting a new paragraphExplanation
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:
-
- 26.
When the text automatically goes onto the next line, this is called?
-
Page wrap
-
Page wrap
-
Word wrap
-
Text wrapping
Correct Answer
A. Text wrappingExplanation
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:
-
- 27.
Which of the following is formatted to 2 decimal places?
-
26
-
1.26
-
26.0000
-
26.000
Correct Answer
A. 1.26Explanation
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:
-
- 28.
The alphabets in the spreadsheet are
-
Columns
-
Rows
-
Both
-
None
Correct Answer
A. ColumnsExplanation
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:
-
- 29.
What programming aspect does Microsoft Excel have that allows the user to employ a wide variety of numerical methods?
-
Java
-
Python
-
Visual Basic for Applications
-
C++
Correct Answer
A. Visual Basic for ApplicationsExplanation
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:
-
- 30.
To keep table headings visible, you can use:
-
Hold panes
-
Line panes
-
Freeze panes
-
Spreadsheet panes
Correct Answer
A. Freeze panesExplanation
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:
-
- 31.
To move a block of text, you would use
-
Cut and copy
-
Copy and paste
-
Cut and paste
-
Move block
Correct Answer
A. Cut and pasteExplanation
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:
-
- 32.
Where should you save your computer files?
-
On the desktop
-
On your flash drive or personal account
-
Anywhere you like
-
In the memory card
Correct Answer
A. On your flash drive or personal accountExplanation
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:
-
- 33.
The default font in Word is
-
Arial
-
Comic Sans MS
-
Times New Roman
-
Courier
Correct Answer
A. Times New RomanExplanation
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:
-
- 34.
Which is the correct formatting of a formula?
-
(A2+E3)
-
=+(A2+E4
-
=(A2+B4)
-
=A2+B4
Correct Answer
A. =A2+B4Explanation
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:
-
- 35.
To control where a page should end, you can always insert a
-
Hard page break
-
End page break
-
Merge page break
-
None of the above
Correct Answer
A. Hard page breakExplanation
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:
-
Quiz Review Timeline (Updated): Jun 17, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jun 17, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Samy Boulos -
Jan 11, 2009Quiz Created by
Haroldkym
Back to top