UNIT4 DB4

The container for Excel spreadsheets - the grid where numbers , text and formulas reside and calculations are performed - is a called a workbook with a default name of Book1 .xls . When Excel is started a new workbook is created and displays a blank worksheet . Within Excel we can create a new workbook from scratch , use a template that defines a design for a workbook , or open an existing workbook and modify it

Data is the core of Excel , yet before we can calculate data , chart it analyze it , and otherwise use it , we have

to place it on a worksheet Data comes in several forms - such as numbers , text , dates , and times - and Excel handles the entry of each form uniquely . After we enter data into Excel 's worksheets , we might want to make changes or verify accuracy , so Excel offers automatic tools to assist us along the way

In an Excel worksheet , text is used to identify , explain , and emphasize numeric data . It comprises characters that cannot be used in calculations . We enter text by typing just as we would in a word processing program . Numbers are numerical data , from the simplest to the most complex . Excel provides several features to help us more easily work with numbers used to represent values in various categories , such as currency , accounting , and mathematics . Besides that Excel lets us easily perform powerful calculations using formulas and functions Formulas are mathematical statements that follow a set of rules and use a specific syntax

An Excel worksheet is a matrix , or grid , of lettered column headers across its top and numbered row headers down its side . The first row of a typical worksheet is used for column headings . The column headings represent categories of similar data . The rows beneath a column heading contain data further categorized by a row heading along the leftmost column , or listed below the column heading . Worksheets can also be used to set up databases , where columns are referred to as fields and each row represents a unique record of data

A workbook is an entire Excel . Each workbook contains worksheets Workbook supplies a stack of worksheet pages . To flip through these pages , we can use the sheet tabs , which appear to the left of the horizontal scroll bar . We just click a tab to move a particular worksheet to the top of the stack . There are usual and popular items in the workbook window , but there are a few more hidden features . The vertical split box and horizontal split box split the workbook window into two chunks , or panes , which we can scroll independently . By splitting a window into panes , we can view and compare nonadjacent portions of the workbook . To use either the vertical or horizontal split box , drag the split box up and down or left and right (To remove a split , we drag the split box back to its original position

The Tab split box lets us change the number of sheet tabs that...