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]
3 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]3 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
Imagine you are building an ATM system; list at least 6 application domains for the system. That is, in which context is the sys
Anvisha [2.4K]

Answer:

Six applications domains for the ATM was listed below in the explanation section below

The main aim of the ATM is cash collection, user information update.

The users of the ATM are people, staff, customers/clients.

Explanation:

Solution

Given that

The Application domain for the system is given below:

  • The System is going to verify the details entered
  • Update the database on the server side
  • Calculation of cash Available
  • Count the Cash and Identify the note in the Machine
  • Troubleshooting of the ATM machine (system)
  • Backup of the system and Operating system /Software installed on the ATM machine.

The ATM is going to be used for the purpose of collecting cash, updating user information, cashing cheques etc and is used by all the Bank customers.

Who are the users of ATM:

  • Customers at the bank
  • Individuals /people
  • Staff of the Bank
3 0
3 years ago
Which of the following statements about the break statement is false? Group of answer choices Common uses of the break statement
Y_Kistochka [10]

" The break statement, when executed in a while, for or do…while, skips the remaining statements in the loop body and proceeds with the next iteration of the loop. " This statement is false.

Explanation:

  • The break statement is used to come out of a loop such as for, while, do-while loop.
  • The break statement is also used to come out of a switch statement.
  • When the break statement is encountered then the control returns outside the current loop or switch statement and proceeds executing the rest of the statements of the remaining program.
  • The break statement is used to come out of the current iteration early and continue execution of the remainder program after the loop.
  • The break statement does not exit the current iteration and start the next iteration of the loop. It directly comes out of the entire loop.
  • When a break statement is encountered in a switch statement, then the control is given outside the current case and handed over to the remainder of the program after the switch statement.
4 0
4 years ago
Accenture has put together a coalition of several ecosystem partners to implement the principles of blockchain and Multi-party S
Anika [276]

Answer:

They include;

1. MAAG Pump Systems,

2. Automatik Plastics Machinery,

3. Gala Industries,

4. Reduction Engineering Scheer,

5. Ettlinger Kunststoffmaschinen and

6. XanTec EDV- und Steuerungstechnik

Explanation:

The MAAG group consists of six companies specialized in different aspects of polymer production. They provide their services to petrochemical, pharmaceutical and food production companies. They produce pellets, gear pumps, filtration systems and components, pelletizers, etc.

They have more than 1000 staff and their offices are located in about 11 countries of the world.

5 0
2 years ago
Select the correct answer.
Sladkaya [172]

Answer:

B

Explanation:

hes not presenting, word processing or making spreadsheets and multimedia software can be used to make music

5 0
3 years ago
Read 2 more answers
Where is the BIOS chip located?
masya89 [10]

Answer:

on the motherboard inside the computer

6 0
3 years ago
Read 2 more answers
Other questions:
  • A(n) ____ loop executes a predetermined number of times.
    12·1 answer
  • What kind of voltage do solar cells generate? Solar cells produce ______ voltage which is not usable by most household appliance
    15·1 answer
  • Mohammed's parents learn that his classmates have
    7·2 answers
  • What is your favorite food
    11·2 answers
  • How do you get banned? By getting reported? Or do admins watch whats posted?
    9·1 answer
  • How do I modify objects in power point 2016 for an assignment
    11·1 answer
  • Who plays xbox one offline and knows some multiplayer games that can be played offline.
    15·2 answers
  • How to deactivate the brainly account?​
    13·1 answer
  • ________ are the symbolic codes used in assembly language?​
    6·1 answer
  • A row-level trigger requires use of the _____ keywords and is executed once for each row affected by the triggering statement.
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!