Excel 2016 Introduction

Lesson – Exploring Excel

Excel 2016

Steps

Practice Data

1. Select the File tab .

Click File tab

The File menu appears.

2. Click Options .

Click

The Excel Options dialog box is displayed.

3. Select the desired category from the left-hand pane in the Excel Options dialog box. The options for the selected category appear in the right-hand pane of the dialog box. 4. Select or deselect options in the right- hand pane, as desired. The desired options are enabled or disabled accordingly.

Click Advanced

Deselect Show Paste Options button when content is pasted in the Cut, copy, and paste section

5. Select OK .

Click

Your preferences are confirmed and the Excel Options dialog box closes.

Practice the Concept: Open Excel Options and select Show Paste Options buttons.

W ORKING WITH W ORKSHEETS  D ISCUSSION

Information in Excel is stored in a Workbook . The first new workbook opened in a session is called Book1 . A workbook is a collection of individual Worksheets . Each worksheet has a name that appears in a Worksheet Tab at the bottom of the workbook window. By default, these names appear as Sheet1 , Sheet2 , Sheet3 , and so on. You can change the default names, if desired.

Worksheets in a workbook are usually related to one another. For example, a company budget could have 13 worksheets, one for each month of the year and one representing the total year. These 13 worksheets can all be stored in one workbook as a single file and then accessed as one unit.

A worksheet is a grid composed of columns and rows. The first 26 columns are labeled column A through column Z. Columns 27 through 52 are labeled column AA through column AZ. Column 53 through 78 are labeled column BA through column BZ and so on. This pattern continues until

Page 10

OFFICEPRO, Inc.