Computer-Based Business Applications

Part1: Accounting using Excel

2nd Class
 2

Chapter 1

Introduction
1.4 Navigating Excel- Quick Access Toolbar 3

1. Point to each icon on the Quick Access Toolbar and read the description that appears as a
ScreenTip.
2. On the right side of the Quick Access Toolbar, click on the drop-down arrow. From the drop-
down list, select Open. The Open icon is added to the Quick Access Toolbar.
3. Similarly, from the drop-down list, select Quick Print. its icon is added to the Quick Access Toolbar.
4. Now, Right-click the Open command and select Remove from Quick Access Toolbar.
5. Right-click anywhere on the Quick Access Toolbar and then select Show Quick Access Toolbar
Below the Ribbon.
6. Click on the drop-down arrow and click Quick Print to remove the checkmark from the menu and
thus remove the Quick Print icon from the Quick Access Toolbar.
 1.4 Navigating Excel- Formula bar
4

• The Formula bar displays the address and the contents of the active cell.; and is divided into:
1. Name box: The left-most section displays the address of the current/active cell.
2. Formula bar buttons: The second, middle, section appears includes three buttons: the Insert
Function button (labeled fx) on the right which is always active; and Cancel (×) and Enter (√ )
buttons which will be active during you start making or editing a cell entry only.
3. Cell contents: The third white area to the right of the Function Wizard button takes up the rest
of the bar and expands as necessary to display long cell entries that won’t fit in the normal area. it
always shows you the contents of the cell even when the worksheet does not (when you’re dealing
with a formula, Excel displays only the calculated result in the cell in the worksheet and not the
formula by which that result is derived). You can edit the contents of the cell in this area at any time.
 1.4 Navigating Excel- Ribbon
5

• The Ribbon changes the way you work in Excel, which always shows you all the most
commonly used options needed to perform a particular Excel task.
1. Right-click the Home tab (or anywhere on the Ribbon) and click Collapse the
Ribbon. Now, only the tabs remain on display, increasing the workspace area.
2. Right-click the Home tab again (or anywhere on the Ribbon) and choose Collapse
the Ribbon to uncheck the option and make the ribbon commands visible again.
 1.4 Navigating Excel- Ribbon
6

• The Ribbon is made up of the following components:

• Tabs: Excel’s main tasks are brought together and display all the commands commonly
needed to perform that core task.
• Groups: Related command buttons can be organized into subtasks normally performed as
part of the tab’s larger core task.
• Command buttons: Within each group you find command buttons that you can select to
perform a particular action or to open a gallery. Note that many command buttons on
certain tabs of the Excel Ribbon are organized into mini-toolbars with related settings.
• Dialog Box launcher: This button is located in the lower-right corner of certain groups
and opens a dialog box containing additional options you can select.
 1.4 Navigating Excel- Ribbon Tabs
7

• Home tab: involves creating, formatting, and editing a spreadsheet. This tab is
arranged into the Clipboard, Font, Alignment, Number, Styles, Cells, and Editing groups.
• Insert tab: involves adding particular elements (including graphics, PivotTables, charts,
hyperlinks, and headers and footers) to a spreadsheet. This tab is arranged into the Tables,
Illustrations, Add-ins, Charts, Tours, Sparklines, Filter, Links, Text, and Symbols groups.
• Page Layout tab: involves preparing a spreadsheet for printing or reordering
graphics on the sheet. This tab is arranged into the Themes, Page Setup, Scale to Fit,
Sheet Options, and Arrange groups.
 1.4 Navigating Excel- Ribbon Tabs
8

• Formulas tab: involves adding formulas and functions to a spreadsheet or checking a worksheet
for formula errors. it is arranged into the Function Library, Defined Names, Formula Auditing, and
Calculation groups.
• Data tab: involves importing, querying, outlining, and subtotaling the data placed into a worksheet’s
data list. This tab is arranged into the Get & Transform, Connections, Sort & Filter, Data Tools, Forecast,
and Outline groups.
• Review tab: involves proofing, protecting, and marking up a spreadsheet for review by others. This
tab is arranged into the Proofing, Accessibility, Insights, Language, Comments, Protect, and Ink groups.

• View tab: involves changing the display of the Worksheet area and the data it contains. This tab is
arranged into the Workbook Views, Show, Zoom, Window, and Macros groups.
 1.4 Navigating Excel- Status Bar
9

• The Status bar is the lower component at the bottom of the Excel program window. it contains the
following areas:
• Mode: This button indicates the current state of the Excel program (Ready, Enter, Edit, and so on).
• Auto Calculate: This indicator displays the Average and Sum of all the numerical entries in the current
cell selection along with the cells Count in the selection.
• Layout buttons: Three layouts for the Worksheet area: Normal, the default view that shows only the
worksheet cells with the column and row headings; Page Layout View, which adds rulers and page margins
and shows page breaks for the worksheet; and Page Break Preview, which enables you to adjust the paging
of a report.
• Zoom: The Zoom slider enables you to zoom in and out on the cells in the Worksheet area by dragging the
slider to the right or left, respectively.
 1.4 Navigating Excel- Worksheet area
10

There are several ways to move through worksheet. You can use the arrow keys, the scroll bars, or the
mouse to navigate through a worksheet:
1. Press Ctrl + End to move to the end of the worksheet.
2. Press Ctrl + Home to move to the beginning of the worksheet.
3. Click in the Name Box (in the formula bar), type B3, and then press Enter to make the cell
active.
4. Press Ctrl + Down Arrow to go to the last row of data.
5. Press Ctrl + Right Arrow = The last column in the range of data becomes the active cell.
6. Press Ctrl + Down Arrow = The last possible row in the worksheet displays.
7. Use the vertical scroll bar to navigate from the beginning to the end of the data.
8. Roll the wheel button of the mouse forward and back to quickly scroll through the worksheet.
 1.4 Navigating Excel- Worksheet area
11

• To be able to enter or edit data in a cell, that cell must be Active. You can active the cell
through many ways including click on it, type its name in the name box, or move to it
by the keyboard arrows.
• Excel indicates that a cell is Active in three ways: The cell cursor (the dark black border)
appears in the cell; the cell’s address appears in the Name Box; and the cell’s column
letter(s) and row number are shaded.

• In order to enter or edit data in an active cell, you can double-click it.
• After you finish typing, you can press ENTER button to move down, or press Tab button
to move right, or click the Enter (√ ) button on the formula bar to stay in the current cell.