FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

The LEFT and MID functions are fully interchangeable. In other words, can you always use the LEFT function instead of MID, as well as using MID instead of LEFT?

A	True
B	False
C	Either A or B
D	None of the above

Explanation:

Detailed explanation-1: -The order of operations is a rule that tells the correct sequence of steps for evaluating a math expression. We can remember the order using PEMDAS: Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right).

Detailed explanation-2: -Which type of cell address will be adjusted in the new location based on the relative position of the original formula’s input cells? A revolving cell address.

Detailed explanation-3: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.

Detailed explanation-4: -SUBTRACT() is not a valid function in MS Excel. Subtract two or more numbers in a cell: 1. Click any blank cell, and then type an equal sign (=) to start the formula.

There is 1 question to complete.