EXCEL SHEET SIDE BY SIDE PASSWORD PROTECT WORKSHEETS

Become familiar with the features in the Excel Help window.MicrosoftВ® Office contains a variety of tools that help people accomplish many personal and professional objectives. In a one-to-many relationship, this table should be on the many side. Become familiar with the Excel workbook.Excel pivot tables allow you to group the spreadsheet or external data source by. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window. In the Compare Side by Side dialog box, click the worksheets that you want to compare.

These computations ultimately convert that quantitative data into information. Making Decisions with ExcelTaking a very simple view, Excel is a tool that allows you to enter quantitative data into an electronic spreadsheet to apply one or many mathematical computations. This chapter provides an overview of the Excel application along with an orientation for accessing the commands and features of an Excel workbook. No matter which career path you choose, you will likely need to use Excel to accomplish your professional objectives, some of which may occur daily.

We will demonstrate how you can use Excel to make these decisions and many more throughout this text.Figure 1.1В shows a completed Excel worksheet that will be constructed in this chapter. With respect to personal decisions, you can use Excel to determine how much money you can spend on a house, how much you can spend on car lease payments, or how much you need to save to reach your retirement goals. For example, employees can use Excel to determine how much inventory to buy for a clothing retailer, how much medication to administer to a patient, or how much money to spend to stay within a budget.

Excel will assign a file name to the workbook, such as Book1, Book2, Book3, and so on, depending on how many new workbooks are opened. AВ workbook is an Excel file that contains one or moreВ worksheetsВ (sometimes referred to asВ spreadsheets). Click the first option вЂњBlank WorkbookвЂќ.Once Excel is started, a blank workbook will open on your screen. Click Microsoft Excel to launch the Excel application and present you with workbook options. Figure 1.1 Example of an Excel Worksheet Starting Excel The worksheet data can help this retailer determine the number of salespeople needed for each month, how much inventory is needed to satisfy sales, and what types of products should be purchased.

If necessary locate the Maximize button as shown in Figure 1.3. Figure 1.2В Blank WorkbookYour workbook should already be maximized (or shown at full size) once Excel is started, as shown in Figure 1.2. Your screen may be slightly different based on the version youвЂ™re using. Take some time to familiarize yourself with this screen.

This would be referred to as cellВ locationВ A1 orВ cellВ referenceВ A1. For example, the cell that is currently activated in Figure 1.3В is A1. Each cellВ in an Excel worksheet contains an address, which is defined by a column letter followed by a row number. The worksheet contains several rectangles called cells for entering numeric and nonnumeric data.

Release the left mouse button. Click and hold the left mouse button and drag the mouse pointer back to cell D5. Figure 1.4 Activating a Cell Location Check to make sure column letter D and row number 5 are highlighted, as shown in Figure 1.4.Note: Your highlighted column letter and row number may be different than figure shown. Place your mouse pointer over cell D5 and left click.

If you only have one sheet, click the вЂњInsert WorksheetвЂќ to add a worksheet. Depending on your version of Excel, you will see either three as displayed above or just one. At the bottom of the screen, youвЂ™ll see worksheets. Figure 1.5 Highlighting a Range of Cells The first cell is the top left corner of the range, and the second cell is the lower right corner of the range. Any two cell locations separated by a colon are known as a cell range.

Click the Sheet1 worksheet tab at the bottom of the worksheet to return to the worksheet shown in Figure 1.5. Add another worksheet so that you now have three sheets displaying here. This is how you open or add a worksheet within a workbook.

Table 1.1 вЂњCommand Overview for Each Tab of the RibbonвЂќВ provides an overview of the commands that are found in each tab of the Ribbon. Figure 1.6В shows the commands available in the Home tab of the Ribbon. Each tab provides access to a different set of Excel commands. Hold the CTRL key while pressing the PAGE DOWN or PAGE UP keys to open other worksheets in a workbook.ExcelвЂ™s features and commands are found in theВ Ribbon, which is the upper area of the Excel screen that contains several tabs running across the top. Hold the SHIFT key and press the arrow keys on your keyboard to highlight a range of cells in a worksheet.

The default settings and options are also found in this tab.Contains the most frequently used Excel commands. Includes print commands, document properties, e-mailing options, and help features. Contains all commands for opening, closing, saving, and creating new Excel workbooks.

Excel Sheet Side By Side Password Protect Worksheets

Common commands include the Zoom and Page Layout view.The Ribbon shown in Figure 1.6В is full, or maximized. Also contains protection features to password protect worksheets or workbooks.Used to adjust the visual appearance of a workbook. Also contains sorting commands and access to scenario tools.Includes Spelling and Track Changes features. Also contains tools for auditing mathematical formulas.Used when working with external data sources such as MicrosoftВ® AccessВ®, text files, or the Internet. Also includes commands used to show and print the gridlines on a worksheet.Includes commands for adding mathematical functions to a worksheet.

Hold down the CTRL key and press the F1 key. When you click on a tab, the command buttons will appear until you select a command or click anywhere on your worksheet. When minimized, the Ribbon will show only the tabs and not the command buttons. If this is the case, you can minimize the Ribbon by clicking the button shown in Figure 1.6. However, depending on the screen dimensions of your computer, you may find that the Ribbon takes up too much vertical space on your worksheet.

If you do not see the command you are looking for on the list, select the More Commands option. This will open a menu of commands that you can add to the Quick Access Toolbar. To customize the Quick Access Toolbar, click the down arrow as shown in Figure 1.7. By placing these commands in the Quick Access Toolbar, you do not have to navigate through the Ribbon to find them. You also can customize the Quick Access Toolbar by adding commands that you use on a regular basis. This area provides access to the most frequently used commands, such as Save and Undo.

To leave the Backstage view and return to the worksheet, click the arrow in the upper left-hand corner as shown below. Figure 1.9В shows the options available in the File tab or Backstage view. It contains a variety of features and commands related to the workbook that is currently open, new workbooks, or workbooks stored in other locations on your computer or network. Figure 1.8В Right-Click Menu The File TabThe File tab is also known as the BackstageВ viewВ of the workbook. Figure 1.8В shows an example of the commands available in the right-click menu.

Figure 1.10В shows the Excel Options window, which gives you access to settings such as the default font style, font size, and the number of worksheets that appear in new workbooks.