Excel Shortcuts and Features
7 Questions
100 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

Which shortcuts can you use for Undo and Redo?

  • Ctrl+z for undo and ctrl+y for redo (correct)
  • Ctrl+x for cut
  • Ctrl+s for save
  • Ctrl+c for copy
  • What statement is accurate in regards to sharing workbooks?

    You must add the feature to the Quick Access Toolbar

    How can you access Track Changes in Microsoft Excel Office 365?

    Track Changes is located under the Customize Quick Access Toolbar

    How do most people think of Excel?

    <p>as a spreadsheet</p> Signup and view all the answers

    What does it mean that the right mouse button is context sensitive?

    <p>The menu items available will differ depending on the context of what you are right clicking</p> Signup and view all the answers

    You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list?

    <p>Regions</p> Signup and view all the answers

    You hide three worksheets in a workbook and need to unhide them. What is an accurate statement about this process?

    <p>You must unhide each worksheet separately</p> Signup and view all the answers

    Study Notes

    Excel Shortcuts

    • Use Ctrl + Z to undo actions.
    • Use Ctrl + Y to redo actions.

    Sharing Workbooks

    • To share workbooks effectively, add the Share feature to the Quick Access Toolbar.

    Track Changes

    • Track Changes can be accessed by customizing the Quick Access Toolbar in Excel Office 365.

    Common Perception of Excel

    • Most users perceive Excel primarily as a spreadsheet application.

    Context-Sensitive Menus

    • The right mouse button provides context-sensitive menus, meaning available options change based on what is being clicked.

    Pivot Tables

    • In Pivot Tables, you will find Regions listed among the Fields options.

    Unhiding Worksheets

    • To unhide hidden worksheets, you must perform the action for each worksheet separately, as they cannot be unhid all at once.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Test your knowledge of essential Excel shortcuts and features, including workbook sharing and track changes. This quiz covers practical tips and common perceptions regarding Excel functions. Enhance your proficiency in using Excel effectively!

    More Like This

    Excel Shortcuts and Functions Quiz
    5 questions
    Microsoft Excel Shortcuts
    24 questions
    Excel Shortcuts Quiz
    10 questions
    MS Excel Shortcuts and Concepts
    19 questions
    Use Quizgecko on...
    Browser
    Browser