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
alina1380 [7]
3 years ago
6

How do you freeze the total cell so that it doesn't change when copied?

Computers and Technology
1 answer:
GenaCL600 [577]3 years ago
7 0

Answer:

c) put a $ in front of the letter and number that represents the cell position.

Explanation:

Dollar sign ($) is used to lock the formula in the cell. This is called absolute reference. In this type of referencing, A dollar sign is place in front of the letter and number to lock that cell. Whenever we copy that cell, the formula will be copied in other cell without changing its reference number.

As

Example 1

C1 = A1 + B1

if we copy this formula in C2 then it becomes

C2= A2 + B2

there both reference of A and B has been changed.

Example 2

If we put $ sign as

C1= $A$1 + $B$1

now of we copy C1 and into C2

C2= $A$1 + $B$1

There reference of cell is not changed.

You might be interested in
What two methods can be used to access and modify an existing program that is running on an iot device in cisco packet tracer? (
dsp73

Cisco Packet Tracer is tool used for network simulation and visualization program.

The two methods can be used to access and modify an existing program that is running on an IoT device in Cisco packet trace are the following:

1. Click on the device then select the Programming tab.

2. Go to the registration server and login. Then select the Editor tab.

3 0
3 years ago
Why should you follow-up with your interviewer after a job interview?
elixir [45]

B. To reinforce your interest in the position and thank your interviewer


8 0
3 years ago
Read 2 more answers
Which of the following arguments are valid? Explain your reasoning
klio [65]

Answer:

a) the Statement is Invalid

b) the Statement is Invalid

Explanation:

a)

lets Consider, s: student of my class

A(x): Getting an A

Let b: john

I have a student in my class who is getting ab A: Зs, A(s)

John need not be the student i.e b ≠ s could be true

Hence ¬A(b) could be true and the given statement is invalid

b)

Lets Consider G: girl scout

C: selling 50 boxes of cookies

P: getting prize

s: Suzy

Now every girl scout who sells at least 50 boxes of cookies will get a prize: ∀x ∈ G, C(x) -> P(x)

Suzy, a girl scout, got a prize: s ∈ G, P(s)

since P(s) is true, C(s) need not be true

Main Reason: false → true is also true

Therefore the Statement is Invalid

7 0
2 years ago
1. Universal Containers has set up a picklist dependency between Region and Zone on the Account object. The sales manager has re
ElenaW [278]

Answer:

Create a validation rule using ISPICKVAL()

Explanation:

Solution

This can be achieved by creating a a validation rule using ISPICKVAL()

Create a Validation Rule Based on a Pick list : The ISPICKVAL() are very important for creating validation rules that check whether a definite pick list value is chosen. for instance, say you want another person to enter a reason when they change a case's Status pick list value to increase.

3 0
3 years ago
You shut down VM1, configure the processor compatibility settings, and then start VM1. Does this meet the goal?
Naddik [55]

Answer:

Yes it does.

Explanation:

VM or virtual machines are enabled by the hypervisor in host operating systems. More than one virtual machine can run in an operating with only one processor.

Live migration, save and restore, and production checkpoints are all mobility processes that does not require rebooting the system. Since these virtual machine mobility processes is not compatible running directly on different processor, the virtual machine must be shutdown, and rebooted on the new processor host.

However, to run the virtual machine on a different processor without rebooting, the VM is run on processor compatibility mode (in the processor compatibility settings).

7 0
3 years ago
Other questions:
  • What does N represent when analyzing algorithms?
    15·1 answer
  • A cell reference is also called a cell _______.
    14·1 answer
  • )in the link based implementation of the ADT sorted list what is the worst case time efficiency of the remove method?
    7·1 answer
  • Most computer attacks are designed to steal information or money. Which of the following attacks is designed to slow down or sto
    14·1 answer
  • Consider the following definition of the recursive function mystery. int mystery(int first, int last) { if (first > last) ret
    12·1 answer
  • (1) Create three files to submit:
    8·1 answer
  • Explain in your own words how remote-access Trojans (RATs) work. How can these be used by attackers? How would a network adminis
    10·1 answer
  • The purpose of​ a/an _________ system is to capture best practice solutions and program them into a set of rules in a software p
    13·1 answer
  • What to do when you accidentally delete usb drivers?
    8·1 answer
  • a developer manages an application that interacts with amazon rds. after observing slow performance with read queries, the devel
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!