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
Burka [1]
3 years ago
8

Pick the correct statements regarding cell references.

Computers and Technology
2 answers:
shusha [124]3 years ago
7 0

Statement two and three is correct.

Statement 1 is incorrect. A relative reference changes when a formula is copied to another cell while Absolute references remain constant. However, it is safe to say that an absolute address can be preceded by a $ sign before both the row and the column values. It is designated by the addition of a dollar sign either before the column reference, the row reference, or both. Statement C is also correct. A mixed reference is a combination of relative and absolute reference and the formula (= A1 + $B$2) is an example of a mixed cell reference.

Lady_Fox [76]3 years ago
3 0

Answer:

<em>1)</em><em> A relative reference will retain its references when copied to another cell.</em>

<em>2) An absolute address has a $ sign before both the row and the column values.</em>

<em>3) </em><em>= A1 + $B$2 is an example of a mixed cell reference.</em>

<em>4) </em><em>The address 7B is invalid.</em>

Explanation:

<em>We know that a call by reference method can be defined as a method of providing different  arguments to a function and then that function copies the address of an argument into the formal pattern.</em>

You might be interested in
A computer is performing a binary search on the sorted list of 7 numbers below.
suter [353]

Answer:

The answer is "Option D".

Explanation:

Binary search is also an efficient mechanism for only a sorted item list. It separates the element into one half of the checklist repeatedly, till you have narrowed it down to the only single place.

In this search, the number of comparisons is much more efficient than in the series to use the binary search approach, the items also should be shown, that's why the last choice is correct.

6 0
3 years ago
Read 2 more answers
Define Technology. Explain the term.​
aleksandrvk [35]

Answer:

Technology refers to methods, systems, and devices which are the result of scientific knowledge being used for practical purposes. Technology is changing fast. They should be allowed to wait for cheaper technologies to be developed.

7 0
3 years ago
Read 2 more answers
Megan was employed by a large company. Her supervisor told her to falsify government reports. She refused and was fired. She sue
Ber [7]

Answer: Option(d) is correct option

Explanation:

At-will employment is the employment in contractual manner in which employer can fire employee without any warning or indication .They can fire employee for any cause .

  • According to the question, even though Megan was hired at at-will employment base ,she does not persist much right over the company but she should not be dismissed for not performing illegal act as the reason for getting fired.This is a unfair and illegal manner of firing.
  • Other options are incorrect because employer was not correct on firing her because of loyalty duty or based on legal right or with just reason.Thus, the correct option is option(d)
7 0
3 years ago
Write a C function which takes three parameters which are the cost for an item in a grocery store, the quantity to buy, and the
xeze [42]

Answer:

struct item

{

  float previousCost;

  float taxAmount;

  float updatedCost;

} itemObject;

void calculation(int cost,int quantity,float tax)

  {

      struct item *itemPointer=&itemObject;

      itemPointer->previousCost=(cost) * (quantity);

      itemPointer->taxAmount=itemPointer->previousCost * (tax/100);

      itemPointer->updatedCost=itemPointer->previousCost+itemPointer->taxAmount;

  }

Explanation:

  • Define a structure called item that has 3 properties namely previousCost, taxAmount and updatedCost.
  • The calculation function takes in 3 parameters and inside the calculation function, make a pointer object of the item structure.
  • Calculate the previous cost by multiplying cost with quantity.
  • Calculate the tax amount by multiplying previous cost with (tax / 100).
  • Calculate the previous cost by adding previous cost with tax amount.
4 0
3 years ago
Read 2 more answers
Which one of these is NOT a common use for hexadecimal numbers?
uysha [10]

Answer:

Boolean Values

Explanation:

Boolean Values are used as return values for functions to check whether something is true or false.

Hexadecimal numbers it is technique of representing numbers whose base value is 16.

The common use of Hexadecimal numbers are:

  1. To define memory locations .
  2. To define colors in web Pages .
  3. To represent error message.
  4. To represent MAC address
3 0
3 years ago
Other questions:
  • Write a program that reads a 4-bit binary number from the keyboard as a string and then converts it into decimal. For example, i
    11·1 answer
  • 1. Mobile devices have a _________ viewport that displays a web page content that fits within a mobile screen.
    11·1 answer
  • What is one important feature of an AUP?
    14·1 answer
  • How to make your keyboard sound like a piano?
    9·1 answer
  • Which of the following is a list of input devices?
    11·1 answer
  • An image can be copied from the Internet or another location and pasted into Paint.
    13·1 answer
  • Each Google My Business location has a unique ID that applies changes to the right listing.
    11·1 answer
  • What is the Role of an algorithm?
    11·1 answer
  • Define two benefits to members of the community of replacing the printed copy with an online version.
    5·1 answer
  • What is the vibrating or buzzing of a hand controller known as?.
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!