Rohan is making an Excel sheet for his boss Rupa. However, Rupa is visually impaired and uses a screen reader to read his data sheet. What are the various ways in which he can make it easy for her comprehension? Here are a few things that he can do to make his sheet blind-friendly. Alt …
Aanchal discovered the ‘SmartArt Graphic’ option in Excel recently and she confused it with Charts. What is the difference between the two? While Charts can be used to depict numerical data in an eye-catching manner, SmartArt Graphics can be used to represent textual information attractively. The various SmartArt Graphics available are: List Process Cycle Hierarchy …
As Excel is primarily used for recording numerical data, it is often necessary to insert charts for clarity of information. Inserting charts in Excel is an easy procedure. The options available for it are as follows Bar Chart Hierarchy Chart Waterfall or Stock Chart Line Chart Statistic Chart Combo Chart Pie and Doughnut Chart Scatter …
Dipti is entering details about her college classmates in an Excel spreadsheet. This includes details like age, native, parents’ names etc. She then notices that one of her classmates is from Yemen. She gets curious and wants to know more about it. How will she do this? Rohan tells her that ‘Smart Lookup’ is the …
One of the most attractive features of Excel is the way it can compute data without human assistance. If the formula has been entered properly, then Excel will work with this formula for you until you change it otherwise. Some of the basic operations that can be carried out in Excel are Addition Subtraction Multiplication …
Working with Basic Functions and Formulas in MS Excel Read More »