ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
Sp
ne
when you click a chart, you will see two additional tabs (____ and ___)
la
for working with the chart
sh
Sp
a. layout tab and formula tab
ne
b. view tab and design tab
la
tz
sh
c. design tab and format tab
Sp
ne
d. formulas tab and format tab - ANSWER--c. design tab and format tab
la
sh
Sp
tiny charts embedded in a cell that display a visual trend summary
ne
alongside your data are called ___.
la
tz
sh
a. data markers
Sp
ne
b. data labels
la
c. sparklines
sh
Sp
d. data series - ANSWER--c. sparklines
ne
la
tz
sh
Sp
T/F: the formula bar displays the value or formula in the active cell. -
ne
ANSWER--true
la
sh
Sp
the ___ function counts the number of cells within a range that meet the
ne
criteria entered.
a
tz
l
sh
a. sum
Sp
ne
b. if
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
c. countif
Sp
ne
d. median - ANSWER--c. countif
la
sh
Sp
ne
T/F: when a new column is inserted into a worksheet, the remaining
columns move to the right. - ANSWER--true
la
tz
sh
Sp
ne
the countif function has two arguments ___.
la
a. a value as the criteria and an average of a range of cells
sh
Sp
b. the range of cells to sum and the criteria
ne
la
c. the range of cells to check and the criteria
tz
sh
Sp
d. the range of cells to check and the sum of the range - ANSWER--c.
ne
the range of cells to check and the criteria
la
sh
Sp
where do sheet tabs display in a workbook?
ne
la
a. under the ribbon
tz
sh
Sp
b. lower area of the workbook window
ne
c. on the status bar
la
d. on the right side of the workbook window - ANSWER--b. lower area
sh
Sp
of the workbook window
ne
a
tz
l
sh
Sp
the median function finds ___.
ne
a. the average value in a range of cells
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
b. the one number that corresponds to an argument in the function
Sp
ne
c. all numbers that correspond to an argument in the function
la
d. the middle value in a range of cells - ANSWER--d. the middle value
sh
Sp
in a range of cells
ne
la
tz
sh
which of the following excel features recognizes a pattern in the data of
Sp
ne
a worksheet?
la
a. if function
sh
Sp
b. countif function
ne
c. find and replace
la
tz
sh
d. flash fill - ANSWER--d. flash fill
Sp
ne
la
in a conditional format, we use ___ to represent the value of a cell
sh
relative to other cells
Sp
ne
a. excel table
la
tz
b. data bar sh
Sp
ne
c. filter
la
d. sparkline - ANSWER--b. data bar
sh
Sp
ne
a
we can group multiple worksheets by right-clicking on the sheet tab, and
tz
l
sh
then click ___ on the shortcut menu.
Sp
ne
a. tab color
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
la|ALREADY GRADED A+
tz
sh
b. select all sheets
Sp
ne
c. grouping
la
d. protect sheet - ANSWER--b. select all sheets
sh
Sp
ne
la
T/F: you can sort a table in ascending or descending order. - ANSWER--
tz
sh
true
Sp
ne
la
what are the default names of worksheets?
sh
Sp
a. sheet1, sheet2, etc.
ne
la
b. worksheet1, worksheet2, etc.
tz
sh
Sp
c. 1, 2, 3, etc.
ne
d. excel 1, excel 2, etc - ANSWER--a. sheet1, sheet2, etc.
la
sh
Sp
ne
if you edit data in a worksheet that is associated with a pie chart, ___.
la
tz
a. the pie slices will be automatically updated sh
Sp
b. the pie slices must be manually updated
ne
la
c. a new second pie chart must be created
sh
d. an error message will display - ANSWER--a. the pie slices will be
Sp
ne
automatically updated
a
tz
l
sh
Sp
which symbol represents that a cell is an absolute cell reference in a
ne
function or formula?
la
sh
Sp
la
Sp
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
Sp
ne
when you click a chart, you will see two additional tabs (____ and ___)
la
for working with the chart
sh
Sp
a. layout tab and formula tab
ne
b. view tab and design tab
la
tz
sh
c. design tab and format tab
Sp
ne
d. formulas tab and format tab - ANSWER--c. design tab and format tab
la
sh
Sp
tiny charts embedded in a cell that display a visual trend summary
ne
alongside your data are called ___.
la
tz
sh
a. data markers
Sp
ne
b. data labels
la
c. sparklines
sh
Sp
d. data series - ANSWER--c. sparklines
ne
la
tz
sh
Sp
T/F: the formula bar displays the value or formula in the active cell. -
ne
ANSWER--true
la
sh
Sp
the ___ function counts the number of cells within a range that meet the
ne
criteria entered.
a
tz
l
sh
a. sum
Sp
ne
b. if
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
c. countif
Sp
ne
d. median - ANSWER--c. countif
la
sh
Sp
ne
T/F: when a new column is inserted into a worksheet, the remaining
columns move to the right. - ANSWER--true
la
tz
sh
Sp
ne
the countif function has two arguments ___.
la
a. a value as the criteria and an average of a range of cells
sh
Sp
b. the range of cells to sum and the criteria
ne
la
c. the range of cells to check and the criteria
tz
sh
Sp
d. the range of cells to check and the sum of the range - ANSWER--c.
ne
the range of cells to check and the criteria
la
sh
Sp
where do sheet tabs display in a workbook?
ne
la
a. under the ribbon
tz
sh
Sp
b. lower area of the workbook window
ne
c. on the status bar
la
d. on the right side of the workbook window - ANSWER--b. lower area
sh
Sp
of the workbook window
ne
a
tz
l
sh
Sp
the median function finds ___.
ne
a. the average value in a range of cells
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
|ALREADY GRADED A+la
tz
sh
b. the one number that corresponds to an argument in the function
Sp
ne
c. all numbers that correspond to an argument in the function
la
d. the middle value in a range of cells - ANSWER--d. the middle value
sh
Sp
in a range of cells
ne
la
tz
sh
which of the following excel features recognizes a pattern in the data of
Sp
ne
a worksheet?
la
a. if function
sh
Sp
b. countif function
ne
c. find and replace
la
tz
sh
d. flash fill - ANSWER--d. flash fill
Sp
ne
la
in a conditional format, we use ___ to represent the value of a cell
sh
relative to other cells
Sp
ne
a. excel table
la
tz
b. data bar sh
Sp
ne
c. filter
la
d. sparkline - ANSWER--b. data bar
sh
Sp
ne
a
we can group multiple worksheets by right-clicking on the sheet tab, and
tz
l
sh
then click ___ on the shortcut menu.
Sp
ne
a. tab color
la
sh
Sp
la
Sp
, ne
SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
sh
200 QUESTIONS AND CORRECT DETAILED ANSWERS
ne
la|ALREADY GRADED A+
tz
sh
b. select all sheets
Sp
ne
c. grouping
la
d. protect sheet - ANSWER--b. select all sheets
sh
Sp
ne
la
T/F: you can sort a table in ascending or descending order. - ANSWER--
tz
sh
true
Sp
ne
la
what are the default names of worksheets?
sh
Sp
a. sheet1, sheet2, etc.
ne
la
b. worksheet1, worksheet2, etc.
tz
sh
Sp
c. 1, 2, 3, etc.
ne
d. excel 1, excel 2, etc - ANSWER--a. sheet1, sheet2, etc.
la
sh
Sp
ne
if you edit data in a worksheet that is associated with a pie chart, ___.
la
tz
a. the pie slices will be automatically updated sh
Sp
b. the pie slices must be manually updated
ne
la
c. a new second pie chart must be created
sh
d. an error message will display - ANSWER--a. the pie slices will be
Sp
ne
automatically updated
a
tz
l
sh
Sp
which symbol represents that a cell is an absolute cell reference in a
ne
function or formula?
la
sh
Sp
la
Sp
