All categories

3 years ago

Gabriel needs to create a formula that does not change when it is copied to cell b2. which formula should he create?

1 answer:

azamat3 years ago

4 0

=sum(1+1) it's a simple formula and won't change from any cells. Another you can do is to put a value in a specific cell, let's say, C3. Then have a formula that says, =sum(C3+2). But if you REALLY wanna impress someone - put a value in A1 - anything at all. Then put this formula in any other cell you want. If you change cells, you get a different answer. If you change the # in A1, you get different answers, all thanks to the RANDom function. =SUM((RAND()*100)+A1)

You might be interested in

If you were setting up a network with 100 nodes and you wanted no more than 25 nodes per segment: what devices and connections w

STatiana [176]

Since at present number user or nodes in an organization counts is 100 and it can be further extended. Moreover concurrent at presented is 25 nodes is active.

Explanation:

So as best practice network administrator has keep in mind and select hardware application.

1. Server with high end rams and further extendable.

2. Minimum life of hardware such as routers, switch or managed or firewall should be considered or two years. But to technology improvement it is possible for 1 year only

3. Upgradable hardware appliances and software updates should be possible with mini cost effect.

4. Network security and update or upgradable workstation or desktop or laptop to be consideration.

5. Functional operation of an organization should run smoothly.

8 0

2 years ago

For a new version of processor, suppose the capacitive load remains, how much more energy will the processor consume if we incre

xxMikexx [17]

Answer:

72.80 % more energy will be consumed.

Explanation:

First of all, let us have a look at the formula of energy for a processor.

$E = CV^2f$

Where, $E$ is the energy

$C$ is the capacitance

$V$ is the voltage and

$f$ is the clock rate.

Let $E_1$ be the energy of older processor.

$C_1$ be the capacitance of older processor.

$V_1$ be the voltage of older processor

$f_1$ be the capacitance of older processor

So, $E_1 = C_1V_1^2f_1$ ....... (1)

and

Let $E_2$ be the energy of newer processor.

$C_2$ be the capacitance of newer processor.

$V_2$ be the voltage of newer processor

$f_2$ be the capacitance of newer processor

$E_2 = C_2V_2^2f_2$ ....... (2)

Dividing equation (2) with equation (1):

$\dfrac{E_2}{E_1} = \dfrac{C_2V_2^2f_2}{C_1V_1^2f_1}$

As per given statement:

$C_1=C_2$

$V_2=1.2\times V_1$

$f_2=1.2\times f_1$

Putting the values above:

$\dfrac{E_2}{E_1} = \dfrac{C_1\times (1.2V_1)^2\times 1.2f_1}{C_1V_1^2f_1}\\\Rightarrow \dfrac{E_2}{E_1} = \dfrac{(1.2)^2\times 1.2}{1}\\\Rightarrow \dfrac{E_2}{E_1} = 1.728\\\Rightarrow \bold{E_2 = 1.728 \times E_1}$

Energy consumed by newer processor is 1.728 times the energy consumed by older processor.

72.80 % more energy will be consumed by the newer processor.

4 0

3 years ago

In Microsoft Word, spelling errors are identified by a _____.

kvasek [131]

Red underline. Hope this helps.

5 0

2 years ago

Read 2 more answers

True or False? Most operating systems allow the user to specify a set of paths that are searched in a specific order to help res

inessss [21]

Answer:

The correct answer to the following question will be "True".

Explanation:

The "kernel" as shown at the core of your OS would be the central machine program. The program facilitates the essential functions of a computer processor, including coordinating activities, executing programs, and managing devices. This allows users to define a series of directions to try to resolve the connections to running program files in an order of preference.

So, the given statement is true.

4 0

3 years ago

Write a program that takes in an integer in the range 20-98 as input. The output is a countdown starting from the integer, and s

S_A_V [24]

Answer:

// program in C++.

#include <bits/stdc++.h>

using namespace std;

int main() {

// variable

int num;

cout<<"Enter the number between 20 and 98: ";

// read number

cin >> num;

while(num<20||num>98)

{

cout<<"Wrong input!!enter number between 20-98 only:";

cin>>num;

}

cout<<"The output is: ";

while(num % 10 != num /10)

{

// print numbers.

cout<<num<<" ";

// update num.

num--;

}

// display the number.

cout<<num<<endl;;

return 0;

}

Explanation:

Read a number from user and assign it to variable "num".Check if entered number is in between 20-98 or not.If input number is less than 20 or greater than 98 then ask again to enter a number between 20-98 until user enter a valid input.Then print the countdown from input number till both the digit of number are same.

Output:

Enter the number between 20 and 98: 99

Wrong input!!enter number between 20-98 only:12

Wrong input!!enter number between 20-98 only:93

The output is: 93 92 91 90 89 88

Enter the number between 20 and 98: 77

The output is: 77

7 0

3 years ago