What is the meaning of the FN key and what is its Function

Assume values 10, 20, 30, and 40 are entered in the cell range A1:A4. Cell A10 contains the formula: =A1+A2+A3+A4 and displays v

r-ruslan [8.4K]

Answer:

The formula and value to this question is "=A1+A3+A4+A5 with value 100"

Explanation:

The explanation of the given question as follows:

In question, it is defined that four cells that are "A1, A2, A3, and A4" contains value that are "10, 20, 30, and 40".
To add these values we use addition formula that is "=A1+A2+A3+A4". it will give value 100.
If the user inserts a new row that is "A2" and assigns a value in the cell that is "50" so, we use the above formula that adds values with these values we also use the value "100".

8 0

3 years ago

"Write an iterative function iterPower(base, exp) that calculates the exponential baseexp by simply using successive multiplicat

sp2606 [1]

Answer:

I am writing the function using Python. Let me know if you want the program in some other programming language.

def iterPower(base, exp):

baseexp = 1

while exp > 0:

baseexp = baseexp*base

exp= exp - 1

return baseexp

base = 3

exp = 2

print(iterPower(base, exp))

Explanation:

The function name is iterPower which takes two parameters base and exp. base variable here is the number which is being multiplied and this number is multiplied exponential times which is specified in exp variable.
baseexp is a variable that stores the result and then returns the result of successive multiplication.
while loop body keeps executing until the value of exp is greater than 0. So it will keep doing successive multiplication of the base, exp times until value of exp becomes 0.
The baseexp keeps storing the multiplication of the base and exp keeps decrements by 1 at each iteration until it becomes 0 which will break the loop and the result of successive multiplication stored in baseexp will be displayed in the output.
Here we gave the value of 3 to base and 2 to exp and then print(iterPower(base, exp)) statement calls the iterPower function which calculates the exponential of these given values.
Lets see how each iteration works:

1st iteration

baseexp = 1

exp>0 True because exp=2 which is greater than 0

baseexp = baseexp*base

= 1*3 = 3

So baseexp = 3

exp = exp - 1

= 2 - 1 = 1

exp = 1

2nd iteration

baseexp = 3

exp>0 True because exp=1 which is greater than 0

baseexp = baseexp*base

= 3*3 = 9

So baseexp = 9

exp = exp - 1

= 1-1 = 0

exp = 0

Here the loop will break now when it reaches third iteration because value of exp is 0 and the loop condition evaluates to false now.
return baseexp statement will return the value stored in baseexp which is 9
So the output of the above program is 9.

5 0

3 years ago

A cell's address, its position in the workbook, is referred to as a ________________ when it is used in a formula.

Inga [223]

Answer:

A cell's address, its position in the workbook, is referred to as a cell reference when it is used in a formula.

5 0

2 years ago

To reduce the number of used digital outputs of the microcontroller, the display board is connected to the main board through th

Luda [366]

Answer:

The program in Python is as follows:

BCD = ["0001","0010","0011","0100","0101","0110","0111"]

num = input("Decimal: ")

BCDValue = ""

valid = True

for i in range(len(num)):

if num[i].isdigit():

if(int(num[i])>= 0 and int(num[i])<8):

BCDValue += BCD[i]+" "

else:

valid = False

break;

else:

valid = False

break;

if(valid):

print(BCDValue)

else:

print("Invalid")

Explanation:

This initializes the BCD corresponding value of the decimal number to a list

BCD = ["0001","0010","0011","0100","0101","0110","0111"]

This gets input for a decimal number

num = input("Decimal: ")

This initializes the required output (i.e. BCD value) to an empty string

BCDValue = ""

This initializes valid input to True (Boolean)

valid = True

This iterates through the input string

for i in range(len(num)):

This checks if each character of the string is a number

if num[i].isdigit():

If yes, it checks if the number ranges from 0 to 7 (inclusive)

if(int(num[i])>= 0 and int(num[i])<8):

If yes, the corresponding BCD value is calculated

BCDValue += BCD[i]+" "

else:

If otherwise, then the input string is invalid and the loop is exited

valid = False

break;

If otherwise, then the input string is invalid and the loop is exited

else:

valid = False

break;

If valid is True, then the BCD value is printed

if(valid):

print(BCDValue)

If otherwise, it prints Invalid

else:

print("Invalid")

7 0

3 years ago

When utilizing the Internet Storage Name Service (iSNS), how can you limit which targets iSCSI initiators can discover and conne

Sati [7]

Answer:

You can limit by devices IQN, DNS name, MAC address, IP address

Explanation:

When you configure an iSCSI target, you define which iSCSI initiators can connect to an iSNSI by the client's IQN. You can also specify which servers can connect to the iSCSI target based on MAC addresses, IP address, and DNS name.

6 0

3 years ago