FORMATIVE ASSESSMENT # 4
F.A. # 4
ADVANCE EXCEL TOOLS
TO PROCESS AND PRESENT DATA
By: T. AXL SLASH P. LEYSON
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
1. Microsoft Excel is an example of
which software application?
A. Database
B. Word Processor
C. Spreadsheet
D. Presentation
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
2. You can get the total of a large range of
data by simply selecting which function?
A. SUM
B. AVERAGE
C. MIN
D. MAX
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
3. Which formula will get the total number
of website visitors during the months of
May and June?
A. A3+A4
B. B3+B4
C. =A3+A4
D. =B3+B4
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
4. Which function should you use to get
the average number of your website
visitors from April to August?
A. =SUM(B2:B6)
B. =AVERAGE(B2:B6)
C. =COUNT(B2:B6)
D. =AVERAGE(B3:B6)
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
5. Which function should you use to get
the least number of customers you have
for a month from April to August?
A. =MIN(B2:B6)
B. =MAX(B2:B6)
C. =SUM(B2:B6)
D. =COUNT(B2:B6)
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
6. Which of the following do you think is
the advantage of using cell references in
your formula instead of writing values?
A. It allows you to format your cell faster.
B. It automatically creates a sparkline in the next cell
C. If the cell is changed, the result in the formula will
be updated.
D. There is no advantage
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
7. Which chart is best used for comparing
proportions making up the percentage of a
whole?
A. Bar
B. Pie
C. Line
D. Area
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
8. You want to see how much sales you have
generated so far, to compute for the sales per
customer. Which formula should be set to
accomplish this?
A. =C2*D2
B. =C2/D2
C. =Price*Quantity Ordered
D. =SUM(C2:C11)
YOUR OWN SMALL CAKE SHOP
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
9. You added a new column. “Amount” placed in
Column E to compute for the sales per customer.
The next step is to get the total amount to determine
your sales data for selling cake slices. Which
formula is correct to do this?
YOUR OWN SMALL CAKE SHOP
A. =SUM(C2:C6)
B. =SUM(D2:D11)
C. =SUM(E2:E6)
D. =AVERAGE(E2:E6)
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
9. You added a new column. “Amount” placed in
Column E to compute for the sales per customer.
The next step is to get the total amount to determine
your sales data for selling cake slices. Which
formula is correct to do this?
YOUR OWN SMALL CAKE SHOP
A. =SUM(C2:C6)
B. =SUM(D2:D11)
C. =SUM(E2:E6)
D. =AVERAGE(E2:E6)
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
10. Which of the following features of Excel
narrow down data in your worksheet allowing
you to view only information you need.
A. Sorting
B. Filtering
C. Formula
D. Function
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Types of Charts
Line – this chart is ideal for showing
trends. The data points are connected
by lines, making it easier to see the
increase or decrease of value over time.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Types of Charts
Pie – this chart used to compare
proportions. It depicts the values that
make up a percentage of the whole and
are shown as slices of a pie.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Types of Charts
Bar – this chart is just like the Column
chart but uses horizontal bars instead.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Types of Charts
Area – this chart is like the Line chart,
except the area under the lines are
shaded.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Types of Charts
Surface – this chart allows you to
display data in 3D Landscape. It lets you
see a variety of information at the same
time. This works best with large data
sets.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Inserting a Chart
1. SELECT THE
CELLS THAT YOU
WANT TO INCLUDE
IN YOUR CHART,
INCLUDING THE
COLUMN TITLES
AND ROW LABELS.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Inserting a Chart
2. SELECT THE DESIRED CHART
COMMAND FROM THE INSERT TAB.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Inserting a Chart
3. SELECT THE DESIRED
CHART TYPE FROM THE
DROP-DOWN MENU.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Inserting a Chart
4. THE CHART
WILL BE
INSERTED IN THE
WORKSHEET.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Changing Chart Types
IF YOU THINK YOUR CHART IS NOT
SUITED FOR THE DATA YOU HAVE, IT’S
JUST EASY TO CHANGE TO A
DIFFERENT CHART TYPE.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Changing Chart Types
1. CLICK THE CHANGE CHART TYPE
COMMAND FROM THE DESIGN TAB.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Changing Chart Types
2. A CHANGE CHART
TYPE DIALOG BOX
WILL APPEAR. SELECT
A NEW CHART TYPE
AND LAYOUT THEN
CLICK OK.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
Changing Chart Types
3. THE NEW CHART
WILL BE DISPLAYED.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
MOVING A CHART
YOU CAN MOVE THE CHART TO A NEW
WORKSHEET TO HELP KEEP YOUR
DATA ORGANIZED
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
MOVING A CHART
1. SELECT THE CHART
YOU WANT TO MOVE.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
MOVING A CHART
2. SELECT MOVE CHART FROM THE
DESIGN TAB.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
MOVING A CHART
3. THE MOVE CHART
DIALOG BOX WILL
APPEAR. SELECT THE
DESIRED LOCATION
FOR THE CHART. THEN
CLICK OK.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
CHARTS
MOVING A CHART
4. THE CHART WILL APPEAR IN THE
SELECTED LOCATION.
LESSON 4: ADVANCE EXCEL TOOLS TO PROCESS AND PRESENT DATA
