Excel 2016 All-in-One For Dummies. Harvey Greg

Чтение книги онлайн.

      ✔ File tab: When clicked, this tab opens the Backstage view, which contains a bunch of file-related options including Info, New, Open, Save, Save As, Print, Share, Export, Publish, Close, and Account, as well as Options, which enables you to change Excel’s default settings.

      ✔ Quick Access toolbar: You can click the Save, Undo, and Redo buttons to perform common tasks to save your work and undo and redo editing changes. You can also click the Customize Quick Access Toolbar button to the immediate right of the Redo button to open a drop-down menu containing additional common commands such as New, Open, Quick Print, and so on, as well as to customize the toolbar, change its position, and minimize the Ribbon.

      ✔ Ribbon: Most Excel commands are contained on the Ribbon. They are arranged into a series of tabs ranging from Home through View.

      ✔ Formula bar: This displays the address of the current cell along with the contents of that cell.

      ✔ Worksheet area: This area contains all the cells of the current worksheet identified by column headings, which use letters along the top, and row headings, which use numbers along the left edge, with tabs for selecting new worksheets. You use a horizontal scroll bar on the bottom to move left and right through the sheet and a vertical scroll bar on the right edge to move up and down through the sheet.

      ✔ Status bar: This bar keeps you informed of the program’s current mode and any special keys you engage, and it enables you to select a new worksheet view and to zoom in and out on the worksheet.

       When using Excel 2016 on a touchscreen device, the Ribbon Display Options are automatically set to Tabs (so that associated commands appear only when you tap a tab) and the Quick Access toolbar contains a Touch/Mouse Mode button. Tap this button followed by the Touch option on its drop-down menu to spread out the tabs and their command buttons on the Ribbon. That way you have a fighting chance of correctly selecting them with your finger or stylus. On a touchscreen tablet such as the Microsoft Surface 3 tablet, an Ink Tools tab where you can modify settings for using a stylus follows the View tab.

       At first glance, the File menu button may appear to you like a Ribbon tab – especially in light of its rectangular shape and location immediately left of the Ribbon’s initial Home tab. Keep in mind, however, that this important file control is technically a command button that, when clicked, leads directly to a totally new, nonworksheet screen with the Backstage view. This screen has its own menu options but contains no Ribbon command buttons whatsoever.

       After you click the File menu button to switch to the Backstage view, you can then select the Back button (with the left-pointing arrow) that appears above the Info menu item to return to the normal worksheet view or you can simply press the Esc key.