Explain cell reference and its types with examples?​

Answers

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.


Related Questions

Match each career to its various job roles. digital media coordinator digital media specialist photographer sound producer creates audio and video content for websites arrowRight records and modifies sound and music for video games and movies arrowRight posts content on the Internet arrowRight captures images and edits the images in graphic design software arrowRight

Answers

Answer:

1. Digital media coordinator.

2. Sound producer.

3. Digital media specialist.

4. Photographer.

Explanation:

1. Digital media coordinator: he or she is saddled with the responsibility of creating audio and video content for use on websites.

2. Sound producer: he or she records and modifies sound and music for video games and movies through the use of specialized software application such as fruity loops.

3. Digital media specialist: he or she is saddled with the responsibility of posting content such as news, pictures, graphic designs, etc., on the Internet.

4. Photographer: he or she captures images using a camera or camcorder and edits the images using a graphic design software such as Adobe Photoshop.

To prevent certain columns from being displayed when printing a worksheet, _______ the columns.

erase
hide
highlight
remove

Answers

Hide I believe!!!!!!
To prevent certain columns from being displayed when printing a worksheet, HIDE the columns.

Your company resides in an area with rapid growth in both the corporate and residential areas surrounding your office. As such, your company has been experiencing several brownouts due to power grid problems (too much demand and not enough electricity). Fearing that your computers (especially the servers) could be damaged by these brownouts, your manager has asked you to find a solution to this problem.
Which of the following would be the BEST device to recommend to your manager for computer protection?
A. Surge suppressor
B. Power strips
C. UPS
D. Wall Outlet

Answers

Answer:

The correct answer is option C (UPS).

Explanation:

Since brownouts are reduced voltages that might not be good enough for the required electricity capacity for your company, fearing that your computers (especially the servers) could be damaged, it is best to use UPS for your computer protection.

A UPS also called (Uninterruptable Power Supply) can function as a Surge suppressor when the voltages entering your company might be higher than normal, it can also function too in protecting your computers (especially the servers) in the case of a brownout when voltage required by your computers dropped below the required level. In the case of a brownout, the  UPS supplies energy stored in its batteries to make the computers keep working without going off from lack of electricity.

A car manufacturer uses'simulation software during the design process for a new car. Which of the
following are reasons to use simulation software in this context?
1. Using simulation software can save the company money by helping to compare designs early in
the process, before prototype cars are built.
II. Using simulation software can help to identify safety issues by providing data about how different
mechanical components will interact in a wide variety of situations.
III. The manufacturer can present simulation software to customers to demonstrate different design
possibilities
А
I and II only
B
I and III only
С
II and III only
D
I, II, and III

Answers

D I,II and III is the answer i think

The reasons to use simulation software in this context are I, II, and III. The correct option is D.

What is simulation software?

The process of simulating a genuine phenomenon with a set of mathematical formulas is the foundation of simulation software. It is essentially a program that allows the user to simulate an operation and view it without really conducting it.

Simulation is a decision-making and decision-support tool. You can use simulation software to assess, compare, and optimize different designs, programs, and policies. As such, it can be used to explain and defend decisions to multiple stakeholders.

By allowing the corporation to evaluate concepts early in the process before prototype automobiles are constructed, simulation software can save the company money.

Therefore, the correct option is D, I, II, and III.

To learn more about simulation software, refer to the link:

https://brainly.com/question/16192324

#SPJ2

four categories of installer apps

Answers

Answer:

I find 5 categories

Explanation:

1 Overview

2 Necessity

3 Types

4 Attended installation

4.1 Silent installation

4.2 Unattended installation

4.3 Headless installation

4.4 Scheduled or automated installation

4.5 Clean installation

4.6 Network installation

5 Installer

5.1 Bootstrapper

5.2 Common types

5.3 System installer

complete the sentence: hexadecimal numbers use base ____

Answers

Hexadecimal numbers use base-16

Being a Base-16 system, the hexadecimal numbering system therefore uses 16 (sixteen) different digits with a combination of numbers from 0 through to 15. In other words, there are 16 possible digit symbols.

I need help in raft survival ocean nomad I was traveling and now I can't enter the island or go back home (raft). Please help me

