DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
to build strong analytical thinking.
|
|
to calculate with accuracy.
|
|
how data is visualized.
|
|
None of the above
|
Detailed explanation-1: -Humans can learn faster from visualizations than from reading and trying to understand large data sets. The confusion inherent to report tables, formulas, and calculations created in Excel are also eliminated.
Detailed explanation-2: -The main goal of data visualization is to make it easier to identify patterns, trends and outliers in large data sets. The term is often used interchangeably with others, including information graphics, information visualization and statistical graphics.
Detailed explanation-3: -Select “insert” from the main menu and choose the type of chart or graph you’d like to create. Once you’ve made your selection, the visualization will automatically appear in your spreadsheet. Right-click on the chart or graph to edit details, such as the title, axes labels, and colors.
Detailed explanation-4: -MS Excel makes it easy to identify and analyse patterns in your data spreading up to one million rows and 16, 000 columns. The conditional formatting options in MS Excel helps to change the formatting of a cell, based on the information contained.