B. These are print options. You can change the margin for printing, whether you want a vertical or horizontal print alignment, which cells in your sheet you want to print, where youd like page breaks, and whether it has a background (to place your company name, for example). You can also start giving each page a heading using the Print Titles button, and the order to print each section.
E. Search Bar: Simply type the value you want to find to highlight all cells containing that value. It doesnt have to be an exact match. For instance, if you searched for “o,” a cell labeled “Dogs” would appear among your search results.
D. Use these tools to create charts and graphs. Most of them work only if you select one or more data sets (numbers only, with words for headers or categories). Charts and graphs function like youd expect _ just select the data you want to visualize, then select your desired type of visual (bar charts, scatter plots, pie charts, or line graphs). Creating one will bring up formatting options where you can change the color, labels, and more.
The Formulas tab stores nearly everything related to Excels reputation as “complex.” Because this article is intended for beginners, we wont cover every function is this section thoroughly.