Excel 2007 Engr 112 Quiz
11 Questions
| Total Attempts: 141
Quiz for ENGR 112 on microsoft excel.
Questions and Answers
- 1.What is the correct cell entry for the following scenario (no spaces):You wish to add cell c46 and d53.
- 2.The colon (:) in B3:B6 indicates a ______ in column B, rows 3 through 6.
- A.
Cell argument
- B.
Cell range
- C.
Cell reference
- 3.What is a function?
- A.
A prewritten formula
- B.
A math operator
- 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.
- 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
- 6.Cell references are __________ by default.
- A.
Absolute
- B.
Relative
- 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
- 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.
- 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.
- 10.You can't change the chart type after you create a chart.
- A.
True
- B.
False
- 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.
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 73273 | Last updated: Mar 22, 2022
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 62836 | Last updated: Mar 22, 2022
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 46070 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top