wgu spreadsheet
Cell addresses - ANS-Cells are referenced by
addresses made from their column letter
and row number
To Edit a Cell's Content - ANS-Select the cell andclick the Formula Bar,or double-click
the cell. Edit the cell contentsand press
Enter
To Clear a Cell's Content - ANS-Select the cell(s) and press the Delete key
To Insert a Column or Row - ANS-Right-click to the right of the column,or below the row
you want to insert. Select Insertfrom the contextual menu, or click the Insertbutton
in the Cells group on the Home tab
To Insert a Commen - ANS-Select the cell where you want to insert a comment
and click the Reviewtabon the Ribbon. Click the New Comment buttonin the Comments
group. Type a comment and click outside the comment box
To Total a Cell Range - ANS-Click the cell where you want to insert the total and
click the Sum button in the Editing group on the Home tab. Verify the selected cell range
and click the Sum button again
To Create an Absolute Cell Reference - ANS-Precede the cell references with a $ sign
or press
F4 after selecting cell(s) to make it absolute
To Create a Chart - ANS-Select the cell range that contains the data you want to chart
and click the Insert tab on the Ribbon. Click a chart type button in the Charts group and
select the chart you want to use from the list
To Insert a Sparkline - ANS-Select the cell range that contains the data you want to
chart and click the Insert tab on the Ribbon.
Select the sparkline you want to insert from the Sparkline group. Select the cell or cell
range where you want to add the sparkline and click OK
To Format Text - ANS-Use the commands in the Font group on the Home tab, or click
the Dialog Box Launcher in the Font group to open the dialog box
Cell addresses - ANS-Cells are referenced by
addresses made from their column letter
and row number
To Edit a Cell's Content - ANS-Select the cell andclick the Formula Bar,or double-click
the cell. Edit the cell contentsand press
Enter
To Clear a Cell's Content - ANS-Select the cell(s) and press the Delete key
To Insert a Column or Row - ANS-Right-click to the right of the column,or below the row
you want to insert. Select Insertfrom the contextual menu, or click the Insertbutton
in the Cells group on the Home tab
To Insert a Commen - ANS-Select the cell where you want to insert a comment
and click the Reviewtabon the Ribbon. Click the New Comment buttonin the Comments
group. Type a comment and click outside the comment box
To Total a Cell Range - ANS-Click the cell where you want to insert the total and
click the Sum button in the Editing group on the Home tab. Verify the selected cell range
and click the Sum button again
To Create an Absolute Cell Reference - ANS-Precede the cell references with a $ sign
or press
F4 after selecting cell(s) to make it absolute
To Create a Chart - ANS-Select the cell range that contains the data you want to chart
and click the Insert tab on the Ribbon. Click a chart type button in the Charts group and
select the chart you want to use from the list
To Insert a Sparkline - ANS-Select the cell range that contains the data you want to
chart and click the Insert tab on the Ribbon.
Select the sparkline you want to insert from the Sparkline group. Select the cell or cell
range where you want to add the sparkline and click OK
To Format Text - ANS-Use the commands in the Font group on the Home tab, or click
the Dialog Box Launcher in the Font group to open the dialog box
