Question

Which function will you use in the given situations? 1. To add the numbers in a given range of cells. 2. To calculate the average value. 3. To count the number of cells with values in it. 4. To show the current date. 5. To calculate the number of characters in a text string.

Answer 1

Answer:

You can use Microsoft excel

Answer 2

Answer:

1-The SUM function

2-click the arrow next to AutoSum , click Average, and then press Enter.

3-Select a blank cell that you want the counting result showing in. 2. Copy and paste the formula =COUNTA(A1:D15)-COUNT(A1:D15) into the Formula Bar and then press the Enter key. Then you can see the total cell number showing in the selected cell.

4-To insert the current date, press Ctrl+; (semi-colon)

5-To use the function, enter =LEN(cell) in the formula bar and press Enter. In these examples, cell is the cell you want to count, such as B1. To count the characters in more than one cell, enter the formula, and then copy and paste the formula to other cells.

Step-by-step explanation: