# Excel 2007 Engr 112 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 Makanzel
M
Makanzel
Community Contributor
Quizzes Created: 1 | Total Attempts: 165
Questions: 11 | Attempts: 165

Settings

Quiz for ENGR 112 on microsoft excel.

• 1.

### What is the correct cell entry for the following scenario (no spaces):You wish to add cell c46 and d53.

Explanation
You may either use the + sign or the sum command.

Rate this question:

• 2.

### The colon (:) in B3:B6 indicates a ______ in column B, rows 3 through 6.

• A.

Cell argument

• B.

Cell range

• C.

Cell reference

B. Cell range
Explanation
The colon (:) in B3:B6 indicates a range of cells in column B, specifically rows 3 through 6. It is used to specify a continuous set of cells in a column or row.

Rate this question:

• 3.

### What is a function?

• A.

A prewritten formula

• B.

A math operator

A. A prewritten formula
Explanation
Functions are prewritten formulas, such as SUM, that save time.

Rate this question:

• 4.

### A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

• A.

Click in cell C6, and then press CTRL+SHIFT.

• B.

Click in cell C6, and then press F5.

• C.

Click in cell C6.

C. Click in cell C6.
Explanation
To see the formula result in cell C6, you need to click on cell C6.

Rate this question:

• 5.

### Cell reference A10,A20 refers to values in:

• A.

The range of cells in column A and rows 10 through 20

• B.

The range of cells in columns A through E and rows 10 through 20

• C.

Cell A10 and A20

C. Cell A10 and A20
Explanation
The cell reference A10, A20 refers to specific cells in a spreadsheet. It means that the values being referred to are located in cell A10 and cell A20.

Rate this question:

• 6.

### Cell references are __________ by default.

• A.

Absolute

• B.

Relative

B. Relative
Explanation
Cell references are relative by default. This means that when a formula or function is copied to another cell, the reference to other cells will adjust accordingly. For example, if a formula in cell A1 references cell B1, when the formula is copied to cell A2, the reference will automatically change to B2. This allows for easy replication of formulas across multiple cells without having to manually adjust each reference.

Rate this question:

• 7.

### If you copy the formula =C4*\$D\$9 from cell C4 to cell C5, what will the formula be in cell C5?

• A.

=C4*\$D\$9

• B.

=C5*\$D\$9

• C.

=C5*\$E\$10

B. =C5*\$D\$9
Explanation
As the formula is copied, the relative cell reference, C4, changes to C5. The absolute cell reference, \$D\$9, does not change; it remains the same in each row it is copied to.

Rate this question:

• 8.

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

• A.

The column is not wide enough to display the content.

• B.

The cell reference is not valid.

• C.

You have misspelled a function name or used a name that Excel doesn't recognize.

A. The column is not wide enough to display the content.
Explanation
This answer is correct because when ##### is displayed in a cell, it means that the column width is not wide enough to display the content. This typically happens when the content in the cell is too long or when the cell contains a date or time value that is not formatted properly. To fix this issue, the column width can be adjusted to make it wider or the content can be shortened.

Rate this question:

• 9.

### You create a chart. But later on you don't see the Chart Tools. What do you do to get them back?

• A.

Create another chart.

• B.

Click inside the chart.

• C.

Click the Insert tab.

B. Click inside the chart.
Explanation
Once you click inside the existing chart, the Chart Tools will be at hand with three tabs: Design, Layout, and Format.

Rate this question:

• 10.

### You can't change the chart type after you create a chart.

• A.

True

• B.

False

B. False
Explanation
The statement "You can't change the chart type after you create a chart" is false. In most charting software, including popular programs like Microsoft Excel, you have the ability to change the chart type even after creating a chart. This flexibility allows users to experiment with different visual representations of their data and choose the one that best suits their needs.

Rate this question:

• 11.

### You want to add data labels above each column to show a value for each column. How can you do this? (You learned this in the practice.)

• A.

• B.

Change the chart style.

• C.

Change the chart layout.

C. Change the chart layout.
Explanation
Layout 2 will add a data label above each column that shows a value for each.

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 21, 2023
Quiz Edited by
ProProfs Editorial Team
• Nov 12, 2009
Quiz Created by
Makanzel

Related Topics