All categories

3 years ago

Find the cell address of first column and last row some one pls answer :'(

Computers and Technology

1 answer:

weeeeeb [17]3 years ago

8 0

Answer:

To get the address of the first cell in a named range, you can use the address function together with row and column functions, and to get the address of the last cell in a range, you can use the address function together with row, column, and max functions.

Hope this helps

Explanation:

You might be interested in

The superclass Calculator contains: a protected double instance variable, accumulator, that contains the current value of the ca

yawa3891 [41]

Answer:

The following program are written in JAVA Programming Language.

//inherit the Calculator class

public class CalculatorWithMemory extends Calculator {

private double memory = 0.0; //initialize double type variable

public void save() { //define function

memory = accumulator;

}

public void recall() { //define function

accumulator = memory;

}

public void clearMemory() { //define function

memory = 0; //initialize the value

}

public double getMemory() {

return memory; // return the value in "memory" variable

}

Explanation:

Here, we inherit the property of the "Calculator" class.

Then, we define the private double type variable "memory" and assign value 0.0.

Then we set the function "save()" inside it we assign the value of "memory" in "accumulator" and close the function.

Then, we define the function "recall()" inside it we assign the value of "accumulator" in "memory" and close the function.

Then we set the function "clearMemory()" inside it we assign "memory" to 0.

After all, we set the double type function "getMemory()" inside we return the value of the "memory".

7 0

3 years ago

Part of the central processing unit

AveGali [126]

Answer:

Explanation:

The arithmetic logic unit (ALU) performs mathematical, logical, and decision operations. It can be divided into the arithmetic unit (responsible for addition, subtraction, multiplication and division). And logic unit (responsible for comparing, selecting, matching and merging different data or information). The power and efficiency of the CPU depends on the design of the ALU.

Next up is the control unit (CU) which directs all the processor’s operations. It’s where the CPU reads and interprets requests from memory and transforms them into a series of signals (binary). Then it sends the operation to various parts of the laptop as instructed. The CU calls the ALU to perform the necessary calculations. It also coordinates all input/output devices to transfer or receive instructions.

The main job of the memory unit is to store data or instructions and intermediate results. It’s divided into primary memory and secondary memory to supply data to other units of the CPU. It allows the CPU to perform functions requested by programs like the operating system without having to ask RAM.

Another element of the CPU not depicted in the diagram is transistors. To carry out calculations, binary information (ones and zeros) is stored in these microscopic switches. They control the flow of electricity depending on whether the switch is ON or OFF. Signals turn off and on different combinations of transistors to perform calculations. A very thin silicon chip can contain several hundred million transistors.

8 0

3 years ago

Explain each kind of pointer and for what it is appropriate

ycow [4]

Answer:

Explanation:

A pointer is nothing but a memory location where data is stored. A pointer is used to access the memory location. There are various types of pointers such as a null pointer, wild pointer, void pointer and other types of pointers. ... When you want to deal different variable data type, you can use a typecast void pointer.

8 0

3 years ago

Read 2 more answers

Please help! Game design!

kvasek [131]

Answer:

player vs anonymous players

4 0

3 years ago

1. Grouping Data in a Pivot Table can help you do what?

valentina_108 [34]

Answer:

1.Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this image. Note: The time grouping feature is new in Excel 2016.

2.Select the rows or columns you wish to grouP

On the Data tab, in the Outline group, click the Group command.

In the Group dialog box, select Rows or Columns and click OK.

3.Select the rows or columns you wish to ungroup.

On the Data tab, in the Outline group, click the Ungroup command.

In the Group dialog box, select Rows or Columns and click OK.

1.Launch Microsoft Excel.

Browse to and open the workbook file containing the pivot table and source data for which you need filter data.

Select the worksheet containing the pivot tab and make it active by clicking the appropriate tab.

Determine the attribute by which you want to filter data in your pivot table.

The attribute should be one of the column labels from the source data that is populating your pivot table.

For example, assume your source data contains sales by product, month and region. You could choose any one of these attributes for your filter and have your pivot table display data for only certain products, certain months or certain regions. Changing the filter field would determine which values for that attribute are shown.

Force the Pivot Table Wizard or Field List to launch by clicking a cell inside the pivot table.

Drag and drop the column label field name you wish to apply as a filter to the "Report Filter" section of the pivot table field list.

This field name may already be in the "Column Labels" or "Row Labels" section.

It may be in the list of all field names as an unused field.

Set the filter to display one of the values for the field.

You can set the filter to display all values or only one. Click the arrow beside the filtered label and check the "Select Multiple Items" check box if you would like to select certain values for your filter.

Explanation:

PLZ MARK ME AS A BRAINLIST ;)

4 0

3 years ago

Find the cell address of first column and last row some one pls answer :'(​

Find the cell address of first column and last row some one pls answer :'(