WGU C268 STUDY GUIDE FOR EXCEL PA FULL
SOLUTION STUDY GUIDE
◉ Auto Fill.
Answer: a quick and easy way to copy the contents of one cell (data
or formulas) into another cell or range of cells
◉ Average Function.
Answer: an excel function that adds a group of values, and then
divides the result by the number of values in the group.
◉ Bar chart.
Answer: A graphic display of numbers as bars horizontally on a
graph
◉ Cell.
Answer: A single box in a spreadsheet containing text, a numeric
value, a formula, or left empty. Intersection of a row and a column
◉ Cell Reference.
Answer: The column letter and the row number. Example: B12
, ◉ Name box or Cell Reference Box.
Answer: identifies the active cell or range of cells selected
◉ Chart or Graph.
Answer: a visual representation of a set of data values
◉ Clip art.
Answer: Electronic artwork available on the computer.
◉ Column.
Answer: A vertical stack of cells in a table or worksheet.
◉ Column Chart.
Answer: a chart that uses bars of varying height to illustrate values
in a worksheet
◉ Embedded chart.
Answer: A chart that is added to an active worksheet
◉ Fill handle.
SOLUTION STUDY GUIDE
◉ Auto Fill.
Answer: a quick and easy way to copy the contents of one cell (data
or formulas) into another cell or range of cells
◉ Average Function.
Answer: an excel function that adds a group of values, and then
divides the result by the number of values in the group.
◉ Bar chart.
Answer: A graphic display of numbers as bars horizontally on a
graph
◉ Cell.
Answer: A single box in a spreadsheet containing text, a numeric
value, a formula, or left empty. Intersection of a row and a column
◉ Cell Reference.
Answer: The column letter and the row number. Example: B12
, ◉ Name box or Cell Reference Box.
Answer: identifies the active cell or range of cells selected
◉ Chart or Graph.
Answer: a visual representation of a set of data values
◉ Clip art.
Answer: Electronic artwork available on the computer.
◉ Column.
Answer: A vertical stack of cells in a table or worksheet.
◉ Column Chart.
Answer: a chart that uses bars of varying height to illustrate values
in a worksheet
◉ Embedded chart.
Answer: A chart that is added to an active worksheet
◉ Fill handle.