MS Word & Excel Quiz # 2

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 Copa201718
C
Copa201718
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,124
| Attempts: 624
SettingsSettings
Please wait...
  • 1/25 Questions

    Ctrl + B

    • Search the selected text
    • Paste the selected text
    • Bold the selected text
    • Open the specified file
Please wait...
About This Quiz

This quiz tests knowledge on MS Word & Excel, focusing on macros, shortcut keys, AutoFormat, and AutoCorrect features.

MS Word & Excel Quiz # 2 - Quiz

Quiz Preview

  • 2. 

    Which button in MS Excel to calculate the sum of number

    • AutoSum

    • Fill

    • Insert

    • Merge

    Correct Answer
    A. AutoSum
    Explanation
    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:

  • 3. 

    Statistical calculations and preparation of tables and graphs can be done using

    • Adobe Photoshop

    • Excel

    • Notepad

    • Power Point

    Correct Answer
    A. Excel
    Explanation
    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:

  • 4. 

    Which is the correct formula for SUM Function in MS Excel.

    • /SUM(A1+A5)

    • =SUM(A1-A5)

    • =SUM(A1:A5)       

    • +SUM(A1:A5)

    Correct Answer
    A. =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:

  • 5. 

    Functions in MS Excel must begin with ___

    • An () sign

    • An Equal Sign

    • A Plus Sign

    • A > Sign

    Correct Answer
    A. An Equal Sign
    Explanation
    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:

  • 6. 

    What is the intersection of a column and a row on a worksheet called?

    • Column

    • Value

    • Address

    • Cell

    Correct Answer
    A. Cell
    Explanation
    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:

  • 7. 

    Which function in Excel checks whether a condition is true or not ? 

    • SUMAVER

    • COUNT

    • IF

    • AVERAGE

    Correct Answer
    A. IF
    Explanation
    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:

  • 8. 

    Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.

    • AutoEntry

    • AutoCorrect

    • AutoAdd

    • AutoSpell

    Correct Answer
    A. AutoCorrect
    Explanation
    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:

  • 9. 

    What is extension of files created in MS-Excel 97-2003

    • .xlx

    • .msx

    • .dot

    • .xls

    Correct Answer
    A. .xls
    Explanation
    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:

  • 10. 

    To move the cursor page to page of document

    • Ctrl+PgDn

    • Ctrl+PgUp

    • Both of above

    • None of above

    Correct Answer
    A. Both of above
    Explanation
    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:

  • 11. 

    Which menu option in MS Excel has the option to "Sort the Data"

    • Review

    • Data

    • Formula

    • Insert

    Correct Answer
    A. Data
    Explanation
    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:

  • 12. 

     Which of the following is the second step in creating a macro?

    • Start recording

    • Using your mouse or keyboard, perform the task you want to automate

    •  Assign a keyboard shortcut to the macro

    • Give the macro a name

    Correct Answer
    A. Give the macro a name
    Explanation
    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:

  • 13. 

    Which one is not a Function in MS Excel ?

    • SUM

    • AVG

    • MAX

    • MIN

    Correct Answer
    A. AVG
    Explanation
    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:

  • 14. 

    Which function in Excel tells how many numeric entries are there

    • Num

    • Count

    • Sum

    • ChkNum

    Correct Answer
    A. Count
    Explanation
    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:

  • 15. 

    When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:

    • Unassigned

    • Located on the ten-key pad section of your keyboard

    • Assigned to another task

    • From the same font family as the symbol

    Correct Answer
    A. Unassigned
    Explanation
    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:

  • 16. 

    What is extension of files created in MS-Excel 2007-2015

    • .txt

    • .xls

    • .xlsx

    • .xsl

    Correct Answer
    A. .xlsx
    Explanation
    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:

  • 17. 

    Which type of chart is useful for comparing value over categories?

    • Pie Chart

    • Column Chart

    • Line Chart

    • Dot Chart

    Correct Answer
    A. Column Chart
    Explanation
    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:

  • 18. 

    A features that displays only the data in column (s) according to specified criteria

    • Formula

    • Sorting

    • Filtering

    • Pivot

    Correct Answer
    A. Filtering
    Explanation
    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:

  • 19. 

    Tabs stop position cannot be the following alignment

    • Decimal Alignment

    • Center Alignment

    • Bar Alignment

    • Justify Alignment

    Correct Answer
    A. Justify Alignment
    Explanation
    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:

  • 20. 

    What is the shortcut key to "Insert Hyperlink" in a document?

    • Ctrl + H

    • Ctrl + K

    • Ctrl + L

    • None of above

    Correct Answer
    A. Ctrl + K
    Explanation
    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:

  • 21. 

    What is the Shortcut key for "Current Date" in Excel

    • Ctrl + C

    • Ctrl + D

    • Alt + ;

    • Ctrl + ;

    Correct Answer
    A. Ctrl + ;
    Explanation
    The shortcut key for "Current Date" in Excel is Ctrl + ;.

    Rate this question:

  • 22. 

    What type of chart will you use to compare performance of two employees in the year 2016 ?

    • Column Chart

    • Line Chart

    • Pie Chart

    • Dot Chart

    Correct Answer
    A. Line Chart
    Explanation
    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 feature is used to replace straight quotes with smart quotes as you type?

    • Auto Correct as you type

    • Auto Change as you type

    • Auto Format as you type

    • Smart Tags as you type

    Correct Answer
    A. Auto Format as you type
    Explanation
    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:

  • 24. 

     Which of the following command is not available in Tools menu?

    • Auto text

    • Autocorrect

    • Auto summarize

    • Macro

    Correct Answer
    A. Auto text
    Explanation
    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:

  • 25. 

    Which option is not available in Insert Table Autofit behavior?

    • Fixed Column Width

    • AutoFit to Contents

    • Autofit to Window

    • Autofit to Column

    Correct Answer
    A. Autofit to Column
    Explanation
    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:

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

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

  • Current Version
  • Mar 15, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 10, 2020
    Quiz Created by
    Copa201718
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.