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.
E. Numbers_based Format Settings: A drop_down menu has options for number formatting. For example, currency places everything you select into “Ũᇸ” format, and percent turns Ǒ or ½ into “50%”, date options. These are the basic format options, but you can select More Number Formats from the drop_down menu to get more specialty use cases (different countries currencies, or adding the “(xxx)xxx_xxxx” formatting to phone number sequences). Often, you may use these tools on entire columns to make all data in one category behave the same way.
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.
I. A Text Box is useful when youre creating a report and dont want typed words to behave like cells. It makes it easy to move your text around, rather than cutting and pasting cells (which could potentially mess up the formatting of real data). The next area is for Headers & Footers, which will take you to the page layout view _ here you can add headers and footers for the entire page. WordArt, on the other hand, lets you embellish text. Insert Object lets you place entire files (Word documents, PDFs, etc.) into the worksheet.