Microsoft Excel Skills Quiz: Questions And Answers

  • 6th Grade,
  • 7th Grade,
  • 8th Grade,
  • 9th Grade,
  • +1
  • 10th Grade
  • MOS
Reviewed by Samy Boulos
Samy Boulos, MSc (Computer Science) |
Data Engineer
Review Board Member
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.
, MSc (Computer Science)
By Rpolete
R
Rpolete
Community Contributor
Quizzes Created: 1 | Total Attempts: 26,908
| Attempts: 26,909 | Questions: 21 | Updated: Nov 24, 2025
Please wait...
Question 1 / 21
0 %
0/100
Score 0/100
1. Is it possible to insert an image from a file into an Excel spreadsheet?

Explanation

Yes, it is possible to insert an image from a file into an Excel spreadsheet. Excel allows users to insert various types of objects, including images, into a spreadsheet. This can be done by selecting the "Insert" tab, then choosing the "Picture" option to browse and select the desired image file. Once inserted, the image can be resized, positioned, and formatted as needed within the spreadsheet.

Submit
Please wait...
About This Quiz
Microsoft Excel Skills Quiz: Questions And Answers - Quiz

Mastering Microsoft Excel is one of the most valuable skills in today’s digital workplace. This Excel Skills Quiz is designed to help learners, students, and professionals test how well they understand core spreadsheet concepts. From formulas and functions to charts, formatting, error messages, and cell references, this quiz covers the... see moreessential features every Excel user should know.

No matter if you're preparing for an assessment, sharpening your office skills, or simply checking your knowledge, these questions will challenge your understanding of real Excel functions and tools. Use this quiz to identify areas for improvement and strengthen your confidence when working with spreadsheets, data analysis, and everyday Excel tasks.
see less

2.
You may optionally provide this to label your report, leaderboard, or certificate.
2. Formulas in a cell start with a _______.

Explanation

Formulas in a cell start with an equals sign (=). The equals sign is used to indicate that the content of the cell is a formula and not a regular text or value. By starting a cell with an equals sign, the user can perform calculations and manipulate data using various mathematical and logical functions available in the spreadsheet software.

Submit
3. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?  

Explanation

The $ button on the Excel toolbar is used to format selected cells as currency values. This formatting adds a currency symbol (such as $) to the selected cells, making them appear as currency values.

Submit
4. "Month 1, Month 2, Month 3" is an example of what?

Explanation

"Month 1, Month 2, Month 3" is an example of a series because it represents a sequence of items that follow a specific pattern or order. In this case, the series is a sequence of months, where each subsequent month follows the previous one.

Submit
5. Inserting Page Number is in Header and Footer.

Explanation

The statement is true because inserting page numbers in the header and footer of a document is a common practice in document formatting. Page numbers help readers navigate through the document and keep track of their progress. By placing the page numbers in the header and footer, they are easily visible on every page of the document. This is particularly useful when dealing with lengthy documents or when referencing specific pages.

Submit
6. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

Explanation

The correct answer is A1:J15. This is because the colon (:) is used to indicate a range of cells. In this case, the range starts from cell A1 and goes over to column J, and down to row 15. The range can be represented as A1:J15.

Submit
7. According to the picture the selected cell in yellow corresponds to:

Explanation

The selected cell in yellow corresponds to Column A, Row 11, Cell A11. This is determined by looking at the picture and identifying the column and row that the yellow cell is in. In this case, the yellow cell is in column A and row 11, and the cell itself is labeled as A11. Therefore, the correct answer is Column A, Row 11, Cell A11.

Submit
8. When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?  

Explanation

If changing the margins on the spreadsheet does not solve the problem with the printout width, using the Fit to Page option can help. This option automatically adjusts the size of the spreadsheet to fit the printed page, ensuring that all content is visible and properly aligned. By selecting this option, the user can avoid any issues with the printout width and ensure that the entire spreadsheet is printed without any parts being cut off.

Submit
9. Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Explanation

The formula that can add all the 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. This formula is commonly used in Excel to calculate the total sum of a range of numbers. It automatically ignores any non-numeric values and only adds up the numeric values in the range.

