Give the following answers with respect to spreadsheet:
1. Cell A1 contains the
number 20 and B1 contains 3. What will
be the contents of cell C1, if the formula =A1+B1*2^3 is
entered in cell C1?
2. The contents of Cell A1, B1, C1 and D1 are 10, -20, 30 & -40
respectively. What will be the value displayed in cell E1 which
contains the formula =MIN (A1:01)
3. Cell D3 contains the formula =B3+C$3 and this formula is
copied to cell G3, what will be the copied formula in cell G3?
4. Cell D3 contains the formula =$B3 + C3 and this formula is
copied to cell E3, what will be the copied formula in cell E3?
5. What will you get the result from =Count(A1:A10) if Cell A1:
A10 are 10,15, a, x, 25, 32,55,A, 22,15
Answers
Answer:
1)44
2)-40
3)E3+F$3
4)$B3+F3
5)7
*HOPE IT HELPS*
if it helps u..mark me as brainliest..
1. The contents of cell C1 will be 44
2. The value displayed in cell E1 will be -40
3. The copied formula in cell G3 will be =E3+F$3
4. The copied formula in cell E3 will be =$B3+D3
5. The result we will get is 7
Let's correct the question as it has some mistakes
Give the following answers with respect to the spreadsheet:
1. Cell A1 contains the number 20 and B1 contains 3. What will
be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?
2. The contents of Cell A1, B1, C1, and D1 are 10, -20, 30 & -40 respectively. What will be the value displayed in cell E1 which contains the formula =MIN (A1:D1)
3. Cell D3 contains the formula =B3+C$3 and this formula is copied to cell G3, what will be the copied formula in cell G3?
4. Cell D3 contains the formula =$B3 + C3 and this formula is copied to cell E3, what will be the copied formula in cell E3?
5. What will you get the result from =COUNT(A1:A10) if Cell A1:
A10 are 10,15, a, x, 25, 32,55,A, 22,15
Explanation
1. In this, the formula present in cell C1 calculates the final value by taking contents from cells A1 and B1.
2. MIN functions display the smallest number from the given cells containing values or cell range having values. In this, the formula present in cell C1 displays the smallest number by checking the contents of cells A1, B1, C1, and D1.
3. When the same formula was entered in another cell i.e. G3 Excel understood the pattern and changed the addresses of the cells accordingly.
4. When the same formula was entered in another cell i.e. E3 Excel understood the pattern and changed the addresses of the cells accordingly.
5. COUNT function only counts the numeric values. So, in the range of A1 to A10 cell, there are 7 numeric values which is why the result is 7
Extra Information
In Excel, columns are named as A, B, C, D, E, F, and so on.
In Excel, rows are named as 1, 2, 3, 4, 5, 6, and so on.
Cells in an Excel sheet are made with intersections of rows and columns.
Cell Address is used to identify cell on an Excel Sheet and Cell Address comprises of a letter and a number. The letter shows the column and the number shows the row.
Example
A1
In this, it is the cell that is present in column A and row 1.
D6
In this, it is the cell that is present in column D and row 6.
Absolute Cell References
Absolute cell referencing helps us in keeping the cell references the same as it was in the cell from where we are copying. A dollar ($) sign is used to hold a column and/or row reference constant.
Example
$B1
It allows the row reference to change, but not the column reference.
C$1
It allows the column reference to change, but not the row reference.
$D$2
It allows neither the column nor the row reference to change.
Function is a predefined formula that allows users to perform mathematical, statistical, and logical operations.
There are various functions in Microsoft Excel some of them are:
1. SUM
2. AVERAGE
3. COUNT
4. IF
5. MAX
6. MIN
There are two formats by which you can apply Excel functions on cells.
1. Name of Function (Range of Cells i.e. Starting Cell : Ending Cell)
Example
=AVERAGE(A1:A3)
2. Name of Function (Each Cell Address separated with a comma(,))
Example
=AVERAGE(A1,A2,A3)
Example
Suppose you want to add values present in cells from A1 to A5 and display the sum in A6.
First, write the values in A1 to A5 and then click on A6 cell and type=SUM(A1:A5)
After that press "Enter"
In the A6 cell, you will get the sum of values present in cells from A1 to A5.
In case you have typed the wrong formula or want to modify it then you can click on the cell where you have written the formula and there will be a Formula Bar available above the worksheet area which will show the formula that you have written in the cell and you can edit it.