# Microsoft Excel 2010 Test Questions And Answers

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)
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 Rpolete
R
Rpolete
Community Contributor
Quizzes Created: 1 | Total Attempts: 26,358
Questions: 25 | Attempts: 26,369

Settings

How well do you know Microsoft Excel 2010? Could you pass this " Microsoft Excel 2010 Test with informative questions and answers?" With this quiz, it is necessary to learn things such as which formula can add the numeric values in a range of cells, put cells in a different cell, and incorporate an image from a file into the spreadsheet. This excellent quiz will show you why Microsoft Excel 2010 still has value. Good Luck!

• 1.

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

• A.

Count

• B.

Average

• C.

Sum

• D.

Large

C. Sum
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.

Rate this question:

• 2.

### Is it possible to insert an image from a file into an Excel spreadsheet?

• A.

Yes

• B.

No

A. Yes
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.

Rate this question:

• 3.

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

• A.

A1-J15

• B.

A1.J15

• C.

A1;J15

• D.

A1:J15

D. A1:J15
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.

Rate this question:

• 4.

### “Month 1, Month 2, Month 3” is an example of what?

• A.

Series

• B.

Function

• C.

Formula

• D.

Syntax

A. Series
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.

Rate this question:

• 5.

### How does a relative reference differ from an absolute reference?

• A.

A relative reference specifies column and row references.

• B.

A relative reference adjusts to its location on the worksheet.

• C.

A relative reference refers to an existing cell reference.

• D.

A relative reference refers to an original value.

B. A relative reference adjusts to its location on the worksheet.
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.

Rate this question:

• 6.

### Which of the following is an absolute cell reference?

• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

D. \$F\$8
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.

Rate this question:

• 7.

### What is the name given to a value that does NOT change when used within a formula?

• A.

Reference

• B.

Constant

• C.

Function

• D.

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

Rate this question:

• 8.

### What name is given to the chart background?

• A.

Chart area

• B.

Background area

• C.

Legend area

• D.

Plot area

A. Chart area
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.

Rate this question:

• 9.

### The Chart Tools commands are found in these three tabs?

• A.

Design, Shape, Layout

• B.

Layout, Format, Type

• C.

Design, Layout, Format

• D.

Styles, Shapes, Effects

C. Design, Layout, Format
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.

Rate this question:

• 10.

### Which of the following is a mixed cell reference with a fixed column address?

• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

C. \$K356
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.

Rate this question:

• 11.

### Which of the following is a mixed cell reference with a fixed row address?

• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

B. G\$9
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.

Rate this question:

• 12.

### Which of the following is a relative cell reference?

• A.

P72

• B.

G\$9

• C.

\$K356

• D.

\$F\$8

A. P72
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.

Rate this question:

• 13.

• A.

:

• B.

{

• C.

=

• D.

/

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

Rate this question:

• 14.

### What is a worksheet tab in Excel 2010?

• A.

A worksheet tab is used to access tools associated with the worksheet.

• B.

A worksheet tab is used to move from one cell to the next cell in a worksheet.

• C.

A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet.

• D.

A worksheet tab is used to get help when working with Microsoft Excel 2010.

C. A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet.
Explanation
A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet. This means that when you click on a worksheet tab, that particular worksheet becomes active and you can start working on it. The sheet tab allows you to easily switch between different worksheets within the same Excel file.

Rate this question:

• 15.

### Once data is entered into a cell, can it be edited?

• A.

Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing.

• B.

No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet.

• C.

No, once a file is saved, cell data cannot be changed.

• D.

Yes, but the file must be saved with a different file name.

A. Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing.
Explanation
The correct answer is stating that data entered into a cell can be edited even after saving the file. It explains that by double-clicking on a cell, the user can make changes to the data. This implies that the data is not permanently locked and can be modified as needed.

Rate this question:

• 16.

### Which feature in Excel allows you to view two spreadsheets in one window?

• A.

Freeze panes

• B.

Split

• C.

View side by side

• D.

Mirror

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

Rate this question:

• 17.

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

• A.

#

• B.

%

• C.

&

• D.

\$

D. \$
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.

Rate this question:

• 18.

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

• A.

The formula in the cell is wrong.

• B.

There are too many characters in the cell to be displayed with the current cell width.

• C.

The decimal point placement in the cell is wrong.

• D.

All of the above.

B. There are too many characters in the cell to be displayed with the current cell width.
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.

Rate this question:

• 19.

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

• A.

Separate the page into two for easier printing.

• B.

Use the Fit to Page option.

• C.

Highlight all cells to print and print selection.

• D.

None of the above.

B. Use the Fit to Page option.
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.

Rate this question:

• 20.

### What does the following error mean - #REF! ?

• A.

The #REF! error value occurs when a cell reference is not valid.

• B.

The #REF! error value occurs when a cell has been formatted as a currency but contains text.

• C.

The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

• D.

None of the above

A. The #REF! error value occurs when a cell reference is not valid.
Explanation
The #REF! error value occurs when a cell reference is not valid. This means that the formula in a cell is trying to refer to a cell that does not exist or has been deleted.

Rate this question:

• 21.

### How do you select noncontiguous cells?

• A.

Click a cell, then hold down SHIFT on the keyboard and select the other cells.

• B.

Click in a cell, then hold down ALT on the keyboard as you select the other cells.

• C.

Click in a cell, hold down CTRL on the keyboard and then select the other cells.

• D.

Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard.

C. Click in a cell, hold down CTRL on the keyboard and then select the other cells.
Explanation
To select noncontiguous cells, you need to click in a cell, hold down CTRL on the keyboard, and then select the other cells. By holding down the CTRL key, you can choose multiple cells that are not adjacent to each other.

Rate this question:

• 22.

### Which function would you use to find the largest number of a selected range?

• A.

MAXIMUM

• B.

MAX

• C.

LARGE

• D.

LARGEST

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

Rate this question:

• 23.

### According to the picture the selected cell in yellow corresponds to:

• A.

Column A, Row A11, Cell 11

• B.

Column 11, Row A, Cell 11A

• C.

Column 11, Row A, Cell A11

• D.

Column A, Row 11, Cell A11

D. Column A, Row 11, Cell A11
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.

Rate this question:

• 24.

### Inserting Page Number is in Header and Footer.

• A.

True

• B.

False

A. True
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.

Rate this question:

• 25.

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

• A.

Function

• B.

Cell

• C.

Formula

• D.

Range

A. Function
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.

Rate this question:

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.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Feb 07, 2024
Quiz Edited by
ProProfs Editorial Team

Expert Reviewed by
Samy Boulos
• Mar 08, 2013
Quiz Created by
Rpolete

Related Topics