SPREADSHEET MODELLING FINAL EXAM 2026 200 QUESTIONS AND

SPREADSHEET MODELLING FINAL EXAM 2026 200 QUESTIONS AND ( ANSWERS)

SPREADSHEET MODELLING FINAL EXAM

2026 200 QUESTIONS

AND CORRECT DETAILED ANSWERS WITH

RATIONALES ( ANSWERS)

when you click a chart, you will see two additional tabs (____

and ___) for working with the chart

a. layout tab and formula tab

b. view tab and design tab

c. design tab and format tab

d. formulas tab and format tab - ANSWER- c. design tab and

format tab

tiny charts embedded in a cell that display a visual trend

summary alongside your data are called ___.

a. data markers

b. data labels

c. sparklines

d. data series - ANSWER- c. sparklines

T/F: the formula bar displays the value or formula in the active

cell. - ANSWER- true

the ___ function counts the number of cells within a range that

meet the criteria entered.

a. sum

b. if

c. countif

d. median - ANSWER- c. countif

T/F: when a new column is inserted into a worksheet, the

remaining columns move to the right. - ANSWER- true

the countif function has two arguments ___.

a. a value as the criteria and an average of a range of cells

b. the range of cells to sum and the criteria

c. the range of cells to check and the criteria

d. the range of cells to check and the sum of the range -

ANSWER- c. the range of cells to check and the criteria

where do sheet tabs display in a workbook?

a. under the ribbon

b. lower area of the workbook window

c. on the status bar

d. on the right side of the workbook window - ANSWER- b.

lower area of the workbook window

the median function finds ___.

a. the average value in a range of cells

b. the one number that corresponds to an argument in the

function

c. all numbers that correspond to an argument in the function

d. the middle value in a range of cells - ANSWER- d. the middle

value in a range of cells

which of the following excel features recognizes a pattern in the

data of a worksheet?

a. if function

b. countif function

c. find and replace

d. flash fill - ANSWER- d. flash fill

in a conditional format, we use ___ to represent the value of a

cell relative to other cells

a. excel table

b. data bar

c. filter

d. sparkline - ANSWER- b. data bar

we can group multiple worksheets by right-clicking on the sheet

tab, and then click ___ on the shortcut menu.

a. tab color

b. select all sheets

c. grouping

d. protect sheet - ANSWER- b. select all sheets

T/F: you can sort a table in ascending or descending order. -

ANSWER- true

what are the default names of worksheets?

a. sheet1, sheet2, etc.

b. worksheet1, worksheet2, etc.

c. 1, 2, 3, etc.

d. excel 1, excel 2, etc - ANSWER- a. sheet1, sheet2, etc.

if you edit data in a worksheet that is associated with a pie chart,

___.

a. the pie slices will be automatically updated