Computer Keyboard Functions in Excel
Which combination of options is the keyboard shortcut to access the Find dialog box and search a worksheet for particular values?
- Ctrl+F
In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?
- Quick Access tool bar
Donte needs to print specific sections in the workbook, as opposed to the entire workbook. Which feature should he use?
- Print Area
Which keyboard shortcut will create a hyperlink in an Excel document?
- Ctrl+K
Which key(s) will launch the Spelling Checker dialog box?
- F2
Which character will always precede an Excel formula?
- !
Where are commonly accessed commands located by default in Excel 2016?
- Quick Access tool bar
Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?
- The worksheets that are hidden will retain data, but references to those worksheets will no longer function.
Which setting is used to determine the order of printing pages?
- Collation Settings
Answer: Ctrl+F
Quick Access toolbar
Print area
Ctrl+K
F2
!
Quick access tool bar
Collation Settings
Keyboard functions
A computer keyboard is an input device used to enter functions and characters into the computer system by pressing buttons or keys.
The main function of the keyboard is to operate the computer by sending it information/data.
Therefore, the correct answers are options Ctrl+F, Quick Access toolbar, Print area, Ctrl+K, F2, !, Quick Access toolbar, Collation Settings.