Identify The Proficiency Of Microsoft Excel Quiz
.JPG "Identify The Proficiency Of Microsoft Excel Quiz - Quiz")
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions and Answers
- 1.
The number of rows in an Excel 2007 worksheet is:
- A.
65536
- B.
256
- C.
64536
- D.
1048576
Correct Answer
D. 1048576Explanation
The number of rows in an Excel 2007 worksheet is 1048576. This is the maximum number of rows that can be used in a single worksheet in Excel 2007. This large number of rows allows for extensive data entry and analysis in Excel, making it a powerful tool for managing and organizing data.Rate this question:
-
- 2.
Reference to the above image of Command Group "Alignment" which of the following tabs consist it:
- A.
View
- B.
Formatting
- C.
Home
Correct Answer
C. HomeExplanation
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?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
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.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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?
- A.
F1
- B.
F2
- C.
F3
Correct Answer
B. F2Explanation
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?
- A.
=If()
- B.
=Sum()
- C.
=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?
- A.
Go to file - save as - save as type - excel 4.0 worksheet
- B.
Right click on the worksheet tab and select delete
- C.
Right click on the worksheet and select insert - entire column
Correct Answer
B. Right click on the worksheet tab and select deleteExplanation
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?
- A.
Count
- B.
Average
- C.
Sum
Correct Answer
C. SumExplanation
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?
- A.
F3
- B.
F7
- C.
F9
- D.
F11
Correct Answer
D. F11Explanation
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 _____.
- A.
The sum of values in the cell's column
- B.
Nothing until you selects a range of cells
- C.
The sum of the cell's row unless you change the range
- D.
A formula which will add values in the range Excel guesses you want to add
Correct Answer
D. A formula which will add values in the range Excel guesses you want to addExplanation
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 _____.
- A.
Print Preview
- B.
Normal
- C.
Page Break Preview
- D.
Split View
Correct Answer
C. Page Break PreviewExplanation
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 _____.
- A.
B1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Correct Answer
D. B1:G10Explanation
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.
- A.
ENTER
- B.
CTRL + ENTER
- C.
TAB
- D.
INSERT
Correct Answer
B. CTRL + ENTERExplanation
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?
- A.
Yes, but it has to be saved as a different file name.
- B.
No, once it is saved it cannot be changed.
- C.
Yes, even after saving the file, double click on the cell where data is to be changed to edit
Correct Answer
C. Yes, even after saving the file, double click on the cell where data is to be changed to editExplanation
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.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
Correct Answer
A. A dark wide borderExplanation
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
- A.
Hold down the CTRL key
- B.
Hold down the SHIFT key
- C.
Hold down the ALT key
Correct Answer
A. Hold down the CTRL keyExplanation
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.
A table of data that is organized into rows and columns
- B.
The Excel file that holds your worksheets
- C.
A built-in formula in Excel
Correct Answer
B. The Excel file that holds your worksheetsExplanation
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.
A symbol that represents a specific action
- B.
A way of arranging data in a particular order
- C.
A built-in formula in Excel
Correct Answer
C. A built-in formula in ExcelExplanation
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.
A group of cells
- B.
A calculation that describes the relationship between cells
- C.
A way of arranging data in a particular order
Correct Answer
A. A group of cellsExplanation
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?
- A.
Ribbon
- B.
Formula Bar
- C.
Tab
Correct Answer
A. RibbonExplanation
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.
A symbol that represents a specific action
- B.
A way of arranging data in a particular order
- C.
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
C. Automatically change the width of a column to fit the longest entry or change the height of a row to fit the fontExplanation
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.
A symbol that represents a specific action
- B.
Refers to the change a formula makes when it is moved or copied to other cells with different data
- C.
A table of data that is organized into rows and columns
Correct Answer
C. A table of data that is organized into rows and columnsExplanation
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?
- A.
It is a visual way to display and compare data
- B.
A way of arranging data in a particular order
- C.
A calculation that describes the relationship between cells
Correct Answer
A. It is a visual way to display and compare dataExplanation
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:
- A.
Type the data in A1 and Merge cells A1:A5
- B.
Type the data in A1 and Merge cells A1:E1
- C.
Type the data in C1
- D.
Choose Center from the Format menu
Correct Answer
B. Type the data in A1 and Merge cells A1:E1Explanation
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"?
- A.
Formula returns the value "DONE"
- B.
Formula will show an error
- C.
Formula returns the value "RESTART"
- D.
Formula returns the value "YES"
Correct Answer
C. 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.
- A.
Shift
- B.
Tab
- C.
Esc
- D.
Alt
Correct Answer
B. TabExplanation
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.
- A.
Red and green
- B.
Yellow and blue
- C.
Black and white
- D.
Red and yellow
Correct Answer
A. Red and greenExplanation
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.
- A.
What-if analysis
- B.
Track Changes
Correct Answer
A. What-if analysisExplanation
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 ______.
- A.
Sort A to Z and Sort Z to A buttons
- B.
Quicksort Options
- C.
Sort command on the Formulas tab
- D.
Any of the above
Correct Answer
D. Any of the aboveExplanation
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:
-
- 50.
=FUNCTION(argument1,argument2, ...) Is ________.
- A.
The syntax of writing optional arguments.
- B.
An example of a formula.
- C.
The general syntax of all functions.
- D.
The general syntax of all formulas.
Correct Answer
C. The general syntax of all functions.Explanation
This answer is correct because the statement "Is ________" is followed by options that describe different aspects related to functions. Among these options, the one that best fits the given statement is "The general syntax of all functions." This option suggests that the function syntax includes the use of arguments, which are enclosed in parentheses and separated by commas. Therefore, this answer correctly explains the given correct answer.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 13, 2016Quiz Created by
Lopeze761
Back to top