Lesson 7- Imaging and Design for Visual Message Using Infographics

Lesson 7- Imaging and Design for Visual Message Using Infographics

Imaging and Design for Visual Message Using Infographics

Learning Competencies and Codes:
1. Use image manipulation techniques on existing images to change or enhance their current state to communicate a message for a specific purpose. CS_ICT11/12-ICTPT-Ie-f

After going through this module, you are expected to:
1. understand the infographics or similar graphs and its importance in showing information;
2. identify which infographic or graph is most appropriate for a particular set of information; and
3. create infographics or similar graphs using a spreadsheet application.

Which should be done first in making a graph in excel?

In the Insert tab click Table then click the desired table.
Select the drag cells needed for the chart.
In the ribbon, click Insert > Charts.
Press right click then click insert table.

How do you rename a graph into “First Data” in Microsoft Excel?

Double click the name of the chart and type “First Data”.
Graph names can’t be changed as they follow the name from the selected data.
Press right click then select rename, a window will appear then type “First Data”.
Press Ctrl + A then Ctrl + R, rename the chart to “First Data”

Which Ribbon Menu is needed to add a Chart?

Cell Formatting
Page Layout
Insert
Home

Which is the main use of line graph?

To visually present the data.
To compare difference between data.
To show hierarchy between data sets.
To see trend of data change.

How do you change formula style in a sheet?

Click Insert > Cell Formatting > Table Format > Table Style
Click Cell Formatting > Format Table > Table Style
You have to select each cell then add cell borders to each of them
Click Home > Format as Table > Table Style

Which Ribbon Menu is needed to be selected to change the font?

Insert
Home
Page Layout
Cell Formatting

What is the formula that will add the contents of the cells C1 and C10?

= C1 + C10
SUM (C1:C3)
C1+C10
C1 + C10 =

With this formula = Expense!C12, what does the Expense! part means?

It is formula label, allowing the user to manage all the formula.
This is not a proper use of the formula.
It a variable that allows quick reference of a value.
It indicates that the c12 to be displayed is on the sheet Expense

Which is an example of infographics?

Graphics
Charts and Graphs
Illustration
Pictures

Which of the following is considered the most important in creating a table in excel?

There must be a data table in excel.
There must be a reason to use infographic.
There must have an image ready for your infographic.
There must have PowerPoint installed.

Which of the following is NOT the purpose of infographics in the presentation of data?

It helps the presentation to be more visually attractive.
It improves people understanding in data gathering.
It engages audience in your presentation.
It helps people interpret data visually.

How do you resize a graph?

Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.
You can’t change the size of graphs.
Click the graph then click and drag any of the eight handles in the edges of the graph.
Select the table the press Ctrl + Arrow Keys.

How do you resize a column or width?

Select the cell the press right click, select format cell then change height and width values.
Click the cell then in the ribbon select format cell then change height and width values.
In the Formula bar type (h[value]w[value]).
Click and drag the column or row heading.

How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
Type the formula where you want it to be displayed on.
In the ribbon click Cell Formatting then select the formula then type where it will displayed.
On the formula bar type cell address

What is the purpose of the Formula Bar?

The Formula Bar is a label below the cell that indicates the result of a formula
It is the formula that allows computation of values from different cells.
It is a selection of shortcuts different formula in Microsoft Excel
It allows an easy to see input box for formula in a cell