I want to know the basic of Excel

Answers

Answer 1

Answer:

Use Pivot Tables to recognize and make sense of data.

Add more than one row or column.

Use filters to simplify your data.

Remove duplicate data points or sets.

Transpose rows into columns.

Split up text information between columns.

Use these formulas for simple calculations.

Get the average of numbers in your cells.


Related Questions

You plan to make a delicious meal and want to take the money you need to buy the ingredients. Fortunately you know in advance the price per pound of each ingredient as well as the exact amount you need. The program should read in the number of ingredients (up to a maximum of 10 ingredients), then for each ingredient the price per pound. Finally your program should read the weight necessary for the recipe (for each ingredient in the same order). Your program should calculate the total cost of these purchases, then display it with 6 decimal places.

Example There are 4 ingredients and they all have a different price per pound: 9.90, 5.50, 12.0, and 15.0. You must take 0.25 lbs of the first, 1.5 lbs of the second, 0.3 lbs of the third and 1 lb of the fourth. It will cost exactly $29.325000.

Answers

Answer:

In Python:

prices = []

pounds = []

print("Enter 0 to stop input")

for i in range(10):

   pr = float(input("P rice: "+str(i+1)+": "))

   pd = float(input("Pound: "+str(i+1)+": "))

   if pr != 0 and pd != 0:

       prices.append(pr)

       pounds.append(pd)

   else:

       break

amount = 0

for i in range(len(pounds)):

   amount+= (pounds[i]*prices[i])

print("Amount: $",amount)

Explanation:

These initialize the prices and pounds lists

prices = []

pounds = []

This prompts the user to enter up to 10 items of press 0 to quit

print("Enter 0 to stop input")

This iterates through all inputs

for i in range(10):

This gets the price of each item

   pr = float(input("P rice: "+str(i+1)+": "))

This gets the pound of each item

   pd = float(input("Pound: "+str(i+1)+": "))

If price and pound are not 0

   if pr != 0 and pd != 0:

The inputs are appended to their respective lists

       prices.append(pr)

       pounds.append(pd)

If otherwise, the loop is exited

   else:

       break

This initializes total to 0

amount = 0

This iterates through all inputs

for i in range(len(pounds)):

This multiplies each pound and each price and sum them up

   amount+= (pounds[i]*prices[i])

The total is then printed

print("Amount: $",amount)

Which of the following are complete sets of data and are the rows of the table?
Files
Fields
Queries
Records

Answers

Answer:

I think the answer is going to be records

The order of slides can be changed here.

Answers

ANSWER:

Yes

WHY:

Not enough information is explained


MARK ME BRAINLIEST PLEASE

Which of the following is probably not a place where it is legal to download the music of a popular artist whose CDs are sold in stores?

Answers

Answer:

A. Personal blogs

Explanation:

I did the quick check, and there you go...it's A.

Why are microcomputers installed with TCP/IP protocols?

Answers

Answer:

microcomputers are installed with TCP/IP protocols because its a set of standardized rule that allows the computer to communicate on a network such as the internet

Explanation:

determine the correct usage for styles and themes by placing each characteristic under the correct category​

Answers

Answer:

Styles create bulletin lists and are found in the format tex tab change indentation

Themes change page colors, create message borders, are found under options tab

Which of the following is a form of media?Check all that apply.

A. a brochure distributed to many people

B. a diary

C. an email to a friend

D. a blog

Answers

Answer:

A. a brochure distributed to many people.

D. a blog.

Explanation:

Communication can be defined as a process which typically involves the transfer of information from one person (sender) to another (recipient), through the use of semiotics, symbols and signs that are mutually understood by both parties.

Generally, the linear model of communication comprises of four (4) main components and these are;

1. Sender (S): this is typically the source of information (message) or the originator of a message that is being sent to a receiver. Thus, they are simply the producer of a message.

2. Channel (C): this is the medium used by the sender for the dissemination or transmission of the message to the recipient. For example, telephone, television, radio, newspapers, billboards etc.

3. Message (M): this is the information or data that is being sent to a recipient by a sender. It could be in the form of a video, audio, text message etc.