Answers

Answer:

Raft Survival : Ocean Nomad is a survival game

Explanation:

The raft survival ocean nomad is a survival video game that is developed by a Swedish developer,  Redbeet Interactive. This game is published by Axolot Games.

In the game the player is moving in a raft in the middle of an ocean searching for his family. It is a survival and strategy game. The player needs to survive in the deserted ocean by whatever he finds and collect from the ocean and also protect himself from the attacks of the sharks.

The player moves by a small island which he can explore to eat something or collect other items to developed his raft.

In the context, if you can not enter the island or go back to the raft, then save the game at that point and press the escape button to start from the first.

In this way, you can refresh the game and start he game again to enter the island.

Write a qbasic program to supply first , middle and last name of a person and print the output as given below :

If input is Sam Christopher Robert output should be Robert Christopher Sam.​

Answers

Answer:

The QBasic program is as follows:

10 INPUT "First name: " fName$

20 INPUT "Middle name: " mName$

30 INPUT "Last name: " lName$

40 PRINT lName$," ",mName$," ",fName$

50 END

Explanation:

This prompts the user and gets input for first name

10 INPUT "First name: " fName$

This prompts the user and gets input for middle name

20 INPUT "Middle name: " mName$

This prompts the user and gets input for last name

30 INPUT "Last name: " lName$

This prints the output in the required format

40 PRINT lName$," ",mName$," ",fName$

This ends the program

50 END

Soluciónes tecnológicas cáseras para combatir los rezagos del corona virus

ayuda porfa
pongo corona

Answers

Explanation:

Los cielos: se están enviando drones para responder al brote en todo el país. Desde patrullar los pasillos con altavoces que advierten a los residentes que usen máscaras, hasta pasar por las calles con carteles de códigos QR que los conductores pueden escanear con sus teléfonos para registrar información médica; Los drones permiten a las autoridades obtener información más rápido y, al mismo tiempo, mantener una distancia segura mientras realizan sus funciones. Los drones agrícolas también están rociando desinfectantes en áreas remotas, mientras que otros se han utilizado para entregar suministros médicos cruciales. Los drones utilizados para rociar desinfectante en las calles de la ciudad son 5 veces más eficientes que la pulverización manual 3. Nuestros teléfonos: los teléfonos inteligentes desempeñan un papel fundamental en la reducción de la exposición. Las aplicaciones de entrega ofrecen entrega sin contacto, mediante la cual los conductores dejan la comida en un punto específico, incluida una tarjeta que indica la temperatura de todos los involucrados en cocinar y entregar la comida. Otro ofrece a los usuarios mapas que marcan comunidades residenciales con casos confirmados y su proximidad a ellos. Mientras tanto, las aplicaciones de pago móvil están reduciendo la transmisión a través del papel moneda, que puede transportar virus hasta por 17 días. Con la penetración más alta del mundo de billeteras electrónicas y dos de los pagos móviles más grandes del mundo, la tecnología china está ayudando a frenar la propagación del coronavirus.

Enfermeras robotizadas y diagnósticos de inteligencia artificial: los robots también se utilizan en muchos hospitales chinos para entregar alimentos, medicamentos y otros suministros a los pacientes; desinfectar hospitales y otras áreas públicas; para controlar la temperatura de los pacientes; y para responder preguntas comunes. El coronavirus se diagnostica mediante IA, que puede leer miles de tomografías computarizadas en 20 segundos con una tasa de precisión del 96%.

This type of mutation occurs when one or more base pairs are added to the gene sequence.

Answers

genetic mutation or engineering

explanation
i think i got it right
two sequences of base pairs

In cell K2 enter a formula using the IF and OR functions, as well as structured references, to determine if Adam Moriarty can be a group leader. a. The IF function should first determine if the staff member’s Service Years is greater than 3 OR if the staff member’s college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns.

Answers

Solution :

The value of the K2 cell is filled by IF and OR functions with structured references as :

