MS Word & Excel Quiz # 2
Questions and Answers
- 1.
Which of the following is the second step in creating a macro?
- A.
Start recording
- B.
Using your mouse or keyboard, perform the task you want to automate
- C.
Assign a keyboard shortcut to the macro
- D.
Give the macro a name
Correct Answer
D. Give the macro a nameExplanation
The second step in creating a macro is to give the macro a name. This is important because the name will be used to identify and refer to the macro when it is being executed or edited.Rate this question:
-
- 2.
When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
- A.
Unassigned
- B.
Located on the ten-key pad section of your keyboard
- C.
Assigned to another task
- D.
From the same font family as the symbol
Correct Answer
A. UnassignedExplanation
When assigning a shortcut key to a symbol, it is important to select a key or key combination that is unassigned. This ensures that the shortcut key does not conflict with any existing functions or commands on the keyboard. By choosing an unassigned key, the symbol can be easily accessed without interfering with other tasks or commands.Rate this question:
-
- 3.
Which feature is used to replace straight quotes with smart quotes as you type?
- A.
Auto Correct as you type
- B.
Auto Change as you type
- C.
Auto Format as you type
- D.
Smart Tags as you type
Correct Answer
C. Auto Format as you typeExplanation
Auto Format as you type is the feature that is used to replace straight quotes with smart quotes as you type. Smart quotes are typographic quotation marks that curve inwards at the beginning and outwards at the end, giving a more professional and aesthetically pleasing look to the text. This feature automatically formats the quotes as you type, saving the user from manually changing them later.Rate this question:
-
- 4.
Which of the following command is not available in Tools menu?
- A.
Auto text
- B.
Autocorrect
- C.
Auto summarize
- D.
Macro
Correct Answer
A. Auto textExplanation
The command "Auto text" is not available in the Tools menu. This command allows users to create and insert reusable pieces of text or graphics into a document. It is commonly used for inserting frequently used phrases, signatures, or other repetitive content. However, in this case, it is not available in the Tools menu, indicating that it cannot be accessed or used from there.Rate this question:
-
- 5.
Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
- A.
AutoEntry
- B.
AutoCorrect
- C.
AutoAdd
- D.
AutoSpell
Correct Answer
B. AutoCorrectExplanation
AutoCorrect is the correct answer because it is a feature in Word that can detect and correct predefined typing, spelling, capitalization, and grammar errors. It automatically fixes common mistakes as you type, making it easier to produce error-free documents. AutoEntry, AutoAdd, and AutoSpell are not features in Word that specifically perform the function of detecting and correcting errors.Rate this question:
-
- 6.
Which option is not available in Insert Table Autofit behavior?
- A.
Fixed Column Width
- B.
AutoFit to Contents
- C.
Autofit to Window
- D.
Autofit to Column
Correct Answer
D. Autofit to ColumnExplanation
The option "Autofit to Column" is not available in the Insert Table Autofit behavior. This means that when inserting a table, there is no option to automatically adjust the width of the columns to fit the contents of each column.Rate this question:
-
- 7.
Tabs stop position cannot be the following alignment
- A.
Decimal Alignment
- B.
Center Alignment
- C.
Bar Alignment
- D.
Justify Alignment
Correct Answer
D. Justify AlignmentExplanation
Justify alignment is not a valid option for setting tab stop positions. Justify alignment is used to align text evenly between the left and right margins, without inserting any extra space between words. It does not involve setting specific tab stop positions. The other options mentioned (decimal alignment, center alignment, and bar alignment) are valid alignment options for setting tab stop positions.Rate this question:
-
- 8.
Ctrl + B
- A.
Search the selected text
- B.
Paste the selected text
- C.
Bold the selected text
- D.
Open the specified file
Correct Answer
C. Bold the selected textExplanation
Ctrl + B is a keyboard shortcut commonly used in text editors and word processors to apply the bold formatting to the selected text. This formatting change makes the selected text appear thicker and more prominent. By pressing Ctrl + B, the user can quickly and easily emphasize important parts of their text to make them stand out. This shortcut is a convenient and efficient way to format text without needing to use the toolbar or menu options.Rate this question:
-
- 9.
To move the cursor page to page of document
- A.
Ctrl+PgDn
- B.
Ctrl+PgUp
- C.
Both of above
- D.
None of above
Correct Answer
C. Both of aboveExplanation
Both Ctrl+PgDn and Ctrl+PgUp can be used to move the cursor page to page in a document. Ctrl+PgDn moves the cursor to the next page, while Ctrl+PgUp moves the cursor to the previous page. Therefore, both options are correct.Rate this question:
-
- 10.
What is the shortcut key to "Insert Hyperlink" in a document?
- A.
Ctrl + H
- B.
Ctrl + K
- C.
Ctrl + L
- D.
None of above
Correct Answer
B. Ctrl + KExplanation
The shortcut key to "Insert Hyperlink" in a document is Ctrl + K. This keyboard shortcut allows users to quickly insert a hyperlink in their document without having to navigate through the menu options. By pressing Ctrl + K, users can easily add a hyperlink to a selected text or object, making it clickable and allowing for easy navigation to another location or website.Rate this question:
-
- 11.
What is extension of files created in MS-Excel 97-2003
- A.
.xlx
- B.
.msx
- C.
.dot
- D.
.xls
Correct Answer
D. .xlsExplanation
The extension of files created in MS-Excel 97-2003 is .xls. This file format is used for saving spreadsheets in the older versions of Microsoft Excel. The .xls extension indicates that the file is compatible with Excel versions 97-2003.Rate this question:
-
- 12.
What is extension of files created in MS-Excel 2007-2015
- A.
.txt
- B.
.xls
- C.
.xlsx
- D.
.xsl
Correct Answer
C. .xlsxExplanation
The extension of files created in MS-Excel 2007-2015 is .xlsx. This is because Microsoft Excel 2007 and later versions use the Open XML format for saving files, which is denoted by the .xlsx extension. This format allows for more efficient storage of data and improved compatibility with other software applications.Rate this question:
-
- 13.
Which is the correct formula for SUM Function in MS Excel.
- A.
/SUM(A1+A5)
- B.
=SUM(A1-A5)
- C.
=SUM(A1:A5)
- D.
+SUM(A1:A5)
Correct Answer
C. =SUM(A1:A5)Explanation
The correct formula for the SUM function in MS Excel is =SUM(A1:A5). This formula adds up the values in cells A1 to A5.Rate this question:
-
- 14.
Which menu option in MS Excel has the option to "Sort the Data"
- A.
Review
- B.
Data
- C.
Formula
- D.
Insert
Correct Answer
B. DataExplanation
The correct answer is "Data" because the Data menu option in MS Excel provides various tools and options for managing and manipulating data. One of these options is the "Sort" feature, which allows users to sort the data in a selected range or table based on specific criteria, such as alphabetical order or numerical value. This feature is useful for organizing and analyzing data in a structured manner.Rate this question:
-
- 15.
Which button in MS Excel to calculate the sum of number
- A.
AutoSum
- B.
Fill
- C.
Insert
- D.
Merge
Correct Answer
A. AutoSumExplanation
The AutoSum button in MS Excel is used to automatically calculate the sum of numbers in a selected range. By clicking on the AutoSum button, Excel identifies the adjacent cells with numerical values and suggests a sum formula. This saves time and effort in manually typing the formula for summing up the numbers. Therefore, the AutoSum button is the correct answer for calculating the sum of numbers in MS Excel.Rate this question:
-
- 16.
What is the Shortcut key for "Current Date" in Excel
- A.
Ctrl + C
- B.
Ctrl + D
- C.
Alt + ;
- D.
Ctrl + ;
Correct Answer
D. Ctrl + ;Explanation
The shortcut key for "Current Date" in Excel is Ctrl + ;.Rate this question:
-
- 17.
What is the intersection of a column and a row on a worksheet called?
- A.
Column
- B.
Value
- C.
Address
- D.
Cell
Correct Answer
D. CellExplanation
A cell is the intersection of a column and a row on a worksheet. It is the smallest unit of a worksheet where data can be entered or displayed.Rate this question:
-
- 18.
Which type of chart is useful for comparing value over categories?
- A.
Pie Chart
- B.
Column Chart
- C.
Line Chart
- D.
Dot Chart
Correct Answer
B. Column ChartExplanation
A column chart is useful for comparing values over categories because it displays data in vertical columns, with each column representing a different category. The height of each column represents the value of the category, allowing for easy visual comparison between categories. This type of chart is particularly effective when there are multiple categories and the focus is on comparing the values of each category.Rate this question:
-
- 19.
Which function in Excel tells how many numeric entries are there
- A.
Num
- B.
Count
- C.
Sum
- D.
ChkNum
Correct Answer
B. CountExplanation
The Count function in Excel is used to determine the number of cells in a range that contain numeric values. It counts only the cells that have numbers and ignores any text or empty cells. Therefore, the Count function is the appropriate choice to find out how many numeric entries are present in a given range.Rate this question:
-
- 20.
A features that displays only the data in column (s) according to specified criteria
- A.
Formula
- B.
Sorting
- C.
Filtering
- D.
Pivot
Correct Answer
C. FilteringExplanation
Filtering is a feature that allows users to display only the data in a column or multiple columns based on specified criteria. It helps in narrowing down the data to show only the relevant information. By applying filters, users can easily sort through large datasets and focus on the specific data they need. This feature is commonly used in spreadsheet programs and databases to analyze and manipulate data efficiently.Rate this question:
-
- 21.
Statistical calculations and preparation of tables and graphs can be done using
- A.
Adobe Photoshop
- B.
Excel
- C.
Notepad
- D.
Power Point
Correct Answer
B. ExcelExplanation
Excel is the correct answer because it is a powerful spreadsheet software that allows users to perform statistical calculations and organize data in tables and graphs. It provides various functions and formulas that can be used for statistical analysis, such as calculating averages, standard deviations, and correlations. Additionally, Excel has built-in charting tools that enable users to create visually appealing graphs to represent their data. Notepad, Adobe Photoshop, and Power Point are not suitable for statistical calculations and data visualization purposes.Rate this question:
-
- 22.
What type of chart will you use to compare performance of two employees in the year 2016 ?
- A.
Column Chart
- B.
Line Chart
- C.
Pie Chart
- D.
Dot Chart
Correct Answer
B. Line ChartExplanation
A line chart would be the most suitable type of chart to compare the performance of two employees in the year 2016. A line chart is ideal for showing trends and changes over time, which makes it effective for comparing the performance of individuals over a specific period. It allows for easy visualization of how the performance of each employee fluctuated throughout the year, enabling a clear comparison between the two.Rate this question:
-
- 23.
Which one is not a Function in MS Excel ?
- A.
SUM
- B.
AVG
- C.
MAX
- D.
MIN
Correct Answer
B. AVGExplanation
The AVG function is not a function in MS Excel. The SUM, MAX, and MIN functions are all built-in functions in Excel that perform mathematical calculations. However, the AVG function, which calculates the average of a range of cells, is not available in Excel.Rate this question:
-
- 24.
Functions in MS Excel must begin with ___
- A.
An () sign
- B.
An Equal Sign
- C.
A Plus Sign
- D.
A > Sign
Correct Answer
B. An Equal SignExplanation
Functions in MS Excel must begin with an equal sign because the equal sign is used to indicate that the following characters are part of a formula or function. This is a convention in Excel to differentiate between regular data and formulas. By starting a function with an equal sign, Excel knows to interpret the following characters as a command to perform a specific calculation or operation.Rate this question:
-
- 25.
Which function in Excel checks whether a condition is true or not ?
- A.
SUMAVER
- B.
COUNT
- C.
IF
- D.
AVERAGE
Correct Answer
C. IFExplanation
The IF function in Excel checks whether a condition is true or not. It allows you to specify a condition and then perform different actions based on whether the condition is true or false. This function is commonly used in formulas to perform calculations or return specific values based on certain criteria.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 15, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 10, 2020Quiz Created by
Copa201718
Back to top