All categories

3 years ago

Spreadshet formula to add totals

Computers and Technology

1 answer:

frozen [14]3 years ago

7 0

Answer:

=SUM(Range value)

like =SUM(A1:A7) or =SUM(A1:H1)

Explanation:

We need to make use of the SUM function, and then we need to mention the cells or range value that references a series of cells row-wise or column-wise. Like a range value of A1:A7 means A1,A2,A3,A4,A5,A6,A7 and the range value of A1:H1 means A1, B1,C1,D1,E1,F1,G1,H1. And similarly, you can represent various cells depending upon the code you come up it, and finally, you need to sum them all using the SUM function.

You might be interested in

Construct a SQL query that displays a list of colleges, their sity/state, the accrediting agency, and whether or not the school

Alex787 [66]

Answer:

SELECT college, city_state, accre_agency, distance LIMIT 10

Explanation:

Given

Table name: College

See attachment for table

Required

Retrieve top 10 college, state, agency and school distance from the table

To retrieve from a table, we make use of the SELECT query

The select statement is then followed by the columns to be selected (separated by comma (,))

So, we have:

SELECT college, city_state, accre_agency, distance

From the question, we are to select only first 10 records.

This is achieved using the LIMIT clause

i.e. LIMIT 10 for first 10

So, the complete query is:

SELECT college, city_state, accre_agency, distance LIMIT 10

6 0

3 years ago

What is the purpose of an IP address? A. identifying source and destination of data B. creating images on websites C. drawing ta

natka813 [3]

Answer:

The Answer is A. I could be wrong though.

3 0

3 years ago

Read 2 more answers

Layer 4 security and application services, including server load balancing, Secure Sockets Layer (SSL) offloading, firewalling,

Fittoniya [83]

Answer:

Layer 4 security and application services, including server load balancing, Secure Sockets Layer (SSL) offloading, firewalling, and intrusion prevention system (IPS) services are provided by the data center <u>aggregation</u> layer.

Explanation:

Consider the given information.

A key point for security and application services is the aggregation layer. In the data centre aggregation layer, the Layer 4 security and application services provide server load balancing, SSL offloading, firewalling, and IPS services.

7 0

3 years ago

George has a set of software programs installed on his computer to create a digital portfolio. He is not sure what each program

d1i1m1o1n [39]

Explanation:

I thinkcreating and edditing Images matchs to adobePhotoshop

Microsoft word is for adding and Creating text document

Creating andeditingpage layout -Adobe In Design

Desktop Publication-QuarkQuark Xpress

I hope thishelp and If wrong Inform me

Good luck

8 0

3 years ago

Read 2 more answers

Select two netiquette guidelines. In three to five sentences, explain why these guidelines make professional online communicatio

abruzzese [7]

"Avoiding sarcasm" and "using appropriate language" make professional online communication more effective. Not all people immediately understand one's sarcasm especially someone you recently knew. They may misinterpret the message you're giving so better say something straightforward to make yourself clear. A place where people can easily gather, the internet can make people against you if you're displaying rude and foul comments. Failure to communicate will then follow. If you follow these two guidelines, you're going to be saved from all the troubles.

8 0

3 years ago

Spreadshet formula to add totals​

Spreadshet formula to add totals