# Hh MS Excel 2007 Knowledge Test

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
| Written by HHMTest
H
HHMTest
Community Contributor
Quizzes Created: 1 | Total Attempts: 138
Questions: 40 | Attempts: 138

Settings

Let's see how well you know Excel. Good luck!

• 1.

### You'd see three worksheets every time you create a new workbook. You can change that default number if you want to.

• A.

True that!

• B.

Impossible! That's why it's called a default setting! Duh!

• C.

Err, so what? Does it even matter?

A. True that!
Explanation
The explanation for the given correct answer is that when you create a new workbook in Excel, by default, it will have three worksheets. However, you have the option to change this default setting and have a different number of worksheets if you prefer.

Rate this question:

• 2.

### The first cell in an Excel worksheet is labeled as:

• A.

A

• B.

1A

• C.

AA

• D.

A1

D. A1
Explanation
The first cell in an Excel worksheet is labeled as A1 because in Excel, columns are labeled with letters (A, B, C, etc.) and rows are labeled with numbers (1, 2, 3, etc.). Therefore, the intersection of column A and row 1 is labeled as cell A1, which represents the top-left cell in the worksheet.

Rate this question:

• 3.

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

• A.

A dotted border

• B.

A bold border

• C.

• D.

A dancing border

B. A bold border
Explanation
The active cell on an Excel spreadsheet is indicated by a bold border. This helps the user easily identify which cell they are currently working on or editing. The bold border stands out from the other cells and provides a visual cue, making it easier to navigate and manipulate data within the spreadsheet.

Rate this question:

• 4.

### The name of the active cell appears in the...

• A.

Name Box

• B.

Formula Bar

• C.

Status Bar

• D.

Ribbon

A. Name Box
Explanation
The active cell in a spreadsheet is the cell that is currently selected or being edited. The name of this active cell is displayed in the Name Box, which is located next to the Formula Bar. The Name Box provides a quick reference to the cell's location and can be used to navigate to specific cells in the spreadsheet. The Formula Bar, on the other hand, displays the contents of the active cell, including any formulas or data entered. The Status Bar displays information about the current state of the spreadsheet, such as the sum of selected cells or the current mode (e.g., editing or viewing). The Ribbon is a toolbar that contains various commands and options for working with the spreadsheet.

Rate this question:

• 5.

### By default, pressing ENTER moves your current selection one cell to the right.

• A.

Yep, it sure does!

• B.

No, it does not!

• C.

Um, is it supposed to move?

• D.

I don't know. My Excel is not fast enough to do that.

B. No, it does not!
Explanation
The correct answer is "No, it does not!" because the statement in the question is incorrect. By default, pressing ENTER in Excel moves your current selection one cell down, not one cell to the right.

Rate this question:

• 6.

### Getting data from a cell located on a different sheet is called...

• A.

Accessing

• B.

Referencing

• C.

Borrowing

• D.

Stealing

B. Referencing
Explanation
Referencing is the correct answer because when we want to retrieve data from a cell located on a different sheet in a spreadsheet, we use referencing. Referencing allows us to access the data in another sheet by specifying the sheet name and cell reference. This is a common practice in spreadsheets to consolidate and organize data from multiple sheets into one.

Rate this question:

• 7.

### Formatting only changes the appearance of the data. It does not affect the data itself.

• A.

Wrong! Formatting changes everything!

• B.

Right!

• C.

I don't know what it does...

B. Right!
Explanation
Formatting refers to the visual presentation of data, such as changing font styles, colors, or alignments. It does not alter the actual data or its content. Therefore, the statement "Formatting only changes the appearance of the data. It does not affect the data itself" is correct. The answer "Right!" aligns with this explanation.

Rate this question:

• 8.

### The icon below allows you to change the color of your text.

• A.

True

• B.

False

• C.

I have never seen that icon before!

B. False
Explanation
The statement "I have never seen that icon before!" suggests that the person is not aware of the icon mentioned in the question. This contradicts the statement in the question that the icon allows you to change the color of your text. Therefore, the correct answer is "False" as the person has not seen the icon before.

Rate this question:

• 9.

### Which function allows you to copy cell formats from one cell to another?

• A.

Enter

• B.

Format Painter

• C.

Esc

• D.

Paste

