A workbook (as previously explained here) actually is an Excel file that contains many objects with their specific functions (Fig. 1).
One important change in Ribbon that doesn’t seem to be too obvious is the presence of dialog launcher. Ribbon interface with all those tab pages may provide user with all necessary commands for regular activities, such as formatting text in bold, changing lettercase, and so on. But there are also moments when specific, yet detailed commands need to be applied. This used to be handled through menu-driven interface – usually by the Format menu – but since the advent of Ribbon Interface all those instructions are “hidden” inside dialog launcher.
Compared to earlier versions with their menu-driven interface, Excel 2007 has a very different look-and-feel user interface, called Ribbon. Ribbon is actually a series of tabbed pages, each relates to a different activity type. For an example, if a user clicked the Insert tab, then he/she will be presented with an activity “group” pertaining to inserting and modifying an object. These tabs are probably the first thing that a user notices upon opening Excel.
This tutorial will basically explain how to start an Excel session and quit it. Just keep in mind that “Excel” here refers to Microsoft Excel 2007. I would like to assume that Excel had been installed on your computer, be it on your laptop or desktop PC, with a typical or standard configuration. No additional setup. I’d safely assume that you run Excel under Windows Vista or Windows 7 environment. UV2HACYCKDZB
This blog entry is submitted to VLOOKUP Week
Converting color bands to the equivalent resistance value is a good example of how table lookup function can be employed. Anyone can pick a separate color for every band through a drop-down list (built from data validation facility) and Excel matches color selected to the reference table, counts and displays the resistance value. As a visual aid of the band and the corresponding color, a table containing both information should be used.