Excel Shortcuts and Features
7 Questions
100 Views

Excel Shortcuts and Features

Created by
@PromisingStonehenge

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 Quizzes Like This

    Microsoft Excel Shortcuts
    24 questions
    Excel Functions and Shortcuts Quiz
    20 questions

    Excel Functions and Shortcuts Quiz

    SucceedingLapisLazuli2023 avatar
    SucceedingLapisLazuli2023
    Excel Shortcuts Quiz for IT Students
    5 questions

    Excel Shortcuts Quiz for IT Students

    TriumphalCharacterization avatar
    TriumphalCharacterization
    Use Quizgecko on...
    Browser
    Browser