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
Jeff’s father is installing a do-it-yourself security system at his house. He needs to get a device from his workshop that conve
Alenkasestr [34]

Answer:

Beeper

Explanation:

A buzzer pr beeper, as security device, converts electrical energy to sound energy.

3 0
4 years ago
Write a method called consecutive that accepts three integers as parameters and returns true if they are three consecutive numbe
Andre45 [30]

Answer:

#include <iostream>

using namespace std;

void swap(int *a,int *b)

{

   int temp;

   temp=*a;

   *a=*b;

   *b=temp;

}

bool consecutive(int k1,int k2,int k3)

{

   int arr[]={k1,k2,k3};  //storing these variables into an array

   int i,j;

   for(i=0;i<3;i++)

   {

       for(j=i;j<3;j++)

       {

           if(arr[i]>arr[j])

           {

               swap(arr[i],arr[j]);  //swapping to sort these numbers

           }

       }

   }

   if((arr[1]==arr[0]+1)&&(arr[2]==arr[0]+2))  //checks if consecutive

       return true;

   else

       return false;

}

int main()

{

   int result=consecutive(6,4,5);   //storing in a result variable

   if(result==0)

       cout<<"false";

   else

       cout<<"true";

   return 0;

}

OUTPUT :

true

Explanation:

In the above code, it stores three elements into an array and then sorts the array in which it calls a method swap() which is also defined and interchanges values of 2 variables. Then after sorting these numbers in ascending order , it checks if numbers are consecutive or not, if it is true, it returns true otherwise it return false.

7 0
3 years ago
What is an optical drive used for?​
solong [7]

Optical Disc Drive (ODD) An optical disc drive (ODD)

for using CDs, DVDs, and Blu-ray discs to listen to music or watch a movie.

Most drives also allow you to write data to a disc, so you can create your own music CDs, video DVDs or even create of back-up copy of your important data files.

dell.com

4 0
2 years ago
Read 2 more answers
Your first project as the new web designer at Smart Design is to increase web traffic to help boost web orders. Before you begin
Allushta [10]

Answer:

Looking at the website analytics helps you to optimize your content based on users’ interests, thus making your website more effective and also increasing your website traffic.

Explanation:

The website data analytics tools will provide me with a lot of information about the actual users of the site like their behaviors, age, demographics, gender. I will get to know:

  • What they do on the website
  • What they like about the site
  • Features they don't use on the website.

These will help me to further optimize the website to meet the taste of the users, which will help boost more traffic on the website.

7 0
3 years ago
Read 2 more answers
What is a variable? Why is it helpful in programming?
Komok [63]

Answer:

Variables can represent numeric values, characters, character strings, or memory addresses. Variables play an important role in computer programming because they enable programmers to write flexible programs. Rather than entering data directly into a program, a programmer can use variables to represent the data.

Explanation:

3 0
3 years ago
Other questions:
  • When composing a tweet with images attached in hootsuite, bear in mind that _____ characters are used up by the photos?
    9·1 answer
  • Select the correct answer. Andy wants to become a multimedia producer. Which degree can help him achieve this goal? A. bachelor’
    5·1 answer
  • How are appointments scheduled in medisoft
    12·1 answer
  • What are the primary functions of motor oil? a. Reduce friction and prevent wear b. Keep engine surfaces clean c. Remove heat to
    11·1 answer
  • When shading paragraphs, Word shades from the left margin to the right margin of the current paragraph. True or false?
    5·1 answer
  • Gross Domestic Product (GDP) is the economic report card for any country. What is the report card measuring?
    6·1 answer
  • The purpose of a ________ is to extract data from operational systems and other sources, clean the data, and store and catalog t
    7·1 answer
  • ___________ is a technique that uses IT to develop an ongoing relationship with the purchasers or buyers of an organization's pr
    13·1 answer
  • Write a program to accept two numbers<br>in two lines and find Square root of Squares<br>of thion​
    13·1 answer
  • If Z=52 and ACT=48 then BAT=​ with explanation??​
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!