Podcast
Questions and Answers
What function would you use if you want to save a document with a different name or file type?
What function would you use if you want to save a document with a different name or file type?
Which location is NOT an option for saving a file?
Which location is NOT an option for saving a file?
Which of the following actions allows you to print a document?
Which of the following actions allows you to print a document?
What does the 'Share' function primarily facilitate?
What does the 'Share' function primarily facilitate?
Signup and view all the answers
What can you NOT include in a descriptive file name when saving a document?
What can you NOT include in a descriptive file name when saving a document?
Signup and view all the answers
What action does the Close command perform when no other files are open for a program?
What action does the Close command perform when no other files are open for a program?
Signup and view all the answers
Which keyboard shortcut is used to paste content?
Which keyboard shortcut is used to paste content?
Signup and view all the answers
In the context of window management, what happens when a window is in Restore Down mode?
In the context of window management, what happens when a window is in Restore Down mode?
Signup and view all the answers
Which of the following keyboard shortcuts moves the cursor to the top of the document?
Which of the following keyboard shortcuts moves the cursor to the top of the document?
Signup and view all the answers
What features does the Info area in Backstage View provide?
What features does the Info area in Backstage View provide?
Signup and view all the answers
Which command is equivalent to Undo in keyboard shortcuts?
Which command is equivalent to Undo in keyboard shortcuts?
Signup and view all the answers
Which of the following is a common office object displayed in the figures?
Which of the following is a common office object displayed in the figures?
Signup and view all the answers
What is the primary purpose of using keyboard shortcuts in software applications?
What is the primary purpose of using keyboard shortcuts in software applications?
Signup and view all the answers
Which file extension is associated with a PowerPoint presentation?
Which file extension is associated with a PowerPoint presentation?
Signup and view all the answers
What is the function of the Most Recently Used List (MRU) in Office applications?
What is the function of the Most Recently Used List (MRU) in Office applications?
Signup and view all the answers
Which of the following steps is NOT part of installing add-ins for Office?
Which of the following steps is NOT part of installing add-ins for Office?
Signup and view all the answers
Which option indicates a way to share files in Office applications?
Which option indicates a way to share files in Office applications?
Signup and view all the answers
What feature is used to adjust the view of documents in Office applications?
What feature is used to adjust the view of documents in Office applications?
Signup and view all the answers
Which button do you click to access the Office Add-ins window?
Which button do you click to access the Office Add-ins window?
Signup and view all the answers
What does the Backstage Print option allow you to do?
What does the Backstage Print option allow you to do?
Signup and view all the answers
What views can you change to in Office applications?
What views can you change to in Office applications?
Signup and view all the answers
Which of the following programs is not part of the Office 2019 suite?
Which of the following programs is not part of the Office 2019 suite?
Signup and view all the answers
What feature is commonly found in all Microsoft Office applications to assist users?
What feature is commonly found in all Microsoft Office applications to assist users?
Signup and view all the answers
Which tab in the ribbon is common to most Microsoft Office applications?
Which tab in the ribbon is common to most Microsoft Office applications?
Signup and view all the answers
What is the purpose of the Ribbon Display Options button?
What is the purpose of the Ribbon Display Options button?
Signup and view all the answers
Which action does the keyboard shortcut Ctrl+F1 perform?
Which action does the keyboard shortcut Ctrl+F1 perform?
Signup and view all the answers
In which type of Office subscription plan does access to Office 365 fall?
In which type of Office subscription plan does access to Office 365 fall?
Signup and view all the answers
Which of the following devices is NOT compatible with Office 2019?
Which of the following devices is NOT compatible with Office 2019?
Signup and view all the answers
Which tab in the ribbon is primarily focused on equations and functions in Excel?
Which tab in the ribbon is primarily focused on equations and functions in Excel?
Signup and view all the answers
Which Office application is specifically designed for database management?
Which Office application is specifically designed for database management?
Signup and view all the answers
What is the primary function of the Home tab in the Microsoft Office ribbon?
What is the primary function of the Home tab in the Microsoft Office ribbon?
Signup and view all the answers
Study Notes
Microsoft Office 365 Excel 2019
- The book is titled "Your Office: Microsoft Office 365 Excel 2019"
- It is a comprehensive fourth edition
- The series editor is Amy Kinser
- Authors include Jacobson, Kinser, Moriarty, and Nightingale
- The book is published by Pearson
Common Features Chapter 1
- The chapter is titled "Understanding the Common Features of Microsoft Office"
- This chapter introduces the common features of the Microsoft Office suite
Learning Objectives
- Understand the Office suite and applications
- Start, save, and manipulate Office applications and use the Office ribbon
- Manipulate, correct, and format content in Excel
- Format using various Office methods
- Find Help, print, and share in Office
- Insert Office add-ins
Programs in Office 2019
- Word
- Excel
- PowerPoint
- Access
- OneNote
- Outlook
- Publisher
- Skype for Business
Versions
- Multiple platforms include Windows phone, iPad, Android devices, and web browser
- Suite packages include Home and Enterprise
- Non-educational consumers use traditional one-time fees or subscriptions (Office 365)
Microsoft Account
- The website address is https://signup.live.com
- The account page shows user information, connected Microsoft account, product information
- The backstage view showcases office background, office theme, and updates
- The software is from Microsoft Corporation
Word Start Screen
- The start screen displays "Good morning"
- Features options to create a Blank document or open an existing document
- Options include "Recent files," "Recent Pinned," and "Shared with Me"
- It also features "More templates" and "More documents"
The Ribbon
- Common tabs include "File" and "Home"
- Application-specific tabs include "Formulas," "Design," and "Database Tools"
- There is also a second part of the ribbon
Zoom and Scroll
- Zoom controls and dialog box are presented
- Quick Access Toolbar allows saving options
- Zoom controls include zoom dialog box, zoom level button, and zoom slider
Common Office Objects
- Tabs and buttons are presented as common objects
- The Format Cells dialog box allows customizing font settings like style, size, color, and effects
- The screenshot of the Mini toolbar allows for quick adjustments to the data
Additional Common Office Objects
- The contextual tab in the Picture Tools group is shown as a key object
- The Mini toolbar is presented for quick editing
- Various formatting and styling options are visible for cells
- The Excel help pane displays various tools and categories for finding information
Saving a File
- Descriptive names cannot include special characters like ?, /, |, <, >, *, and :
- Common file extensions include .docx, .xlsx, .pptx, and .accdb
- File paths are used for saving documents, such as C:\Budget2020\January Minutes.docx
Quick Access Toolbar
- The Quick Access Toolbar allows for quickly saving and accessing commonly used features
- Includes zoom controls, zoom level, and zoom slider
Roaming Settings
- Most Recently Used List (MRU)
- Documents and Places
- MRU Templates
- Office Personalization
- Custom Dictionary
- List of Connected Services
- Word Resume Reading Position
- OneNote-the custom name a notebook view
- PowerPoint the Last Viewed Slide
Backstage View
- Presents various areas to manage documents, like "Info," "New," "Open," etc.
- Allows adding properties, protecting a document, and saving to different locations
- Backstage view includes "Print," "Share," "Export," and "Close"
Share Files
- Methods of sharing include hard copy, digital copy, and a print option
- Option to share links and use backstage function
Help
- The Excel Help pane provides various tools and categories for finding information
- Includes "Get started," "Rows, columns, cells," "Formulas & functions," "Formatting," "Tables & charts," "PivotTables," and "Share & coauthor"
Add-ins
- QUICK REFERENCE: Installing Add-ins for Office
- Steps include opening the application, selecting My Add-ins arrow, navigating to the app, and clicking Insert.
- Steps for installing the Add-ins include selecting the app, clicking Store link, searching, and following instructions
- The printer settings can be accessed from Backstage
- Options including copies, pages, orientation, and printer properties are available
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Test your understanding of the common features of Microsoft Office 365 Excel 2019 as introduced in Chapter 1. This quiz covers essential skills such as manipulating, formatting content, and using the Office ribbon. Hone your skills in navigating various Office applications and tools.
