Computer
Fundamentals
Dr. Muhammad Waqar Ashraf
Faculty of Computer Engineering
Bahauddin Zakariya University Multan, Pakistan
Chapter 8: Understanding Microsoft Office
Identify the basic parts of an Office application’s interface
Use common features that all Office applications share
Save, open, and create data files
Print your work and email it to others
Adjust the options of an Office application
Computer Fundamentals 2
Microsoft Office
Microsoft Office is a suite of applications designed to help with
productivity and completing common tasks on a computer. You can
create and edit documents containing text and images, work with data in
spreadsheets and databases, and create presentations and posters.
Computer Fundamentals 3
The Office Ribbon
Ribbon
Computer Fundamentals 4
Hiding the Ribbon
Computer Fundamentals 5
Backstage View
Computer Fundamentals 6
Quick Access Toolbar
Computer Fundamentals 7
Shortcut Menus
Right-click for a shortcut menu
Mini toolbar also appears when
right-clicking on text
Computer Fundamentals 8
ScreenTips
Computer Fundamentals 9
Status Bar
Computer Fundamentals 10
Window Controls
Computer Fundamentals 11
Getting Help
Press the F1 key
Click the Help button
Click the File tab and click
Help
Computer Fundamentals 12
Changing Views
Computer Fundamentals 13
Moving Around
Scroll bars
Scroll box
Scroll arrows
Keyboard movement
▪ Arrow keys
▪ Page up, Page Down
▪ End, Home
▪ Ctrl+End, Ctrl+Home
Computer Fundamentals 14
Selecting Content
Selecting Text in Word or PowerPoint
▪ Drag across it
▪ Click at the start point, hold down Shift, and click at the end point.
▪ Click at the start point, hold down Shift, and press arrow keys to extend the
selection
Computer Fundamentals 15
Selecting Content
Selecting Cells in Excel
▪ Drag across the cells
▪ Select the first cell, hold down Shift, and click the last cell.
▪ Select the first cell, hold down Shift, and press arrow keys to extend the
selection
▪ Click a cell, hold down Ctrl, and drag across additional cells to select them
Computer Fundamentals 16
Using the Clipboard
Office Clipboard The enhanced version of the Windows Clipboard that
appears in Office applications.
Computer Fundamentals 17
Office Clipboard
Holds up to 24 objects at a time
Click an item to paste it
Computer Fundamentals 18
Undo and Redo
The shortcut for Undo is Ctrl+Z.
The shortcut for Redo is Ctrl+Y.
Computer Fundamentals 19
Text Formatting
Computer Fundamentals 20
Themes
Computer Fundamentals 21
Theme Colors and Palettes
Computer Fundamentals 22
Moving and Resizing Objects
Drag selection handle to resize
Drag border to move
Computer Fundamentals 23
Saving Files
Choose File, Save or press
Ctrl+S
When saving subsequent
times, use Save As to reopen
dialog box
Computer Fundamentals 24
Default File Formats for Office Applications
Computer Fundamentals 25
Opening Recently Used Files
Computer Fundamentals 26
New Files with Templates
File, New
Select one of the
templates, or search
for a template
Computer Fundamentals 27
Printing Files
Computer Fundamentals 28
Sending a File as an Email Attachment
Computer Fundamentals 29
Setting Application Options
Computer Fundamentals 30
Application Options
Computer Fundamentals 31
Key Terms
AutoCorrect object standard colors
AutoRecover Office Clipboard status bar
Backstage view Quick Access Toolbar tab
cell cursor (QAT) template
color palette Ribbon theme
default file location ScreenTip theme colors
dialog box launcher scroll Zoom controls
embed fonts scroll bar
group scroll box
insertion point selection handle
keyboard shortcut shortcut menu
Computer Fundamentals 32
Quick Review
Explain how to save and open files in Office applications.
Describe the main features that the user interfaces of all Office
applications have in common.
Describe how colors are arranged on a palette and how they relate to
the active theme.
Name three things you can customize in an application via its Options
dialog box.
Explain how to change the default save location.
Describe how to move the insertion point.
Contrast the Windows Clipboard to the Office Clipboard.
Computer Fundamentals 33
Think It Over…
Ribbon Customization
Customizing the Status Bar
Theme Colors versus Standard Colors
Computer Fundamentals 34
THANK YOU
For Your Attention