Spreadsheets are grid_based files designed to organize information and perform calculations with scalable entries. People all around the world use spreadsheets to create tables for any personal or business need.
D. Multi_cell Formatting Features: This section contains two very important features that solve common problems for new Excel users. The first is Wrap Text. Normally, when you enter text into a cell that extends beyond the size of the cell, it spills into the next cell. For example, if you type “Budgeted Items” into A1, some of the word “Items” spills into B1. Then, if you type into B1, you cover up any characters from A1 that extended into B1. The extra text from cell A1 still exists, but now it is hidden. If you dont want to widen the cells, click the Wrap Text icon on A1 _ this will split “Budgeted Items” into two stacked lines instead of one within A1. This makes the entire row taller to accommodate the content. Now, typing into B1 wont cover up existing text.
Sort & Filter tools let you choose what to display, and in what order. At the base level, this tool sorts cells containing text from A to Z, and cells containing numbers from lowest to highest. It can also sort by color or icon. Sorting and filtering helps surface only the data you need.
G. Viewability Options: The left icon is Normal which shows the worksheet as it appears in the image above, and the right icon is Page Layout, which divides your worksheet into pages resembling how it would look when printed, with the option to add headers. The slider with the “_” and “+” on it is for scale or zoom_level. Drag the slider left or right to zoom in or out.