Microsoft Excel Proficiency Trivia Questions
(50).webp "Microsoft Excel Proficiency Trivia Questions - Quiz")
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions and Answers
- 1.
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 Command Group "Alignment" consists of the tabs: View, Formatting, and Home.Rate this question:
-
- 2.
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 connect to various database systems and retrieve data from tables. Once the connection is established and the data is imported into an Excel worksheet, you can set up a refresh option that allows you to update the data with just one click. This ensures that the results in the worksheet are always up to date with the database table.Rate this question:
-
- 3.
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 designed to represent the relative values of the cells in the range, so when one value changes, the barsize of all other cells will adjust accordingly to maintain the relative proportions. Therefore, the correct answer is False.Rate this question:
-
- 4.
The Insert Function dialog box tells you how to use functions.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because the Insert Function dialog box is a feature in many software applications, such as Microsoft Excel, that provides a user-friendly interface for selecting and inserting functions into a cell or formula. It typically includes a search bar, a list of available functions, and a description or explanation of how to use each function. This dialog box serves as a helpful tool for users who may not be familiar with all the available functions or how to properly use them.Rate this question:
-
- 5.
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. To print the grid lines, the user needs to enable the "Print Gridlines" option in the print settings. Therefore, the statement "When a worksheet is printed, the grid lines that surround the cells are printable by default" is false.Rate this question:
-
- 6.
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 you cleared will be cleared, not all filters in the worksheet. This means that if the worksheet contains multiple filters, the other filters will remain applied and unchanged.Rate this question:
-
- 7.
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 on the input parameters that a function requires, as well as any optional arguments and their respective data types. This information helps users understand the correct way to use functions in their code. Therefore, the statement "The function arguments dialog box tells you how to use functions" is true.Rate this question:
-
- 8.
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
Entering data in the first blank row is the simplest and most convenient way to add a record to a table because it ensures that the new record is added at the end of the existing data. This method avoids any potential conflicts or errors that may arise when trying to insert a record in a specific location within the table. Additionally, it allows for easy organization and readability of the table, as new records are appended to the bottom.Rate this question:
-
- 9.
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
When you insert a new row at the top of the table, the existing header row remains unchanged and does not become the new row. The new row that is inserted will not automatically be formatted with the table style. Therefore, the correct answer is False.Rate this question:
-
- 10.
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 means that any changes made to the data in the source worksheet will be automatically reflected in the chart, regardless of which worksheet the chart is located in. 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:
-
- 11.
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 is a formatting feature in which multiple adjacent cells are combined into a single cell. This is commonly used to create headings or to merge cells with similar data. After merging, you can still adjust the alignment of the content within the merged cell, such as aligning it to the left, center, or right. Therefore, the statement that you can't realign the content after merging is false.Rate this question:
-
- 12.
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 the workbook and reopen it, the row will still be hidden. This feature allows you to temporarily hide certain rows of data without permanently deleting them. To unhide the row, you would need to activate the workbook and manually unhide the row.Rate this question:
-
- 13.
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 parameters to perform its task. They can be called without providing any arguments. Therefore, not all functions require arguments.Rate this question:
-
- 14.
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 relationship between the values in the chart. This is because the depth and perspective of the chart can obscure the size of each slice or bar, making it challenging to determine which slice or bar is larger or smaller. As a result, the relationship between the values may not be accurately conveyed, leading to potential misinterpretation of the data. Therefore, the statement is true.Rate this question:
-
- 15.
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 displaying 4 digit year values in Excel. Therefore, the statement "True" is correct.Rate this question:
-
- 16.
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 visual representation of data without altering the underlying values or calculations. This can include changing the font, color, alignment, or adding borders to cells. The purpose of formatting is to enhance the readability and presentation of data. However, formatting does not modify the actual data or its values. Therefore, the statement that formatting only changes the appearance of data and does not affect the data itself is true.Rate this question:
-
- 17.
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 when evaluating a formula that contains several functions. This means that Excel will first calculate the innermost function and then use the result of that calculation 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:
-
- 18.
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
When there is only one sort field, using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data. These buttons allow the data to be sorted in ascending (A to Z) or descending (Z to A) order based on the selected field.Rate this question:
-
- 19.
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 and manage multiple tables within a single worksheet. Each table can have its own set of columns, rows, and formatting options. This feature is useful for organizing and analyzing data in different ways within the same worksheet.Rate this question:
-
- 20.
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 in a cell, a list of functions that start with the letters you have typed appears. This feature is called "AutoComplete" and it helps users by suggesting relevant function names as they type, saving time and reducing errors. Therefore, the given statement is true.Rate this question:
-
- 21.
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 or vice versa. Additionally, you can also rotate it vertically along the y-axis, allowing you to change the angle of view from top to bottom or vice versa. These two directions of rotation give you the ability to explore different perspectives and angles of the 3D chart.Rate this question:
-
- 22.
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:
-
- 23.
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 will make the font in that cell bold. This is a common shortcut used in many software programs, including spreadsheet applications like Microsoft Excel.Rate this question:
-
- 24.
What key should be used to edit the content of a cell?
- A.
F1
- B.
F2
- C.
F3
Correct Answer
B. F2Explanation
The F2 key should be used to edit the content of a cell. This key allows the user to directly edit the text or formula within a cell without having to go into the formula bar or double-clicking on the cell. By pressing F2, the cursor is placed at the end of the cell's content, allowing for easy editing and modification.Rate this question:
-
- 25.
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 you the possibility to view different results depending on the entered condition. With this function, you can set up a logical test and specify what should happen if the test is true or false. This allows you to create conditional statements and display different results based on the conditions you specify.Rate this question:
-
- 26.
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
The correct sequence of events to remove a worksheet from a workbook is to right-click on the worksheet tab and select delete. This action will delete the selected worksheet from the workbook.Rate this question:
-
- 27.
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 is used to add up 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. This formula is commonly used when you want to calculate the total of a set of numbers and exclude any text or empty cells in the range.Rate this question:
-
- 28.
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. By selecting the desired cells and pressing F11, users can easily visualize their data in a chart format, making it easier to analyze and interpret the information.Rate this question:
-
- 29.
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 it guesses you want to add. This saves you the time and effort of manually typing out the formula.Rate this question:
-
- 30.
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". This view is used in programs like Microsoft Excel to show how the content of a document will be divided and printed on separate pages. It helps users to identify where page breaks will occur and adjust the layout accordingly. The blue line around each page in this view indicates the boundaries of each printed page.Rate this question:
-
- 31.
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 because the colon (:) is used to indicate a range of cells, and B1:G10 represents a range that starts from cell B1 and goes over to column G and down to row 10.Rate this question:
-
- 32.
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 your typing into the cell, but the focus remains in the same cell. This means that after typing, you can continue editing or formatting the cell without having to navigate to a different cell.Rate this question:
-
- 33.
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
The correct answer states that data entered into a cell can be edited after saving the file. This can be done by double-clicking on the cell where the data is located, allowing for changes to be made.Rate this question:
-
- 34.
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 to distinguish the currently selected cell from the rest of the cells on the spreadsheet. It allows the user to easily identify and manipulate the active cell, such as entering data or performing calculations. The other options, a dotted border and a blinking border, are not commonly used to indicate the active cell in Excel.Rate this question:
-
- 35.
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 of them individually. This is a useful feature when you need to select specific cells or ranges scattered throughout a spreadsheet without selecting everything in between.Rate this question:
-
- 36.
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 in Excel refers to the file that contains multiple worksheets. It is the main file where you can create, edit, and organize your worksheets. Each worksheet within the workbook can contain different data, formulas, and formatting. Therefore, the correct answer is "The Excel file that holds your worksheets."Rate this question:
-
- 37.
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 in Excel is a built-in formula that performs a specific action or calculation on data. It is used to manipulate and analyze data in a spreadsheet. Functions can be used to perform mathematical operations, manipulate text, calculate dates and times, and much more. They are predefined formulas that can be easily applied to cells or ranges in a worksheet to automate calculations and save time.Rate this question:
-
- 38.
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 multiple cells simultaneously. By selecting a range, users can easily perform operations on a specific set of cells, making data management and analysis more efficient.Rate this question:
-
- 39.
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 in Excel is the part of the 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 tabs, such as Home, Insert, Page Layout, and more. Each tab contains specific commands and options related to different tasks and functions in Excel. The ribbon provides easy access to various tools and features, allowing users to navigate and perform actions efficiently.Rate this question:
-
- 40.
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
The function of the autofit is to automatically adjust the width of a column to fit the longest entry or change the height of a row to fit the font. This feature is useful in spreadsheet programs or table editors where the content of cells may vary in length or font size. Autofit ensures that all the content is visible within the cell without any truncation or overlapping.Rate this question:
-
- 41.
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
The correct answer is a table of data that is organized into rows and columns. A worksheet in the context of computer software, such as Microsoft Excel, refers to a document or file that contains a grid-like structure where data can be entered, organized, and manipulated. This grid is typically divided into rows and columns, forming a table-like structure. Users can input data into individual cells, perform calculations using formulas, and analyze and present the data in various ways. Worksheets are commonly used for tasks such as budgeting, data analysis, and creating charts or graphs.Rate this question:
-
- 42.
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 clear and concise way to present information in a graphical format, making it easier to understand and analyze trends, patterns, and relationships within the data. By using different types of charts, such as bar graphs, pie charts, or line graphs, data can be visually organized and interpreted, enabling users to make informed decisions based on the information presented.Rate this question:
-
- 43.
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, the correct way would be to type the data in cell A1 and then merge cells A1 to E1. This will create a single merged cell spanning across all five columns, allowing the title to be centered across the top of the data.Rate this question:
-
- 44.
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
The formula =IF(A1="YES","DONE","RESTART") checks the value in cell A1. If the value is "YES", it returns "DONE". If the value is anything other than "YES", including "NO", it returns "RESTART". Therefore, if A1="NO", the formula will return the value "RESTART".Rate this question:
-
- 45.
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
When Excel displays an existing entry in the column that matches the characters typed, pressing the Tab key is the correct action to accept the entry. The Tab key allows the user to move to the next cell in the spreadsheet, effectively accepting the displayed entry and advancing to the next input.Rate this question:
-
- 46.
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 important 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, and individuals with this condition may have difficulty distinguishing between these colors. Using red and green together can make it challenging for color-blind users to read and interpret the information in the workbook accurately.Rate this question:
-
- 47.
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 useful for exploring different scenarios and understanding how changes in input variables can impact the outcome. It helps in making informed decisions and analyzing the sensitivity of the model to different inputs. Track Changes, on the other hand, is a different feature in Excel that allows you to track and review changes made to a workbook by different users.Rate this question:
-
- 48.
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 of the options mentioned can be used to sort data in an Excel worksheet. The Sort A to Z and Sort Z to A buttons are available on the Home tab and can be used to sort data alphabetically in ascending or descending order. The Quicksort Options provide additional sorting options and customization. The Sort command on the Formulas tab can be used to sort data based on formulas or calculations. Therefore, any of these options can be used to sort data in Excel.Rate this question:
-
- 49.
=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 type of information that can be filled in the blank. The statement "The general syntax of all functions" accurately describes what can be expected when using the =FUNCTION() formula in any context. It suggests that the function can take multiple arguments, and the syntax for writing these arguments is the same for all functions.Rate this question:
-
- 50.
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:
- A.
Abbreviate all text
- B.
Reduce the font size to 8 pt
- C.
Click Wrap text
- D.
Delete one column
Correct Answer
C. Click Wrap textExplanation
Clicking the "Wrap text" option allows the text to be displayed on multiple lines within a single cell, instead of being truncated. This ensures that all the content is visible without losing any data.Rate this question:
-
.JPG "Reference to the above image of Command Group \"Alignment\" which of the following tabs consist it:")
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Sep 13, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 13, 2015Quiz Created by
Daminda Chandimal
Back to top