B. Format Painter
Explanation
The Format Painter function allows you to copy cell formats from one cell to another. This feature is useful when you want to apply the same formatting to multiple cells without manually adjusting each one. By selecting the cell with the desired format and using the Format Painter tool, you can easily transfer the formatting to other cells with just a few clicks.

Rate this question:

• 10.

### Excel recognizes similar entries in a column and displays an existing text that matches the characters you type. To accept the suggested entry, press ________.

• A.

ALT

• B.

CTRL + ALT + DEL

• C.

ENTER

• D.

ESC

C. ENTER
Explanation
When using Excel, if you start typing in a column and Excel recognizes a similar entry, it will display an existing text that matches the characters you have typed. To accept this suggested entry, you need to press the ENTER key on your keyboard. This will allow Excel to automatically complete the entry with the suggested text.

Rate this question:

• 11.

### The easiest way to select an entire column is to...

• A.

Click the first cell and drag your selection all the way down to the last cell of the column.

• B.

Double-click any cell in the column.

• C.

• D.

Press CTRL + A.

Explanation
To select an entire column, you can simply click on the column heading. This is the easiest way because it allows you to select the entire column in just one click. Clicking on the first cell and dragging the selection down to the last cell of the column would require more effort and time. Double-clicking any cell in the column would only select that specific cell, not the entire column. Pressing CTRL + A would select the entire spreadsheet, not just the column.

Rate this question:

• 12.

### All formulas begin with...

• A.

A question mark (?)

• B.

An equal sign (=)

• C.

A forward slash (/)

• D.

A semicolon (;)

B. An equal sign (=)
Explanation
The correct answer is an equal sign (=). In mathematical and programming contexts, an equal sign is used to indicate that the value on the left side is equal to the value on the right side. It is the symbol used to define equations and assign values to variables.

Rate this question:

• 13.

### Characters such as +, -, * and / are examples of...

• A.

Formulas.

• B.

Values.

• C.

Arithmetic operators.

• D.

Symbols with special meanings.

C. Arithmetic operators.
Explanation
The characters +, -, *, and / are commonly used in arithmetic operations such as addition, subtraction, multiplication, and division. These characters are known as arithmetic operators because they perform specific mathematical operations on values or variables. They are not formulas, values, or symbols with special meanings, but rather symbols that represent specific mathematical operations.

Rate this question:

• 14.

### You can display all formulas in an active worksheet by pressing...

• A.

ALT + ~

• B.

CTRL + ~

• C.

CTRL + F4

• D.

Nothing... It simply can't be done. Excel always displays cell values and not formulas.

B. CTRL + ~
Explanation
Pressing CTRL + ~ in Excel allows you to toggle between displaying cell values and displaying formulas in the active worksheet. This keyboard shortcut provides a quick way to view and check the formulas used in the cells without having to manually select each cell.

Rate this question:

• 15.

### What does ###### mean?

• A.

You've misspelled something.

• B.

You've entered the wrong formula.

• C.

The cell is not wide enough.

• D.

A lot of hashtags...

C. The cell is not wide enough.
Explanation
The answer "The cell is not wide enough" is the correct explanation because the use of hashtags in the question suggests that the word "######" is being used as a placeholder to represent a long text that is being cut off due to the cell not being wide enough to display the entire content.

Rate this question:

• 16.

### What happens when dollar signs (\$) are correctly entered in a formula? Check all that apply.

• A.

It locks the cell range.

• B.

An error message will appear.

• C.

The array won't change even if the formula gets dragged or copied to a different cell.

• D.

It changes the number format to currency.

A. It locks the cell range.
C. The array won't change even if the formula gets dragged or copied to a different cell.
Explanation
When dollar signs (\$) are correctly entered in a formula, it locks the cell range, meaning that the formula will always refer to the same cells even if it is dragged or copied to a different cell. This ensures that the formula always uses the same range of cells for calculations. The other options, such as an error message appearing or the number format changing to currency, are not applicable when dollar signs are used in a formula.

Rate this question:

• 17.

### If a number with too many decimal places creates a distraction in your report, make your data appear much cleaner by...

• A.

Re-entering the number without the decimals this time.

• B.

Decreasing the font size or the column width.

• C.

Adjusting the number format to display lesser decimal places.

• D.