4. Receiver (R): this is typically the destination of information (message) or the recipient of a message that is being sent from a sender.

Hence, the following are forms of media (communication channel);

I. A brochure distributed to many people. It comprises of printed textual informations used mainly for promotional purposes.

II. A blog. It is an online website that contains both textual and multimedia messages, especially as a news platform.

which software manages the functioning of the entire computer system

Answers

it’s the operating system

The difference between a dot matrix printer and a line printer

Answers

Answer:

please give me brain list and follow

Explanation:

Difference Between Dot Matrix and Line Printer is that Dot-matrix printer produce printed images, they produce image when tine wire pins on a print head mechanism strike an inked ribbon. While Line printer is a type of impact printer which is high-speed and printer an entire line at a time.

Answer:

Difference between Dot Matrix and Line printer is that Dot Matrix printer produce printed images, they produce image when tine wire pins on a print head mechanism strike an inked ribbon. While Line printer ia a type of impact printer which is high speed and printer an entire Line at a time.

Four reasons why users attach speakers to their computer

Answers

Sound
Quality
Easier
Reliable

function of dobji dzong​

Answers

Answer:

Dobji is consider to be the first model dzong in Bhutan

Question 4
What methods do phishing and spoofing scammers use? List and explain methods to protect
against phishing and spoofing scams. (10 marks​

Answers

Answer:

The answer is below

Explanation:

There are various methods of phishing and spoofing scammers use, some of which are:

Phishing:

1. Descriptive phishing: here the scammer use fake email to pretend to be a genuine company and steal people's vital details

2. Spear Phishing: here the scammer creates an email that appears there is a connection on the potential victim

3. CEO Fraud: here the scammer target CEO of a company, thereby if successful can fraudulently attack the company due to his access.

Other phishing attacks are vishing, smishing, and pharming, etc.

Spoofing:

1. Email spoofing: here the attacker sends an email through a fake email address to get personal details of a potential victim

2. Caller ID Spoofing: here the attacker makes it appear that he is one specific person, but he is not in the real sense.

3. GPS Spoofing: here the attacker makes it appear he is in a specific location, whereas, he is not.

Others include website spoofing, text message spoofing, Io spoofing etc.

Describe how operating system use the following security tools: firewall, automatic updating, antivirus software, spyware and malware detection software

Answers

Answer:There are several software products and settings you can make that will help alert you to or protect you from certain kinds of technology attacks such as malware, viruses, and so on.   Use these programs and keep them up to date so they can defend you against the latest threats.

Explanation:

Write a program that will filter a list of non-negative integers such that all duplicate values are removed. Integer values will come from standard input (the keyboard) and will range in value from 0 up to 2,000,000,000. Input will be terminated by the special value, -1. Once the input is read in you should output (to the screen) the list of numbers as a sorted list (smallest to largest) with one value listed per line where all duplicates have been removed. The primary difficulty with this program is that there are an enormous number of input values and an expected large number of duplicate numbers.

Answers

Answer:

The program in python is as follows:

original = []

inp = int(input(": "))

while inp>=0:

   if inp<=2000000000:

       original.append(inp)

   inp = int(input(": "))

newlist = []

for i in original:

if i not in newlist:

 newlist.append(i)

newlist.sort()

for i in newlist:

   print(i)

Explanation:

This initializes the original list

original = []

This gets input for the list

inp = int(input(": "))

The following loop is repeated while input is not negative

while inp>=0:

This ensures that only inputs from 0 and 2000000000 enters the list

   if inp<=2000000000:

       original.append(inp)

Prompt the user for another input

   inp = int(input(": "))

This initializes a newlist

newlist = []

Iterates through the original list

for i in original:

Check for duplicate

if i not in newlist:

Each number is entered to the new list, without duplicate

 newlist.append(i)

This sorts the new list in ascending order

newlist.sort()

This prints the list item one per line

for i in newlist:

   print(i)

What menu and grouping commands is the "SORT" tool? ( please answering meeeee)

A)Home - editing

B) Edit - format

C )Page layout - sheet options

D) File - edit

Answers