[tex]K2=IF(OR([CBF\ \text{Staff[ Service years]} > 3, \text{CBF Staff[College graduate]}="Yes"),"Yes","No")[/tex]

Now if the syntax of the formula is not provided, then we can use :

[tex]$K2=IF(OR([[\text{Service Years}]]>3,[[\text{College Graduate}]]="Yes"),"Yes","No")$[/tex]

The staff member are required to satisfy one of the two or both the conditions so as to become a group leader. The conditions are :

---   staff member should served for more than 3 years

--- staff members should be college graduate

a diagram of a flow chart to find the average of 10 numbers​

Answers

Answer:

Kindly check attached picture

Explanation:

Flowchart gives a graphical representation of a steps taken towers the execution of a program.

In the flowchart attached, A variable was initialized and set to 0 ; then a for loop was used to iterate integers 1 up to 10, for each number. It is added to the initialized variable sum until all the 10 integer numbers are added. The the average is obtained by dividing by 10.

A sum of money is shared between 2 friends in the ratio 2 : 3. If the larger

share is $450. What is the total sum shared?

Answers

300! Is the answer for this problem. 450 is the bigger sum, and that’s the 3 part of the ratio. So when we divide 450 by 3 it gives us 150. 150 is what one point on the ratio stands for. We’re looking for what 2 points on the ratio is, so 150*2 which gives us 300 … hope this helps

why is computer system maintenance important​

Answers

Answer:

Because it helps your computer to have better performance and last longer

Explanation:

For what purpose do the hackers create the zombies army?

A. DDoS Attacks
B. DoS Attacks
C. Warm Attacks

Answers

Answer:

A. DDoS Attacks

Explanation:

A zombie, in computer terminology, is a hacker, computer worm, trojan horse, or virus compromised internet connected computer, which can be remotely directed to perform malicious tasks

E-mail spams and denial-of-service, DoS attacks are spread and launched by botnets of zombie computers

Botnets which are also known as "zombie army", are used by hackers mainly for spam and distributed-denial-of-service, DDoS, attacks

While a DoS attack involves one machine, while a DDoS attack consist of multiple computing devices and machines

A botherder is the originator of a botnet and common botnets include Mr Black. Pushdo, and cyclone

Can someone please type a code that makes a house in python and turtle graphics i need help

Answers

Answer:

import turtle  

turtle.speed(2)

#shape

turtle.forward(100)

turtle.left(90)

turtle.forward(100)

turtle.left(45)

turtle.forward(100)

turtle.left(90)

turtle.forward(100)

turtle.left(45)

turtle.forward(100)

turtle.left(90)

turtle.forward(100)

#door

turtle.left(90)

turtle.forward(50)

turtle.left(90)

turtle.forward(25)

turtle.left(90)

turtle.forward(50)

#windows

turtle.penup()

turtle.right(90)

turtle.forward(20)

turtle.right(90)

turtle.forward(20)

turtle.pendown()

turtle.forward(25)

turtle.left(90)

turtle.forward(40)

turtle.left(90)

turtle.forward(25)

turtle.left(90)

turtle.forward(40)

Explanation:

here :)

In cell K26, create a formula that counts the number times "Thunder" occurs in the columns containing "Names"

I would wanna know the Formula for this In Excel

Answers

Answer:

I1 to K2: Use a formula to link the cells. Create a formula in column L that calculates the averages for each matching category in K2:

hope it's help you plz mark as brain list

Following are the excel formula to count the number of times "Thunder" occurs in the names column:

Excel formula to count the number of times the value occurs:

Formula:

=COUNTIF(C:C,C8)

Explanation of the Formula:

The COUNTIF function in Excel is a built-in function that counts cells according to several criteria. "=COUNTIF" is how it's spelled. The "COUNTIF" is a statistical function that can be used to count the number of cells that meet a requirement, like the number of times a certain city occurs in a client list.Inside the "COUNTIF" method we pass a two-parameter, in which the first parameter selects the column and the next parameter finds the value that will occur the number of times.

Find out more about the excel function here:

brainly.com/question/20497277

what is spyware and what is it function?​

Answers

Explanation:

Spyware is a type of malicious software -- or malware -- that is installed on a computing device without the end user's knowledge. It invades the device, steals sensitive information and internet usage data, and relays it to advertisers, data firms or external users.

