Located just above the Ribbon, lets you access common commands no matter which tab is selected
Slide Pane
Contains the current slide in your presentation
Slide View Option
A presentation of a series of still images (slides) on a projection screen or electronic display device, typically do in a prearranged sequence
Slide Navigation Pane
Allows you to easily move from one slide to another or to rearrange (by dragging) the order of the slides
Scroll Bar
Enables you to scroll through content that extends beyond the visible portion of a window
Ribbon
Contains all of the options and command that you use to accomplish tasks in PowerPoint for the web
Do's in MS PowerPoint
Keep it simple with minimalist design
Cut the clutter — 6 x 6 rule
Boost engagement with quality visuals
Create brand consistency with formatting
Check accessibility settings
Create custom icons and illustrations
Use subtle animations — but not too many
Pace your delivery
Don'ts in MS PowerPoint
Don't overwhelm with walls of text
Don't rely on boring bullets
Don't use inconsistent formatting
Don't use unsupported graphics
Don't plagiarize content
Don't wing your speech
MS Excel
A spreadsheet program where one can record data in the form of tables
Cell
A spreadsheet is a table with rows and columns, with a rectangular box at the intersection of these points forming a cell
Cell Address
The name by which a cell can be addressed
Benefits of using MS Excel
Easy to store data
Easy to recover data
Application of mathematical formulas
More secure
Data at one place
Neater and clearer visibility of information
Quick Access Toolbar
The toolbar in the upper left corner displays frequently used excel commands
Title Bar
It is at the top of the window, displays the active document's name
Control Buttons
Located in the upper-right side of the window, allows users to modify labels, minimize, maximize, share and close the sheet
Dialogue Box Button
A small down arrow in the lower-right corner of a command group on the ribbon, allows users to explore additional options related to the group
Name Box
Shows the location of the active cell, row or column
Formula Bar
Permits us to observe, insert of edit the information/formula entered in the active cell
Spreadsheet Area
The place where we enter our data, includes all the rows, columns and built-in data
Leaf Bar
Preset at the bottom of the spreadsheet, which it says sheet1
Columns Bar
Located below the formula bar, vertically ordered series of boxes across the full sheet
Rows Bar
The left part of the sheet where a sequence of numbers is expressed
Cell/s
Those parallelepipeds that divided the spreadsheet into many pieces, separating rows and columns
View Buttons
Normal View
Page Layout View
Page Break View
Excel Formula
Performs calculations like addition, subtraction, multiplication, division, averages, percentages, date and time manipulation and return results, even with errors
SUM
Performs the mathematical operation which is addition
AVERAGE
Focuses calculating the average of the selected range of cell values
COUNT
Counts the total number of cells in a range that contains a number
CEILING
Rounds a number up to its nearest multiple of significance
FLOOR
Rounds a number down to the nearest multiple of significance
CONCATENATE
Merges or joins several text strings into one text string
POWER
Used to square, cube or apply any raise to power to your cell
TRIM
Used to remove extra spaces from the start, middle and end
REPLACE
Used for replacing a part of the string with a new string
SUBSTITUTE
Similar to replace, instead of providing the location of a character, we will only provide old text and new text