Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions