Excel Program Window Components Quiz
30 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

How does Excel indicate that a cell is current?

  • The cell cursor appears in the cell with a red border.
  • The cell cursor appears in the cell with a blue border.
  • The cell cursor appears in the cell with a dark green border. (correct)
  • The cell cursor appears outside the cell.
  • What is one way to move the cell cursor in Excel?

  • Clicking the Name box
  • Clicking the desired cell (correct)
  • Pressing the Tab key
  • Typing in bold letters
  • What happens if a cell is not displayed within the section visible in the Worksheet area?

  • Excel will display an error code.
  • The cell cannot be selected.
  • Excel will display a warning message.
  • The sheet will automatically scroll to that cell. (correct)
  • How can you move the cell cursor to a desired cell using the Go To dialog box?

    <p>Press F5, type the address, and click OK</p> Signup and view all the answers

    In Excel, what indicates the column letter(s) and row number of the current cell?

    <p>Shaded column headings and row headings</p> Signup and view all the answers

    What is another term used for the dark green border around a current cell?

    <p>Selection border</p> Signup and view all the answers

    What is the purpose of the 'Don't Save' button in Excel 2019?

    <p>To abandon the workbook without saving any changes</p> Signup and view all the answers

    Why is it important to enable 'Touch mode' when using Excel 2019 on a touchscreen device?

    <p>To separate the 'Close' button from the 'Restore Down' button to prevent accidental exits</p> Signup and view all the answers

    What is the purpose of the 'Help' tab on the Ribbon in Excel 2019?

    <p>To provide access to Excel's online documentation and video tutorials</p> Signup and view all the answers

    Which keyboard shortcut can be used to open the Help task pane in Excel 2019?

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

    What is the purpose of the 'Customizing the Quick Access toolbar' section mentioned in the text?

    <p>To provide instructions for customizing the buttons and commands on the Quick Access toolbar</p> Signup and view all the answers

    What is the purpose of the phrase '(For detailed information on saving documents, see Chapter 2.)' at the beginning of the text?

    <p>To direct the reader to another chapter for more information on saving documents</p> Signup and view all the answers

    What is the function of the File button in the Excel program window?

    <p>It opens the Backstage view containing document and file-related commands</p> Signup and view all the answers

    Which of the following is NOT a component of the Backstage view in Excel?

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

    What is the purpose of the Quick Access toolbar in the Excel program window?

    <p>It contains buttons for common tasks, such as saving and undoing edits</p> Signup and view all the answers

    What is the function of the AutoSave button in the Excel program window?

    <p>It saves the workbook file automatically at regular intervals</p> Signup and view all the answers

    What is the purpose of the Ribbon in the Excel program window?

    <p>It consists of a series of tabs containing the bulk of Excel's features and commands</p> Signup and view all the answers

    Which component of the Excel program window displays the address and contents of the current cell?

    <p>Formula bar</p> Signup and view all the answers

    What is the easiest method for selecting commands on the Ribbon if you know your keyboard well?

    <p>Press the Alt key and then type the letter of the hot key for the desired tab</p> Signup and view all the answers

    What does Excel do when you press the Alt key and type the letter of a tab you want to select?

    <p>Display all the command button hot keys next to their buttons</p> Signup and view all the answers

    What can be used as a shortcut to copy a cell selection to the Windows Clipboard?

    <p>Ctrl+C</p> Signup and view all the answers

    What happens in Touch mode in Excel 2019?

    <p>The command buttons on Ribbon tabs are spread out with more space around them</p> Signup and view all the answers

    Which method allows users to access old Excel shortcut keys from versions prior to Excel 2007?

    <p>Type Alt key followed by the hot key letters</p> Signup and view all the answers

    What does Excel do after displaying all command button hot keys next to their buttons?

    <p>Along with hot keys for Dialog Box launchers in any group on that tab</p> Signup and view all the answers

    What is the purpose of the Backspace key on the standard Windows Touch keyboard?

    <p>To delete characters to the left when entering or editing a cell entry</p> Signup and view all the answers

    What does the Enter key do on the standard Windows Touch keyboard?

    <p>Completes the entry in the current cell and moves the cursor down one row in the same column</p> Signup and view all the answers

    What is the purpose of the Shift keys on the standard Windows Touch keyboard?

    <p>To enter capital letters in a cell entry</p> Signup and view all the answers

    How do you switch to the numeric keyboard on the standard Windows Touch keyboard?

    <p>By pressing the Numeric key (marked with &amp;123)</p> Signup and view all the answers

    What is the purpose of the Ctrl key on the standard Windows Touch keyboard?

    <p>To run macros to which letter keys have been assigned, or to move the cursor to the first or last column</p> Signup and view all the answers

    How do you switch to a display of emoticons on the standard Windows Touch keyboard?

    <p>By pressing the Emoticon key (with a smiley face icon)</p> Signup and view all the answers

    More Like This

    Excel Spreadsheet Program
    6 questions
    Excel Program Basics
    5 questions

    Excel Program Basics

    DurableBromine avatar
    DurableBromine
    SimNet Program Exam Flashcards
    15 questions
    Use Quizgecko on...
    Browser
    Browser