Which scenario would most benefit from a self-join query?
a. a query connecting customers and products
b. a query connecting supervisors and customers
c. a query connecting employees and their orders
d. a query connecting employees and their supervisors

Answers

Answer:

answer is D

Explanation:

Just did it on edge

Describe how serial data access finds data

Answers

Answer:

Serial data access will go through all the data by order until the target data is reached

Explanation:

This is opposite of direct data access which immediately finds the desired

data

Answer:

Serial access works by accessing the data at the beginning and then working through it bit-by-bit until the end.

...

Examples of storage medium that use serial access are:

Video cassettes.

Music cassettes.

Backup tape cartridges(hold lots of tape for backing up large amounts of data)

State two pieces of information that need to be labeled on the idea development sketch. 1 .________________________________________________. 2 .___________________________________________.​

Answers

Answer:

Design drawings should show details on layout, measurements, plan, cross-sectional and vertical profiles. This information is prepared as scale drawings of the works to be constructed. they are legible  they include all information from previous revisions and updates.

Explanation:

A chart is used to represent ______ data in pictorial form
Computer question
From the chapter ms excel pls answer!!

Answers

Answer:Pictorial form is also called a pictogram

this bar is located at the top of your computer school in.Its functions allow you to navigate the web​

Answers

Answer:

idu

Explanation:

The answer is Address bar

essay on personal assistants

Answers

Answer:

Explanation:

Personal assistants are hired to work very closely and directly to an individual such as a manager or top ranking persons who are usually very busy and have lots of several different tasks to attend to. The personal assistant would be seen as a person who posses the right multitasking skill, good communication skill and good interpersonal relationship skills can p handle administrative duties, respond to calls and visitors who may need to see the boss, give savvy response to cliemts and visitors and a good fre of mind to ensure that all scheduled lettings, appointments, travels are clearly noted to avoid missing important schedules. Depending on the preference of the manager or boss, they may be need to make specific gender representation of the personal assistant required. Also, some have designated some jobs to suit a certain gender more than the other as the favouured gender gets considered ahead of the other during the application process for jobs of such nature.

State the feature of a database management system that prints data in a specified format with a title.

Answers

Answer:

Data structuring

A DBMS is a database management system that is responsible for the software packages made for manipulating, retrieval, and managing the data in the DB.

DB generally manipulates the data itself on the basis of field names and file structure. It has multiuser access and provides a high level of security. It is a network database and network and has an object-oriented database.

Hence the format with a title would be data structuring.

Learn more about the database management system that prints.

brainly.com/question/22486925.

Write a pseudocode to calculate the factorial of a number

Answers

Answer:

Answer CODE from C# Sharp  Language

Explanation:

using System;

namespace test

{

   class Program

   {

       public void silnia()

       {

           decimal liczba;

           decimal silnia = 1;

           Console.WriteLine("Obliczanie Silni ");

           Console.WriteLine("Podaj liczbę: ");

           liczba = Convert.ToInt32(System.Console.ReadLine());

           //liczba = int.Parse(Console.ReadLine());

           for (int i = 1; i <= liczba; i++)

               silnia *= i;

           Console.WriteLine("Wynik Silni Wynosi :  " +silnia +" \n ");

       }

       static Program ćwiczeniaA;

       static void Main(string[] args)

       {

           ćwiczeniaA = new Program();

           ćwiczeniaA.silnia();

       

           Console.WriteLine("Koniec Programu");

           System.Console.ReadLine();

       }                                

   }

}

Use the drop-down menus to complete statements about options for inserting video files.
V is a point of interest in a video clip that can trigger animations or provide a location that a user
can jump to quickly.
The Embed Code command will link an online video to a presentation and requires
to work.
Recording mouse actions and audio is done by using the
command.

Answers

Answer:

1 book mark

2 internet connection

3 inset screen

Explanation:

because

help please asap please l​

Answers

Answers:

(a) Processor type

(b) Processor speed

(c) Display size

(d) Resolution

(e) Drive size

(f) Memory size

(g) Memory type

(h) Available interfaces

(i) Operating system

(j) Utilities

♛ Mark me as Brainliest if I’m right

