Excel Data Analysis

Question 1

Ranges can be sorted using the TWO commands

Answer 1

Sort Ascending and Sort Descending

Question 2

from largest to smallest.

Answer 2

Sort Descending:

Question 3

from smallest to largest.

Answer 3

Sort Ascending:

Question 4

can be applied to sort and hide data. It makes data analysis easier.

Answer 4

Filters

Question 5

Tables allow for options such as:

Answer 5

Sort & Filter
Formatting
AutoFilling

Question 6

There are three ways to resize a table

Answer 6

Resize table command
Drag to resize
Adding headers

Question 7

are extra copies of values.

Answer 7

Duplicates

Question 7

used to change the appearance of cells in a range based on your specified conditions.

Answer 7

Highlight Cell Rules

Question 8

is used to change the appearance of cells in a range based on your specified conditions.

Answer 8

Conditional formatting

Question 9

The web browser version of Excel offers the following appearance options for conditionally formatted cells:

Answer 9

• Light Red Fill with Dark Red Text
• Yellow Fill with Dark
• Yellow Text
• Green Fill with Dark Green Text
• Light Red Fill
• Red Text
• Red Border

Question 10

Used to highlight cells in a range to indicate how large the cell values are compared to the other values in the range.

Answer 10

Color scales

Question 10

used to add colored bars to cells in a range to indicate how large the cell values are compared to the other values.

Answer 10

Data Bars

Question 11

used to add icons to cells in a range to indicate how large the cell values are compared to the other values in the range.

Answer 11

Icon Sets

Question 12

Icon Sets Options

Excel has a number of different icon sets, organized as:

Answer 12

Directional
Shapes
Ratings

Question 12

Commonly used charts are:

Answer 12

Pie chart
Column chart
Line chart

Question 13

show the data as horizontal bars.

Answer 13

Bar charts

Question 13

are visual representations of data used to make it more understandable.

Answer 13

Charts

Question 14

There are three different type of bar charts:

Answer 14

Clustered bar
Stacked bar
100% stacked bar

Question 15

show the data as vertical bars.

Answer 15

Column charts

Question 16

are used when the value of data is important but the order is not.

Answer 16

Clustered Bar charts

Question 17

are used to highlights the total amount of contribution for each category.

Answer 17

Stacked bar charts

Question 18

arrange the data as slices in a circle.

Answer 18

Pie charts

Question 19

are used for representing values of qualitative (categorical) data.

Answer 19

Pie charts

Question 20

are used when you only have one data column.

Answer 20

2-D pie charts

Question 20

Excel has two types of pie charts:

Answer 20

2-D pie Doughnut

Question 21

show the data as a continuous line. are typically used for showing trends over time.

Answer 21

Line charts

Question 22

Excel has six types of line charts:

Answer 22

- Line - Line with Markers - Stacked Line - Stacked Line with Markers - 100% Stacked Line - 100% Stacked Line with Markers

Question 23

show the proportion of contribution to trends in the data.

Answer 23

100% Stacked Line charts

Question 23

show the contribution to trends in the data.

Answer 23

Stacked Line charts

Question 24

show multivariate data as values relative to a center point.

Answer 24

Radar charts

Question 25

is a functionality in Excel which helps you organize and analyze data.

Answer 25

PivotTable

Question 26

Excel Examples

Answer 26

Excel Exercises Excel Syllabus Excel Study Plan Excel Certificate Excel Training