All categories

3 years ago

Where should you click to edit an existing formula?

Computers and Technology

2 answers:

kkurt [141]3 years ago

7 0

Answer:

option c "in the formula bar"

Explanation:

user100 [1]3 years ago

3 0

Answer:

You can edit the existing formula by clicking the cell in which formula is referenced, then edit the formula in the formula bar. (option c is correct)

Explanation:

This question is about how to edit the existing formula. In Excel, you can edit the formula. First, you have to click the cell in which the formula is written. Then you have to edit it in the formula bar. However, if you know and remember the formula, you can edit directly in the cell. But the best practice is to edit the formula in the formula bar.

Why other options are not correct.

In a cell that is referenced in the formula:

The cell that is referenced in the formula does not affect the formula. Because to edit something in the referenced cell, does not guarantee to affect the formula that you want to edit. To edit the existing formula, you click the cell in which formula is written, then edit it in the formula bar.

In the first blank cell of the worksheet

It is not necessary, that there would be a formula in the first cell. But, if there is a formula in the first cell, you should edit the formula directly in the formula bar.

In the status bar

You can't edit the existing formula in the status bar because the status bar is used for showing the status of actions you are doing in excel. The status bar is shown at the bottom of the excel sheet.

You might be interested in

A) Write a class Card. A Card has the following private attributes:

Over [174]

Answer:

Java.

Explanation:

public class Card

{

String Suit;

int value;

public Card(int value, String Suit) {

self.value = value;

// Check Suits value

if ((Suit == "hearts") || (Suit == "spades") || (Suit == "clubs") || (Suit == "diamonds"))

self.Suit = Suit;

else {

Suit = "none";

throw new IllegalArgumentException("no card of this type exists.");

}

public String getSuit() {

return Suit;

}

public int getValue() {

return value;

}

public void print() {

System.out.println("%d of %s", value, Suit);

}

public class Deck {

}

6 0

3 years ago

5. What is a domain name used for?

Mnenie [13.5K]

Answer:

Domain names serve to identify Internet resources, such as computers, networks, and services, with a text-based label that is easier to memorize than the numerical addresses used in the Internet protocols. A domain name may represent entire collections of such resources or individual instances.

Explanation:

*Hope this helps*

7 0

3 years ago

How does math help you determine the amount of watts a turbine produces?

vlada-n [284]

It helps you determine the amount of watts a turbine produces because math is the only way to go

7 0

3 years ago

Given numrows and numcols, print a list of all seats in a theater. rows are numbered, columns lettered, as in 1a or 3e. print a

trapecia [35]

/* package whatever; // don't place package name! */

import java.util.*;

import java.lang.*;

import java.io.*;

class NestedLoops {

public static void main (String [] args) {

int numRows = 4;

int numCols = 5;

int i,j;

char ch = 'A';

// Note: You'll need to declare more variables

/* Your solution goes here */

for ( i = 0; i < numRows; i++) { // Outer loop runs for numRows times

for ( j = 0; j < numCols; j++) { // Inner loop runs for numCols times

System.out.print(i+1);

System.out.print((char)(ch+j));

System.out.print(" ");

}

System.out.println("");

return;

}

8 0

3 years ago

Do all the countries have the same date format?

alexandr402 [8]

No they don’t have the same data format.

4 0

3 years ago