C, sorting is meant to arrange therefore layout falls under that

Declare a 4 x 5 array called N.

Using for loops, build a 2D array that is 4 x 5. The array should have the following values in each row and column as shown in the output below:

1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5

Write a subprogram called printlt to print the values in N. This subprogram should take one parameter, an array, and print the values in the format shown in the output above.

Call the subprogram to print the current values in the array (pass the array N in the function call).

Use another set of for loops to replace the current values in array N so that they reflect the new output below. Call the subprogram again to print the current values in the array, again passing the array in the function call.

1 1 1 1 1
2 2 2 2 2
3 3 3 3 3
4 4 4 4 4

I really need help with this thanks. (In Python)

Answers

Answer:

N = [1,1,1,1,1],

[2,2,2,2,2],

[3,3,3,3,3],

[4,4,4,4,4]

def printIt(ar):

  for row in range(len(ar)):

      for col in range(len(ar[0])):

          print(ar[row][col], end=" ")

      print("")

           

N=[]

for r in range(4):

  N.append([])

   

for r in range(len(N)):

  value=1

  for c in range(5):

      N[r].append(value)

      value=value + 1

           

printIt(N)

print("")

newValue=1

for r in range (len(N)):

  for c in range(len(N[0])):

      N[r][c] = newValue

  newValue = newValue + 1

       

printIt(N)

Explanation:

:D

Below is the required program of Python.

Python

Program:

# Array name will be "N".

# Start program

# Defining a function and taking input array

def printIt(ar):

# Using for loop to scan the rows as well as columns of array

 for row in range(len(ar)):

     for col in range(len(ar[0])):

# Printing the element of array

         print(ar[row][col], end=" ")

     print("")

# Passing the array N

N=[]

# Again using the loop

for r in range(4):

 N.append([])

# Loop to control rows

for r in range(len(N)):

 value=1

# Loop to control columns

 for c in range(5):

     N[r].append(value)

     value=value + 1

# Calling the function

printIt(N)

print("")

newValue=1

# Value in row and column

for r in range (len(N)):

 for c in range(len(N[0])):

# Assigning the values to the array

     N[r][c] = newValue

 newValue = newValue + 1

# Printing the array

# End program

printIt(N)

Program code:

Start a program.Defining a function and taking input arrayUsing for loop to scan the rows as well as columns of arrayPrinting the element of arrayAgain using the loop to control rows and columns.Assigning the values to the arrayEnd program.

Output:

Find below the attachment of the output of the program code.

Find out more information about Python here:

https://brainly.com/question/26497128

Write an application that combines several classes and interfaces.

Answers

Answer:

Explanation:

The following program is written in Java and it combines several classes and an interface in order to save different pet objects and their needed methods and specifications.

import java.util.Scanner;

interface Animal {

   void animalSound(String sound);

   void sleep(int time);

}

public class PetInformation {

   public static void main(String[] args) {

       Scanner scnr = new Scanner(System.in);

       String petName, dogName;

       String dogBreed = "null";

       int petAge, dogAge;

       Pet myPet = new Pet();

       System.out.println("Enter Pet Name:");

       petName = scnr.nextLine();

       System.out.println("Enter Pet Age:");

       petAge = scnr.nextInt();

       Dog myDog = new Dog();

       System.out.println("Enter Dog Name:");

       dogName = scnr.next();

       System.out.println("Enter Dog Age:");

       dogAge = scnr.nextInt();

       scnr.nextLine();

       System.out.println("Enter Dog Breed:");

       dogBreed = scnr.nextLine();

       System.out.println(" ");

       myPet.setName(petName);

       myPet.setAge(petAge);

       myPet.printInfo();

       myDog.setName(dogName);

       myDog.setAge(dogAge);

       myDog.setBreed(dogBreed);

       myDog.printInfo();

       System.out.println(" Breed: " + myDog.getBreed());

   }

}

class Pet implements Animal{

   protected String petName;

   protected int petAge;

   public void setName(String userName) {

       petName = userName;

   }

   public String getName() {

       return petName;

   }

   public void setAge(int userAge) {

       petAge = userAge;

   }

