Essential Excel 2016: A Step-by-Step Guide

Index

A

1. Absolute cell references

   1. AutoFill handle

   2. cell address

2. Account group

3. Adding and removing worksheets

   1. available templates

   2. insert dialog box

   3. new sheet button

4. Alignment group

   1. buttons

   2. Home Tab

   3. indentation of text

   4. merging and unmerging cells

   5. rotating text

   6. Shrink to fit

   7. text wrapping

   8. vertical and horizontal

   9. worksheet, students information

5. American Standard Code of Information Interchange (ASCII)

6. AND function

   1. logical conditions

   2. nesting, IF function

   3. return FALSE

   4. syntax

   5. tool tip

7. Arrange Windows dialog box

8. Audio file

9. AutoCalculate Tools feature

   1. AutoSum feature

      1. AutoSum button

      2. Ctrl key

      3. handling blank cells

      4. location

      5. summing, rows and columns

   2. Average, Count Numbers, Max(imum), Min(imum)

      1. AutoFill Handle

      2. auto functions

      3. cell styles

      4. more button

      5. thick outside border

      6. wrap text

      7. wrong range

10. AutoComplete ...