FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ chart that compares two items of information within a Microsoft Excel spreadsheet
A
Pie
B
Column
C
Line
D
All of the above
Explanation: 

Detailed explanation-1: -A comparison chart is a general kind of chart or diagram which shows the comparison of two or more objects or groups of objects. This comparison diagram shows qualitative and/or quantitative information data.

Detailed explanation-2: -Bar chart. Data that is arranged in columns or rows on an Excel sheet can be plotted in a bar chart. Use bar charts to show comparisons among individual items.

Detailed explanation-3: -Bar graphs can help you compare data between different groups or to track changes over time. Bar graphs are most useful when there are big changes or to show how one group compares against other groups.

Detailed explanation-4: -Vertical bar charts – Also called a column chart. It represents the numerical values represented in the vertical bars. These are used mainly to display age ranges and salary ranges. Grouped bar charts – Grouped bar charts represent the different time period numbers that belong to a single category.

There is 1 question to complete.