Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started