Excel 2007 Engr 112 Quiz
11 Questions
| Total Attempts: 129
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.
A Basic Microsoft excel quiz! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it...
Questions: 20 | Attempts: 100541 | Last updated: Jul 27, 2021
-
Sample QuestionA fast way to add up this column of numbers is to click on the cell below the numbers and then:
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: 61338 | Last updated: May 30, 2021
-
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: 59571 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Back to top