# The Ultimate Microsoft Excel Quiz!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Octara
O
Octara
Community Contributor
Quizzes Created: 1 | Total Attempts: 19,164
Questions: 114 | Attempts: 19,256

Settings

Welcome to the ultimate Microsoft Excel Quiz! Whether it’s for school, college, work or personal use, Excel is incredibly handy spreadsheet software that allows you to track and analyze data of all kinds. What do you know about the tool? Let’s take a look right now!

• 1.

### The number of rows in an Excel 2007 worksheet is:

• A.

65536

• B.

256

• C.

64536

• D.

1048576

D. 1048576
Explanation
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 a single worksheet, making it more efficient for complex calculations and data analysis tasks.

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

A. True
Explanation
This statement is true because Excel has the ability to connect to various databases and import data from them into a worksheet. Once the data is imported, it can be refreshed with just one click, allowing the user to update the results without having to manually re-import the data. This feature makes it convenient and efficient for users to work with database tables in Excel.

Rate this question:

• 3.

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

• A.

True

• B.

False

A. True
Explanation
The statement is true because the Insert Function dialog box provides information and guidance on how to use functions in a specific software or program. It helps users understand the syntax, parameters, and purpose of different functions, making it easier for them to utilize the functions effectively in their work or calculations.

Rate this question:

• 4.

• A.

True

• B.

False

B. False
• 5.

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

• A.

True

• B.

False

B. 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 correct answer is False.

Rate this question:

• 6.

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

• A.

True

• B.

False

A. True
Explanation
The function arguments dialog box provides information on how to use functions. It likely includes details about the input parameters that a function accepts and how to format them correctly. This information helps users understand how to properly utilize functions in their code.

Rate this question:

• 7.

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

A. True
Explanation
Entering data in the first blank row of a table is the simplest and most convenient way to add a record. This is because it ensures that the new record is added at the end of the existing data without any need for sorting or rearranging. By entering data in the first blank row, the record will be automatically appended to the table, maintaining the order of the existing records. Therefore, the statement "True" is the correct answer.

Rate this question:

• 8.

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

A. True
Explanation
The statement is true because 3D charts, while visually appealing, can actually make it harder to interpret the data accurately. The use of depth and perspective in 3D charts can distort the sizes of the slices, making it difficult to determine which slice is larger or smaller. This can lead to a misrepresentation of the data and potentially misleading conclusions. Therefore, it is important to be cautious when using 3D charts and consider alternative chart types that present the data more accurately and clearly.

Rate this question:

• 9.

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

• A.

True

• B.

False

A. True
Explanation
Excel does have a built-in format to display 4 digit year values. Therefore, there is no need to create a custom format for this purpose. This statement is true.

Rate this question:

• 10.

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

• A.

True

• B.

False

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 values or content of the data. The underlying data remains the same, and only the visual representation is modified. Therefore, formatting data does not affect the data itself, making the statement true.

Rate this question:

• 11.

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

• A.

True

• B.

False

B. False
Explanation
Excel actually starts with the innermost function and then moves outward. When a formula contains multiple functions, Excel first evaluates the innermost function and then uses the result of that function as an argument for the next outer function. This process continues until all functions have been evaluated. Therefore, the correct answer is False.

Rate this question:

• 12.

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

A. True
Explanation
The statement is true because 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 writing complex sorting algorithms, making it a convenient and efficient method for sorting data.

Rate this question:

• 13.

### You can create maximum one Excel table in a worksheet

• A.

True

• B.

False

B. False
Explanation
You can create more than one Excel table in a worksheet. This allows you to organize and analyze different sets of data separately within the same worksheet.

Rate this question:

• 14.

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

A. True
Explanation
When typing a function name within a formula into a cell, a list of functions that start with the letters you have typed will appear. This feature is known as autofill or autocomplete, and it helps users by providing suggestions and saving time in searching for the desired function. By displaying a list of functions that match the typed letters, it allows users to easily select the correct function without having to remember the exact name or syntax. Therefore, the statement is true.

Rate this question:

• 15.

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

A. True
Explanation
The statement is true because in a 3D chart, you can rotate it horizontally along the x-axis and vertically along the y-axis. These two directions allow for a complete view of the chart from different angles. However, rotating the chart in any other direction, such as along the z-axis, is not possible.

Rate this question:

• 16.

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

• A.

True

• B.

False

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

Rate this question:

• 17.

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

• A.

True

• B.

False

A. True
Explanation
The statement is true because pressing the Ctrl+B key combination in a selected cell will make the font bold. This is a common shortcut used in various software programs, including spreadsheet applications like Microsoft Excel. By selecting a cell and using this shortcut, users can quickly and easily apply the bold formatting to the text in that cell.

Rate this question:

• 18.

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

• A.

F1

• B.

F2

• C.

F3

B. F2
Explanation
F2 should be used to edit the content of a cell. This key is commonly used in spreadsheet software like Microsoft Excel. Pressing F2 allows the user to directly edit the text or formula within a selected cell, without needing to double-click or use the mouse to access the editing mode. This shortcut helps to streamline the editing process and improve efficiency when working with large amounts of data.

