Excel 2007 Engr 112 Quiz
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
Correct Answer
B. Cell rangeExplanation
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
Correct Answer
A. A prewritten formulaExplanation
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.
Correct Answer
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
Correct Answer
C. Cell A10 and A20Explanation
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
Correct Answer
B. RelativeExplanation
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
Correct Answer
B. =C5*$D$9Explanation
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.
Correct Answer
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.
Correct Answer
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
Correct Answer
B. FalseExplanation
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.
Add the labels manually.
- B.
Change the chart style.
- C.
Change the chart layout.
Correct Answer
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:
-
Back to top