admin@kcseforecast.com

+2541026301456

Spreadsheets

Spreadsheets

Continued

Excel Window

  • The Quick Access Toolbar (QAT) - provides a faster access to commands. 
  • By default, the Quick Access Toolbar contains the Save, Undo, and Redo command buttons in addition to the Customize Quick Access Toolbar button.
  • You can add or remove command buttons on the Quick Access Toolbar to help you quickly perform common tasks.
  1. Title bar – contains the name of the workbook and  the name of the software
  2. Microsoft Office Excel Help button – used to access Excel Help.
  3. Minimize Window button – minimizes the current workbook to a title bar icon inside the Excel window.
  4. Restore Window button – restores the active workbook to a smaller window inside the Excel window.
  5. Close Window button – closes the active workbook.
  1. Scroll bars – vertical and horizontal scroll bars used to change the vertical or horizontal view of worksheet areas
  2. Status bar – a customizable bar below the worksheet area that is used to display various messages, the View Toolbar, the Zoom button and the Zoom Slider.
  3. View Shortcuts – contains view command buttons used to change the view of the active worksheet
  4. Zoom button – a command button used to change the magnification or “zoom” of the worksheet view
  5. Zoom Slider – a slide control used to change the magnification of “zoom” of the worksheet view
  • The Ribbon contains a series of grouped command buttons organized around specific tasks. 
  • There are 3 parts to the ribbon – tabs, groups and commands.
  1. Tab – designed to be task oriented.
  2. Tab group – divides a task into subtasks
  3. Command – carries out a command operation or displays a command menu.

 

  1. The Name Box- shows the cell reference of the active cell in the worksheet.
  2. The Formula Bar- shows the contents of the active cell. 
  1. Column Headers - are the letters only at the top of the worksheet.
  2. Row Headers - are the numbers on the left side of each row of the worksheet.
  3. Active Cell - is the currently selected cell, displayed with a thick black border around the cell.
  4. Status bar-provides a message area, for example the Caps Lock or Num Lock “on” warning message, in addition to displaying the View Shortcuts, the Zoom command button, and the Zoom Slider.
  5. Sheet Tabs –
  • Identify the current worksheet.
  • Used to navigate from one worksheet to another.

Navigating in a Worksheet

  • You can use the mouse pointer to navigate from one cell to another, thereby making the destination cell the active cell. 

Keyboard shortcuts for navigating in a worksheet

Excel Data Types

Labels

Any text and alphanumeric data

Used to make worksheet data more readable.

Text 

Any text and alphanumeric data

Cannot be manipulated mathematically

Numbers

Numerical values that can be manipulated mathematically

Date

Calendar values

Time

Time values

Formula

User defined mathematical expression

Function 

Excel inbuilt mathematical/text operations