I love science its my favorite subject

Answers

Answer:

Nice!

Explanation:

i like physics and biology :)

Answer:

I also love science!!

Explanation:

what are the tyoe of typical application of mainframe computer

Answers

Explanation:

customer order processingfinancial transactions production and inventory control payroll

hope it is helpful to you

Other Questions
explain any 4 qualities of a good society in brief on a tv game show,omar needs answer 7 out of every 10 questions correctly. There will be 30 questions in all While working on a site in State A, a State B construction worker was standing near a steel crane when the crane's boom swung near a high tension power line. The worker was electrocuted and severely injured. The worker filed an action in federal district court against the power company that owns the power lines. The action seeks $500,000 and alleges that the power company's negligent construction, maintenance, and operation of the power lines caused the injury. The power company is a State A corporation and all its operations are in State A. The power company filed a third-party complaint against the owner-operator of the crane, a State B citizen. The third-party claim is based on state law and alleges that the crane's owner-operator is liable to the power company for any liability the power company has to the injured worker. The worker amended his complaint to add a state law negligence claim for $500,000 against the crane's owner-operator.Does the federal court have subject matter jurisdiction over the worker's claim against the owner-operator of the crane?A No, because the court does not have supplemental jurisdiction over the worker's claim against the owner-operator of the crane.B Yes, because the claim arose from the same transaction or occurrence as the worker's claim against the power company.C Yes, because all claims asserted arose from a common nucleus of operative fact.D Yes, because the State B worker has sufficient contacts with State A. Wich Type of rectangle has not equal side lengths A. Isosceles B. Equilateral C. Scalene D. None of the above elevation types in art What trig ratio would you use to solve for x?O CosineO TangentO Sine Consider function g.6,-8 < x Pls I beg someone to finish ALL of this :(. Ive stayed up all night to do this but I couldnt figure all of them out. Pls pls pls!!! ill mark you brainliest n I can give you a thank you such as 5 Stars in return. Please take your time and I hope you all have a amazing day! Anita is concerned that shell be diagnosed with type 2 diabetes. What type of lifestyle changes could she make to help prevent this diagnosis Find a mathematical model for the below statement. (Use k for the constant of proportionality.) The gravitational attraction F between two objects of masses m1 and m2 is jointly proportional to the masses and inversely proportional to the square of the distance r between the objects. ...................... you....................(know) the way the lake? Question 10 Multiple Choice Worth 1 points)(01.06 MC)James fenced in his backyard. The perimeter of his fence is 20 feet, and the width of his yard is 2 feet wide. Use the perimeter formula to find the length of his rectangular yardin inches: P2L+2W. which of the following is the result of the equation below after completing the square and factoring x^2+3x+8=6 mRST =______because they are __________ (Fill in the blanks) HELP PLZ SND THANKS WILL MARK YOU AS BRAINLIEST pls help plsssss sss sss sss s How does a referendum give people more influence in government?It allows people to vote to accept or reject a law.It allows people to remove an official from office.It allows people to change laws or propose new ones.It allows people to impeach an official for wrongdoing. e^2x dx= ???? thanks The owner of Artisanal Chips etc. produces three flavors of artisanal corn chips marketed at new college graduates pumpkin (P), chipotle adobo (A) and basement (B). He has a limited amount of the three ingredients used to produce these chips available for his next production run: 1,000 ounces of salt, 2,000 ounces of maize, and 1,200 ounces of herbs. A bag of pumpkin chips requires 2 ounces of salt, 6 ounces of maize, and 1.75 ounces of herbs to produce; while a bag of chipotle-adobo chips requires 6 ounces of salt, 6 ounces of maize, and 5 ounces of herbs. A bag of basement chips requires 1.75 ounces of salt, 3.5 ounces of maize, and 1.5 ounces of herbs. Profits for a bag of basement chips are $0.40, for chipotle-adobo chips is $0.60, and for a bag of pumpkin chips $0.50.For the production combination of 100 bags of each flavor of chips, which of the three resources is (are) not completely used? a. salt and herbs only b. salt and maize only c. herbs maize and salt d. maize only give me one secondddd..