Submit
10. When number signs (#####) are displayed in the cell, it means:  

Explanation

When number signs (#####) are displayed in a cell, it means that there are too many characters in the cell to be displayed with the current cell width. This usually happens when the content of the cell is too long or when the font size is too large for the cell. To display the full content, the cell width needs to be adjusted or the font size needs to be reduced.

Submit
11. What is the name given to a value that does not change when used within a formula?

Explanation

A constant is a value that does not change when used within a formula. It remains fixed and does not vary, providing a consistent value in calculations. Unlike variables, constants are not meant to be changed or modified during the execution of a program or formula. They are typically used to represent fixed values such as mathematical constants (e.g., pi) or values that are known and unchanging in a specific context. In the given question, the correct answer is "Constant" because it accurately describes a value that does not change when used within a formula.

Submit
12. Which function would you use to find the largest number of a selected range?

Explanation

The function "MAX" would be used to find the largest number of a selected range.

Submit
13. Which of the following is a relative cell reference?

Explanation

A relative cell reference is a cell reference that can change when it is copied or filled. In this case, the answer "P72" is a relative cell reference because the column letter "P" can change when the reference is copied to another column, while the row number "72" can change when the reference is copied to another row.

Submit
14. A _________ is a built-in mathematical formula included in Excel.

Explanation

A function is a built-in mathematical formula included in Excel. It allows users to perform various calculations and operations on data in cells or ranges. Functions can be used to add, subtract, multiply, divide, calculate averages, find maximum or minimum values, and perform many other mathematical operations. They are predefined formulas that can be easily applied to cells or ranges to automate calculations and save time.

Submit
15. The Chart Tools commands are found in these three tabs? 

Explanation

The correct answer is Design, Layout, Format. These three tabs, Design, Layout, and Format, contain the Chart Tools commands. The Design tab allows users to modify the overall appearance of the chart, such as changing the chart type or adding chart elements. The Layout tab provides options for adjusting the layout and placement of chart elements, such as titles, legends, and axes. The Format tab allows users to customize the appearance of specific chart elements, such as colors, fonts, and borders.

Submit
16. Which feature in Excel allows you to view two spreadsheets in one window?

Explanation

The Split feature in Excel allows you to view two spreadsheets in one window. This feature is useful when you want to compare or work with two different parts of a spreadsheet simultaneously. By splitting the window, you can scroll and navigate through each section independently, making it easier to analyze and make changes to your data.

Submit
17. Which of the following is an absolute cell reference?

Explanation

An absolute cell reference is denoted by a dollar sign ($) before both the column letter and row number. In the given options, only $F$8 has both the column letter and row number preceded by a dollar sign, indicating that it is an absolute cell reference.

Submit
18. What name is given to the chart background?

Explanation

The chart area refers to the entire area where the chart is displayed, including the plot area, legend area, and other elements. It is the overall background of the chart that encompasses all the components. The chart area provides a visual context and boundary for the chart, helping to organize and present the data effectively.

Submit
19. Which of the following is a mixed cell reference with a fixed column address?

Explanation

The given answer, $K356, is a mixed cell reference with a fixed column address. In a mixed cell reference, either the row or the column is fixed while the other is relative. In this case, the column is fixed with the dollar sign ($) before the letter K, indicating that the column will not change when the formula is copied to other cells. The row address, 356, is not fixed, so it will adjust relative to the cell where the formula is copied.

Submit
20. Which of the following is a mixed cell reference with a fixed row address?

Explanation

A mixed cell reference with a fixed row address means that the row number is fixed, while the column letter can change. In the given options, only G$9 fits this criteria. The dollar sign before row number 9 indicates that the row address is fixed, while the letter G can be changed to refer to different columns.

Submit
21. How does a relative reference differ from an absolute reference?

Explanation

A relative reference adjusts to its location on the worksheet, meaning that it changes its cell reference based on its position relative to the formula. This allows the formula to be copied and pasted to different cells without affecting the references. On the other hand, an absolute reference remains fixed and does not change when the formula is copied to other cells.

Submit
×
Saved
Thank you for your feedback!
View My Results
Samy Boulos |MSc (Computer Science) |
Data Engineer
Samy Boulos is an experienced Technology Consultant with a diverse 25-year career encompassing software development, data migration, integration, technical support, and cloud computing. He leverages his technical expertise and strategic mindset to solve complex IT challenges, delivering efficient and innovative solutions to clients.
Cancel
  • All
    All (21)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Is it possible to insert an image from a file into an Excel...
Formulas in a cell start with a _______.
Which of the following buttons on the Excel toolbar will format...
"Month 1, Month 2, Month 3" is an example of what?
Inserting Page Number is in Header and Footer.
The cell range that starts in cell A1 and goes over to column J and...
According to the picture the selected cell in yellow corresponds to:
When changing the margins on your spreadsheet does not solve the...
Which formula can add all the numeric values in a range of cells,...
When number signs (#####) are displayed in the cell, it means:...
What is the name given to a value that does not change when used...
Which function would you use to find the largest number of a selected...
Which of the following is a relative cell reference?
A _________ is a built-in mathematical formula included in Excel.
The Chart Tools commands are found in these three tabs? 
Which feature in Excel allows you to view two spreadsheets in one...
Which of the following is an absolute cell reference?
What name is given to the chart background?
Which of the following is a mixed cell reference with a fixed...
Which of the following is a mixed cell reference with a fixed row...
How does a relative reference differ from an absolute reference?
Alert!

Advertisement