Which is the correct formula to add the values in cells A1 and B1? A. SUM(A1+B1) B. =SUM(A1+B1) C. =SUMA1+B1 D. A1+B1

Ask the user to type in an integer greater than 50 and assign it to a variable called x. Write a program to calculate the sum of

Zinaida [17]

Answer:

The solution in Python is as follows:

num = int(input("Number: "))

if num>50:

sum = 0

count = 0

for i in range(1,num):

count = count + 1

sum = sum + i**2

if sum > num:

sum = sum - i**2

count = count - 1

break;

print("Sum: "+str(sum))

print("Numbers: "+str(count))

else:

print("Number must be greater than 50")

Explanation:

The condition stated in the question do not conform with the example. The question says, the loop should stop when sum > x.

But:

When x = 100 and sum = 91, the program loop should not stop because 91 is not greater than 100.

However, I'll answer based on the example given in the question.

This prompts user for number

num = int(input("Number: "))

The following if condition is executed if number is greater than 50

if num>50:

This initializes sum to 0

sum = 0

This initializes count to 0

count = 0

The iterates through the inputted number (e.g. 100)

for i in range(1,num):

This increases the count

count = count + 1

This calculates the sum of square of the positive integer

sum = sum + i**2

The following removes excess number from the sum

if sum > num:

sum = sum - i**2

count = count - 1

break;

This prints the calculated sum

print("Sum: "+str(sum))

This prints the count of number used

print("Numbers: "+str(count))

The following is executed if user input is less than 50

else:

print("Number must be greater than 50")

3 0

3 years ago

What needs to be true of data used in consolidation

Dahasolnce [82]

Data consolidation is a collection and integration of data from multiple sources into a single destination.

Explanation:

Data consolidation allows you collect all your datas together from seperate worksheet into a master worksheet. Its function is to take data from a series of worksheet or workbooks and summaries it into a worksheet that can be updated easily.

During the process of data consolidation the different data sources are gathered together or consolidated into a single data source.

To consolidate first step is to open all files that contains data then ensure that data is organized in the same way and the third step is on the data ribbons select data tools and then consolidate. In the final step select the method of consolidation .

Consolidation is important strategically as the company looks to grow important share and market.

5 0

4 years ago

Which two statements are true about algorithms?

DENIUS [597]

Answer:

I. Algorithms can be written using pseudocode.

II. Algorithms can be visualized using flowcharts.

Explanation:

An algorithm can be defined as a standard formula or procedures which comprises of set of finite steps or instructions for solving a problem on a computer. The time complexity is a measure of the amount of time required by an algorithm to run till its completion of the task with respect to the length of the input.

The two statements which are true about algorithms are;

I. Algorithms can be written using pseudocode. A pseudocode refers to the description of the steps contained in an algorithm using a plain or natural language.

II. Algorithms can be visualized using flowcharts. A flowchart can be defined as a graphical representation of an algorithm for a process or workflow.

Basically, a flowchart make use of standard symbols such as arrows, rectangle, diamond and an oval to graphically represent the steps associated with a system, process or workflow sequentially i.e from the beginning (start) to the end (finish).

3 0

3 years ago

Read 2 more answers

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________

Ivanshal [37]

The answer is true. Data redundancies should be avoided, because redundancy of information or encoded data, may cause inconsistencies within the database itself and the system and also redundant information can consume a lot of storage space and will just waste it, which is why it is important to avoid data redundancy.

5 0

3 years ago

What is a common use for append queries?

Karo-lina-s [1.5K]

Answer:

You use an append query when you need to add new records to an existing table by using data from other sources. If you need to change data in an existing set of records, such as updating the value of a field, you can use an update query.

6 0

3 years ago

Read 2 more answers