J. This section lets you insert Equations and Symbols. Use equations to write a math equation with fractions, variables, and more that you can place in your sheet like a Text Box. For instance, this can be helpful for explaining how a portion of a table was calculated in a report. Symbols, on the other hand, can be inserted directly into cells, and include all non_standard characters from most languages, as well as emojis.
B. This section lets you insert visual elements, like picture files, pre_built shapes, and SmartArt. You can add shapes and resize, recolor, and reposition them to create intuitive data sets and reports. SmartArt objects are prebuilt diagrams that you can insert text and information into. Theyre great for representing what the data says in another place on your workbook.
One powerful Excel feature is Macro, little scripts and recordings you can create to make the program perform different actions automatically. While no other spreadsheet program has this type of feature, it is complex and can pose difficulty for beginners.
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.