FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Unless you first select a range of cells or an object before starting the spell checker, Excel checks the entire selected worksheet, including all cell values, cell comments, embedded charts, text boxes, buttons, and headers and footers.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Detailed explanation-2: -Correct spelling as you type Here’s how to use it: Click File > Options. Under the Proofing category, click AutoCorrect Options, and check the most likely typing errors.

Detailed explanation-3: -Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column.

Detailed explanation-4: -To check spelling in all the sheets of the current workbook, right click on any sheet tab and pick Select all Sheets from the context menu. With all the sheets selected, press F7 or click the Spelling button on the ribbon. Yep, it’s that easy!

There is 1 question to complete.
Previous
Next