Insert An Up Arrow Block Arrow Shape

Question: Use AutoSum to enter a formula in the selected cell to calculate the sum.

Answer: On the Home tab, In editing group, click the AutoSum button. Press Enter.

Question: Cut cell B7 and paste it to cell E12

Answer: On the Home tab, in the clipboard group on the Home tab, click the cut button. Click cell E12, and click the paste button.

Question: Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6

Answer: Type the formulas =SUM(B2:B6) in the cell or the formula bar and press Enter.

Question: Change the font color of the selected cells to the Blue-Gray, Text 2 color.

Answer: On the Home tab, in the Font group, click the Font Color arrow, and select Blue_Gray Text 2

Question: Set the print area so only the selected cells will print.

Answer: Click the Back button. On the page Layout tab, in the Page Setup group, click the Print Area button. Click Set Print Area.

Question: Add a new worksheet to the left of the Dec. 18 sheet

Answer: On the Home tab, in Cells group, click the Insert button arrow, and select Insert Sheet.

Question: Set row 1 to print on every page

Answer: On the Page Layout tab, in the Page Setup group, click the Print Titles button. In the Page Setup dialog, on the Sheet tab, click the Rows to repeat at the top box. Click the row selector for row 1. click OK in the dialog.

Question: Without adjusting the column widths, guarantee that all columns will print on one page.

Answer: On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page.

Question: Use Format Painter to copy the formatting from cell D1 and apply it to cell E1

Answer: On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.

Question: Print this worksheet.

Answer: Click the File tab to open Backstage view. Click Print. Click the Print button.