SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
,SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
b. the pie slices must be manually updated
c. a new second pie chart must be created
d. an error message will display - ANSWER--a. the pie slices will be
automatically updated
which symbol represents that a cell is an absolute cell reference in a
function or formula?
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
,SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
, SPREADSHEET MODELLING FINAL EXAM ACTUAL EXAM
200 QUESTIONS AND CORRECT DETAILED ANSWERS
|ALREADY GRADED A+
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
b. the pie slices must be manually updated
c. a new second pie chart must be created
d. an error message will display - ANSWER--a. the pie slices will be
automatically updated
which symbol represents that a cell is an absolute cell reference in a
function or formula?
