All categories

3 years ago

Which column and row references are updated when you copy the formula f$3/15

Computers and Technology

1 answer:

Tasya [4]3 years ago

3 0

Answer: Column F

Explanation: In Microsoft excel, for the sake of robustness and to aid the effectiveness of updating formulas across cells. The reference of cells are treated as relative which means that when formulas are copied across columns or within rows, they get updated automatically. However, some numbers may be treated as constants such that we do not want them to change or be updated as we move acisss cells. Thus, such numbers are treated Given absolute references, which is made possible by adding a '$' prefix before the colum alphabet or row number or both. in the scenario given above, the row has the $ prefix, hence, it is absolute and will not change but the column alphabet does not and hence, treated as relative.

You might be interested in

PLEASE HELP ASAP! WILL MARK BRAINLIEST IF THE ANSWER IS CORRECT! I NEED HELP WITH THE 3RD ONE!

Bogdan [553]

Answer:

Explanation:

.1 Display all information from the customer table for all customers that have a balance that is greater than the average balance.

2. Display all information from the rep table for all representatives that have a rate which is equal to the minimum rate for representatives.

3. Display each unique description and price (no duplicates) for all parts that have a quoted price that is greater than the average quoted price for all parts ordered.

4. List all streets where either a customer or a representative is located

5 0

4 years ago

What is a specific challenge faced by information visualization researchers who are building an interface?

Mkey [24]

Answer:

Information virtualization is the process of representing the abstract data such as numeral number and text into the form of visual which is human can easily understand.

The main challenges faced by the information visualization researchers are:

The main challenge which are faced by the information virtualization is during the data importing and also cleaning in the system.
It also not able to access the large amount of the data easily from the system.
Due to the poor selection of the scale and the coordinate rotation it also lead to the data distortion.

3 0

3 years ago

Is ryzen really better for all-around purpose, and intel is better for gaming?

barxatty [35]

Answer:

Its really personal preference G.

Explanation:

But what you said is about right.

6 0

3 years ago

Write, compile, and test the MovieQuoteInfo class so that it displays your favorite movie quote, the movie it comes from, the ch

Irina18 [472]

Using the knowledge of computational language in JAVA it is possible to write a code that removes your favorite phrase from the movie. It consists of two classes in which one is driver code to test the MovieQuoteInfo class.

<h3>Writing code in JAVA:</h3>

public class MovieQuoteInfo { //definition of MovieQuoteInfo class

//All the instance variables marked as private

private String quote;

private String saidBy;

private String movieName;

private int year;

public MovieQuoteInfo(String quote, String saidBy, String movieName, int year) { //parameterized constructor

super();

this.quote = quote;

this.saidBy = saidBy;

this.movieName = movieName;

this.year = year;

}

//getters and setters

public String getQuote() {

return quote;

}

public void setQuote(String quote) {

this.quote = quote;

}

public String getSaidBy() {

return saidBy;

}

public void setSaidBy(String saidBy) {

this.saidBy = saidBy;

}

public String getMovieName() {

return movieName;

}

public void setMovieName(String movieName) {

this.movieName = movieName;

}

public int getYear() {

return year;

}

public void setYear(int year) {

this.year = year;

}

//overriden toString() to print the formatted data

public String toString() {

String s = quote+",\n";

s+="said by "+this.saidBy+"\n";

s+="in the movie "+this.movieName+"\n";

s+="in "+this.year+".";

return s;

}

}

Driver.java

public class Driver { //driver code to test the MovieQuoteInfo class

public static void main(String[] args) {

MovieQuoteInfo quote1 = new MovieQuoteInfo("Rosebud", "Charles Foster Kane", "Citizen Kane", 1941);//Create an object of MovieQuoteInfo class

System.out.println(quote1); //print its details

}

}

See more about JAVA at brainly.com/question/12975450

#SPJ1

7 0

2 years ago

Which of the following statements is NOT a valid way to create a date object named birthday?

dem82 [27]

Answer:

var birthday = "12/2/1978";

Explanation:

It does not create a date object named birthday because in this statement the birthday is a string which contains 12/2/1978 a date it is not date object it is a string.All other three options are correct way to create a date object.

var birthday = new Date();

creates a date object with the current date and time.

we can also pass date string in the new Date().So var birthday = new Date("12/2/1978"); is also correct.

we can also pass year,month,day in new Date() In this order only.So option fourth is also correct.

4 0

3 years ago