FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

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: -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-2: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

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: -When you enter data into a cell in Excel, that cell becomes the active cell. The active cell is the one that has the blinking cursor in it. You can move to a different cell by using the arrow keys on your keyboard, or by clicking in a different cell with your mouse.

There is 1 question to complete.