   public int getAge() {

       return petAge;

   }

   public void printInfo() {

       System.out.println("Pet Information: ");

       System.out.println(" Name: " + petName);

       System.out.println(" Age: " + petAge);

   }

   //The at (email symbol) goes before the Override keyword, Brainly detects it as a swearword and wont allow it

   Override

   public void animalSound(String sound) {

       System.out.println(this.petName + " says: " + sound);

   }

//The at (email symbol) goes before the Override keyword, Brainly detects it as a swearword and wont allow it

  Override

   public void sleep(int time) {

       System.out.println(this.petName + " sleeps for " + time + "minutes");

   }

}

class Dog extends Pet {

   private String dogBreed;

   public void setBreed(String userBreed) {

       dogBreed = userBreed;

   }

   public String getBreed() {

       return dogBreed;

   }

}

The XYZ daycare has installed a new high-tech system for keeping track of which children are under its supervision at any moment in time. Each parent of a child has a card with a unique ID, where the ID is some integer x. Every morning, the parent swipes the card at a card-reader when dropping their child off at the daycare. The system then adds x to an array of integers. In the evening, when the parent comes to pick up the child, the same card is swiped, and a second copy of x is added to the list. Each night at midnight, the array is wiped clean and reset to have zero elements. In this way, the daycare can quickly check every afternoon which children are yet to be picked up by their parents by picking out the array elements that occur precisely once. Unfortunately, at 4:55 pm on Thursday, April 20, 2017, the daycare realizes that somewhere in their daycare is precisely one child who is yet to be picked up. Can you help them determine the integer ID of this child

Answers

Answer:

Use or Add a log of the actions of the system including the integer, the action,  and the time. Scroll through and see which integer was added but was not removed.

Explanation:

I wouldn't be able to program this, but I think a log is the best solution for this.

To understand, read, and give meaning to data in
tables and charts is to perform which of the
following?

A interpretation

B analysis

C assessment

D data collection

Answers

Answer:

teh answer is b

Explanation:

which of the

following?

A interpretation

B analysis

C assessment

D data collection

Answer:

interpretation

Explanation:

1

The city of Green Acres is holding an election for mayor. City officials have decided to automate the process of tabulating election returns and have hired your company to develop a piece of software to monitor this process. The city is divided into five precincts. On election day, voters go to their assigned precinct and cast their ballots. All votes cast in a precinct are stored in a data file that is transmitted to a central location for tabulation.

Required:
Develop a program to count the incoming votes at election central.

Answers

Answer:

Explanation:

The following program asks the user to enter the precinct number and then loops to add votes until no more votes need to be added. Then it breaks the loop and creates a file called results to save all of the results for that precinct.

precinct = input("Enter Precinct Number: ")

option1 = 0

option2 = 0

while True:

   choice = input("Enter your vote 1 or 2: ")

   if int(choice) == 1:

       option1 += 1

   else:

       option2 += 1

   endVote = input("Vote again y/n")

   if endVote.lower() != 'y':

       break

f = open("results.txt", "w")

f.write("Precinct " + precinct + ": \nOption 1: " + str(option1) + "\nOption 2: " + str(option2))

list out and discuss the characteristics of big data​

Answers

Answer:

Volume: Volume refers to the sheer size of the ever-exploding data of the computing world. It raises the question about the quantity of data.

Velocity: Velocity refers to the processing speed. It raises the question of at what speed the data is processed.

Variety: Variety refers to the types of data.

Explanation:


State
any three (3) reasons why users attach speakers to their computer?

Answers

Answer:

To complete the computer setup, to hear audio, to share audio.

Explanation:

A computer is not really complete without speakers.

So that you can actually hear the computer's audio.

So that you can have multiple people hear the same audio. (Headphones do not do this)

why do we need to settle technology in business?​

Answers

Answer:

Technology has important effects on business operations. No matter the size of your enterprise, technology has both tangible and intangible benefits that will help you make money and produce the results your customers demand. Technological infrastructure affects the culture, efficiency and relationships of a business.

This is gonna be very long but I have no idea what to do, I'm confused.

