Identify The Proficiency Of Microsoft Excel Quiz

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 Lopeze761
L
Lopeze761
Community Contributor
Quizzes Created: 1 | Total Attempts: 190
| Attempts: 194
SettingsSettings
Please wait...
  • 1/122 Questions

    You can have results of any database table into Excel Worksheet, and by one click you can refresh the results?

    • True
    • False
Please wait...
Identify The Proficiency Of Microsoft Excel Quiz - Quiz
About This Quiz

This quiz is created to identify the proficiency of users about Microsoft Excel.

Quiz Preview

  • 2. 

    The Insert Function dialog box tells you how to use functions.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The Insert Function dialog box provides instructions on how to use functions. It guides users on the steps to follow in order to correctly utilize functions in their calculations or formulas. This can be helpful for users who are not familiar with the specific syntax or parameters required for a particular function. By providing guidance and instructions, the Insert Function dialog box assists users in effectively using functions in their work.

    Rate this question:

  • 3. 

    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because when adding a record to a table, it is common practice to enter the data in the first blank row. This ensures that the data is organized sequentially and makes it easier to locate and manage the records. By entering the data in the first blank row, it also avoids any potential conflicts or overwriting of existing data in the table.

    Rate this question:

  • 4. 

    In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    In Excel, charts can remain linked or connected to the data sources even if they appear in different worksheets. This can be achieved by selecting the chart, going to the "Design" tab, and clicking on "Select Data". From there, you can update the data range for the chart to ensure it is linked to the correct data source. Therefore, the statement that charts do not remain linked or connected to the data sources if they appear in different worksheets is false.

    Rate this question:

  • 5. 

    Once you hide a row, it remains hidden as long as the workbook is active.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When you hide a row in a workbook, it will remain hidden as long as the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only way to make the row visible again is to unhide it manually. Therefore, the statement is true.

    Rate this question:

  • 6. 

    Formatting data only change the appearance of data, it does not affect the data itself.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Formatting data refers to changing the way data is displayed, such as changing the font, color, or alignment. This does not alter the actual content or value of the data. For example, if a number is formatted to display with two decimal places, it does not change the actual value of the number. Similarly, if text is formatted to be bold or italic, it does not change the actual text itself. Therefore, formatting data only affects the visual representation of the data and does not impact the underlying data itself.

    Rate this question:

  • 7. 

    You can create maximum one Excel table in a worksheet

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because you can create multiple Excel tables in a worksheet. Excel allows you to create multiple tables within a single worksheet to organize and analyze data in different ways. Each table can have its own set of columns and rows, and you can apply different formatting and calculations to each table independently. This feature is useful when you have multiple sets of data that you want to manage separately within the same worksheet.

    Rate this question:

  • 8. 

    As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When you start typing a function name within a formula in a cell, a list of functions that start with the letters you have typed will appear. This feature is available in most spreadsheet software, such as Microsoft Excel and Google Sheets, to assist users in quickly finding and selecting the desired function without having to remember the exact name or syntax.

    Rate this question:

  • 9. 

    On an Excel spreadsheet the active cell is indicated by

    • A dark wide border

    • A dotted border

    • A blinking border

    • None of the above

    Correct Answer
    A. A dark wide border
    Explanation
    The active cell on an Excel spreadsheet is indicated by a dark wide border. This border helps users easily identify which cell is currently selected and ready for input or editing. The other options, such as a dotted border or a blinking border, are not commonly used to indicate the active cell in Excel.

    Rate this question:

  • 10. 

    A worksheet is..

    • A symbol that represents a specific action

    • Refers to the change a formula makes when it is moved or copied to other cells with different data

    • A table of data that is organized into rows and columns

    Correct Answer
    A. A table of data that is organized into rows and columns
    Explanation
    A worksheet is a table of data that is organized into rows and columns. It is a tool used in spreadsheet programs, such as Microsoft Excel, to store and manipulate data. Worksheets allow users to input and organize data in a structured manner, making it easier to analyze and perform calculations on the data. The rows and columns provide a grid-like structure that helps in organizing and referencing the data effectively.

    Rate this question:

  • 11. 

    What is a Chart?  

    • It is a visual way to display and compare data

    • A way of arranging data in a particular order

    • A calculation that describes the relationship between cells

    Correct Answer
    A. It is a visual way to display and compare data
    Explanation
    A chart is a visual representation that allows for the display and comparison of data. It provides a visual way to present information in a clear and organized manner, making it easier to understand and analyze. Charts can be used to show trends, patterns, and relationships between different data points, making it a valuable tool for data analysis and decision-making.

    Rate this question:

  • 12. 

    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry.

    • Shift

    • Tab

    • Esc

    • Alt

    Correct Answer
    A. Tab
    Explanation
    Pressing the Tab key allows you to accept the existing entry in the column that matches the characters you have typed in Excel. This key is used to move to the next cell in the row, and when an existing entry matches the characters you have typed, pressing Tab confirms and accepts that entry.

    Rate this question:

  • 13. 

    You can use a spreadsheets package like the Microsoft Excel To _________________

    • Design speadsheets models.

    • Create charts.

    • Perform mathematical operations

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    A spreadsheets package like Microsoft Excel can be used to design spreadsheets models, create charts, and perform mathematical operations. It provides a wide range of functions and features that allow users to organize and analyze data efficiently. With the ability to input data, apply formulas, and generate visual representations, Excel is a versatile tool for various tasks related to data manipulation and analysis.

    Rate this question:

  • 14. 

    What would be the effect of the formula shown below in an Excel spreadsheet assuming cells A1 & A2 contain numbers? =A1^A2

    • Multiply the value in A1 by the value in A2

    • Raise the value in cell A1 to the power of A2

    • Change cell values in A1 and A2 to text

    • Compare the values in A1 and A2 and display the larger one

    Correct Answer
    A. Raise the value in cell A1 to the power of A2
    Explanation
    The formula "=A1^A2" in an Excel spreadsheet would raise the value in cell A1 to the power of A2.

    Rate this question:

  • 15. 

    A Logical test in Excel can contain =, >=, <=, >,<, <>, $

    • All Except $

    • All Except

    • All Except =

    • All Except >=

    Correct Answer
    A. All Except $
    Explanation
    The correct answer is "All Except $". This means that all of the logical test operators listed in the question are valid except for the "$" symbol. The "$" symbol is not a valid operator for logical tests in Excel.

    Rate this question:

  • 16. 

    A function inside another function is called a _____________ function.

    • Nested

    • Round

    • Complex

    • None of the above

    Correct Answer
    A. Nested
    Explanation
    A function inside another function is called a nested function because it is enclosed within the scope of the outer function. This allows the nested function to access variables and parameters from the outer function, creating a hierarchical structure. The nesting of functions can be useful for organizing code and creating modular and reusable components.

    Rate this question:

  • 17. 

    The divide symbol is

    • /

    • D

    • \

    • )

    Correct Answer
    A. /
    Explanation
    The divide symbol is represented by the forward slash (/). It is commonly used in mathematics to indicate division between two numbers or quantities. The forward slash is a widely recognized symbol for division and is used in mathematical equations and expressions to separate the numerator and denominator.

    Rate this question:

  • 18. 

    You can print

    • A range of cells by range name

    • An entire workbook

    • A single worksheet

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    The correct answer is "All of the above" because the statement implies that you can print a range of cells by range name, an entire workbook, or a single worksheet. This means that you have the flexibility to choose what you want to print based on your needs.

    Rate this question:

  • 19. 

    You can modify an exisiting chart?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because in most charting software or applications, you have the ability to modify an existing chart. This can include changing the chart type, adding or removing data series, adjusting the formatting, and updating the chart title or axis labels. Modifying an existing chart allows you to make updates or improvements to the visual representation of your data without having to recreate the entire chart from scratch.

    Rate this question:

  • 20. 

    Which number formatting style adds the dollar signs and commas to values?

    • Comma

    • Currency

    • Percent

    • AdjustDecimal

    Correct Answer
    A. Currency
    Explanation
    The currency number formatting style adds dollar signs and commas to values. This formatting is commonly used when displaying monetary values to make them more readable and standardized. The dollar sign indicates the currency symbol, while the commas are used to separate thousands, millions, and so on. This formatting style helps to improve clarity and ease of understanding when dealing with financial data.

    Rate this question:

  • 21. 

    An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the user to quickly organize the data in either ascending (A to Z) or descending (Z to A) order based on the selected sort field. This eliminates the need for manual sorting and makes the process more efficient. Therefore, the statement "True" accurately reflects the given explanation.

    Rate this question:

  • 22. 

    Columns are identified by a _______________ .  

    • Letter

    • Number

    • Word

    Correct Answer
    A. Letter
    Explanation
    Columns are identified by a letter in many systems and formats, such as spreadsheets or databases. Each column is typically assigned a unique letter as its identifier, which allows for easy reference and organization of data. This letter-based identification system is commonly used because it provides a clear and concise way to distinguish between different columns in a table or dataset.

    Rate this question:

  • 23. 

    Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

    • Count

    • Average

    • Sum

    Correct Answer
    A. Sum
    Explanation
    The formula that can add all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the SUM formula. The SUM formula adds up all the numbers in a given range and ignores any non-numeric values. It provides the total sum of the numeric values in the range, making it the appropriate formula for this scenario.

    Rate this question:

  • 24. 

    What is the function of the autofit ?

    • A symbol that represents a specific action

    • A way of arranging data in a particular order

    • Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

    Correct Answer
    A. Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
    Explanation
    Autofit is a function that automatically adjusts the width of a column to accommodate the longest entry in that column or changes the height of a row to fit the font size.

    Rate this question:

  • 25. 

    What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as?    

    • Matrix

    • Window

    • Sheet

    • Cell

    Correct Answer
    A. Cell
    Explanation
    The area at the intersection of a single row and column in an Excel spreadsheet is referred to as a cell.

    Rate this question:

  • 26. 

    Ctrl+B key makes the shortcut for making font in selected cell bold.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because pressing the Ctrl+B key combination is a shortcut for making the font in a selected cell bold.

    Rate this question:

  • 27. 

    A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this?

    • Go to file - save as - save as type - excel 4.0 worksheet

    • Right click on the worksheet tab and select delete

    • Right click on the worksheet and select insert - entire column

    Correct Answer
    A. Right click on the worksheet tab and select delete
    Explanation
    To remove a worksheet from a workbook, the correct sequence of events is to right-click on the worksheet tab and select delete. This action will delete the selected worksheet from the workbook.

    Rate this question:

  • 28. 

    Which of the following formulas would find the sum of the cells in column J between rows 1 and 8 in an Excel spreadsheet?

    • =ADD(J1-J8)

    • =SUM(J1:J8)

    • =J:1+J:8

    • =SUM J:1-8

    Correct Answer
    A. =SUM(J1:J8)
    Explanation
    The correct answer is =SUM(J1:J8) because the SUM function in Excel is used to add up a range of cells. In this case, it is specifying the range from cell J1 to J8, which means it will sum the values in all the cells in column J between rows 1 and 8.

    Rate this question:

  • 29. 

    When a formula is written in a cell. It appears in the the active cell in which it is being written and in the __________________ bar as well.  

    • Formula

    • Name Box

    • Title bar

    Correct Answer
    A. Formula
    Explanation
    When a formula is written in a cell, it appears in the active cell where it is being written and in the formula bar as well. The formula bar displays the formula that is entered in the active cell, allowing users to view and edit the formula easily. This feature helps users keep track of the formulas they have entered and make any necessary changes.

    Rate this question:

  • 30. 

    The _________________ displays the name of the sheets in the workbook.

    • Sheet Tabs

    • Book Tabs

    • Menu Bar

    Correct Answer
    A. Sheet Tabs
    Explanation
    The sheet tabs in a workbook display the names of the sheets. This allows users to easily navigate between different sheets within the workbook.

    Rate this question:

  • 31. 

    Graphics objects on a chart are used to

    • Add emphasis to chart data

    • Add interest to a chart

    • Help explain the chart data

    • All of Above

    Correct Answer
    A. All of Above
    Explanation
    Graphics objects on a chart are used to add emphasis to chart data, add interest to a chart, and help explain the chart data. By incorporating graphics objects such as colors, shapes, and images, the chart becomes more visually appealing and engaging. These elements can also be strategically placed to highlight important data points or trends, making it easier for viewers to understand and interpret the information presented in the chart. Therefore, all of the given options are correct.

    Rate this question:

  • 32. 

    If you have columns that are truncating your content, but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:

    • Abbreviate all text

    • Reduce the font size to 8 pt

    • Click Wrap text

    • Delete one column

    Correct Answer
    A. Click Wrap text
    Explanation
    Click Wrap text is the correct answer because it allows the text to be displayed in multiple lines within a cell, making it visible without truncating or losing any data. This feature automatically adjusts the height of the cell to accommodate the wrapped text. It is a practical solution when there is limited space and the content needs to be fully visible without sacrificing any information.

    Rate this question:

  • 33. 

    Which function converts miles to kilometers, kilograms to pounds, and so on?

    • Convert

    • Product

    • Change

    • All of above

    Correct Answer
    A. Convert
    Explanation
    The function "Convert" is the correct answer because it is a general term used to describe the action of converting one unit of measurement to another. In this case, it can be used to convert miles to kilometers, kilograms to pounds, and other similar conversions. The other options, "Product" and "Change," do not specifically refer to the act of conversion. The option "All of above" is incorrect because it includes options that are not related to conversion.

    Rate this question:

  • 34. 

    How would you print formulas?

    • Click the Microsoft Office Button and then click Print.

    • Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

    • Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.

    Correct Answer
    A. Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.
    Explanation
    To print formulas, you need to first go to the Formulas tab and point to Formula Auditing. Then, click on Show Formulas to display the formulas instead of the calculated values. After that, click on the Microsoft Office Button and select Print to print the formulas.

    Rate this question:

  • 35. 

    A Function is?

    • A symbol that represents a specific action

    • A way of arranging data in a particular order

    • A built-in formula in Excel

    Correct Answer
    A. A built-in formula in Excel
    Explanation
    A function is a built-in formula in Excel that performs a specific action or calculation on data. It is a predefined formula that simplifies complex calculations and allows users to perform various tasks such as mathematical operations, statistical analysis, and data manipulation. Functions in Excel are represented by symbols and are used to automate calculations and save time for users.

    Rate this question:

  • 36. 

    A Range in Microsoft Excel refers to...

    • A group of cells

    • A calculation that describes the relationship between cells

    • A way of arranging data in a particular order

    Correct Answer
    A. A group of cells
    Explanation
    A range in Microsoft Excel refers to a group of cells. This means that multiple cells can be selected and manipulated together as a single unit. Ranges are commonly used for performing calculations, applying formatting, or entering data across a specific set of cells. By selecting a range, users can easily perform operations on multiple cells simultaneously, saving time and effort.

    Rate this question:

  • 37. 

    One person in the office is working on Excel 97, another in Excel 2000 and you are working in Excel 2007. How would you save it in order for other users can open and edit the file?

    • Template

    • Excel 97-2003 Workbook (*.xls)

    • CSV

    • HTML

    Correct Answer
    A. Excel 97-2003 Workbook (*.xls)
    Explanation
    To ensure that all users can open and edit the file, you should save it in the Excel 97-2003 Workbook (*.xls) format. This format is compatible with Excel 97, Excel 2000, and Excel 2007, allowing users with different versions of Excel to access the file without any issues. Saving it in this format ensures that the file can be opened and edited by all users, regardless of the Excel version they are using.

    Rate this question:

  • 38. 

    Which of the following would you use in an Excel formula to reference the cell located at column G row 17?

    • G(17)

    • G17

    • Cgr17

    • A cell is a dynamic value and cannot be referenced in a formula.

    Correct Answer
    A. G17
    Explanation
    In Excel, to reference a specific cell, you need to use the column letter followed by the row number. In this case, "G17" is the correct answer as it refers to the cell located at column G and row 17.

    Rate this question:

  • 39. 

    What function would you use to display today's date so that tomorrow it will updates automatically

    • =TODAY()

    • =[date]

    • =[system date]

    • =datevalue()

    Correct Answer
    A. =TODAY()
    Explanation
    The correct answer is =TODAY(). This function is used to display today's date, and it automatically updates to the current date every time the spreadsheet is opened or recalculated. Therefore, if you use this function to display today's date, it will automatically update to tomorrow's date when the new day begins.

    Rate this question:

  • 40. 

    What feature enables you to adjust or solve the value in a cell to reach a desired outcome/result?

    • Goal Seek

    • Forcasting

    • TrendLine

    • Scenario Summary

    Correct Answer
    A. Goal Seek
    Explanation
    Goal Seek is a feature in Excel that allows users to adjust the value in a cell in order to achieve a desired outcome or result. It is commonly used in financial modeling or data analysis to find the input value needed to reach a specific goal. By specifying a target value and changing a specific cell, Goal Seek iteratively calculates the value needed to achieve the desired result. This feature is helpful for scenario analysis, sensitivity analysis, and decision-making processes.

    Rate this question:

  • 41. 

    When using Excel 2007 which sign is used to create a formula or function in a cell?

    • Single Quotes

    • Double Quotes

    • Equal Sign

    • Parentheses

    Correct Answer
    A. Equal Sign
    Explanation
    In Excel 2007, the equal sign is used to create a formula or function in a cell. By starting a cell entry with an equal sign, Excel recognizes that it is a formula or function and evaluates it accordingly. The equal sign is the key symbol that indicates to Excel that a calculation or operation needs to be performed.

    Rate this question:

  • 42. 

    Which Excel 2007 feature can be used to keep user desired rows or columns visible at all times when scrolling around the sheet?

    • Headers

    • Filter

    • Freeze Panes

    • Data Validation

    Correct Answer
    A. Freeze Panes
    Explanation
    Freeze Panes is the correct answer because it allows users to keep certain rows or columns visible while scrolling through the rest of the sheet. This feature is useful when working with large datasets or when needing to reference specific information in a spreadsheet without losing sight of it. By freezing panes, users can easily navigate through the sheet while keeping important information in view.

    Rate this question:

  • 43. 

    When creating an Excel workbook, you should avoid using ______ text and background together, since this is the most common form of color blindness.  

    • Red and green

    • Yellow and blue

    • Black and white

    • Red and yellow

    Correct Answer
    A. Red and green
    Explanation
    When creating an Excel workbook, it is advised to avoid using red and green text and background together. This is because red-green color blindness is the most common form of color blindness. People with this condition have difficulty distinguishing between red and green colors, so using these colors together can make it challenging for them to read and understand the content in the workbook.

    Rate this question:

  • 44. 

    Which mathematical operation is performed by the ^ key in an Excel formula?

    • Multiplication

    • Factorial

    • Power

    • Logical

    Correct Answer
    A. Power
    Explanation
    The ^ key in an Excel formula is used to perform the mathematical operation of raising a number to a power. It is used to calculate exponential values, where a number is multiplied by itself a certain number of times. This operation is commonly used in various mathematical calculations, such as calculating compound interest or exponential growth.

    Rate this question:

  • 45. 

    Rows are identified by a _______________________

    • Cell

    • Column

    • Number

    Correct Answer
    A. Number
    Explanation
    Rows are identified by a number in a table or spreadsheet. Each row is assigned a unique number to distinguish it from other rows. This numbering system allows for easy reference and organization of data within the table or spreadsheet. By using numbers to identify rows, it becomes simpler to locate and manipulate specific rows of data when needed.

    Rate this question:

  • 46. 

    Except for the ______________ function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

    • =AND()

    • =NOT()

    • =OR()

    • =COUNT()

    Correct Answer
    A. =COUNT()
    Explanation
    A formula with the COUNT() function does not show the words "TRUE" or "FALSE" as a result. The COUNT() function is used to count the number of cells in a range that contain numbers. Therefore, it does not produce a logical result of "TRUE" or "FALSE" like the other logical functions such as AND(), NOT(), or OR().

    Rate this question:

  • 47. 

    To open the Format Cells dialog box, press

    • Alt + 1

    • Ctrl + 1

    • Ctrl + Shift + 1

    • F1

    Correct Answer
    A. Ctrl + 1
    Explanation
    To open the Format Cells dialog box, you need to press Ctrl + 1. This keyboard shortcut allows you to quickly access the Format Cells option, where you can modify the formatting of cells in a spreadsheet. By pressing Ctrl + 1, you can easily make changes to the font, number format, alignment, borders, and other formatting options for selected cells.

    Rate this question:

  • 48. 

    When a worksheet is printed, the grid lines that surround the cells are printable by default.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement suggests that when a worksheet is printed, the grid lines that surround the cells are printable by default. However, this statement is incorrect. By default, the grid lines are not printed when a worksheet is printed. If the user wants to print the grid lines, they need to manually enable the option to print grid lines before printing the worksheet.

    Rate this question:

  • 49. 

    To format a cell like an already formated one you can use ------------------------------- .

    • The Fill down command

    • The Autosum command

    • The Format Painter command

    • None of the above.

    Correct Answer
    A. The Format Painter command
    Explanation
    The Format Painter command allows you to copy the formatting from one cell and apply it to another cell. This is useful when you want to format a cell in the same way as another cell without having to manually adjust all the formatting settings. The Format Painter command saves time and ensures consistency in formatting throughout the spreadsheet.

    Rate this question:

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.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 13, 2016
    Quiz Created by
    Lopeze761
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.