Excel 2016 Introduction

Excel 2016

Lesson – Exploring Excel

Steps

Practice Data

11. Select the OK button.

Click

The Excel Options dialog box closes and the changes you have made are displayed in the Quick Access Toolbar . 12. To remove a command from the Quick Access Toolbar , select the More arrow on the right of the Quick Access Toolbar . The Customize Quick Access Toolbar menu is displayed.

Click

13. Select More Commands from the menu.

Click More Commands

The Excel Options dialog box opens with the Customize category selected.

14. In the right-hand list in the dialog box, select the command you wish to remove. The selected command is highlighted in the list.

Click AutoSum

15. Select the Remove button.

Click

The selected command is removed from the list.

16. Select the OK button.

Click

The Excel Options dialog box closes and the command is removed from the Quick Access Toolbar .

U SING THE M INI T OOLBAR  D ISCUSSION

When you right-click a cell or range of selected cells, the Mini toolbar and a Shortcut Menu appear beside the mouse pointer. The Mini toolbar contains a selection of popular formatting command buttons so that you do not have to move away from the cell to format it.

When you select text in an inserted object such as a Shape , SmartArt or Chart , the Mini toolbar automatically appears as a faint outline above and to the right of the selected text. If you move the mouse pointer towards the Mini toolbar, it fades in and can be used to format the selected text. If you move the mouse pointer away from the Mini toolbar, it fades away.

OFFICEPRO, Inc.

Page 21