Course Project Part 4: Conducting the Experiment and Recording Data
After much preparation, you are finally ready to begin conducting your experiment. Due to all the hard work you put into your literature review and planning your procedures, the steps that you need to take to conduct your experiment successfully have already been set. While you conduct your experiment, you will need to keep a daily journal where you record the activities you undertake that are relevant to the experiment and also where you record any data that you collect. This is your experiment log and serves as a record of your work while also allowing you to make a record of any changes or modifications you may need to make during the experiment.

Conducting the Experiment and Keeping an Experiment Journal
Following the procedure that you established in the previous part of this project, set up your experiment and begin running it. Every day while your experiment is running you will make an entry in your journal. Record what activities you completed (refer to your outlined procedure to make sure you are following the procedure that you established), any modifications that had to be made to your set up or procedure, and any observations or data you collect. Even on days when you do not collect data (depending on your experiment, there may not be data collection every day), make an entry in your journal. Each journal entry should be clearly labeled with the date on which it was entered. You do not need to type up all your entries, but make sure that your journal entries are neatly written, as they will be evaluated by your instructor.

Depending on the topic and design of your experiment, the period of time during which you conduct and record your experiment may range from one to several weeks. In consultation with your instructor, you will establish a timeline for the evaluation of your journal. If you are running a shorter experiment, your journal may be evaluated several times over the course of one or two weeks. If your experiment takes longer to complete, you may have a weekly review over the course of a month. Follow the guidelines provided by your instructor.

Collecting Data
All experiments generate data. This data allows the scientist to evaluate the success of the experiment and make interpretations about the results generated by the investigation. When you record your data, you must collect it as consistently as possible. Returning to the plant experiment, it would be best to measure the plants on a set schedule. For example, you might choose to measure the plants every Thursday at 3 pm. It is important to measure the plants at the same time each week so that the difference in growth you might observe is a reflection of the experimental condition, not simply longer growing time. Additionally, it is important to use the same instruments to collect data. The plants should be measured with the same ruler or measuring tape each time. This helps reduce any error or bias that might be introduced by using different instruments to make measurements. Whatever measurements or data you collect, do so in a consistent manner. Use the same instruments, the same scales, and record the data in a standardized manner. It is also a good idea to record your experiment using photographs. This will help you later during analysis and provides information for others who might be interested in recreating your experiment. Record your data in your experiment journal, where it will be reviewed by your teacher on an on-going basis. Submit your journal to your instructor according to the schedule you have established together.

Someone answered before but gave a link and I don't trust it

Answers

for such experiment, you do it with care and to acquire and determine to put experience in it

Explanation:

because without you been or using experience the experiment will not correct

What methods do phishing and spoofing scammers use?

Answers

Answer:

please give me brainlist and follow

Explanation:

There are various phishing techniques used by attackers:

Installing a Trojan via a malicious email attachment or ad which will allow the intruder to exploit loopholes and obtain sensitive information. Spoofing the sender address in an email to appear as a reputable source and request sensitive information

Q.No.3 b. (Marks 3)
Explain why change is inevitable in complex systems and give examples (apart from prototyping and incremental delivery) of software process activities that help predict changes and make the software being developed more resilient to change.

Answers

Answer:

The change in complex systems can be explained according to the relationship of the environment where the system is implemented.

The system environment is dynamic, which consequently leads to adaptation to the system, which generates new requirements inherent to changes in business objectives and policies. Therefore, changing systems is necessary for tuning and usefulness so that the system correctly supports business requirements.

An example is the registration of the justification of the requirements, which is a process activity that supports changes in the system so that the reason for including a requirement is understood, which helps in future changes

Explanation:

Setting Up Cascading Deletes
Use the drop-down menus to complete the steps to set up cascading deletes between two related tables.
1. Click the
tab
2. In the Relationships group, click Relationships
3. Double-click
4. In the Edit Relationship dialog box, add a check mark next to
5. Click OK
Done

Answers

Answer:

Database Tools, The Line Connecting the Tables, Cascade Delete Related Records

Explanation:

8.9 Lesson Practice edhesive

Answers