Deleting the numbers after the decimal point.

C. Adjusting the number format to display lesser decimal places.
Explanation
To make the data appear cleaner and remove distractions caused by too many decimal places, the recommended solution is to adjust the number format to display lesser decimal places. This can be done by rounding or truncating the decimal values to a desired number of decimal places, providing a more concise representation of the data.

Rate this question:

• 18.

### The Paste Special function allows you to do a lot of things, such as ________________. Check all that apply.

• A.

Paste values without any formatting

• B.

Paste cell formulas instead of values

• C.

Keep source formatting

• D.

Skip blanks and transpose copied text

A. Paste values without any formatting
B. Paste cell formulas instead of values
C. Keep source formatting
D. Skip blanks and transpose copied text
Explanation
The Paste Special function allows you to paste values without any formatting, paste cell formulas instead of values, keep source formatting, and skip blanks and transpose copied text. This means that you can choose to copy and paste only the values of the cells without any formatting, or you can paste the formulas of the cells instead of their values. Additionally, you can choose to keep the formatting of the source cells when pasting, and you can also skip any blank cells and transpose the copied text.

Rate this question:

• 19.

### Conditional Formatting is used to _____________. Choose the best answer.

• A.

• B.

Change font sizes and colors.

• C.

Highlight cells if conditions are met.

• D.

C. Highlight cells if conditions are met.
Explanation
Conditional Formatting is a feature in spreadsheet software that allows users to apply formatting to cells based on specified conditions. It is commonly used to highlight cells if certain conditions are met, such as when a value is above or below a certain threshold, or when a cell contains specific text or a formula evaluates to true. This helps users visually identify and analyze data that meets specific criteria, making it easier to interpret and understand the information presented in the worksheet.

Rate this question:

• 20.

### What is an absolute cell reference?

• A.

A cell reference without any special formatting.

• B.

A fixed cell reference.

• C.

A reference that automatically changes when a formula gets dragged down a column or across a row.

B. A fixed cell reference.
Explanation
An absolute cell reference is a fixed cell reference that does not change when a formula is copied or dragged to other cells. It is denoted by a dollar sign (\$) before the column letter and row number. This type of reference is useful when you want to keep a specific cell constant in a formula, such as when calculating a percentage based on a fixed value.

Rate this question:

• 21.

### Which of the following characters CANNOT be used in an Excel formula?

• A.

An equal sign (=)

• B.

A comma (,)

• C.

An ampersand (&)

• D.

None of the above

D. None of the above
Explanation
In Excel, all of the characters listed (equal sign, comma, and ampersand) can be used in a formula. The equal sign is used to indicate the start of a formula, the comma is used to separate arguments in a function, and the ampersand is used for concatenation of text. Therefore, none of the above characters cannot be used in an Excel formula.

Rate this question:

• 22.

### If your mouse suddenly stopped working and you needed to change the contents of the highlighted cell, which key should you press?

• A.

F1

• B.

F2

• C.

F3

• D.

None. I'd get another mouse!

B. F2
Explanation
Pressing the F2 key is the correct answer because it is the key commonly used to enter edit mode in many applications, including spreadsheet software like Microsoft Excel. When the mouse stops working, pressing F2 allows you to directly edit the contents of the highlighted cell without the need for mouse input.

Rate this question:

• 23.

### You are editing a worksheet that has been previously saved. If you want to save the edited worksheet without losing the original one, which command in the Office Menu should you click?

• A.

Save

• B.

Save As

• C.

Prepare

• D.

Publish

B. Save As
Explanation
If you want to save the edited worksheet without losing the original one, you should click on the "Save As" command in the Office Menu. This command allows you to save the edited worksheet with a different name or in a different location, while keeping the original worksheet intact. By selecting "Save As", you can create a new version of the worksheet without overwriting the original file.

Rate this question:

• 24.

### If you wish to show the current date in your worksheet without having to update it every time you access the file, what formula would you use?

• A.

=DATETODAY()

• B.

=TODAY()

• C.

=[systemdate]

• D.

=[datevalue]

B. =TODAY()
Explanation
The correct answer is =TODAY(). This formula is used to display the current date in a worksheet without the need to manually update it. The TODAY() function automatically returns the current date based on the system date and time settings of the computer. This ensures that the date is always up to date whenever the file is accessed.