Rate this question:

• 19.

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

• A.

=If()

• B.

=Sum()

• C.

=SumIf()

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 if the condition is true, it returns one value, and if the condition is false, it returns another value. 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:

• 20.

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

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

• 21.

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

C. Sum
Explanation
The SUM formula can add all the numeric values in a range of cells and ignore those that are not numeric. It will then place the result in a different cell.

Rate this question:

• 22.

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

• A.

F3

• B.

F7

• C.

F9

• D.

F11

D. F11
Explanation
Pressing the F11 key on the keyboard creates a chart from the selected cells. This shortcut allows for quick and easy creation of charts without having to go through the menu options.

Rate this question:

• 23.

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

D. A formula which will add values in the range Excel guesses you want to add
Explanation
When using 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 means that Excel will look at the adjacent cells and determine the range based on the data in the column or row. The autosum button saves time by automatically creating the formula for you.

Rate this question:

• 24.

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

C. Page Break Preview
Explanation
The view that puts a blue line around each page that would be printed is the Page Break Preview. This view allows users to see how their document will be divided into pages when printed, with blue lines indicating where each page will start and end. It is useful for adjusting page breaks and formatting to ensure that the document is properly organized and does not have awkward page breaks.

Rate this question:

• 25.

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

D. 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 B1:G10 specifies the range from cell B1 to cell G10.

Rate this question:

• 26.

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

B. CTRL + ENTER
Explanation
Pressing CTRL + ENTER allows the user to input their typing as the contents of the cell, but the focus remains in the same cell. This means that after typing, the cursor does not move to another cell and the user can continue working within the same cell.

Rate this question:

• 27.

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

C. Yes, even after saving the file, double click on the cell where data is to be changed to edit
Explanation
After saving the file, the 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 without having to save it as a different file name.

Rate this question:

• 28.

### On an Excel spreadsheet the active cell is indicated by

• A.

A dark wide border

• B.

A dotted border

• C.

• D.

None of the above

A. A dark wide border
Explanation
The active cell on an Excel spreadsheet is indicated by a dark wide border. This border helps the user identify which cell they are currently working on or editing. It stands out from the other cells and provides a visual cue to the user. The dark wide border helps prevent any confusion or mistakes when navigating through the spreadsheet and ensures that the user is aware of their current cell selection.

Rate this question:

• 29.

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

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-contiguous cells or ranges by clicking on each of them individually. This is useful when you want to select specific cells or ranges from different parts of the worksheet without selecting everything in between. Holding down the SHIFT key would select a continuous range of cells, while holding down the ALT key does not have any specific function for selecting cells or ranges.

Rate this question:

• 30.

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

B. The Excel file that holds your worksheets
Explanation
A workbook in Excel refers to the Excel file that holds multiple worksheets or spreadsheets. It is the main container where you can store and organize your data, calculations, and analysis. A workbook can contain multiple worksheets, each of which can have its own data and formulas. It provides a convenient way to manage and manipulate data in a structured manner.

Rate this question:

• 31.

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

C. A built-in formula in Excel
Explanation
A function is a built-in formula in Excel that performs a specific action or calculation. It is used to manipulate data and perform various operations such as mathematical calculations, text manipulation, and logical operations. Functions in Excel are predefined formulas that can be used to simplify complex calculations and automate tasks. They are represented by a symbol or a combination of letters and symbols and are used by entering them into a cell along with the required arguments or parameters.

Rate this question:

• 32.

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

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 treated as a single unit. Ranges are commonly used for performing calculations, formatting data, and applying functions or formulas to a specific set of cells. By selecting a range, users can easily manipulate and analyze data within Excel, making it a fundamental feature of the software.

Rate this question:

• 33.

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

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 screen and contains various tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View. Each tab contains specific commands and functions related to that category, making it easy to access and use different features of Excel.

Rate this question:

• 34.

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

C. 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 fit the longest entry or changes the height of a row to fit the font. It ensures that all the data in a column or row is visible without any truncation or overlap. This feature is particularly useful when working with large amounts of data or when formatting a spreadsheet to make it more readable and organized.

Rate this question:

• 35.

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

C. A table of data that is organized into rows and columns
Explanation
The correct answer is "A table of data that is organized into rows and columns." A worksheet is a type of document in spreadsheet software where data can be entered, stored, and organized. It consists of a grid-like structure with rows and columns, similar to a table, where data can be inputted and manipulated. Worksheets are commonly used for data analysis, calculations, and creating charts or graphs.

Rate this question:

• 36.

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

A. It is a visual way to display and compare data
Explanation
A chart is a visual way to display and compare data. It allows for easy understanding and analysis of information by presenting it in a graphical format. Charts can be used to represent various types of data, such as numerical values, percentages, or categories. They provide a clear and concise representation of data, making it easier for users to identify patterns, trends, and relationships between different data points. By visually organizing and presenting data, charts help in making data-driven decisions and communicating information effectively.

