Microsoft Excel Proficiency Test
.JPG "Microsoft Excel Proficiency Test - 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. Excel 2007 increased the maximum number of rows from the previous version, which had only 65536 rows. This increase allows for a larger amount of data to be stored and analyzed in Excel 2007.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. Home -
- 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 a feature called "Data Connection" that allows users to connect to various data sources, including database tables. Once the connection is established, users can import the data into an Excel worksheet. By setting up automatic data refresh options, users can easily update the data in the worksheet with just one click, ensuring that the results are always up to date.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 means that if the value of one cell increases, the barsize for that cell will also increase, and if the value decreases, the barsize will decrease accordingly. Therefore, the statement "changing the value of one cell in the range will not affect the barsize of all the other cells" is incorrect.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 information and guidance on how to use functions in a software program or application. It offers a step-by-step process or instructions on how to input and utilize different functions effectively. Therefore, the statement "The Insert Function dialog box tells you how to use functions" is true.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
By default, when a worksheet is printed, the grid lines that surround the cells are not printable. This means that when you print a worksheet, only the content within the cells will be printed without the grid lines. However, it is possible to change this default setting and make the grid lines printable if desired.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 statement "all filters in the worksheet are cleared, if the worksheet contains more than one filter" 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. It likely includes details such as the number and type of arguments required, as well as any additional parameters or options that can be used. This information helps users understand how to properly utilize functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" 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 new record is added at the end of the existing data and maintains the sequential order of the table. It is also convenient as it eliminates the need to search for an appropriate location to insert the new record.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 unchanged and retains its formatting.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 done by selecting the chart, going to the "Design" tab in the Chart Tools, and clicking on the "Select Data" button. From there, you can choose the data range for the chart and update it as needed, even if the data is in a different worksheet. 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
The statement is false. After merging a range into a single cell, you can still realign its content. Merging cells is a formatting feature that combines multiple cells into one larger cell, but it does not affect the alignment or formatting options for the content within the merged cell. You can still adjust the alignment, font size, and other formatting settings for the content within the merged cell.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 stay hidden until the workbook is active. This means that even if you close and reopen the workbook, the row will still be hidden. The only time the row will be visible again is when you have the workbook open and active.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
This statement is false because there are functions called "void functions" that do not require any arguments. Void functions are used when a function does not need any input from the user and does not return any value. Therefore, not all functions have arguments and there are functions that can work without providing them arguments.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 can indeed be visually attractive, but they can also make it difficult to accurately interpret the values in the chart. This is because the use of three dimensions can obscure the relationship between the different slices or data points. In particular, it can be challenging to determine which slice is larger or smaller when viewing a 3D chart. Therefore, the statement that 3D charts can obscure the relationship between values is true.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. This means that users do not need to create a custom format for this purpose. 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 style. It does not alter the actual values or content of the data. Therefore, formatting data only affects the visual representation of the data without changing 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 several functions, Excel will first evaluate the innermost function and then use the result of that function as an argument for the next outer function, and so on, until it reaches the outermost function. 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 arrange the data in ascending or descending order based on the selected field. This eliminates the need for manual sorting or using more complex sorting methods, making it a convenient option for simple data sorting tasks.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 users to create multiple tables in a single worksheet, each with its own set of columns and rows. This feature is useful when organizing and analyzing different sets of data 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 begin with the letters you typed will appear. This feature is designed to help users easily find and select the desired function without having to remember the exact syntax or name of the function. It saves time and reduces the chances of errors in formula creation.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
The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis, which means you can change the angle of view from left to right, and vertically along the y-axis, which means you can change the angle of view from top to bottom. These two directions of rotation allow you to explore and analyze the chart from different perspectives.Rate this question:
-
- 23.
Pressing ENTER moves the selection one cell to the right by default.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
By default, pressing ENTER moves the selection one cell down, 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 in a selected cell in a document or spreadsheet application will make the font in that cell bold. This is a commonly used shortcut for applying the bold formatting to text.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 such as Microsoft Excel. Pressing F2 allows the user to enter the editing mode for the selected cell, where they can make changes to the content. This key is convenient for quickly editing cell contents without the need to use the mouse or navigate through menus.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 programming languages to perform conditional calculations or display different values based on certain criteria.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 SUM formula can be used to add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range.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 F11 on the keyboard creates a chart from the selected cells.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 you use the autosum button, Excel will automatically generate a formula in the selected cell that adds up the values in the range that it guesses you want to add. This means that it will create a formula that sums up 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 view that puts a blue line around each page that would be printed is the Page Break Preview. In this view, users can see where each page will break when printed, allowing them to make adjustments to ensure the content is displayed and printed correctly.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. It uses the colon (:) to indicate the range of cells.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 allows you to input the desired content into the cell, but it keeps the focus in the same cell. This means that after typing the content, you can continue editing or formatting the cell without having to move to another cell.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, the data entered into a cell can still be edited by double-clicking on the cell. This action allows the user to make changes to the data without having to save the file as a different name.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 the user easily identify which cell is currently selected and ready for data entry or manipulation. The other options, such as a dotted border or a blinking border, are not typically 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. This key allows you to select multiple non-contiguous cells or ranges by clicking on each of them individually. By holding down the CTRL key, you can add or remove cells from the selection without losing the previously selected ones. This is useful when you want to perform operations on multiple separate areas of a spreadsheet without having to select them all at once.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. In Excel, a workbook can contain multiple worksheets, each of which can have its own set of data and calculations. It serves as the container for all the data, formulas, and formatting within Excel.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 calculations, logical operations, text manipulation, and more. Functions in Excel are represented by symbols and can be used to manipulate and analyze data in a specific way.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 are selected and grouped together to form a range. This allows users to perform operations or calculations on multiple cells simultaneously, making it easier to manipulate and analyze data in Excel. Ranges can be used for various purposes such as entering data, applying formatting, or performing calculations using formulas or functions.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 contains multiple tabs, each representing a different set of commands related to specific functions or features in Excel. The ribbon provides easy access to various tools and options for creating, formatting, and manipulating data 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 feature that automatically adjusts the width of a column to accommodate the longest entry or the height of a row to fit the font. This ensures that all the data in a spreadsheet is visible and properly formatted, without any text being cut off or hidden. It saves time and effort by automatically resizing the columns or rows to optimize the display of data.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 refers to a table of data that is organized into rows and columns. It is a document where data can be entered, manipulated, and analyzed. Worksheets are commonly used in spreadsheet software, such as Microsoft Excel, to perform calculations, create charts, and present data in a structured format.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 of data that allows for easy comparison and analysis. It uses different types of graphs, such as bar charts or line graphs, to present data in a clear and organized manner. By visually displaying data, charts make it easier to identify patterns, trends, and relationships between different data points. They are commonly used in presentations, reports, and data analysis to effectively communicate information to an audience.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 that runs across five columns, one way is to type the title in cell A1 and then merge cells A1 to E1. This will combine the cells into one and allow the title to be centered across all five columns.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
After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This means that the entry will be selected and the cursor will move to the next cell in the column, allowing the user to continue entering data without having to manually select the next cell.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
Color blindness is a condition that affects the ability to distinguish between certain colors. The most common form of color blindness is red-green color blindness, where individuals have difficulty differentiating between shades of red and green. Therefore, when creating an Excel workbook, it is advisable to avoid using red and green text and background together to ensure that the content is easily readable for individuals with color blindness.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 is the correct answer because it refers to the feature in Excel that allows users to change values in a spreadsheet and observe the impact of those changes on calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making purposes. Track Changes, on the other hand, is a different feature in Excel that allows users to track and review changes made to a spreadsheet by multiple users.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 you can sort data in an Excel worksheet using the Sort A to Z and Sort Z to A buttons, the Quicksort Options, or the Sort command on the Formulas tab. All of these options allow you to arrange the data in ascending or descending order based on a specific column or criteria.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 given statement "Is ________" is asking for the function that fills in the blank. The correct answer is "The general syntax of all functions" because the syntax of a function typically includes the function name followed by parentheses that can contain one or more arguments. This syntax applies to all functions in general, regardless of the specific function being used.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 20, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 29, 2015Quiz Created by
Coolhausworks
Back to top