FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you insert a formula by clicking the AutoSum button, Excel first looks ____ the active cell for a range of cells containing numbers.
A
to the right of
B
below
C
to the left of
D
above
Explanation: 

Detailed explanation-1: -When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Detailed explanation-2: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells. A spreadsheet formula is a mathematical equation that will calculate a result.

Detailed explanation-3: -You can change the active cell by clicking any other cell with your left mouse button or with the arrow keys on your keyboard to move the selected cell. If the cell contains no data, you can begin typing to insert new data into that cell.

Detailed explanation-4: -An active cell is simply a rectangular box that highlights the cell in a spreadsheet. It helps us to identify the cell that we are currently working on, where data is being entered. An active cell is also referred to as cell pointer, current cell or selected cell.

There is 1 question to complete.
Previous
Next