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.
- 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
Correct Answer
D. My Documents and DesktopExplanation
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.Rate this question:
-
- 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.
Correct Answer
E. Click on Start, Shut Down, then click Shut down from the drop-down dialog box.Explanation
If you chose "E", you know how to properly shut down a computer!Rate this question:
-
- 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.
Correct Answer
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.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.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 5.
True or False: To quickly copy formulas from one cell to another, you would use Formula Painter.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.Rate this question:
-
- 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
Correct Answer
E. None of the aboveExplanation
None of the above. The correct answer is A1:G7.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
False. The Alignment tab allows you to change a cell's text alignment; the Borders tab allows you to add borders to cells.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
This is the first thing you should do, or you risk losing your work in the event of a power failure or system crash.Rate this question:
-
- 9.
Which Microsoft Office application would you use to create a company memo?
- A.
Power Point
- B.
Outlook
- C.
Excel
- D.
Word
- E.
Access
Correct Answer
D. WordExplanation
Word is best suited for writing letters and memos.Rate this question:
-
- 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
Correct Answer
D. =SUM(A1-G7)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.Rate this question:
-
- 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.
Correct Answer
B. Yes, these are two of the ways that you can format the text.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.Rate this question:
-
- 12.
Can I use Microsoft Excel to create a letter?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
You can use Excel to create a letter, but Word is more appropriate for this task.Rate this question:
-
- 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.
Correct Answer(s)
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.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.Rate this question:
-
- 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.
Correct Answer
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.Explanation
Yes. The best answer is the one that describes the process by which a print area can be adjusted.Rate this question:
-
- 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
Correct Answer
B. FalseExplanation
You can copy then paste any file into the same directory; it will be renamed automatically once pasted into the same directory.Rate this question:
-
- 16.
Can a single worksheet be inserted into an entirely different workbook?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
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.Rate this question:
-
- 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.
Correct Answer
D. Right click on the row or rows, select Insert from the list of options.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.Rate this question:
-
- 18.
Can you insert images into an Excel worksheet?
- A.
Yes
- B.
No
Correct Answer
A. YesExplanation
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.Rate this question:
-
- 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.
Correct Answer(s)
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.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.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 23, 2010Quiz Created by
Spdwaver1
Back to top