# Spreadsheet Formulas And Functions Quiz #3

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 Havroncl21
H
Havroncl21
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,852
Questions: 15 | Attempts: 1,781

Settings

Spreadsheet Formulas and Functions Quiz #3 from Atomic learning exercises

• 1.

### You do not need to take the time to create a formula for specific set of cells you can use the ________ __________ to do it for you.

• A.

Auto Fix

• B.

Auto Calculate

• C.

Auto Default

• D.

Sum

B. Auto Calculate
Explanation
The correct answer is "Auto Calculate." This feature allows you to automatically calculate the values in a set of cells without having to create a specific formula. It saves time and effort by performing the calculations for you, making it easier to work with large sets of data.

Rate this question:

• 2.

### The Auto Calculate can be changed to display different features/ functions.

• A.

True

• B.

False

A. True
Explanation
The statement is true because the Auto Calculate feature in a program or software can be customized to display various features or functions. This means that users have the flexibility to choose what specific calculations or functions they want the Auto Calculate feature to perform, allowing for a more personalized and tailored experience.

Rate this question:

• 3.

### Creating formulas in Excel begin with using what symbol?

• A.

*

• B.

-

• C.

+

• D.

=

D. =
Explanation
In Excel, formulas are created using the equal (=) symbol. This symbol is used to indicate that the following characters or values are part of a formula and should be calculated accordingly. By starting a cell entry with the equal symbol, Excel recognizes it as a formula and performs the necessary calculations based on the given expression.

Rate this question:

• 4.

### Each cell address is colored differently.

• A.

True

• B.

False

A. True
Explanation
The explanation for the given correct answer is that each cell address being colored differently is a true statement. This means that in a spreadsheet or any other document where cell addresses are used, each address is assigned a different color. This can be helpful for visually distinguishing between different cells and making it easier to navigate and understand the document.

Rate this question:

• 5.

### By using the cell name, such as C4, you do not have to go back into a formula and make changes when your information is changed or updated.

• A.

True

• B.

False

A. True
Explanation
Using cell names, such as C4, allows for easier updating and editing of formulas. Instead of manually changing the formula every time the information is updated or changed, you can simply update the value in the referenced cell. This saves time and reduces the chances of making errors in the formula. Therefore, the statement is true.

Rate this question:

• 6.

• A.

Set up a cell

• B.

Set up a formula

• C.

Set up a number

• D.

B. Set up a formula
Explanation
The function wizard is a tool in spreadsheet software that assists users in setting up complex formulas. It provides a step-by-step guide, allowing users to select the desired function, specify the necessary arguments, and preview the results. By using the function wizard, users can easily create accurate and efficient formulas without the need for manual input or extensive knowledge of formula syntax. Therefore, the function wizard helps users set up formulas in their spreadsheets.

Rate this question:

• 7.

### Expanding and collasping the function dialoge box allows you to easily select the cell you wish to enter into your formula.

• A.

True

• B.

False

A. True
Explanation
Expanding and collapsing the function dialogue box allows for easy selection of the desired cell to be entered into a formula. This suggests that the statement is true, as this functionality would indeed make it easier to select the desired cell.

Rate this question:

• 8.

### If there is an error in your formula, Excel will not identify the error.

• A.

True

• B.

False

B. False
Explanation
If there is an error in your formula, Excel will identify the error. This means that if there is any mistake or incorrect syntax in the formula, Excel will highlight it and show an error message. Therefore, the statement "If there is an error in your formula, Excel will not identify the error" is false.

Rate this question:

• 9.

### What would a formula look like?

• A.

2.38+3.588.25

• B.

(C12:B12)

• C.

=3.65+ (3.65*0.03)

• D.

*A9+B9+C9=

C. =3.65+ (3.65*0.03)
Explanation
The given answer is a formula that calculates the sum of 3.65 and the product of 3.65 and 0.03. The formula is correctly written with the equal sign at the beginning, followed by the arithmetic operations. The parentheses are used to indicate the order of operations, ensuring that the multiplication is performed before addition. The formula does not include the values from cells A9, B9, and C9, as indicated by the equal sign at the end.

Rate this question:

• 10.

### You can copy and auto fill in a formula. This is called?

• A.

Referencing

• B.

Auto Formatting

B. Auto Formatting
Explanation
Auto Formatting is the correct answer because it refers to the feature that allows users to copy and automatically fill in a formula. This feature automatically adjusts the cell references in the formula as it is copied to different cells, making it easier and more efficient to perform calculations across multiple cells or ranges. Auto Formatting is a time-saving feature that helps streamline data entry and calculation tasks in spreadsheet applications.

Rate this question:

• 11.

### There is no way to set a cell in a formula so that it will not change when using the Auto Fill.

• A.

True

• B.

False

B. False
Explanation
The statement is false because it is possible to set a cell in a formula so that it will not change when using the Auto Fill. This can be done by using absolute cell references. By adding a dollar sign (\$) before the column letter and row number of the cell reference, the reference will remain fixed when the formula is copied or filled to other cells.

Rate this question:

• 12.

### What icon appears when you are about to Auto Fill

• A.

Black plus sign

• B.

White plus sign

• C.

Question mark

• D.

Hand

A. Black plus sign
Explanation
The black plus sign is the correct answer because it is the icon that typically appears when you are about to Auto Fill. The plus sign indicates that you are adding or filling in information, and the black color is a common design choice for this type of icon.

Rate this question:

• 13.

### What is added to the formula to create an absolute reference?

• A.

?

• B.

&

• C.

\$

• D.

#

C. \$
Explanation
To create an absolute reference in a formula, the dollar sign (\$) is added. This is done by placing the dollar sign in front of both the column letter and the row number in the cell reference. By adding the dollar sign, the reference becomes fixed and does not change when the formula is copied to other cells. This allows the formula to always refer to the specific cell, regardless of its position relative to the formula.

Rate this question:

• 14.

### An example of a formula that includes and absolute reference look like?

• A.

=C12+D12+E12

• B.

=C12*D12*E12

• C.

=C12+\$B12\$

• D.

=C12= B12=D12

C. =C12+\$B12\$
Explanation
The correct answer is "=C12+\$B12\$". This formula includes an absolute reference by using the dollar sign (\$) before the row and column references. The dollar sign makes sure that the reference does not change when the formula is copied to other cells. In this case, the reference to cell C12 is absolute, while the reference to cell B12 is relative, meaning it will change based on the position of the formula when copied to other cells.

Rate this question:

• 15.

### What could you do to add an absolute reference?

• A.

Add dollar signs around the cell

• B.

Click F4

• C.

All of the Above

• D.

None of the ones listed

C. All of the Above
Explanation
To add an absolute reference in Excel, you can either add dollar signs around the cell or click F4. Both methods achieve the same result of creating an absolute reference. Therefore, the correct answer is "All of the Above" as both options are valid ways to add an absolute reference.

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
• Jan 07, 2013
Quiz Created by
Havroncl21

Related Topics