1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Elena-2011 [213]
4 years ago
6

When cells or rows are inserted or deleted in an excel worksheet how are cell reference deletion?

Computers and Technology
1 answer:
sasho [114]4 years ago
8 0

Answer:

Whenever a new row is inserted, based on the insertion point, the rest of the rows will move down and the reference will be changed accordingly.

Explanation:

Suppose there are 5 columns and ten rows in excel containing the value of student marks from column 2 to 4 in each subject and column 1 contains Student roll number.

There are totally 10 entries in the sheet (number of student = 10) and the column 6 is utilized to calculate total and there is a formula associated to each row to add marks.

When we want to enter another student data below the 5th student, we can insert and the whole row including the formula gets changed thus the reference of formula gets changed. Same is the case for deletion.

You might be interested in
WIN
Delicious77 [7]
The correct answer is D
6 0
3 years ago
Read 2 more answers
What are the differences between packet and circuit switching? Which is more prevalent today?
Juliette [100K]

Answer: The difference present between the packet switching and circuit switching are as follows:-

  • Packet switching i the switching in which the data packet travels through the connectionless path whereas connection oriented routes are present for circuit switching
  • Network layer uses the feature of packet switching while physical layer uses circuit switching technique
  • Data transferring is mostly preferred through packet switching and voice communication takes place through the circuit switching.
  • Packet switching is considered flexible as no already established connection is present for switching but the connection in circuit switching are already defined which makes it less flexible.

Among the packet switching and circuit switching , packet switching is preferred for the communication through the data packets because they have  flexibility and affordability.It can establish numerous connection for switching and this make it efficient.

4 0
4 years ago
Provide the definition of an abstract class named DesktopComponent that contains the following:
Bess [88]

package mypackage; // Whatever package this should be in.

public abstract class DesktopComponent {

   

   private String type;

   // Alternatively you may want a final variable.

   // private final String type;

   

   public DesktopComponent(String type)

   {

       this.type = type;

   }

   

   abstract void onClick();

   

   

 

}

7 0
3 years ago
Technical colleges offer certification in audio engineering through programs that are normally from 2 to 6 months long. False Tr
kompoz [17]

Answer: False

Explanation:

Certification in Audio Engineering equips one with skills needed in the music industry such as being able to record, mix and master sounds as well as knowledge of studio equipment such as microphones, speakers, consoles and the computer software needed to blend all these components together.

As such, it can take a bit of time to learn it adequately enough to be certified.  This is why Technical colleges offer certifications in audio engineering through programs that usually last between 6 months and a year.

6 0
3 years ago
What is a CPU or a GPU? What’s the difference? Which one is better?
Alik [6]
The CPU (central processing unit) has often been called the brains of the PC. But increasingly, that brain is being enhanced by another part of the PC, the GPU (graphics processing unit), which is its soul. The GPU renders images, animations and video for the computer's screen. GPUs are located on plug-in cards, in a chipset on the motherboard or in the same chip as the CPU.
6 0
3 years ago
Other questions:
  • Read the spreadsheet formula below, then answer the question.
    14·2 answers
  • Which of these automotive repair areas helps the vehicle change speeds to operate efficiently under all conditions?
    5·1 answer
  • In your opinion, is it more beneficial to have many folders or is it better to “nest” subfolders? Explain your response.
    10·2 answers
  • Which of the following functions does a browser perform?
    7·2 answers
  • Derek is working at the help desk when he receives a call from a client about an issue with the company's email. The customer is
    9·1 answer
  • A company gives you a document to review. This document lays out the strengths and weaknesses of a proposed business venture. It
    13·1 answer
  • ______ is/are the replacement of human operation and control of machinery with some form of programmed control.
    11·1 answer
  • Unemployment can be viewed as
    14·1 answer
  • Dante went to change the date for an appointment in his Outlook calendar. He double-clicked in the appointment and made the chan
    11·1 answer
  • What is missing in the following program in order to have the output shown?
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!