When you click the header & footer button on the insert tab, excel switches to _____ view.

Which of the following is not an excel function category? ____

You can ____ the chart title text to select it.

You can access the find and replace feature by pressing the ____ key(s).

You can apply the bold font style by pressing the ____ keyboard shortcut keys.

You can change, or ____, the contents of an active cell at any time.

Column A contains first names and Column B contains last names. What formula would output in the format 'Last, First' in cell C7?

Column A lists a long string (example:A3= 1234Smith1740.434.21) where the first four digits are the employee number. What formula in B3 will extract only the employee number from the string in cell A3?

Which formula allows the retrieval of information in any relative direction?

When you assign a password to a worksheet, what are the rules or restrictions for what the password can be?

Which feature quickly copies and adjusts a formula down a column or across a row?