Lesson 4

steps in Using Hyperlinks in MS PowerPoint

1. Select an object or highlight a text. 2. Go to Insert > Hyperlinks (under links category) or use the shortcut key Ctrl + K. The insert Hyperlink dialog box would appear. 3. When done, click OK to apply your hyperlink.

Limit the content to six lines and seven words per line.

6 x 7 rule

If I wanted to compute the average salary of all the employees, which specific function should I use?

=AVERAGE(range)

is used to find the arithmetic mean of specified numbers.

=AVERAGE(range)

if i want to find the average salary of employees in the Sales department, which specific function should I use?

=AVERAGEIF(range, criteria, average_range)

is a pre-made function in Excel that calculates the average of a range based on a given condition or criteria.

=AVERAGEIF(range, criteria, average_range)

If I wanted to count the number of salaries of my employees, which specific function should I use?

=COUNT(range)

counts the number of cells that contain numbers, and countsnumbers within the list of arguments

=COUNT(range)

counts cells containing any type of information, including error values and empty text ("")

=COUNTA(range)

If I wanted to find the highest amount of salary of my employees, which specific function should I use?

=MAX(range)

returns the largest number in a set of values.

=MAX(range)

If I wanted to find the least amount of salary of my employees, which specific function should I use?

=MIN(range)

returns the smallest number in a set of values.

=MIN(range)

selected cell

Active Cell

set of effects which can be applied to text or graphic within a slide

Animation

It automatically fixes common spelling errors, such as changing "teh" to "the," and can also correct capitalization mistakes, like making sure the first letter of a sentence is capitalized

Autocorrect

is a built-in feature in many word processing and textediting software.

Autocorrect

what are the Features of MS Word

Autocorrect grammar checker template tables

the place where information is held in a spreadsheet

Cell

cell address of the cell usually a combination of letter and number

Cell Reference

Avoid being too fancy by using font style that is easy to read. Make sure that it is also big enough to be read by the audience. Once you start making your presentation, consider how big the screen is during your report.

Clarity.

vertical line of entries in a table

Column

the box at the top of each column containing a letter

Column Heading

Use a light font on dark background or vice versa. This is done so that it is easier to read.

Contrast

creates a hyperlink that once clicked, creates a new document on your specified location.

Create a New Document

select all content in the document

Ctrl + A

bold the selected text

Ctrl + B

copy selected text or objects

Ctrl + C

move the cursor to the end of the document

Ctrl + End

open the "Find" dialog to search for specific text

Ctrl + F

open the "Find and Replace" dialog to search and replace text

Ctrl + H

move the cursor to the beginning of the document

Ctrl + Home

italicize the selected text

Ctrl + I

move the cursor one word to the left

Ctrl + Left Arrow

create a new document

Ctrl + N

open an existing document

Ctrl + O

print the document

Ctrl + P

save the current document

Ctrl + S

underline the selected text

Ctrl + U

paste selected text or objects

Ctrl + V

cut selected text or objects

Ctrl + X

redo the last undone action

Ctrl + Y

undo the last done action

Ctrl + Z

move the cursor to the end of the current paragraph

Ctrl + down Arrow

move the cursor one word to the right

Ctrl + right Arrow

move the cursor to the beginning of the current paragraph

Ctrl + up Arrow

pre-designed graphic styles that you can apply to your slides

Design Template

creates a hyperlink that opens Microsoft Outlook that automatically adds your specified recipient on a new email.

E-mail Address

creates a hyperlink to website or a local file saved in your hard drive.

Existing File or Web Page

expression which calculates the value of a cell

Formula

the bar that displays the content of the cell

Formula Bar

They are executed by providing specific values known as arguments.

Functions

are typically displayed in capital letters, are accessible for selection and use, and can be inserted into created formulas.

Functions

predefined formulas and are already available in Excel

Functions

predefined formulas within the spreadsheet.

Functions

allows you to jump to another location

Hyperlink

They significantly speed up document creation and editing processes, making word processing software more user-friendly and productive.

Keyboard shortcuts

are quick and efficient commands that allow users to perform various tasks in word processing software without the need to use the mouse or navigate through multiple menus.

Keyboard shortcuts

Some examples of Electronic Spreadsheets are:

LibreOffice Calc Google Sheets Apple iWork Numbers Microsoft Excel

Some examples of Presentation Software are:

LibreOffice Impress Google Slides Apple iWork Keynote Microsoft PowerPoint

what are the examples of word processors?

LibreOffice Writer Google Docs Apple iWork Pages Microsoft Word

Consistency

Make your design uniform. Avoid having different font styles and backgrounds.

combining or joining two or more cells

Merge

Keep slides counts to a minimum to maintain a clear message and to keep the audience attentive.

Minimize

what are the Tips in Creating an Effective Presentation

Minimize. Clarity Simplicity Visual Consistency Contrast

simplified layout of the page so you can quickly key, edit, and format the presentation.

Normal View

what are the types of vies in MS powerpoint?

Normal View Notes Page View Outline View Slide Sorter View

displays your slides on the top portion of the page, with thespeaker notes for each slide in the notes pane on the bottom of the pane

Notes Page View

displays all text in a PowerPoint slide show in outline formregardless of the design, objects, and animation.

Outline View

creates a hyperlink that allows you to jump to a specific slide in your presentation.

Place in This Document

allows users to create slides or pages that can be displayed sequentially to deliver a cohesive and interactive presentation

Presentation Software

is an application software that allows users to create visual aids for presentations tocommunicate ideas, messages, and other information.

Presentation Software

horizontal line of entries in a table

Row

the box at the left of each row containing a number

Row Heading

Use bullets or short sentences. Summarize the information on the screen to have your audience focus on what the speaker is saying than on reading the slide.

Simplicity

collection of pages arranged in a sequence that contain text and images for presenting to an audience

Slide Show

displays mini versions of slides and allows you to re-arrangethem

Slide Sorter View

an electronic document in which data is arrangedin the rows and columns of a grid and can be manipulated and used incalculations

Spreadsheets

are versatile tools that find numerous applications across various industries and for personal use.

Spreadsheets

common uses of this are financial reports, data management, statistical analysis, accounting and bookkeeping, data analysis, project management, etc.

Spreadsheets

They are especially useful for presenting data in a structured and easy-to-read format

Tables

are commonly used in reports, research papers, and data analysis.

Tables

used to organize information into rows and columns.

Tables

motion effects that when in Slide Show view add movements to your slides as you advance from one slide to another

Transition

Use graphics to help in your presentation but not too much to distract the audience.

Visual

contains different categories of information

column

It involves using values or numerical data that are either directly input or referenced from other cells

formula

can be created using either direct values or by referencing specific cells

formula

refers to a mathematical equation used for calculations

formula

It also checks for grammar issues, writing style problems, sentence structure errors, and can even provide readability statistics

grammar checker

It helps writers improve the overall quality of their writing

grammar checker

tool that proofreads documents for more than just spelling errors.

grammar checker

represents a separate entry

row

single page of a presentation

slide

Collection of slides

slide deck

pre-designed document that contains the formatting necessary for a specific document type.

template

they save time by providing a structure that you can fill in with your content

template

are widely used for various purposes, including writing documents, letters, reports, essays, articles, and more.

word processors

is an electronic device or computer software application that performs the tasks of composing, editing, formatting, and printing of documents.

word processors