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: 180
| Attempts: 180
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/122 Questions

    The number of rows in an Excel 2007 worksheet is:

    • 65536
    • 256
    • 64536
    • 1048576
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. 
    Reference to the above image of Command Group "Alignment" which of the following tabs consist it:      - ProProfs

    Reference to the above image of Command Group "Alignment" which of the following tabs consist it:     

    • View

    • Formatting

    • Home

    Correct Answer
    A. Home
    Explanation
    The correct answer is "Home" because in the image of the Command Group "Alignment," the tab that is highlighted and selected is the "Home" tab. This indicates that the Alignment command group is located within the Home tab in the user interface.

    Rate this question:

  • 3. 

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

    • True

    • False

    Correct Answer
    A. True
    Explanation
    This statement is true because Excel has the capability to import data from various sources, including databases. By using the appropriate data connection and query, users can retrieve the results of any database table and display it in an Excel worksheet. Additionally, Excel provides the option to set up automatic data refresh, allowing users to update the data with just one click.

    Rate this question:

  • 4. 

    When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When using a databar, changing the value of one cell in the range will affect the barsize of all the other cells. This is because databars are conditional formatting tools that visually represent the values in a range of cells. The length of the databar is determined by the relative value of each cell compared to the other cells in the range. Therefore, changing the value of one cell will cause the barsize of all the other cells to adjust accordingly.

    Rate this question:

  • 5. 

    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:

  • 6. 

    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:

  • 7. 

    When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When you clear a filter, only the specific filter that you cleared will be cleared. The other filters in the worksheet will remain unaffected. Therefore, the given statement is false.

    Rate this question:

  • 8. 

    The function arguments dialog box tells you how to use functions.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The function arguments dialog box provides information on how to use functions. This suggests that the statement is true.

    Rate this question:

  • 9. 

    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:

  • 10. 

    If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    If you insert a new row at the top of the table, the new row does not become the header row and is not formatted with the table style. The header row remains the same and any new row added will have the same formatting as the other rows in the table.

    Rate this question:

  • 11. 

    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:

  • 12. 

    After you merge a range into a single cell, you can't realign its content.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When you merge a range into a single cell, you can still realign its content. Merging cells allows you to combine multiple cells into one, which can be useful for formatting purposes. However, it does not restrict you from changing the alignment of the content within the merged cell. Therefore, the correct answer is false.

    Rate this question:

  • 13. 

    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:

  • 14. 

    All functions have arguments.  There are no functions which work without providing them arguments.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because there are functions called "void functions" that do not require any arguments. These functions are designed to perform a specific task without needing any input from the user. They are typically used for tasks such as printing a message or performing a simple calculation. Therefore, not all functions require arguments to work.

    Rate this question:

  • 15. 

    Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    3D charts may look visually appealing, but they can actually make it harder to accurately interpret the data. The use of depth and perspective in a 3D chart can make it difficult to accurately compare the sizes of different slices or bars in the chart. This can lead to a distorted understanding of the relationships between the values being represented. Therefore, it is true that 3D charts can obscure the relationship between values in the chart.

    Rate this question:

  • 16. 

    Excel has a builtin format to display 4 digit year values, so you do not need to create one.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Excel does have a built-in format to display 4 digit year values, which means that users do not need to create their own format. This format can be easily applied to any cell or range of cells containing year values, saving time and effort for the user. Therefore, the statement is true.

    Rate this question:

  • 17. 

    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:

  • 18. 

    If a formula contains several functions, Excel starts with the outermost function and then moves inward.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Excel actually starts with the innermost function and then moves outward. This means that if a formula contains multiple functions, Excel will first evaluate the innermost function and then use the result in the next outer function, and so on. Therefore, the correct answer is false.

    Rate this question:

  • 19. 

    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:

  • 20. 

    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:

  • 21. 

    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:

  • 22. 

    You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A 3D chart can be rotated in two directions, horizontally along the x-axis and vertically along the y-axis. This means that you can change the angle and perspective of the chart by rotating it either left or right, and up or down. The statement is true because there are only two possible directions of rotation for a 3D chart.

    Rate this question:

  • 23. 

    Pressing ENTER moves the selection one cell to the right by default.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Pressing ENTER moves the selection one cell down by default, not one cell to the right.

    Rate this question:

  • 24. 

    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:

  • 25. 

    What key should be used to edit the content of a cell?

    • F1

    • F2

    • F3

    Correct Answer
    A. F2
    Explanation
    F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software like Microsoft Excel. When F2 is pressed, the selected cell becomes editable, allowing the user to make changes to the cell's content.

    Rate this question:

  • 26. 

    What function offers you the possibility to view different results depending on the entered condition?

    • =If()

    • =Sum()

    • =SumIf()

    Correct Answer
    A. =If()
    Explanation
    The IF() function offers the possibility to view different results depending on the entered condition. It allows you to specify a condition and provides two possible outcomes based on whether the condition is true or false. This function is commonly used in Excel and other spreadsheet programs to perform logical tests and make decisions based on the results.

    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 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:

  • 29. 

    What is the keyboard shortcut for creating a chart from the selected cells?

    • F3

    • F7

    • F9

    • F11

    Correct Answer
    A. F11
    Explanation
    Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows users to quickly generate a chart without having to go through the menu options or use the mouse. It is a convenient and efficient way to visualize data and analyze trends.

    Rate this question:

  • 30. 

    Using the autosum button will place in the selected cell _____.

    • The sum of values in the cell's column

    • Nothing until you selects a range of cells

    • The sum of the cell's row unless you change the range

    • A formula which will add values in the range Excel guesses you want to add

    Correct Answer
    A. A formula which will add values in the range Excel guesses you want to add
    Explanation
    When using the autosum button, Excel will place a formula in the selected cell that will add the values in the range it guesses you want to add. This means that Excel will automatically calculate the sum of the values in the column of the selected cell.

    Rate this question:

  • 31. 

    The view that puts a blue line around each page that would be printed is the _____.  

    • Print Preview

    • Normal

    • Page Break Preview

    • Split View

    Correct Answer
    A. Page Break Preview
    Explanation
    The correct answer is "Page Break Preview" because this view allows the user to see where page breaks will occur when the document is printed. It helps in adjusting the content and formatting accordingly to ensure that the printed pages are organized and visually appealing. The blue lines indicate the boundaries of each page, making it easier for the user to identify and make necessary adjustments.

    Rate this question:

  • 32. 

    The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.  

    • B1-G10

    • B1.G10

    • B1;G10

    • B1:G10

    Correct Answer
    A. B1:G10
    Explanation
    The correct answer is B1:G10. This is the correct cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10. The colon (:) is used to indicate a range of cells, and the B1 represents the starting cell while G10 represents the ending cell of the range.

    Rate this question:

  • 33. 

    If you press _____, the cell accepts your typing as its contents but the focus stays in the same cell.  

    • ENTER

    • CTRL + ENTER

    • TAB

    • INSERT

    Correct Answer
    A. CTRL + ENTER
    Explanation
    Pressing CTRL + ENTER in a cell accepts the typing as its contents but keeps the focus in the same cell. This means that after typing in the cell, you can press CTRL + ENTER to confirm the input without moving to the next cell. This can be useful when you want to quickly input data in multiple cells without having to navigate to each cell individually.

    Rate this question:

  • 34. 

    Once data is entered into a cell, can it be edited after saving the file?

    • Yes, but it has to be saved as a different file name.

    • No, once it is saved it cannot be changed.

    • Yes, even after saving the file, double click on the cell where data is to be changed to edit

    Correct Answer
    A. Yes, even after saving the file, double click on the cell where data is to be changed to edit
    Explanation
    After saving the file, data entered into a cell can still be edited by double-clicking on the cell. This allows the user to make changes to the data even after the file has been saved.

    Rate this question:

  • 35. 

    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:

  • 36. 

    To select several cells or ranges that are not touching each other, you would _____ while selecting

    • Hold down the CTRL key

    • Hold down the SHIFT key

    • Hold down the ALT key

    Correct Answer
    A. Hold down the CTRL key
    Explanation
    To select several cells or ranges that are not touching each other, you would hold down the CTRL key while selecting. Holding down the CTRL key allows you to select multiple non-adjacent cells or ranges by clicking on each cell or range individually. This feature is useful when you need to select specific cells or ranges scattered throughout a worksheet without selecting everything in between.

    Rate this question:

  • 37. 

    What is a Workbook?

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

    • The Excel file that holds your worksheets

    • A built-in formula in Excel

    Correct Answer
    A. The Excel file that holds your worksheets
    Explanation
    A workbook refers to the Excel file that holds your worksheets. It is the main file in Excel where you can create, edit, and save multiple worksheets. Each workbook can contain multiple sheets or tabs, allowing you to organize and manage your data efficiently. The workbook serves as a container for all the data, formulas, formatting, and other elements within Excel. It provides a centralized location for you to work on your data and perform various tasks using the different worksheets it contains.

    Rate this question:

  • 38. 

    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:

  • 39. 

    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:

  • 40. 

    Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?  

    • Ribbon

    • Formula Bar

    • Tab

    Correct Answer
    A. Ribbon
    Explanation
    The ribbon is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before. It is located at the top of the Excel window and is divided into multiple tabs, such as Home, Insert, Page Layout, Formulas, etc. Each tab contains different groups of related commands and functions that you can use to perform various tasks in Excel.

    Rate this question:

  • 41. 

    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:

  • 42. 

    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:

  • 43. 

    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:

  • 44. 

    If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:  

    • Type the data in A1 and Merge cells A1:A5

    • Type the data in A1 and Merge cells A1:E1

    • Type the data in C1

    • Choose Center from the Format menu

    Correct Answer
    A. Type the data in A1 and Merge cells A1:E1
    Explanation
    To center a title across the top of the data, you need to type the data in cell A1 and then merge the cells A1 to E1. This will combine all the cells from column A to column E into one cell, allowing the title to be centered across the entire row.

    Rate this question:

  • 45. 

    In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1="NO"?  

    • Formula returns the value "DONE"

    • Formula will show an error

    • Formula returns the value "RESTART"

    • Formula returns the value "YES"

    Correct Answer
    A. Formula returns the value "RESTART"
    Explanation
    If A1 is equal to "NO", the formula will return the value "RESTART".

    Rate this question:

  • 46. 

    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:

  • 47. 

    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:

  • 48. 

    The  ___________ allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.

    • What-if analysis

    • Track Changes

    Correct Answer
    A. What-if analysis
    Explanation
    What-if analysis allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values. This feature is particularly useful when you want to explore different scenarios or understand the impact of different inputs on the final results. By changing the values and observing the resulting calculations, you can make informed decisions or predictions based on the data.

    Rate this question:

  • 49. 

    To sort data in an Excel worksheet you can use the ______.

    • Sort A to Z and Sort Z to A buttons

    • Quicksort Options

    • Sort command on the Formulas tab

    • Any of the above

    Correct Answer
    A. Any of the above
    Explanation
    The correct answer is "Any of the above". This is because all three options mentioned - Sort A to Z and Sort Z to A buttons, Quicksort Options, and Sort command on the Formulas tab - can be used to sort data in an Excel worksheet.

    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

