FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
True or False:You can view a formula by double-clicking the cell that contains the formula.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The provided statement in the question is TRUE.

Detailed explanation-2: -Most formulas use at least one cell reference. When you double-click a formula, it will highlight all of the referenced cells. You can then double-check each one to make sure they are correct.

Detailed explanation-3: -You can also double-click a cell that contains a formula to see what cells it’s referencing. You can also switch to formula view, which will display all of the formulas in the spreadsheet.

Detailed explanation-4: -Navigation. To quickly navigate through a worksheet, use a double-click shortcut. Excel will select a cell in that row or column, moving in the direction that you clicked. It stops at the cell just before the first blank cell.

Detailed explanation-5: -Double click on that cell. Excel will open a new worksheet with the data relating to that cell. This is how you can use Excel double click to source!

There is 1 question to complete.