WGU C268 STUDY GUIDE FOR EXCEL PA COMPLETE ASSESSMENT WITH CORRECT ANSWERS

WGU C268 STUDY GUIDE FOR EXCEL PA
COMPLETE ASSESSMENT WITH CORRECT
ANSWERS

◉ 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.


◉ Chart.
Answer: A visual depiction of a dataset.


◉ Chart Data Range.
Answer: An element in the Chart dialog window that defines the
range of values of a worksheet that contain data for a chart.


◉ Column.
Answer: A stack of cells arranged vertically from the top to the
bottom of a worksheet.


◉ Column Chart.
Answer: A type of chart that presents data with vertical bars.


◉ Column Headings.
Answer: The first row in a dataset that contains labels describing the
information in the dataset.