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

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Spdwaver1
S
Spdwaver1
Community Contributor
Quizzes Created: 1 | Total Attempts: 882
| Attempts: 882 | Questions: 19
Please wait...
Question 1 / 19
0 %
0/100
Score 0/100
1. Proper sequence by which to shut down a computer:

Explanation

If you chose "E", you know how to properly shut down a computer!

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

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... see moresome of them. Do give it a try and answer the quiz as best as you can. see less

2. Can a single worksheet be inserted into an entirely different workbook?

Explanation

Yes, a single worksheet can be inserted into an entirely different workbook. This can be done by copying the worksheet from one workbook and pasting it into another workbook. It allows for the consolidation of data or the sharing of specific information between workbooks.

Submit
3. Can you insert images into an Excel worksheet?

Explanation

Yes, you can insert images into an Excel worksheet. Excel allows users to insert images in various formats such as JPEG, PNG, GIF, etc. This feature is useful when you want to include visual elements like logos, charts, or product images in your spreadsheet. To insert an image, you can go to the "Insert" tab, click on the "Pictures" button, and then select the desired image file from your computer.

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

Explanation

This is the first thing you should do, or you risk losing your work in the event of a power failure or system crash.

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

Explanation

To quickly copy formulas from one cell to another, you would not use Formula Painter. Formula Painter is a feature in Microsoft Excel that allows you to copy formatting from one cell to another, not formulas. To copy formulas, you can use the fill handle, which is a small square at the bottom right corner of a selected cell. By dragging the fill handle, you can quickly copy the formula to adjacent cells while adjusting the cell references accordingly.

Submit
6. Which Microsoft Office application would you use to create a company memo?

Explanation

Word is best suited for writing letters and memos.

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

Explanation

False. The Alignment tab allows you to change a cell's text alignment; the Borders tab allows you to add borders to cells.

Submit
8. The two default directories within Windows where one would normally find all user files and documents are:

Explanation

These are the two default locations into which most applications will save user-created files by default. New directories can be created just about anywhere, but these are the defaults.

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

Explanation

You can copy then paste any file into the same directory; it will be renamed automatically once pasted into the same directory.

Submit
10. Which of these describes a valid formula?

Explanation

The correct answer is "=SUM(A1-G7)". This formula is valid because it follows the correct syntax for a formula in most spreadsheet software. The equal sign at the beginning indicates that it is a formula, followed by the function name "SUM". The parentheses enclose the arguments for the function, which in this case is the subtraction of cell A1 from cell G7. This formula will calculate the sum of the values in these two cells.

Submit
11. Can I use Microsoft Excel to create a letter?

Explanation

You can use Excel to create a letter, but Word is more appropriate for this task.

Submit
12. What is the correct way find Microsoft Word in Windows?

Explanation

The correct way to find Microsoft Word in Windows is to click on Start, then click on Programs, and expand Programs until the full list of applications is displayed. In the list, Microsoft Word can be found along with the other Office applications.

Submit
13. 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.

Explanation

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

Submit
14. 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)

Explanation

The explanation for the given correct answer is that the statement is true. You can indeed change the alignment of text within a cell by either clicking on Format, Cells, then the Alignment tab or by changing the text alignment from the Formatting toolbar. These are two valid methods to format the text in Excel.

Submit
15. 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?

Explanation

None of the above. The correct answer is A1:G7.

Submit
16. Adjusting the margins on a worksheet can allow more cells to fit within a printed area. Select the best answer.

Explanation

Yes. The best answer is the one that describes the process by which a print area can be adjusted.

Submit
17. Which of the following statements is true? (Select all that apply)

Explanation

The answer is correct because text can indeed be rotated in a cell in Excel. This can be done by selecting the cell, going to the "Home" tab, clicking on the "Alignment" group, and then selecting the desired rotation angle. Additionally, there are multiple ways to copy and paste the contents of a cell in Excel, such as using the copy and paste shortcuts (Ctrl+C and Ctrl+V), using the right-click menu, or using the "Copy" and "Paste" options in the "Home" tab.

Submit
18. Choose the correct process by which new rows can be inserted into a worksheet:

Explanation

To insert new rows into a worksheet, you need to right-click on the row or rows where you want to add the new rows. Then, select "Insert" from the list of options that appear. This will create new rows above the selected row or rows, allowing you to add data or information in the newly inserted rows.

Submit
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)

Explanation

The correct answer is to press 'ctrl + x' in the populated cell or cells, then 'ctrl + v' into the empty cell or cells, and to right click on the cell or cells in question, then choose Cut; right click on the empty cell or cells then choose Paste. These are both valid processes for cutting and pasting data in Excel. The other options mentioned in the question are incorrect or do not apply to cutting and pasting data in Excel.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 23, 2010
    Quiz Created by
    Spdwaver1
Cancel
  • All
    All (19)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Proper sequence by which to shut down a computer:
Can a single worksheet be inserted into an entirely different...
Can you insert images into an Excel worksheet?
True or False: When starting a new Excel workbook, it is best NOT to...
True or False: To quickly copy formulas from one cell to another, you...
Which Microsoft Office application would you use to create a company...
True or False:  To add borders to a cell or a range of cells, you...
The two default directories within Windows where one would normally...
True or False: You can't copy an Office document or spreadsheet...
Which of these describes a valid formula?
Can I use Microsoft Excel to create a letter?
What is the correct way find Microsoft Word in Windows?
True or False:  To insert a new sheet into an Excel workbook...
To change the alignment of text within a cell, you can choose either...
A group of cells that have been highlighted would be considered a...
Adjusting the margins on a worksheet can allow more cells to fit...
Which of the following statements is true? (Select all that apply)
Choose the correct process by which new rows can be inserted into a...
Select the processes by which one would cut the contents of one cell...
Alert!

Advertisement