Ask question

Ask question

All categories

2 years ago

7

In Microsoft Excel, you have data to enter in cells A1 through A250. You need a function that adds all of these cells together.

What is one way to write formula to achieve this?

Computers and Technology

1 answer:

UkoKoshka [18]2 years ago

6 0

Answer:

So you have to highlight all the cells that you want to sum up then click Insert Then SUM.

Explanation:

You might be interested in

Write a loop that outputs the numbers in a list named salaries. The outputs should be formatted in a column that is right-justif

GalinKa [24]

Answer:

Following is the loop statement in the Python programming language

salaries=[93.85967,4232.32,13343.3434] #storing the values in salaries

for k in salaries:#iterating the loop

print("%12f"%round(k,2))# print the width of 12 and a precision of 2

Output:

93.860000

4232.320000

13343.340000

Explanation:

Following is the description of the statement

Declared a dictionary "salaries" and initialized some values into it.

iterating the for a loop .

In this for loop print the width 12 and a precision of 2 .The print statement in python will

print the data with width 12 and a precision of 2 in the console window

7 0

2 years ago

The vast amount of data collected from Internet searches, social media posts, customer transactions, military

Brums [2.3K]

Answer:

A. Big Data

Explanation:

It is big data. The internet searches, customer transactions, social media posts, medical tests, weather sensors, military surveillance, and all the data source you are seeing around yourself forms together with the big data. And a big social media company gathers around so many petabytes of data each day. And there are so many such companies, plus all sorts like eLearning sites, etc. And all these together form the big data.

3 0

2 years ago

A 'array palindrome' is an array which, when its elements are reversed, remains the same (i.e., the elements of the array are sa

muminat

The code below is used to determine a recursive, bool-valued function, isPalindrome, that accepts an integer-valued array, and the number of elements and returns whether the array is a palindrome.

Explanation:

The code shows 'array palindrome' is an array which, when its elements are reversed, remains the same.

bool isPalindrome(arr[((n-1) - n) +1], n)

{

if (n == 0 || n == 1)

{

return true;

}

else if (arr[n-1] == isPalindrome(arr[], n-1)

{

return true;

}

else {

return false;

}

}

5 0

2 years ago

Write a public static method named printArray, that takes two arguments. The first argument is an Array of int and the second ar

Serjik [45]

Answer:

Written in Java

public static void printArray(int myarr[], String s){

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

System.out.print(myarr[i]+s);

}

}

Explanation:

This defines the static method alongside the array and the string variable

public static void printArray(int myarr[], String s){

The following iteration iterates through the elements of the array

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

This line prints each element of the array followed by the string literal

System.out.print(myarr[i]+s);

}

}

The method can be called from main using:

<em>printArray(myarr,s);</em>

Where myarr and s are local variables of the main

5 0

2 years ago

Referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relation

Jet001 [13]

Answer:

a) true

Explanation:

In Computer programming, integrity constraints can be defined as a set of standard rules that ensures quality information and database are maintained.

Basically, there are four (4) types of integrity constraints and these are;

1. Key constraints.

2. Domain constraints.

3. Entity integrity constraints.

4. Referential integrity constraints.

Referential integrity is a property of data which states that each foreign key value must match a primary key value in another relation or the foreign key value must be null.

For instance, when a foreign key in Table A points to the primary key of Table B, according to the referential integrity constraints, all the value of the foreign key in Table A must be null or match the primary key in Table B.

Hence, the referential Integrity constraints ensures that the relationship between the data in a table is consistent and valid.

Hence, referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relationships.

<em>This ultimately implies that, referential Integrity are rules used in database management systems (DBMS) to ensure relationships between tables when records are changed is VALID (INSERT and UPDATE).</em>

<em>In a nutshell, it always ensures a primary key must have a matching foreign key or it becomes null. </em>

6 0

2 years ago