wgu spreadsheet Study Guide With Practical Exam Advanced Answers All Correct/2024.

Cell addresses - correct answer Cells are referenced by addresses made from their column letter and row number To Edit a Cell's Content - correct answer Select the cell andclick the Formula Bar,or double-click the cell. Edit the cell contentsand press Enter To Clear a Cell's Content - correct answer Select the cell(s) and press the Delete key To Insert a Column or Row - correct answer 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 - correct answer 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 - correct answer 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 - correct answer Precede the cell references with a $ sign or press F4 after selecting cell(s) to make it absolute To Create a Chart - correct answer 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 - correct answer 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 - correct answer 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 To Format Values - correct answer Use the commands in the Number group on the Home tab, or click the Dialog Box Launcher in the Number group to open the Format Cells dialog box. To Apply a Cell Style - correct answer Select the cell(s) you want to apply a cell style to. Click the Cell Styles button in the Styles group of the Home tab on the Ribbon and select a style from the gallery To Format a Cell Range as a Table - correct answer Select the cells you want to apply table formatting to. Click the Format as Table button in the Styles group of the Home tab on the Ribbon and select a table format from the gallery To Apply a Document Theme - correct answer Click the Page Layouttab on the Ribbon, click the Themes button in the Themes group, and select a theme from the gallery To Apply Conditional Formatting - correct answer Select the cells to which you want to apply conditional formatting. Click the Conditional Formatting button in the Styles group of the Home tab.Select the formatting scheme you wish to use, then set the conditions in the dialog box To Adjust Column Widthor Row Height - correct answer Drag the right border of the column header, or the bottom border of the row header. Double-click the border to AutoFit the column or row according to its contents. To Rename a Worksheet: - correct answer Double-click the sheet tab, enter a new name for the worksheet, and press Enter To Split a Window - correct answer Click the View tab and click the Split button in the Window group. Or, press Alt+ WS (one at a time). To Freeze Panes - correct answer Place the cell pointer where you want to freeze the window, click the View tabon the Ribbon, click the Freeze Panes button in the Window group, and select an option from the list To Select a Print Area - correct answer Select the cell range you want to print, click the Page Layouttabon the Ribbon, click the Print Area button in the Page Setup group, and select Set Print Area To Protect or Share a Workbook - correct answer Click the Review tab on the Ribbon and use the commands in the Changes group Insert Images - correct answer ClickInsert menu, choosePicture then either Clip Art or From File Insert Date - correct answer Insert menu then choose Date and Time Insert Comments - correct answer Position insertion point where Comment will go. ClickInsert menu, choose Insert Commen Auto calculate: Use your mouse to view calculation results ( what can you see) - correct answer Auto Calculate lets you see SUM, MIN, MAX, COUNT, COUNTA and AVERAGE results. View→Page Layout View - correct answer Puts the worksheet into Page Layout view, showing the page breaks, margins, and rulers View→Page Break Preview - correct answer Puts the worksheet into Page Break Preview, showing pages breaks that you can adjust View→Gridlines - correct answer Hides and redisplays the row and column gridlines that form the cells in the Worksheet area View→Freeze Panes - correct answer Opens the Freeze Panes drop-down menu, where you select how to freeze rows and columns in the Worksheet area: Freeze Panes (to freeze all the rows above and columns to the left of the cell cursor); Freeze Top Row; or Freeze First Column View→Split - correct answer Splits the worksheet into four panes using the top and left edge of the cell cursor as the vertical and horizontal dividing lines — press hot keys again to remove all panes View→View Side by Side - correct answer Tiles two open windows or workbooks one above the other for comparison — press the hot keys again to restore the original full windows Formulas→AutoSum→Sum - correct answer Selects the occupied range above the cell cursor and inserts SUM formula to total the range Formulas→AutoSum→Average - correct answer Selects the occupied range above the cell cursor and inserts AVERAGE formula