All categories

2 years ago

What does clicking and dragging the fill handle in excel

Computers and Technology

1 answer:

Olegator [25]2 years ago

5 0

Answer:

The fill handle copies the same values, formulas, or fills a series of dates, texts, numbers, and other data to a desired number of cells. ... Click and hold the handle, then you can drag up, down, across over other cells. When you release your mouse button, it auto-fills the content to the cells you dragged over.

You might be interested in

This question is for one of my classes I am in right now, and the question is:

suter [353]

Answer:

I will respond by saying the destination is not the most important , the journey is.

Explanation:

8 0

3 years ago

Assign testResult with 1 if either geneticMarkerA is 1 or geneticMarkerB is 1. If geneticMarkerA and geneticMarkerB are both 1,

OverLord2011 [107]

Answer:

Following python statement will give the assignment to testResult as specified:

if((geneticMarkerA == 1) or (geneticMarkerB ==1)):

testResult = 1

if((geneticMarkerA ==1) and (geneticMarkerB == 1)):

testResult = 0

if((geneticMarkerA == 0) and (geneticMarkerB == 0)):

testResult = 0

Explanation:

In above statements or and and operator are used to check the conditions of set of values present in variable geneticMarkerA and geneticMarkerB.

Based on if the condition evaluate to true or false respective values to testResult varaible is assigned.

Following is sample run for above statements:

geneticMarkerA = 1

geneticMarkerB = 0

if((geneticMarkerA == 1) or (geneticMarkerB ==1)):

testResult = 1

if((geneticMarkerA ==1) and (geneticMarkerB == 1)):

testResult = 0

if((geneticMarkerA == 0) and (geneticMarkerB == 0)):

testResult = 0

print(testResult)

Output

4 0

3 years ago

Most project files will contain:

Leno4ka [110]

Explanation:

not A or D,

about B and C I'm not sure

7 0

3 years ago

Reference variables allow arguments to be passed by ____________.

son4ous [18]

Answer:

Reference

Explanation:

The Reference type variable is such type of variable in C# that holds the reference of memory address instead of value. Examples for reference type are classes, interfaces, delegates and arrays.

We can pass parameters to the method by reference using <em>ref </em>keyword

It’s mandatory to initialize the variable value before we pass it as an argument to the method in c#

For example,

int x = 10; // Variable need to be initialized

Add(ref x); // method call

If you pass parameters by reference in method definition, any changes made to it affect the other variable in method call.

Here's a sample program:

using System;

namespace ConsoleApplication

{

public class Test

{

public static void Main()

{

int i = 10;

Console.WriteLine("i=" + i);

Add(ref i);

Console.WriteLine("i=" + i);

Console.ReadLine();

}

public static void Add( ref int j)

{

j = j + 10;

Console.WriteLine("j="+j);

}

Output:

i=10

j=20

i=20

7 0

3 years ago

Use JavaWrite a program that will simulate a change machine found at cash registers. Input the amount due and amount paid from t

Ksju [112]

Answer:

Here is the JAVA program:

import java.util.Scanner; //to accept input from user

public class Main { // class name

public static void main(String [] args) { // start of main method

Scanner input = new Scanner(System.in); // creates Scanner class object to take input from user

System.out.println("Please Enter the Cost of the Item: "); // prompts user to enter the cost of item

double itemCost = input.nextDouble(); //scans and reads the input value of item cost

System.out.println("Please Enter the Amount Paid: "); // prompts user to enter the amount paid

double amount = input.nextDouble(); //scans and reads the value of amount from user

int change = (int)(amount * 100 - itemCost * 100); //compute the remaining amount i.e. change

System.out.println("Change Owed: " + change / 100.0); // displays the owed change

int quarters = change / 25; // computes the value for quarters

change = change % 25; // compute the quarters remaining

int dimes = change / 10; // computes dimes

change = change % 10; // computes dimes remaining

int nickels = change / 5; // computes nickels

change = change % 5; // compute nickels remaining

int pennies = change; // computes pennies

System.out.println("Quarters: " + quarters); // displays computed value of quarters

System.out.println("Dimes: " + dimes); // displays value of dimes

System.out.println("Nickels: " + nickels); // displays value of nickels

System.out.println("Pennies: " + pennies); }} //displays value of pennies

Explanation:

I will explain the program with an examples.

Suppose the user enters 4.57 as cost of the item and 5.00 as amount paid. Then the program works as follows:

Change is computed as

change = (int)(amount * 100 - itemCost * 100);

This becomes;

change = (int)(5.00 * 100 - 4.57 * 100)

= 500 - 457

change = 43

Now the change owed is computed as:

change / 100.0 = 43/100.0 = 0.43

Hence change owed = 0.43

Next quarters are computed as:

quarters = change / 25;

This becomes:

quarters = 43/25

quarters = 1

Now the remaining is computed as:

change = change % 25;

This becomes:

change = 43 % 25;

change = 18

Next the dimes are computed from remaining value of change as:

dimes = change / 10;

dimes = 18 / 10

dimes = 1

Now the remaining is computed as:

change = change % 10;

This becomes:

change = 18 % 10

change = 8

Next the nickels are computed from remaining value of change as:

nickels = change / 5;

nickels = 8 / 5

nickels = 1

Now the remaining is computed as:

change = change % 5;

This becomes:

change = 8 % 5

change = 3

At last the pennies are computed as:

pennies = change;

pennies = 3

So the output of the entire program is:

Change Owed: 0.43 Quarters: 1 Dimes: 1 Nickels: 1 Pennies: 3

The screenshot of the output is attached.

7 0

3 years ago