Rate this question:

• 25.

### You can select multiple non-adjacent ranges by holding the __________ while selecting the cells.

• A.

ALT key

• B.

CTRL key

• C.

SHIFT key

• D.

ESC key

B. CTRL key
Explanation
To select multiple non-adjacent ranges of cells, you can hold down the CTRL key while selecting the cells. This key allows you to choose individual cells or ranges that are not next to each other. By holding down CTRL and clicking on different cells, you can create a selection of multiple non-adjacent ranges.

Rate this question:

• 26.

### A function inside another function is called a _ _ _ _ _ _ function.

nested
Nested
Explanation
A function inside another function is called a nested function. The term "nested" refers to the fact that the inner function is enclosed or nested within the outer function. This allows the inner function to access variables and parameters from the outer function, creating a hierarchical relationship between the two functions. The use of nested functions can help organize code and improve modularity by encapsulating related functionality within a single scope. The term "Nested" is capitalized to indicate that it is a proper noun and specifically refers to this concept in programming.

Rate this question:

• 27.

### Which icon should you click to increase a number's decimal places?

• A.
• B.
• C.
A.
Explanation
To increase a number's decimal places, you should click on the "Increase Decimal" icon. This icon is typically represented by a plus sign (+) or an arrow pointing towards the right. Clicking on this icon will add additional decimal places to the number, allowing for more precise calculations or measurements.

Rate this question:

• 28.

### Excel does not display zeroes (0) if it's the first digit of a number (e.g. mobile phone number). What is the quickest way to prevent the program from doing so?

• A.

Put the prefix access code in a parenthesis. e.g. (0917)1234567

• B.

Go to Format Cells. On the Number tab, choose Text.

• C.