Related Topics

Recent Quizzes

Quiz: Test Your Microsoft Forms Expertise! Quiz: Test Your Microsoft Forms Expertise!
Microsoft Azure IoT Certification Exam Prep Test Microsoft Azure IoT Certification Exam Prep Test
Microsoft Azure Fundamentals (AZ-900) Pre Exam Assessment Microsoft Azure Fundamentals (AZ-900) Pre Exam Assessment
MS Word & Excel Quiz # 2 MS Word & Excel Quiz # 2
Microsoft Azure Fundamentals Exam: Quiz! Microsoft Azure Fundamentals Exam: Quiz!
MS-101: Microsoft 365 Mobility and Security MS-101: Microsoft 365 Mobility and Security
IT Tech Lounge 2019 - Microsoft Teams IT Tech Lounge 2019 - Microsoft Teams
How well do you know Microsoft? How well do you know Microsoft?
Quiz 1 - Processes & Threads Quiz 1 - Processes & Threads

Featured Quizzes

Which Sonic Character Are You? Which Sonic Character Are You?
Articles Quiz With Answers Articles Quiz With Answers
What Is My Talent? What Is My Talent?
What Is My Ethnicity? Let's Take Ethnicity Quiz What Is My Ethnicity? Let's Take Ethnicity Quiz
Are You Ready For IQ Quiz: Test Your Intelligence Now Are You Ready For IQ Quiz: Test Your Intelligence Now
Introduction to Computer: MCQ Questions With Answers Introduction to Computer: MCQ Questions With Answers
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.