Answer:

1. search

2. False

3. Our algorithm did not find the element we were looking for.

Explanation:

According to O*NET, what is the most common level of education earned by Secondary School Special Education Teachers?

master’s degree
bachelor’s degree <------- THE ANSWER
some college, no degree
associate degree
POSTED TO HELP OTHERS

Answers

Answer:

bachelor’s degree

Explanation:

Answer:

B bachelors degree

Explanation:

The phone in your hand is a computer. So too is the machine that occupies a 100,000 square foot data center. Given their vast differences in size, how can they both be computers?

Answers

Answer:

Well when you think about it they both do the same thing but they are diffirent, they have the same perpose but diffirent parts in them so, when you compair them the phone is smaller and slower, the bigger the computer the better it is depending on the amount of money spent on parts.

Other Questions
Hurry 20ptsIdentify each sentence as either the topic or the theme of "The Three Little Pigs." Three pigs build houses from different materials and try to avoid a wolf. In the long run, taking the time to do something well, such as constructing a house from bricks, is better than taking a shortcut, such as building a house from straw. someone please help me answer this ...The Slave Trade and Colonization: Tutorial11 of 35E Save & ExitQuestionAType your response List three factors that that caused Africa to become a growing source of slaves for the slave trade. Which is more dangerous for the world A world war or a bio- war? Justify your answer. (80-100words what can i use to curl my eyelashes other den mascara and eyelash curler Solve the equation. What is the value of x? x minus 6.8 = 356.3 x = please help as soon as possible A state wants to build a light rail system between two cities. It purchases most of the land needed for the system, but one family refuses to sell its property to the state. What can the state do?The state can file a civil law case with the Supreme Court to get the land.The state will ask the federal government to handle the negotiations with the family.There is nothing the state can do and the plans for the light rail system will not proceed.The state has the authority through eminent domain to take the land if it is necessary for the general public. A triangle on a sphere could have____degrees.A. 175B. 220C. 180D. any number of Two people play a game in which they randomly draw numbers from 1 to 13. If the number is even, player 1 wins. Otherwise, player 2 wins. This is a fair game. True False Which of the following is true about the figure?a. m MUC - m MUP = m PUCb. m DUC + m VUA = m DUVC. m MUC = m MUV = m VUA = m AUDd. m CUA + m DUP = m PUM Three vertices of a rectangle are at points (-2, 2), (4,2) and (4, -1). Which point could be the fourth vertex of the rectangle?A. 2, 1B. -2, -1C. 2, 4D. -2, 1 Part DWhat do the measures of angles BDA and BEA and the fact that AD and AE are radii of circle A tell us about BD and BE Font Sizes The digestive system of most birds includes a structure called the gizzard. Thegizzard crushes and grinds food, often with the help of small stones that the birdhas swallowed.Which of the following structures in the human digestive system has a function mostsimilar to that of a bird's gizzard?F esophagusG large intestineH small intestineJ teeth count the numbers of triangles in the figures A weather report said there is a 60% chance of rain on Monday, and a30% chance of rain on Tuesday. Based on the report, what is the chanceit will rain on both days?-Select- What is the main function of the urinary system?AIt keeps your body hydrated.B.It expels water from your body.It removes poisons from your body. Jack bought 3 slices of cheese pizza and 4 slices ofmushroom pizza for a total cost of $12.50. Gracebought 3 slices of cheese pizza and 2 slices ofmushroom pizza for a total cost of $8.50.a. What is the cost of one slice of cheese pizza andone slice of mushroom pizza?b. Jordyn met Jack and Grace for pizza. She bought 5cheese slices and 2 mushroom pizzas. How much didshe spend? what is the sum, product of [tex]2 {x}^{2} + 3x = 0[/tex] Which examples demonstrate common Sales and Service work environments? Check all that apply.Tara travels to meet with customers and sell them parts.Wesley works in an airplane, assisting passengers with their needs.Audrey works in an office, taking customer orders over the telephone.Bernard works at a ticket counter in an airport.Yuk works on a ship, overseeing other workers.Leo drives a large tractor-trailer truck across long distances.