All categories

3 years ago

Worksheet ranges can be turned For easy analysis

Computers and Technology

1 answer:

Firdavs [7]3 years ago

6 0

Answer:

Worksheet ranges is a group of cells, and a value range like 25 to 340. It is used for data modeling. Like you can use it in the vlookup, Hlookup and Xlookup for looking up a column cell value in the mentioned worksheet range. Different worksheet's ranges of cells can also be used, and in any number from throughout the workbook, and that makes the analysis quite easy. Through work sheet ranges we get the control over all the cells as well as cells group. Whatever analysis we do, we do on the list of cells. And through the worksheet ranges we get the control over the cells. And thus, this is extremely useful definitely.

Explanation:

Like one worksheet range can be from top left corner to the bottom right corner. And this assigns whole worksheet as the worksheet range.

Its used in almost all the Excel formulas, and you must know it.

An example is:

Worksheets("Sheet2").Range(Cells(2, "B"), Cells(35, "B")).select

This selects the Range B2:B35 from Sheet 2.

You might be interested in

How do you create a logo on Adobe illustrator

artcher [175]

Idk idk idk idk if dub

7 0

2 years ago

2) A ________ uses electronic memory and has no motors or moving parts. A) mechanical hard drive B) solid-state drive C) Blu-ray

grin007 [14]

Answer:

A.mechanical hard

Explanation:

brainliest me and follow ty

7 0

2 years ago

Why do software developers prefer to use high-level language to author programs?

Charra [1.4K]

Answer:

The answer to this question is given below in the explanation section

Explanation:

The correct answer to this question is: it used a more English-like syntax.

The software developer use high-level language to develop or author the program because it is more likely to English syntax and it would be easy for a software developer to author a program easily instead of using low level language and remembering ones and zeros.

Other options are not correct because:

It can be used on computers without microprocessors: Each computer has a microprocessor either you develop a program using high-level or low-level languages. Changes and modifications are easy in high-level language than in low-level languages. so, the option that prevents anyone from making changes to the software later is wrong. However, high-level languages are less complicated in learning and in authoring the programs but it does not use zeros and ones, it uses English-like syntax. So, the last option is also wrong.

4 0

2 years ago

What should every Software Engineer know about Software Architecture?

Alenkinab [10]

<span>!UML (all of them)
2.Flowchart (more for understanding a real world process of some kind; like a business process)
3.Data model including Bachman (if you don't need to at least understand your data, how it is stored versus a model, i.e., Bachman then you are doing it wrong and your schema could be simplistic)
This is 3 different examples</span>

6 0

2 years ago

What options are available for storing backups, physically?

RUDIKE [14]

The options are available for storing backups, physically are:

In both on site and off site,, a person can backup data to a given system that is located on-site, or the backups can be sent to any remote system that is off-site.

<h3>What is a backup?</h3>

This is known to be a device that helps to save information or data temporarily or permanently.

Note that in the above, The options are available for storing backups, physically are:

In both on site and off site,, a person can backup data to a given system that is located on-site, or the backups can be sent to any remote system that is off-site.

Learn more about backups from

brainly.com/question/17355457

#SPJ12

7 0

1 year ago