FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
____ are entries that have equations that calculate values
A
Labels
B
Constants
C
Spreadsheets
D
Formulas
Explanation: 

Detailed explanation-1: -Formulas are entries in Excel that have equations, by which values are calculated. A typical formula might contain cell references, constants, and even functions.

Detailed explanation-2: -Ture or falsea) formula are entries that have an equation that calculates the variety to display. [ ] b) a cell reference refers to a cell or a range of cells on a insert tab. [ ]

Detailed explanation-3: -Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.

Detailed explanation-4: -Formulas are equations that perform calculations on values in our worksheet.

Detailed explanation-5: -To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3.

There is 1 question to complete.