Microsoft Office 365 Excel 2019 Chapter 1 Quiz
31 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What function would you use if you want to save a document with a different name or file type?

  • Save
  • Close
  • Export
  • Save As (correct)

Which location is NOT an option for saving a file?

  • OneDrive
  • USB
  • Cloud server (correct)
  • Hard drive

Which of the following actions allows you to print a document?

  • Print (correct)
  • Save
  • Export
  • Share

What does the 'Share' function primarily facilitate?

<p>Collaborating by sending invitations or emails (B)</p> Signup and view all the answers

What can you NOT include in a descriptive file name when saving a document?

<p>Question mark (?) (B)</p> Signup and view all the answers

What action does the Close command perform when no other files are open for a program?

<p>Closes a file and exits the program (B)</p> Signup and view all the answers

Which keyboard shortcut is used to paste content?

<p>Ctrl+V (B)</p> Signup and view all the answers

In the context of window management, what happens when a window is in Restore Down mode?

<p>The window expands to full size (A)</p> Signup and view all the answers

Which of the following keyboard shortcuts moves the cursor to the top of the document?

<p>Ctrl+Home (D)</p> Signup and view all the answers

What features does the Info area in Backstage View provide?

<p>Adding properties and managing a document (B)</p> Signup and view all the answers

Which command is equivalent to Undo in keyboard shortcuts?

<p>Ctrl+Z (D)</p> Signup and view all the answers

Which of the following is a common office object displayed in the figures?

<p>Contextual tab (B)</p> Signup and view all the answers

What is the primary purpose of using keyboard shortcuts in software applications?

<p>Increasing efficiency and saving time (D)</p> Signup and view all the answers

Which file extension is associated with a PowerPoint presentation?

<p>.pptx (A)</p> Signup and view all the answers

What is the function of the Most Recently Used List (MRU) in Office applications?

<p>To display frequently accessed files (C)</p> Signup and view all the answers

Which of the following steps is NOT part of installing add-ins for Office?

<p>Insert a new document (B)</p> Signup and view all the answers

Which option indicates a way to share files in Office applications?

<p>Use Share link (D)</p> Signup and view all the answers

What feature is used to adjust the view of documents in Office applications?

<p>Page Layout view (B)</p> Signup and view all the answers

Which button do you click to access the Office Add-ins window?

<p>Insert tab (A)</p> Signup and view all the answers

What does the Backstage Print option allow you to do?

<p>Print documents (D)</p> Signup and view all the answers

What views can you change to in Office applications?

<p>Page Break and Page Layout views (A)</p> Signup and view all the answers

Which of the following programs is not part of the Office 2019 suite?

<p>Adobe Photoshop (B)</p> Signup and view all the answers

What feature is commonly found in all Microsoft Office applications to assist users?

<p>Spelling and Grammar Checker (C)</p> Signup and view all the answers

Which tab in the ribbon is common to most Microsoft Office applications?

<p>File (C)</p> Signup and view all the answers

What is the purpose of the Ribbon Display Options button?

<p>To toggle the visibility of the ribbon (B)</p> Signup and view all the answers

Which action does the keyboard shortcut Ctrl+F1 perform?

<p>Toggles the display of the ribbon (A)</p> Signup and view all the answers

In which type of Office subscription plan does access to Office 365 fall?

<p>Enterprise Package (D)</p> Signup and view all the answers

Which of the following devices is NOT compatible with Office 2019?

<p>Linux desktop (A)</p> Signup and view all the answers

Which tab in the ribbon is primarily focused on equations and functions in Excel?

<p>Formulas (A)</p> Signup and view all the answers

Which Office application is specifically designed for database management?

<p>Access (A)</p> Signup and view all the answers

What is the primary function of the Home tab in the Microsoft Office ribbon?

<p>Basic formatting and clipboard functions (C)</p> Signup and view all the answers

Flashcards

Microsoft Office Suite

A collection of applications like Word, Excel, PowerPoint, and more, used for various tasks.

Ribbon

The bar at the top of Office applications that displays tabs for different functions and commands.

File Tab

Ribbon tab with features like saving, printing, and sharing an app.

Home Tab

Commonly used basic features found on ribbon tabs in Office apps

Signup and view all the flashcards

Office Applications

Specific programs (like Word, Excel, PowerPoint) within the Microsoft Office suite.

Signup and view all the flashcards

Excel

Microsoft Office application for spreadsheets.

Signup and view all the flashcards

Word

Microsoft Office application for creating documents.

Signup and view all the flashcards

PowerPoint

Microsoft Office application for creating presentations.

Signup and view all the flashcards

Ribbon Display Options

Controls the way the Ribbon is shown, allowing it to be collapsed or expanded.

Signup and view all the flashcards

Microsoft 365

A subscription-based service for multiple Office applications.

Signup and view all the flashcards

New Document

Starts a blank or template-based document.

Signup and view all the flashcards

Open File

Loads a file from the computer, recent files, or online storage.

Signup and view all the flashcards

Save File

Saves the current file to your computer or cloud storage.

Signup and view all the flashcards

Save As

Creates a copy of the file with a new name or type.

Signup and view all the flashcards

File Locations

Where files are stored (hard drive, USB, network, cloud).

Signup and view all the flashcards

Restore Down Mode

A window mode that expands a window to its full size.

Signup and view all the flashcards

Alt+F4

Closes the current file, or exits a program if no other files are open.

Signup and view all the flashcards

Keyboard Shortcuts

Key combinations that perform software commands.

Signup and view all the flashcards

Copy (Ctrl+C)

Makes a duplicate of selected content.

Signup and view all the flashcards

Cut (Ctrl+X)

Removes selected content and places it on the clipboard.

Signup and view all the flashcards

Paste (Ctrl+V)

Inserts content from the clipboard.

Signup and view all the flashcards

Select (Ctrl+A)

Selects all content.

Signup and view all the flashcards

Backstage View

Area in some applications for document properties, protection, inspection, and management.

Signup and view all the flashcards

File Extension

A three-letter code after a period in a filename, indicating the file type (e.g., .docx for Word documents, .xlsx for Excel spreadsheets).

Signup and view all the flashcards

Quick Access Toolbar

A customizable tool bar that provides commonly used commands, often located above the Ribbon.

Signup and view all the flashcards

Most Recently Used List (MRU)

A feature that keeps track of the files you've recently opened, making them easy to access again.

Signup and view all the flashcards

Roaming Settings

Settings that apply to your Microsoft Office account, so your preferences are carried across multiple devices and locations.

Signup and view all the flashcards

Word Start Screen

The initial screen you see when you open Microsoft Word, offering options like starting a new document or opening an existing one.

Signup and view all the flashcards

Get Help (in Office)

A feature within Office applications that allows you to search for assistance, find tutorials, and resolve errors.

Signup and view all the flashcards

Share Files (in Office)

Various options within Microsoft Office for distributing your files, including printing, sharing links, and saving to the cloud.

Signup and view all the flashcards

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

Print

  • 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.

Quiz Team

Related Documents

Microsoft Office 365 Excel 2019 Textbook PDF

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.

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser