Microsoft Word And Excel Exam Quiz!
(209).jpg "Microsoft Word And Excel Exam Quiz! - Quiz")
.
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 WordExplanation
Microsoft Word is a word processing software because it is specifically designed for creating, editing, and formatting text documents. It provides various features such as spell check, grammar check, font formatting, page layout, and document templates, which are essential for word processing tasks. On the other hand, Microsoft Excel is a spreadsheet software, Microsoft Internet Explorer is a web browser, and Microsoft Windows Explorer is a file management software.Rate this question:
-
- 2.
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 wrappingExplanation
Text wrapping refers to the automatic adjustment of text to fit within a given space or container. When the text reaches the end of a line and automatically moves to the next line, it is known as text wrapping. This feature is commonly used in word processors, text editors, and web design to ensure that text is displayed in a readable and organized manner. It allows for efficient use of space and prevents text from extending beyond the boundaries of a page or container.Rate this question:
-
- 3.
When entering in 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 keyExplanation
When entering a lot of text in capitals, it is most efficient to use the Caps Lock key. This key allows the user to toggle between uppercase and lowercase letters without having to hold down the Shift key continuously. By activating the Caps Lock key, all letters typed will automatically be in uppercase until the key is deactivated. This saves time and effort when typing lengthy passages in capital letters.Rate this question:
-
- 4.
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 rightExplanation
To move the text to the right side of the page, you would use the "align right" option. This aligns the text to the right margin of the page, allowing it to be positioned on the right side. The other options, such as "align left" and "align top," do not achieve the desired result of moving the text to the right side.Rate this question:
-
- 5.
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 asExplanation
To save a file under a different name, the correct option is "save as." This option allows the user to specify a new name and location for the file while preserving the original file. The "save" option simply saves the file with its current name and location, while "save all" is used to save multiple files at once. "Save new" is not a valid option and does not exist in most software applications.Rate this question:
-
- 6.
To send the same document addressed to 10 different people you should use
- A.
Multiple merge
- B.
Mail merge
- C.
Merge
Correct Answer
B. Mail mergeExplanation
Mail merge is the correct answer because it is a feature in word processing software that allows users to personalize and send the same document to multiple recipients. It combines a template document with a data source, such as a spreadsheet, to automatically populate the document with personalized information for each recipient. This saves time and effort compared to manually creating and sending individual documents to each person.Rate this question:
-
- 7.
To ensure that you do not lose all of your files you should always make a
- A.
Back up copy
- B.
Back down
- C.
Back over
- D.
Back under
Correct Answer
A. Back up copyExplanation
To ensure that you do not lose all of your files, it is recommended to 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 against data loss in case of any unforeseen events like hardware failure, accidental deletion, or system crashes. Having a backup copy allows you to restore your files and prevent permanent loss or damage.Rate this question:
-
- 8.
In addition to using a spell checker you should also always:
- A.
Ignore any mistakes because spellcheck will catch all of them.
- B.
Proofread your papers
- C.
Press read your papers.
Correct Answer
B. Proofread your papersExplanation
In addition to using a spell checker, it is important to proofread your papers. While a spell checker can catch some mistakes, it may not identify all errors, such as incorrect grammar or missing words. Proofreading allows you to carefully review your work, ensuring that it is free from any errors or inconsistencies. It helps to improve the overall quality and clarity of your papers, making them more professional and reliable.Rate this question:
-
- 9.
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 tallerExplanation
Landscape mode refers to the orientation of a paper or document where it is wider than it is taller. This means that the width of the paper is greater than its height. This orientation is commonly used for displaying images or content that is better suited for a wider display, such as panoramic views or wide tables.Rate this question:
-
- 10.
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. HeaderExplanation
The header is an area in the top margin of each page in a document where you can insert text or graphics. It typically contains information such as the document title, page numbers, date, and author's name. The header appears at the top of every page, providing consistency and easy navigation throughout the document.Rate this question:
-
- 11.
The default font in Word is
- A.
Arial
- B.
Comic Sans MS
- C.
Times New Roman
- D.
Courier
Correct Answer
C. Times New RomanExplanation
The default font in Word is Times New Roman.Rate this question:
-
- 12.
To find alternative words with the same/similar meaning use the
- A.
Spell checker
- B.
Thesaurus
- C.
Grammar Checker
- D.
Editor
Correct Answer
B. ThesaurusExplanation
The correct answer is "Thesaurus". A thesaurus is a reference tool that provides alternative words with similar or identical meanings to a given word. It helps in expanding vocabulary and finding synonyms to enhance writing and communication skills. Unlike a spell checker, grammar checker, or editor, a thesaurus specifically focuses on providing synonyms and related words.Rate this question:
-
- 13.
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 pasteExplanation
To move a block of text, you would use the "Cut and paste" function. This involves selecting the desired text and cutting it from its original location, and then pasting it into the desired new location. This action effectively removes the text from its original place and relocates it to the new position.Rate this question:
-
- 14.
Before copying the 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 textExplanation
To copy the text, you must first highlight it. Highlighting the text allows you to select the specific portion of the text that you want to copy. 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:
-
- 15.
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 previewExplanation
To see how a spreadsheet will print out, the most appropriate option is to use the "page preview" feature. This feature allows users to get a visual representation of how the spreadsheet will appear when printed, including the layout, formatting, and any adjustments made for printing purposes. It provides an opportunity to review and make any necessary changes before actually printing the document.Rate this question:
-
- 16.
In Excel, what is the following symbol used for in a formula.... *
- A.
Subtracting
- B.
Dividing
- C.
Multiplying
- D.
Adding
Correct Answer
C. MultiplyingExplanation
The symbol "*" is used for multiplying in a formula in Excel. This means that when this symbol is used between two numbers or cell references, it will calculate the product of those values. For example, if you have the formula "= A1 * B1", it will multiply the values in cell A1 and B1 together to give you the result.Rate this question:
-
- 17.
In Excel, what is the following symbol used for in a formula.... +
- A.
Multiplying
- B.
Dividing
- C.
Adding
- D.
Subtracting
Correct Answer
C. AddingExplanation
The symbol "+" is used for adding in a formula in Excel. It is used to perform the arithmetic operation of addition between two or more numbers or cell references. When the "+" symbol is used in a formula, it adds the values together to give a total or sum. This allows users to perform calculations and manipulate data by adding values from different cells or directly inputting numbers to obtain the desired result.Rate this question:
-
- 18.
In Excel, what is the following symbol used for in a formula.... /
- A.
Division
- B.
Multiplying
- C.
Adding
- D.
Subtracting
Correct Answer
A. DivisionExplanation
The symbol "/" is used for division in Excel formulas. It is used to divide one number by another and obtain the quotient as the result.Rate this question:
-
- 19.
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. 12Explanation
The formula in cell A1 is =2*6, which means that the cell will display the result of multiplying 2 and 6. The product of 2 and 6 is 12, so 12 will be displayed in cell A1.Rate this question:
-
- 20.
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. 3Explanation
The correct answer is 3 because the formula in cell A1 is dividing 6 by 2, which equals 3. Therefore, the result displayed in the cell will be 3.Rate this question:
-
- 21.
What are the steps to changing the tab color in a spreadsheet?
- A.
Right click on the sheet, select the color and click ok
- B.
Right click on the menu bar, select the color and click yes
- C.
Right click on the sheet tab, select tab color, select the color, click ok
- D.
Right click and select the color.
Correct Answer
C. Right click on the sheet tab, select tab color, select the color, click okExplanation
To change the tab color in a spreadsheet, you need to right-click on the sheet tab. Then, select the option for tab color and choose the desired color from the available options. Finally, click on the "ok" button to apply the selected color to the tab.Rate this question:
-
- 22.
Which of the following is formatted to 2 decimal places?
- A.
26
- B.
.26
- C.
26.00
- D.
26.000
Correct Answer
C. 26.00Explanation
The number 26.00 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:
-
- 23.
True or false...The SUM function allows 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 answer is true because the SUM function in Excel allows users to quickly calculate the sum of a range of numbers without having to manually create a formula. By using the SUM function, users can save time and effort as the function automatically adds up the numbers in the specified range, resulting in a faster calculation process compared to creating formulas from scratch.Rate this question:
-
- 24.
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. .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 for saving workbooks. By using this extension, Excel can recognize and open the file correctly, ensuring that the data and formatting are preserved.Rate this question:
-
- 25.
Which of the following is spreadsheet software?
- A.
Microsoft Word
- B.
Microsoft Excel
- C.
Microsoft Access
- D.
Microsoft PowerPoint
Correct Answer
B. Microsoft ExcelExplanation
Microsoft Excel is the correct answer because it is a spreadsheet software commonly used for creating, organizing, and analyzing data. It allows users to create tables, perform calculations, and create charts and graphs. Microsoft Word is a word processing software, Microsoft Access is a database management software, and Microsoft PowerPoint is a presentation software.Rate this question:
-
- 26.
Which of the following is a correct cell address in Excel?
- A.
A1
- B.
Cell1
- C.
Row1
- D.
1A
Correct Answer
A. A1Explanation
A1 is the correct cell address in Excel. In Excel, cell addresses are represented by the combination of a letter and a number. The letter represents the column and the number represents the row. A1 refers to the cell in the first column and the first row, which is the top-left cell in a worksheet.Rate this question:
-
- 27.
Bold, italic, underline and alignment are _____ options.
- A.
Excel options only
- B.
Shared options
- C.
Formatting options
- D.
Tool options
Correct Answer
C. Formatting optionsExplanation
The given correct answer is "Formatting options". This is because bold, italic, underline, and alignment are all formatting options that can be applied to text in Excel. These options allow users to modify the appearance of their data by making it bold, italicized, underlined, or by adjusting its alignment on the spreadsheet.Rate this question:
-
- 28.
Which is the correct formatting of a formula?
- A.
(A2+E3)
- B.
=+(A2+E4
- C.
=(A2+B4)
- D.
=A2+B4
Correct Answer
D. =A2+B4Explanation
The correct formatting of a formula is "=A2+B4". In this format, the equal sign indicates that it is a formula, followed by the cell references A2 and B4, and the plus sign represents the addition operation. This format ensures that the formula is recognized by the software and performs the desired calculation correctly.Rate this question:
-
- 29.
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. 50Explanation
The Auto SUM function adds up the values in a given range. In this case, the range is A1 to A5, and all the values in these cells are 10. Therefore, when we use the Auto SUM function with the range A1:A5, it will add up all the 10s, resulting in a total of 50.Rate this question:
-
- 30.
To save a workbook with a different name you should use
- A.
Save all
- B.
Save
- C.
Save as
- D.
Save once
Correct Answer
C. Save asExplanation
To save a workbook with a different name, you should use the "save as" option. This allows you to create a new copy of the workbook with a different name, while keeping the original version intact. By selecting "save as," you can specify the desired name and location for the new file, ensuring that it is saved separately from the original document.Rate this question:
-
- 31.
True or False. It is possible to insert an image into a spreadsheet.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
It is possible to insert an image into a spreadsheet. This feature is commonly available in spreadsheet software such as Microsoft Excel and Google Sheets. Users can insert images from their computer or from online sources, and resize or position them within the spreadsheet. This functionality is useful for adding visual elements or incorporating charts, graphs, or logos into the spreadsheet for better presentation and analysis.Rate this question:
-
- 32.
The alphabets in the spreadsheet are...
- A.
Columns
- B.
Rows
Correct Answer
A. ColumnsExplanation
The answer is "columns" because a spreadsheet is typically organized into a grid with columns running vertically and rows running horizontally. Each column is labeled with a letter, such as A, B, C, and so on, while each row is labeled with a number, such as 1, 2, 3, and so on. Therefore, the alphabets in the spreadsheet refer to the columns.Rate this question:
-
- 33.
HTML stands for:
- A.
Happy Thanksgiving Mama Luigi
- B.
Hypertext Machine Language
- C.
Hypertext Markup Language
- D.
Hyperlink Textual Mode Language
Correct Answer
C. Hypertext Markup LanguageExplanation
HTML stands for Hypertext Markup Language. It is a standard markup language used for creating and structuring the content of web pages. It is the language that is used to define the structure, layout, and formatting of a webpage, including text, images, links, and other elements. The correct answer is Hypertext Markup Language.Rate this question:
-
- 34.
What tag will have the information that will be displayed in the Web Page?
- A.
HTML Tag
- B.
Body Tag
- C.
Head Tag
- D.
Title Tag
Correct Answer
B. Body TagExplanation
The body tag in HTML contains all the content that will be displayed on the web page. It includes text, images, links, and other elements that make up the visible part of the website. The information within the body tag is what users see when they visit the webpage, making it the correct answer for the tag that holds the information displayed on the web page.Rate this question:
-
- 35.
Which heading tag will create the largest heading?
- A.
H1 tag
- B.
H2 tag
- C.
H5 tag
- D.
H6 tag
Correct Answer
A. H1 tagExplanation
The h1 tag will create the largest heading. In HTML, heading tags are used to define the hierarchy and importance of the headings on a webpage. The h1 tag is the highest level heading and is typically used for the main heading or title of the page. It is considered to have the largest font size and carries the most weight in terms of SEO and accessibility.Rate this question:
-
- 36.
Where should you save your computer files.
- A.
On the desktop
- B.
On your flash drive or personal account
- C.
Anywhere you like.
- D.
Somewhere in your house
Correct Answer
B. On your flash drive or personal accountExplanation
You should save your computer files on your flash drive or personal account because these options provide secure and portable storage. Saving files on the desktop or anywhere you like may lead to data loss or difficulty in accessing the files from other devices. Storing files in your house may not be a reliable option as it is susceptible to physical damage or loss.Rate this question:
-
- 37.
Left justify is the same as
- A.
Align over one space
- B.
Align next
- C.
Align left
- D.
Align all
Correct Answer
C. Align leftExplanation
The term "left justify" refers to aligning text or elements to the left side of a page or container. It means that the content starts from the left margin and extends towards the right. Therefore, "align left" is the correct answer as it accurately describes the action of left justifying the text or elements. "Align over one space," "align next," and "align all" do not specifically convey the idea of aligning to the left side, making them incorrect options.Rate this question:
-
- 38.
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 okExplanation
To place a page break into a document, you need to access the menu bar and click on the "insert" option. From there, select "break" and then choose "page break" from the drop-down menu. After that, click on "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:
-
- 39.
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.
Option 4
Correct Answer
C. You are starting a new paragraphExplanation
The indent option is used when starting a new paragraph. This feature helps to create a visual distinction between paragraphs by adding a space or tab at the beginning of the first line. It is commonly used in academic writing, reports, and other documents where clear paragraph breaks are necessary to enhance readability and organization.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
-
Aug 26, 2023Quiz Edited by
ProProfs Editorial Team -
May 30, 2017Quiz Created by
Minaturene
Are You Smarter Than A 5th Grader? MCQ Quiz Questions
Are You Smarter Than A 5th Grader? MCQ Quiz Questions
Uncover Your True Personality: Take the 'What Am I?' Quiz
Uncover Your True Personality: Take the 'What Am I?' Quiz
Back to top