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.

← How to calculate integers in code fragment Concerns for hp laptop owners after hidden keylogger discovery →