All categories

3 years ago

When would an absolute cell reference be most helpful?

Computers and Technology

2 answers:

Makovka662 [10]3 years ago

5 0

Answer:

Explanation:

Aliun [14]3 years ago

3 0

Answer:

The answer is : When there is a need to copy a formula and have the references update based on the new location

Explanation:

<em>I often use this function in any spreadsheet document. Imagine, you have thousands of data in a single sheet. And you inserted one row or column. Normally, you have to update EACH CELL's formula. Imagine the work load and the effort you need to exert. But when the single cell updates all the cell's reference, formula will be affected and you don't need to re update all the cells. It saves you time and effort and worries.</em>

You might be interested in

Assume the user types in 7 and 10. What is output by the following?

Marianna [84]

Answer:

Enter a number: 7

Enter a number: 10

Traceback (most recent call last):

File "main.py", line 3, in <module>

print (numi + num2)

NameError: name 'numi' is not defined

Explanation:

The typo in the print statement causes a run-time error, where obviously num1+num2 was expected, and an output of 17.

3 0

3 years ago

Which method adds 10 to the right end of the array?<br> myArray.<br> insert<br> (10)

vladimir1956 [14]

JavaScript has a set of mutator functions that allow you to modify the contents of an array without referencing the individual elements.To add to to myArray we us the push() method

<h3>Adding Elements to an Array</h3>

To add to to myArray we us the push() method

(10)

myArray.push(10)

There are two mutator functions for adding elements to an array: push() and unshift(). The push() function adds an element to the end of an array:

var nums = [1,2,3,4,5]; print(nums); // 1,2,3,4,5 nums.push(6);

print(nums); // 1,2,3,4,5,6

var nums = [1,2,3,4,5]; print(nums); // 1,2,3,4,5 nums[nums.length] = 6; print(nums); // 1,2,3,4,5,6

Learn more about arrays here:

brainly.com/question/24275089

6 0

2 years ago

A hacker corrupted the name:IP records held on the HOSTS file on a client, to divert traffic for a legitimate domain to a malici

balu736 [363]

The type of attack that the hacker performed is Domain Name System (DNS) server cache poisoning.

<h3>What is DNS poisoning?</h3>

In Domain Name System (DNS) server cache poisoning, the hackers often enter into a DNS server because they want to make an adjustment to its directory so that it can point the domain name users enter to a wrong, IP address.

Note that Domain Name Server (DNS) poisoning is a form of system attack in which there is the change of DNS records which are then used to redirect online traffic to a wrong website.

Learn more about hacker from

brainly.com/question/24956493

7 0

2 years ago

Suppose you are given a string containing only the characters ( and ). In this problem, you will write a function to determine w

Whitepunk [10]

Answer:

Code is completed below

Explanation:

Source Code in Java:

class Parenthesis

{

boolean hasBalancedParentheses(String eq) //method to check and return if a set of parenthesis is balanced or not

{

int count=0; //to store count of current unclosed opening brackets

for(int i=0;i<eq.length();i++)

{

if(eq.charAt(i)=='(')

count++;

else if(eq.charAt(i)==')')

count--;

if(count<0) //if count falls below zero, there were more closing brackets than opening brackets till this point

return false;

}

if(count>0) //if count is still more than zero, there were less closing brackets than opening brackets

return false;

return true; //if program reaches this point, it has passed all the tests

}

public static void main(String args[])

{

//testing the function

Parenthesis ob=new Parenthesis();

System.out.println(ob.hasBalancedParentheses("()(()())((())())"));

System.out.println(ob.hasBalancedParentheses(")((()())(()))())"));

}

8 0

3 years ago

Landslides often accompany earthquakes and volcanoes and pose an additional threat to humans after these events.

xxTIMURxx [149]

I think the answer is tur

5 0

3 years ago