USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Before submitting a worksheet full of accounting formulas to his boss, Ken wants to make sure that he has entered all of the formulas correctly. There are a lot of them. What is the easiest way to perform this check?
|
|
Set the options for the worksheet to show the formula in every cell instead of the calculated results.
|
|
|
Click on each formula in the worksheet in succession and read the formula input in the formula bar.
|
|
|
Print the worksheet, then perform each mathematical operation in the worksheet on a calculator and compare the answers.
|
|
|
Set the options for the worksheet to check each formula as it is entered.
|
Explanation:
Detailed explanation-1: -In general, Excel’s order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet. First, any expressions in parentheses are evaluated.
Detailed explanation-2: -Press and hold the Shift key on the keyboard. Press and release the F11 key. Release the Shift key. A new worksheet is inserted into the current workbook to the left of all existing worksheets.
There is 1 question to complete.