Excel Unit 3

Excel Task

• • Create a formula using absolute cell reference

  • Create a formula using the IF function

  • Rotate cell content to an exact value

  • Edit placeholder text in a chart element

  • Add a chart element

  • Add a chart element at a specific location

  • Add axis titles to a chart

  • Change text direction of an axis title

  • Split a worksheet into panes

  • Freeze columns and rows

  • Remove worksheet panes

  • Unfreeze columns and rows

  • Insert a sparkline

  • Insert a chart using the Recommended Chart button

  • Move worksheets

  • Zoom a worksheet

  • Use Goal Seek

  • Italicize cell content

  • Apply a sparkline style

  • Enter a number containing format symbols

  • Enter a series of values using Autofill

  • Use the Format Painter

  • Copy and paste using a Paste option

  • Indent cell contents

  • Delete a chart element

  • Move a chart element

  • Group and Ungroup worksheets

  • Insert a row