WGU C268 SPREADSHEETS EXAM PREASSESSMENT
AND OBJECTIVE ASSESSMENT 2025 | ACCURATE
AND VERIFIED EXAM QUESTIONS AND ANSWERS
workbook - (ANSWER)file that stores all the information. Must contain at least
one worksheet
worksheet - (ANSWER)contains the actual data and calculations
cells - (ANSWER)store individual pieces of data and calculations. addressed via
column letter and row number
referencing cell - (ANSWER)using values stored in another cell of a worksheet
fill - (ANSWER)automatically populate cells in a worksheet
home, editing
hide & unhide - (ANSWER)home, cells, format
freeze panes - (ANSWER)lock rows and columns so they don't disappear when
navigating. freezes column directly to the left and directly above the selected cell.
view, window
format painter - (ANSWER)home, clipboard, format painter
, filter - (ANSWER)data, sort & filter
relative cell references - (ANSWER)references that AUTOMATICALLY update when
a formal is pasted to a new cell
C1
absolute cell references - (ANSWER)a cell reference that REMAINS constant when
a formula is pasted into a new cell
C$1
$ symbol in front of the part of the reference that we wish to remain constant
when a formula is pasted into a new cell
function wizard - (ANSWER)function argument
=
=COUNT - (ANSWER)counts the number of cells in a range of cells that contain
numbers. Does not include blank cells or cells with non-numeric values
=COUNTA - (ANSWER)counts the number of cells in a range of cells that are NOT
blank. Differentiates between blank cells and those with any type of data
=AVERAGE - (ANSWER)calculates the simple average of a set of numbers
AND OBJECTIVE ASSESSMENT 2025 | ACCURATE
AND VERIFIED EXAM QUESTIONS AND ANSWERS
workbook - (ANSWER)file that stores all the information. Must contain at least
one worksheet
worksheet - (ANSWER)contains the actual data and calculations
cells - (ANSWER)store individual pieces of data and calculations. addressed via
column letter and row number
referencing cell - (ANSWER)using values stored in another cell of a worksheet
fill - (ANSWER)automatically populate cells in a worksheet
home, editing
hide & unhide - (ANSWER)home, cells, format
freeze panes - (ANSWER)lock rows and columns so they don't disappear when
navigating. freezes column directly to the left and directly above the selected cell.
view, window
format painter - (ANSWER)home, clipboard, format painter
, filter - (ANSWER)data, sort & filter
relative cell references - (ANSWER)references that AUTOMATICALLY update when
a formal is pasted to a new cell
C1
absolute cell references - (ANSWER)a cell reference that REMAINS constant when
a formula is pasted into a new cell
C$1
$ symbol in front of the part of the reference that we wish to remain constant
when a formula is pasted into a new cell
function wizard - (ANSWER)function argument
=
=COUNT - (ANSWER)counts the number of cells in a range of cells that contain
numbers. Does not include blank cells or cells with non-numeric values
=COUNTA - (ANSWER)counts the number of cells in a range of cells that are NOT
blank. Differentiates between blank cells and those with any type of data
=AVERAGE - (ANSWER)calculates the simple average of a set of numbers
