Question: Question 1 Each correct multiple choice question will be graded 1 mark: (i) A formula in Excel begins with a(n): a. *. b. $. c.
| Question 1 | Each correct multiple choice question will be graded 1 mark: | |||||||
| (i) A formula in Excel begins with a(n): | ||||||||
| a. *. | ||||||||
| b. $. | ||||||||
| c. =. | ||||||||
| d. /. | ||||||||
| Answer | ||||||||
| (ii) The types of cell referencing available in Excel are mixed, absolute, and: | ||||||||
| A. relative. | ||||||||
| B. stationery. | ||||||||
| C. abstract. | ||||||||
| pragmatic | ||||||||
| Answer | ||||||||
| (iii) To copy a formula across a range of cells and have the formula automatically update thecell row and column, use ---------- cell referencing | ||||||||
| A. absolute | ||||||||
| B. mixed | ||||||||
| C. relative | ||||||||
| D. abstract | ||||||||
| Answer | ||||||||
| (iv) If you have formula that must always reference Column A but the row needs to adjust as you copy your formula, you want to use a(n)-------- cell reference. | ||||||||
| A. abstract | ||||||||
| B. relative | ||||||||
| C. mixed | ||||||||
| D. absolute | ||||||||
| Answer | ||||||||
| (v) =$E2+$C3-G$4 is an example of a formula using __________ cell references. | ||||||||
| A. absolute | ||||||||
| B. mixed | ||||||||
| C. relative | ||||||||
| D. constant | ||||||||
| Answer | ||||||||
| (vi) __________ are used to make difficult computations easier to calculate. | ||||||||
| A. Functions | ||||||||
| B. Styles | ||||||||
| C. Algorithms | ||||||||
| D. Features | ||||||||
| Answer | ||||||||
| (vii) To add numeric entries quickly in Excel, use the __________ function. | ||||||||
| A. financial | ||||||||
| B. count | ||||||||
| C. sum | ||||||||
| D. text | ||||||||
| Answer | ||||||||
| (viii) B5:C10 is an example of a cell: | ||||||||
| A. location. | ||||||||
| B. range. | ||||||||
| C. style. | ||||||||
| D. macro. | ||||||||
| Answer | ||||||||
| (ix) To find the smallest number in a range of cells, use the ___________ function. | ||||||||
| A. min | ||||||||
| B. max | ||||||||
| C. average | ||||||||
| D. low | ||||||||
| Answer | ||||||||
| (x) To determine the middle number in a range of cells, use the __________ function. | ||||||||
| A. max | ||||||||
| B. count | ||||||||
| C. average | ||||||||
| D. median | ||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
