IT 254
INTELLIPATH
DEFINING AND CREATING THE TABLE
Learning Materials
Excel table is very similar to any database table. Before going further, you must know a
few important database terms that are common in Excel tables too.
What is a Field?
Let's begin w
IT 254
INTELLIPATH
EXPLANATION OF EXCEL FUNCIONS
Learning Materials
Examining Functions
Excel has many functions that can be used in formulas. Some of these functions even
involve the manipulation of text as well as performing calculations. To examine the
IT 254
INTELLIPATH-FAST TRACK
FORMATTING A CHART
Learning Materials
Formatting your charts can give you more control over the data. You can format different
areas of the chart to draw a users attention, or to outline important differences.
Format Tab
The
IT 254
INTELLIPATH WORKSHEET
CHARTS AND THEIR BENEFITS
1.
If you want to show the enrollment by majors for a specific semester you would use
which of the following?
a)
b)
c)
d)
e)
2.
If you have experimental data and you need to find a correlation between
IT 254
INTELLIPATH
PIVOT TABLES AND ITS RANGE
Learning Materials
What is a Pivot Table?
Pivot tables are great reporting tool and they provide an excellent option to extract the
information from the large table. They are very user-friendly and provide a l
IT 254
INTELLIPATH
EXCEL FORMULAS
What are the largest and smallest numbers that can result from a
formula and be stored in a cell? (Choose 2)
The smallest is 1.024 E256
The largest is 1.79 E+308
The largest is 1.024
E+256
The smallest is 2.22 E-308
What
IT 254
INTELLIPATH WORKSHEET
EXPLANATION OF EXCEL FUNCTIONS
1.
What is a lookup function? (Choose 2)
a) HLOOKUP is a lookup function that sorts through a horizontal table based
on a value, finds a match and then returns a value from a specified row
b) VLO
IT 254
INTELLIPATH-FAST TRACK
SORTING AND FILTERING DATA
Learning Materials
It is mind boggling to know that that there are over 17 billion cells in a single worksheet
and you can store over a million rows of data.
Sorting and Filtering
Anyone working wit
IT 254
INTELLIPATH WORKSHEET
EXCEL FORMULAS
1.
What are the largest and smallest numbers that can result from a formula and be
stored in a cell? (Choose 2)
a)
b)
c)
d)
2.
The smallest is 1.024 E-256
The largest is 1.79 E+308
The largest is 1.024 E+256
The
IT 254
INTELLIPATH WORKSHEET
FORMATTING A CHART
1.
What are some of the special effects in formatting?
a)
b)
c)
d)
e)
2.
What options do you have for the background?
a)
b)
c)
d)
3.
Jump in
Spiral
Spinning
Soft Edges
Shadow
You can insert a picture in the
1.
Which of the following is a step to create a dynamic range in a Pivot Table?
a)
b)
c)
d)
2.
What is true about Pivot Table Ranges? (Choose 2)\
a)
b)
c)
d)
3.
Select any cell in the Pivot Table
Create Pivot Chart
Select the data in the data source
Selec
IT 254
INTELLIPATH WORKSHEET
PIVOT CHARTS AND HOW TO CREATE THEM
1.
What is the suggested range in the Formal for which the Table dialog box based on?
a) It is based on location of the active cell and the layout and layout of the
column and row headings
b
IT 254
INTELLIPATH WORKSHEET
SORTING AND FILTERING DATA
1.
What is the default setting when a range of cells is converted to a table?
a)
b)
c)
d)
2.
What are two of the four types of filters? (Choose 2)
a)
b)
c)
d)
e)
3.
You can only sort formatted data
S
IT 254
INTELLIPATH WORKSHEET
DEFINING AND CREATING THE TABLE
1.
What Excel table feature takes a formula in a column and automatically adjusts cell
references for each row in the table?
a)
b)
c)
d)
2.
What values do you need to input or confirm in the For
IT 254
INTELLIPATH
PIVOT CHARTS AND HOW TO CREATE THEM
Learning Material
Pivot charts are a data analyzing tool. Pivot charts are used for visual representation of
the data. Pivot charts and pivot tables are linked, in other words, any update made in
pivo