Rate this question:

• 37.

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

B. Type the data in A1 and Merge cells A1:E1
Explanation
By typing the data in A1 and merging cells A1:E1, the title will be centered across the top of the data. Merging cells allows the title to span multiple columns and by typing the data in A1, it ensures that the title is aligned with the center of the merged cells. This method is a simple and effective way to center the title in the given scenario.

Rate this question:

• 38.

### 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"

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

Rate this question:

• 39.

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

B. Tab
Explanation
After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This is because the Tab key is used to move to the next cell in Excel, and accepting the entry means moving to the next cell after the existing entry is displayed.

Rate this question:

• 40.

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

A. Red and green
Explanation
Color blindness is a condition where individuals have difficulty distinguishing certain colors, particularly red and green. This means that individuals with color blindness may struggle to differentiate between red and green text and background. Therefore, when creating an Excel workbook, it is recommended to avoid using red and green together to ensure that the content is accessible to individuals with color blindness.

Rate this question:

• 41.

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

A. What-if analysis
Explanation
What-if analysis is the correct answer because it is a feature in Excel that allows users to change values in a spreadsheet and see how those changes affect the calculated values. This feature is commonly used for scenario planning, forecasting, and decision-making. 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:

• 42.

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

D. Any of the above
Explanation
The correct answer is "Any of the above". This is because to sort data in an Excel worksheet, you can use either 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 can be used to sort data in Excel.

Rate this question:

• 43.

### =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.

C. The general syntax of all functions.
Explanation
This answer is correct because the "=FUNCTION(argument1, argument2, ...)" format represents the general syntax of all functions in various programming languages or spreadsheet software. It indicates that a function is being called with one or more arguments enclosed in parentheses. The specific function name and arguments may vary, but the overall structure remains the same.

Rate this question:

• 44.

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

C. Click Wrap text
Explanation
Clicking "Wrap text" is the correct answer because it allows the text to be displayed on multiple lines within a cell, making it visible without losing any data. This is a useful solution when the content is being truncated due to limited column width and increasing the worksheet width is not an option.

Rate this question:

• 45.

### The most efficient way to format several cells with a specific font, number format, alignment, font color would be to:

• A.

Use Format Painter

• B.

Format each element using the Toolbar

• C.

Select all and use the Formatting dialog box

• D.

Apply a table style

D. Apply a table style
Explanation
Applying a table style is the most efficient way to format several cells with a specific font, number format, alignment, and font color. This allows you to quickly apply a predefined set of formatting options to the selected cells, saving time and effort compared to manually formatting each element using the Toolbar or the Formatting dialog box. Using the Format Painter may work for copying the formatting of a single cell to others, but it may not be as efficient when formatting multiple cells with different formatting options.

Rate this question:

• 46.

### What is a workbook made up of?

• A.

Rows & Columns

• B.

Worksheets

• C.

Files

B. Worksheets
Explanation
A workbook is made up of worksheets. Worksheets are individual sheets within a workbook where data can be organized and analyzed. Each worksheet consists of rows and columns that can be filled with data, formulas, and charts. Multiple worksheets can be created within a workbook to separate and organize different sets of data or calculations. Therefore, the correct answer is worksheets.

Rate this question:

• 47.

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

• A.

The Fill down command

• B.

The Autosum command

• C.

The Format Painter command

• D.

None of the above.

C. The Format Painter command
Explanation
The Format Painter command allows you to copy the formatting from one cell and apply it to another cell. This is useful when you want to format a cell in the same way as another cell without manually applying each formatting option.

Rate this question:

• 48.

### You use ______ filters to find all objects with a value greater than X or acquired after a certain date

• A.

Custom

• B.

Criteria

• C.

Index

• D.

Pivot

A. Custom
Explanation
Custom filters allow you to create specific criteria to find objects with a value greater than X or acquired after a certain date. These filters can be customized according to your requirements and help you narrow down the search results to only include the desired objects.

Rate this question:

• 49.

### in "=SUM(number1 [,number2 ,number3 ...])" number 1, number 2, and number 3 may be numbers or __________.

• A.

Letters

• B.

Cell references

• C.

Symbols

• D.

Operators

B. Cell references
Explanation
In the formula "=SUM(number1 [,number2 ,number3 ...])", the numbers that can be included as arguments are not limited to just numerical values. They can also be cell references, which refer to the values stored in specific cells within a spreadsheet. This allows for dynamic calculations based on the values in those cells.

Rate this question:

• 50.

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

• A.

• B.

Create charts.

• C.

Perform mathematical operations

• D.

All of the above

D. All of the above
Explanation
A spreadsheets package like Microsoft Excel can be used to design spreadsheet models, create charts, and perform mathematical operations. Therefore, the correct answer is "All of the above."

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 22, 2023
Quiz Edited by
ProProfs Editorial Team
• Mar 24, 2012
Quiz Created by
Octara

Related Topics