All categories

2 years ago

Pick the correct statements regarding cell references.

Computers and Technology

2 answers:

shusha [124]2 years ago

7 0

Statement two and three is correct.

Statement 1 is incorrect. A relative reference changes when a formula is copied to another cell while Absolute references remain constant. However, it is safe to say that an absolute address can be preceded by a $ sign before both the row and the column values. It is designated by the addition of a dollar sign either before the column reference, the row reference, or both. Statement C is also correct. A mixed reference is a combination of relative and absolute reference and the formula (= A1 + $B$2) is an example of a mixed cell reference.

Lady_Fox [76]2 years ago

3 0

Answer:

1) A relative reference will retain its references when copied to another cell.

2) An absolute address has a $ sign before both the row and the column values.

3) = A1 + $B$2 is an example of a mixed cell reference.

4) The address 7B is invalid.

Explanation:

We know that a call by reference method can be defined as a method of providing different arguments to a function and then that function copies the address of an argument into the formal pattern.

You might be interested in

A computer application such as Microsoft Access that is used to store data and convert it into information is a ________________

lorasvet [3.4K]

All data is stored in table

5 0

2 years ago

An author is preparing to send their book to a publisher as an email attachment. The file on their computer is 1000 bytes. When

Yakvenalex [24]

Answer:

See explanation

Explanation:

My explanation to the author is that:

The reduction in size of the attachment doesn't mean that some parts of the book (i.e. the attachment) has been deleted.

I'll also made him understand that the book will retain its original size and contents after downloading by the recipient of the mail.

6 0

2 years ago

Which statement below correctly differentiates between frames and bits? Frames have more information in them than bits. Frames a

9966 [12]

Frames have more information in them than bits.

Frames are made up of bits but not vice versa.

A bit (BInary digiT) is the basic unit of digital. It can be 0 (logical false, off) or 1 (not logical false - true, on). Four bits are in a nybble, which can have a value of 0 - 15, eight bits are in a byte which can have a value of 0 - 255. Words vary in size, they consist of multiple bytes and are generally correlated with the system's data bus/processor data width (a 64 bit system has an 8 byte word).

5 0

2 years ago

Read 2 more answers

What is one major structural difference between a decision structure (such as a decoder) and a storage structure (such as an RS

Andrej [43]

Answer:

B. The storage structure requires a clock input.

Explanation:

Logic circuits are circuits in electronics that give output based on the logic gate principle and its inputs. It can be a sequential logic circuit or a combinational logic circuit.

Decoders RS latches are combinational logic circuits because they both comprise of a combination of several sequential circuits to make their systems. The difference between decoders and RS latches is that the RS is a storage structure which is made up of flip-flops which require a clock input

8 0

1 year ago

Write two methods: encrypt and decrypt. encrypt should #take as input a string, and return an encrypted version #of it according

Harman [31]

Answer:

The code is given below with appropriate comments

Explanation:

CIPHER = (("D", "A", "V", "I", "O"),

("Y", "N", "E", "R", "B"),

("C", "F", "G", "H", "K"),

("L", "M", "P", "Q", "S"),

("T", "U", "W", "X", "Z"))

# Add your code here!

def encrypt(plaintext):

theList = []

for char in plaintext:

if char.isalpha():

char = char.upper()

if char == "J":

char = "I"

theList.append(char)

if len(theList) % 2 == 1:

theList.append("X")

for i in range(0, len(theList), 2):

if theList[i] == theList[i + 1]:

theList[i + 1] = "X"

findex = [-1, -1]

sindex = [-1, -1]

for j in range(len(CIPHER)):

for k in range(len(CIPHER)):

if theList[i] == CIPHER[j][k]:

findex = [j, k]

if theList[i + 1] == CIPHER[j][k]:

sindex = [j, k]

# same row

if (findex[0] == sindex[0]):

findex[1] += 1

sindex[1] += 1

if findex[1] == 5:

findex[1] = 0

if sindex[1] == 5:

sindex[1] = 0

theList[i] = CIPHER[findex[0]][findex[1]]

theList[i + 1] = CIPHER[sindex[0]][sindex[1]]

# same column

elif (findex[1] == sindex[1]):

findex[0] += 1

sindex[0] += 1

if findex[0] == 5:

findex[0] = 0

if sindex[0] == 5:

sindex[0] = 0

theList[i] = CIPHER[findex[0]][findex[1]]

theList[i + 1] = CIPHER[sindex[0]][sindex[1]]

else:

theList[i] = CIPHER[findex[0]][sindex[1]]

theList[i + 1] = CIPHER[sindex[0]][findex[1]]

return "".join(theList)

def decrypt(ciphertext):

theString = ""

findex = [-1, -1]

sindex = [-1, -1]

for i in range(0, len(ciphertext), 2):

for j in range(len(CIPHER)):

for k in range(len(CIPHER)):

if ciphertext[i] == CIPHER[j][k]:

findex = [j, k]

if ciphertext[i + 1] == CIPHER[j][k]:

sindex = [j, k]

if (findex[0] == sindex[0]):

findex[1] -= 1

sindex[1] -= 1

if findex[1] == -1:

findex[1] = 4

if sindex[1] == -1:

sindex[1] = 4

theString += CIPHER[findex[0]][findex[1]]

theString += CIPHER[sindex[0]][sindex[1]]

# same column

elif (findex[1] == sindex[1]):

findex[0] -= 1

sindex[0] -= 1

if findex[0] == -1:

findex[0] = 4

if sindex[0] == -1:

sindex[0] = 4

theString += CIPHER[findex[0]][findex[1]]

theString += CIPHER[sindex[0]][sindex[1]]

else:

theString += CIPHER[findex[0]][sindex[1]]

theString += CIPHER[sindex[0]][findex[1]]

return theString

# Below are some lines of code that will test your function.

# You can change the value of the variable(s) to test your

# function with different inputs.

# If your function works correctly, this will originally

# print: QLGRQTVZIBTYQZ, then PSHELXOWORLDSX

print(encrypt("PS. Hello, worlds"))

print(decrypt("QLGRQTVZIBTYQZ"))

5 0

2 years ago