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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!