NUR 354 2 COMPREHENSIVE STUDY
GUIDE 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
◍ AVERAGE.
Answer: A function that calculates the simple average of a dataset.
◍ Absolute Reference.
Answer: A cell reference that stays fixed when a formula is copied from one
cell to another.
◍ Accounting.
Answer: An option in the Number Format drop-down menu that defines a
number as money with the appropriate monetary symbol and two decimal
places. The user does not have as many ways to format negative numbers as
the Currency option.
◍ Algorithm.
Answer: The part of a calculation that is applied to the measure. Example:
average revenue.
◍ Alignment.
Answer: The way values in a cell are positioned.
◍ Area Chart.
Answer: A type of chart that combines a line chart and a bar chart to show
changes in quantities over time. Area charts display the height of each
category in relation to the height of the other categories.
◍ Argument.
Answer: The information that a function requires to perform the intended
calculation.
, ◍ Average.
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
◍ Bar Chart.
Answer: A type of chart that presents data with horizontal bars.
◍ Bold.
Answer: A feature in the Font group that thickens and darkens the font face,
making it stand out.
◍ Borders.
Answer: An icon in the Font group of the Home menu that, when selected,
gives multiple options to add lines, or "borders," to one or more sides of a
cell.
◍ COUNT.
Answer: A function that counts the number of numbers in a dataset.
◍ COUNTA.
Answer: A function that counts the number of cells that have values, i.e.,
non-blank cells.
◍ Calculated Column.
Answer: A column in an Excel table in which a calculation is created in any
of the cells and then automatically applied to all the cells in that column.
◍ Category.
Answer: An element within a dataset that is used to classify non-numerical
values.
◍ Cell.
Answer: A small box that stores an individual piece of data or a calculation
in a worksheet.
◍ Centering.
Answer: Aligning values in the center of a cell.
GUIDE 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+
◍ AVERAGE.
Answer: A function that calculates the simple average of a dataset.
◍ Absolute Reference.
Answer: A cell reference that stays fixed when a formula is copied from one
cell to another.
◍ Accounting.
Answer: An option in the Number Format drop-down menu that defines a
number as money with the appropriate monetary symbol and two decimal
places. The user does not have as many ways to format negative numbers as
the Currency option.
◍ Algorithm.
Answer: The part of a calculation that is applied to the measure. Example:
average revenue.
◍ Alignment.
Answer: The way values in a cell are positioned.
◍ Area Chart.
Answer: A type of chart that combines a line chart and a bar chart to show
changes in quantities over time. Area charts display the height of each
category in relation to the height of the other categories.
◍ Argument.
Answer: The information that a function requires to perform the intended
calculation.
, ◍ Average.
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
◍ Bar Chart.
Answer: A type of chart that presents data with horizontal bars.
◍ Bold.
Answer: A feature in the Font group that thickens and darkens the font face,
making it stand out.
◍ Borders.
Answer: An icon in the Font group of the Home menu that, when selected,
gives multiple options to add lines, or "borders," to one or more sides of a
cell.
◍ COUNT.
Answer: A function that counts the number of numbers in a dataset.
◍ COUNTA.
Answer: A function that counts the number of cells that have values, i.e.,
non-blank cells.
◍ Calculated Column.
Answer: A column in an Excel table in which a calculation is created in any
of the cells and then automatically applied to all the cells in that column.
◍ Category.
Answer: An element within a dataset that is used to classify non-numerical
values.
◍ Cell.
Answer: A small box that stores an individual piece of data or a calculation
in a worksheet.
◍ Centering.
Answer: Aligning values in the center of a cell.
