SPREADSHEET MODELLING FINAL EXAM QUESTIONS AND ANSWERS 2025

SPREADSHEET LATEST
MODELLING FINAL
EXAM
ANSWER ALL QUESTIONS IN THIS SECTION



QUESTION 1



which of the following displays trends over time?

a. line chart

b. pie chart

c. what-if analysis

d. an axis - ANSWER-a. line chart



in goal seek, you enter the specific value that you want to achieve in the box.

a. goal seek dialog

b. set cell

c. by changing cell

d. to value - ANSWER-d. to value



T/F: the y-axis of a chart is also referred to as the category axis - ANSWER-false



A in a pie chart identifies the pie slices.

END OF
PAGE 1

, SPREADSHEET LATEST
MODELLING FINAL
EXAM
a. data series



b. data label

c. data market

d. data point - ANSWER-b. data label



in a lookup formula, the defined range is referred to as the .

a. named range

b. validation list

c. defined name

d. table array - ANSWER-d. table array



a method to find a specific value for a cell by adjusting the value of one other cell
is .

a. goal seek

b. validation

c. protection

d. look up - ANSWER-a. goal seek




END OF
PAGE 2

, SPREADSHEET LATEST
MODELLING FINAL
EXAM
we can define a name to represent a range of cells in the .

a. cell range



b. validation list

c. table array

d. name box - ANSWER-d. name box



in a cell that contains a function, to copy the VALUE to another to cell-- rather
than the function-- use the .

a. paste command

b. format painter command

c. pasta special command

d. paste link command - ANSWER-c. paste special command



T/F: present value represents the amount of the loan before any payments are
made. - ANSWER-true



T/F: you cannot insert new data into a named range -

ANSWER-false


END OF
PAGE 3