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

Computer Science

Information Technology

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

Spdwaver1

Community Contributor

Quizzes Created: 1 | Total Attempts: 882

| Attempts: 882 | Questions: 19

Quiz Flashcard

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Question 1 / 19

0 %

0/100

Score 0/100

1. Proper sequence by which to shut down a computer:

Unplug the power cord from the back of the workstation.

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

Press the power button on the front of the workstation.

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

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

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

Explanation

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

Submit

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

What's your name? Tell us your name to personalize your report, certificate & get on the leaderboard!

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

Yes

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.

Explanation

Submit

3. Can you insert images into an Excel worksheet?

Yes

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.

Explanation

Submit

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

True

False

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

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.

True

False

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.

Explanation

Submit

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

Power Point

Outlook

Excel

Word

Access

Word is best suited for writing letters and memos.

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.

True

False

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

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:

"C:\ Drive" and My Computer

Program Files and User Files

My Pictures and My Music

My Documents and Desktop

All of the above

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.

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.

True

False

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

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?

A1:G7=SUM

=A1;G7(SUM)

A1+G7

=SUM(A1-G7)

None of the above

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.

Explanation

Submit

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

Yes

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

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?

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

Go to My Computer, click on the "C:\" drive, then press the Enter key. When this is opened, you... 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.

Click on Start, click on Programs, expand Programs until the full list of applications is displayed. There, in the... 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.

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

Ask the IS Manager.

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.

Explanation

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.

True

False

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.

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)

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

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

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

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

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

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.

Explanation

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?

G1:G7

G7;C2

A1-G7

A7+G7

None of the above

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

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.

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

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

Yes. You can do this by clicking on Print Preview, click on Margins, then click and drag the margins... 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.

No.

Yes.

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

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)

An Excel workbook can not contain more than one worksheet.

Text can be rotated in a cell.

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

Populated cells (containing either a border, text or number) that are outside of the print range will be automatically adjusted... 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.

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

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.

Explanation

Submit

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

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

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

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

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

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

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.

Explanation

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)

Highlight the populated cell or cells, right click and choose Copy, then right click and choose Paste into the cell... 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.

Highlight only the first cell within a range of cells, click on Cut from the toolbar then highlight the other... 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.

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

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

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

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.

Explanation

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.