Place a single quotation mark (') before the zero. e.g. '09171234567

• D.

Why bother with the mobile number when you can just enter the home phone number without the area code? Problem solved!

C. Place a single quotation mark (') before the zero. e.g. '09171234567
Explanation
Placing a single quotation mark before the zero in the mobile phone number will force Excel to treat the number as text, preventing it from removing the leading zero. This is a quick and effective way to ensure that Excel displays the complete mobile phone number without omitting the leading zero.

Rate this question:

• 29.

### You have a wide array of data and you wanted to count the number of cells that are not empty. Which function would you use to get this done?

• A.

COUNT

• B.

COUNTA

• C.

COUNTIF

• D.

None of the above. I'd be counting them myself.

B. COUNTA
Explanation
The correct answer is COUNTA. This function is used in Excel to count the number of cells in a range that are not empty. It counts both text and numerical values, as well as cells that contain formulas. Therefore, COUNTA is the appropriate function to use when you want to count the number of non-empty cells in a dataset.

Rate this question:

• 30.

### If your text is too long and you don't want your data to visually spill over to the adjacent cell, which alignment tab function would you use to do this?

• A.

Wrap Text

• B.

Merge & Center

• C.

Merge Across

• D.

Decrease Indent

A. Wrap Text
Explanation
The correct answer is Wrap Text. This function allows the text to wrap within a cell, preventing it from spilling over to adjacent cells. It is useful when the text is too long to fit within a single cell and you want to display all the text without resizing the column width. By enabling Wrap Text, the text will automatically wrap to the next line within the cell, maintaining the cell's original size.

Rate this question:

• 31.

### Which of these statements best describes what a Pivot Table can do?

• A.

It gives extra details on tables.

• B.

• C.

It is an efficient tool that quickly rearranges your data to meet your varying needs.

• D.

It doesn't do anything. It is an annoying feature that serves no purpose at all.

C. It is an efficient tool that quickly rearranges your data to meet your varying needs.
Explanation
A Pivot Table is an efficient tool that quickly rearranges data to meet varying needs. It allows users to summarize and analyze large amounts of data in a flexible and dynamic way. By organizing data into a compact and customizable format, Pivot Tables enable users to easily identify patterns, trends, and relationships within the data. This tool enhances data analysis and reporting capabilities, making it a valuable feature for data manipulation and decision-making purposes.

Rate this question:

• 32.

### Why would you graph your data?

• A.

To organize my data in columns and rows.

• B.

To show trends and relationships across a number of data points.

• C.

To make my spreadsheet look aesthetically appealing.

• D.

Because I was told to do so...

B. To show trends and relationships across a number of data points.
Explanation
Graphing data allows for a visual representation of trends and relationships across multiple data points. It helps to identify patterns, compare different variables, and make data analysis easier. By presenting data in a graphical format, it becomes easier to understand and interpret the information. Graphs also provide a clear and concise way to communicate findings to others.

Rate this question:

• 33.

### True or False. You've created a line chart and then you realized that it'd be better to present your data using a bar graph. To do this, you must delete the first one and create a second chart.

• A.

True! Excel only allows you to create one chart per data source. You really need to decide which chart to use before graphing your data.

• B.

False! You don't need to create a new one.

B. False! You don't need to create a new one.
Explanation
The given answer explains that it is false that you need to create a new chart. This is because in Excel, you can easily change the chart type of an existing chart without having to delete it and create a new one. Therefore, you can simply change the line chart to a bar graph without any need for creating a second chart.

Rate this question:

• 34.

### When a worksheet is printed, the grid lines that surround the cells are printed as well.

• A.

Right! You have to color the entire spreadsheet white to make the lines invisible.

• B.

No they're not!

B. No they're not!
Explanation
The given answer "No they're not!" is correct because when a worksheet is printed, the grid lines that surround the cells are not printed by default. To make the lines invisible, you would need to color the entire spreadsheet white.

Rate this question:

• 35.

### You have just finished encoding a long list of names in the Master Gradebook when you realized that you entered them in lowercase. What would be the quickest way to capitalize all the text?

• A.

I would retype them as Excel doesn't have a workaround for this.

• B.

I'd simply change the font style.

• C.

I'd use a formula for this.

• D.

I wouldn't do anything.

C. I'd use a formula for this.
Explanation
The quickest way to capitalize all the text would be to use a formula in Excel. By using a formula, you can easily convert all the lowercase text to uppercase without the need to manually retype or change the font style. This would save time and effort in correcting the mistake.

Rate this question:

• 36.

### The Merge Cells function also combines the contents of the merged cells.

• A.

I know! Such an amazing feature, right?!

• B.

I beg to differ.

B. I beg to differ.
Explanation
The given statement contradicts the initial claim that the Merge Cells function combines the contents of the merged cells. The person expressing their disagreement is implying that they have a different opinion or perspective on the matter.

Rate this question:

• 37.

### Which of the following allows you to check the grammar and spelling of the text in your spreadsheet?

• A.

F1

• B.

F4

• C.

F7

• D.

C. F7
Explanation
F7 is the correct answer because it is the keyboard shortcut in most spreadsheet programs, including Microsoft Excel, to check the grammar and spelling of the text in the spreadsheet. By pressing F7, the software will run a spell check and highlight any errors or inconsistencies in the text, allowing the user to correct them.

Rate this question:

• 38.

### What does this icon (fx) do? Check all that apply.

• A.

Clicking it opens the Insert Function box where you could choose formulas from several categories.

• B.

It opens your active formula in the Functions Argument box.

• C.

It helps you find simple errors in your formula.

• D.

A. Clicking it opens the Insert Function box where you could choose formulas from several categories.
B. It opens your active formula in the Functions Argument box.
C. It helps you find simple errors in your formula.
Explanation
The icon (fx) in Microsoft Excel is used to open the Insert Function box, where users can choose formulas from various categories. It also opens the active formula in the Functions Argument box, allowing users to modify or review the formula. Additionally, it helps users find simple errors in their formulas.

Rate this question:

• 39.

### C2 has the following formula : = IF(B2="YES","DONE","PENDING"). If B2 = "NO", what value will C2 return?

• A.

#NAME?

• B.

#DIV/0!

• C.

PENDING

• D.

DONE

C. PENDING
Explanation
The formula in C2 states that if B2 is equal to "YES", then the value in C2 should be "DONE". However, if B2 is not equal to "YES", then the value in C2 should be "PENDING". In this case, B2 is equal to "NO", so the value in C2 will be "PENDING".

Rate this question:

• 40.

### What is the maximum number of rows can a single MS Excel 2007 worksheet hold?

• A.

65,536

• B.

256

• C.

Over a million

• D.

Excel has an infinite number of rows.