30 Questions
How does Excel indicate that a cell is current?
The cell cursor appears in the cell with a dark green border.
What is one way to move the cell cursor in Excel?
Clicking the desired cell
What happens if a cell is not displayed within the section visible in the Worksheet area?
The sheet will automatically scroll to that cell.
How can you move the cell cursor to a desired cell using the Go To dialog box?
Press F5, type the address, and click OK
In Excel, what indicates the column letter(s) and row number of the current cell?
Shaded column headings and row headings
What is another term used for the dark green border around a current cell?
Selection border
What is the purpose of the 'Don't Save' button in Excel 2019?
To abandon the workbook without saving any changes
Why is it important to enable 'Touch mode' when using Excel 2019 on a touchscreen device?
To separate the 'Close' button from the 'Restore Down' button to prevent accidental exits
What is the purpose of the 'Help' tab on the Ribbon in Excel 2019?
To provide access to Excel's online documentation and video tutorials
Which keyboard shortcut can be used to open the Help task pane in Excel 2019?
F1
What is the purpose of the 'Customizing the Quick Access toolbar' section mentioned in the text?
To provide instructions for customizing the buttons and commands on the Quick Access toolbar
What is the purpose of the phrase '(For detailed information on saving documents, see Chapter 2.)' at the beginning of the text?
To direct the reader to another chapter for more information on saving documents
What is the function of the File button in the Excel program window?
It opens the Backstage view containing document and file-related commands
Which of the following is NOT a component of the Backstage view in Excel?
Undo
What is the purpose of the Quick Access toolbar in the Excel program window?
It contains buttons for common tasks, such as saving and undoing edits
What is the function of the AutoSave button in the Excel program window?
It saves the workbook file automatically at regular intervals
What is the purpose of the Ribbon in the Excel program window?
It consists of a series of tabs containing the bulk of Excel's features and commands
Which component of the Excel program window displays the address and contents of the current cell?
Formula bar
What is the easiest method for selecting commands on the Ribbon if you know your keyboard well?
Press the Alt key and then type the letter of the hot key for the desired tab
What does Excel do when you press the Alt key and type the letter of a tab you want to select?
Display all the command button hot keys next to their buttons
What can be used as a shortcut to copy a cell selection to the Windows Clipboard?
Ctrl+C
What happens in Touch mode in Excel 2019?
The command buttons on Ribbon tabs are spread out with more space around them
Which method allows users to access old Excel shortcut keys from versions prior to Excel 2007?
Type Alt key followed by the hot key letters
What does Excel do after displaying all command button hot keys next to their buttons?
Along with hot keys for Dialog Box launchers in any group on that tab
What is the purpose of the Backspace key on the standard Windows Touch keyboard?
To delete characters to the left when entering or editing a cell entry
What does the Enter key do on the standard Windows Touch keyboard?
Completes the entry in the current cell and moves the cursor down one row in the same column
What is the purpose of the Shift keys on the standard Windows Touch keyboard?
To enter capital letters in a cell entry
How do you switch to the numeric keyboard on the standard Windows Touch keyboard?
By pressing the Numeric key (marked with &123)
What is the purpose of the Ctrl key on the standard Windows Touch keyboard?
To run macros to which letter keys have been assigned, or to move the cursor to the first or last column
How do you switch to a display of emoticons on the standard Windows Touch keyboard?
By pressing the Emoticon key (with a smiley face icon)
Test your knowledge of the components found in the Excel program window, including the File button, Backstage view, Account option, and Options item. See how well you understand these essential elements of Excel's user interface.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free