To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12

Answers

Answer 1

Answer:

For finding the largest quantity of items ordered from Rex Technologies the excel formula used is max(). Inside max you must specify the range of rex technologies quantity column cells just like if quantity is in D column and rex technologies items start from cell 4 to cell 7 then the formula will be max(D4:D7)

Explanation:

In max formula first argument is starting cell of range and last is ending cell of range. In this scenario starting cell is D4 and end cell D7


Related Questions

Write some code that assigns True to the variable is_a_member if the value assigned to member_id can be found in the current_members list. Otherwise, assign False to is_a_member. In your code, use only the variables current_members, member_id, and is_a_member.

Answers

Answer:

current_members = [28, 0, 7, 100]

member_id = 7

if member_id in current_members:

   is_a_member = True

else:

   is_a_member = False

print(is_a_member)

Explanation:

Although it is not required I initialized the current_members list and member_id so that you may check your code.

After initializing those, check if member_id is in the current_members or not using "if else" structure and "in" ("in" allows us to check if a variable is in a list or not). If member_id is in current_members, set the is_a_member as True. Otherwise, set the is_a_member as False.

Print the is_a_member to see the result

In the example above, since 7 is in the list, the is_a_member will be True

HELP!!
Why is email etiquette important? (1 point)

Email is rarely used to communicate via technology.

With more and more written communication through technology, it is important to sound competent and qualified and for your meaning to be clear.

Not many classes are taken online.

Even though companies and employers use a lot of email communication, they don't really care if you are clear with your communication

Answers

Answer:

B

Explanation:

1. Add an import statement above the class declaration to make the Scanner class available to your program.
2. In the main method, create a Scanner object and connect it to the System.in object.
3. Prompt the user to enter his/her first name.
4. Read the name from the keyboard using the nextLine method, and store it into a variable called firstName (you will need to declare any variables you use).
5. Prompt the user to enter his/her last name.
6. Read the name from the keyboard and store it in a variable called lastName.
7. Concatenate the firstName and lastName with a space between them and store the result in a variable called fullName.
8. Print out the fullName.
9. Compile, debug, and run, using your name as test data.
10. Since we are adding on to the same program, each time we run the program we will get the output from the previous tasks before the output of the current task.

Answers

Answer:

import java.util.Scanner;

public class Assignment{

public static void main(String [] args)

{

Scanner input = new Scanner(System.in);

String firstName, lastName;

System.out.print("Firstname: ");

firstName = input.nextLine();

System.out.print("Lastname: ");

lastName = input.nextLine();

String fullName = firstName +" "+lastName;

System.out.print(fullName);

}

}

Explanation:

I'll use the line numbers in the question to point at the corresponding instruction

import java.util.Scanner; -- The import statement (1)

public class Assignment{

public static void main(String [] args)

{

Scanner input = new Scanner(System.in); -- Scanner object (2)

String firstName, lastName; -- Variable declarations

System.out.print("Firstname: "); ---- Prompt to enter first name (3)

firstName = input.nextLine(); --- User input for firstName (4)

System.out.print("Lastname: "); ---- Prompt to enter first name (5)

lastName = input.nextLine(); --- User input for lastName (6)

String fullName = firstName +" "+lastName; --- concatenating both user inputs (7)

System.out.print(fullName); --- Print out fullName (8)

}

}

Implement the following logic in C++, Use appropriate data types. Data types are represented as either numeric (num) or string.
start
string name
string address
num item //use int
num quantity
num price //use double as data type
num SIZE = 6
num VALID_ITEM [SIZE] = 106, 108, 307, 405, 457, 688 //use int as data type
num VALID_ITEM_PRICE [SIZE] = 0.59, 0.99, 4.50, 15.99, 17.50, 39.00 //use double as data type
num i
bool foundIt = false
string MSG_YES = "Item available"
string MSG_NO = "Item not found" get name, address, item, quantity
i = 0
while i < SIZE
if item == VALID_ITEM [i] then
foundIt = true
price = VALID_ITEM_PRICE [i]
endif
i = i + 1
endwhile
if foundIt == true then
print MSG_YES
print quantity, " at " , price, " each"
print "Total ", quantity * price
else
print MSG_NO
endif
stop

Answers

Answer:

Follows are the modified code in c++ language:

#include<iostream>//header file

#include<string>//header file

using namespace std;

int main()//main method

{

string name,address, MSG_YES, MSG_NO;//defining string variable

int item,quantity,size=6, i=0;//defining integer variable

double price;//defining double variable  

int VALID_ITEM[]={106,108,307,405,457,688};//defining integer array and assign value

double VALID_ITEM_PRICE[]={0.59,0.99,4.50,15.99,17.50,39.00};//defining double array and assign value

bool foundIt=false;//defining bool variable  

MSG_YES="Item available";//use string variable to assign value

MSG_NO = "Item not found"; //use string variable to assign value

cout<<"Input name: ";//print message

cin>>name;//input value in string variable

cout<<"Input Address: ";//print message

cin>>address;//input value in string variable

cout<<"Input Item: "<<endl;//print message

cin>>item;//input value in string variable

cout<<"Input Quantity: "<<endl;//print message

cin>>quantity;//input value in string variable

while(i <size)//defining while that checks i less then size  

{

if (item ==VALID_ITEM[i]) //use if block to match item in double array

{

foundIt = true;//change bool variable value

price = VALID_ITEM_PRICE[i];//hold item price value in price variable  

}

i++;//increment the value of i

}

if (foundIt == true)//use if to check bool variable value equal to true

{

cout<<MSG_YES<<endl;//print value

cout<<"Quantity "<<quantity<<" at "<<"Price "<<price<<"each"<<endl;//print value

cout<<"Total"<<quantity*price;//calculate the total value

}

else//else block

cout<<MSG_NO;//print message  

}

Output:

please find the attached file.

Explanation:

In the above given C++ language modified code, four-string variable " name, address, MSG_YES, and MSG_NO", four integer variable "item, quantity, size, and i", and "integer and double" array is defined, that holds values.

In the string and integer variable "name, address, and item, quantity", we input value from the user-end and use the while loop, which uses the if block to check the "item and quantity" value from the user end and print its respective value.

If a function does not return a value, which of the follow is correct?Group of answer choicesThe return type is a Swift optional type.The return type must be set to nil.The return type is omitted from the function declaration.

Answers

Answer:

In swift programming language it is ok when a function does not return any value you are not necessarily required to set return type because it is optional so the correct answer is  "The return type is omitted from the function declaration".

Explanation:

If programing language is swift so we can omit return type from function declaration otherwise if language is C++ we can set return type "Void".

write a program that reads in a number n and prints out n rows each containing n star charactersg

Answers

In python:

rows = int(input("How many rows would you like? "))

i = 0

while i < rows:

   print("*" * rows)

   i += 1

I hope this helps!

Read the following code:

x = 1
while(x < 26)
print(x)
x = x + 1

There is an error in the while loop. What should be fixed? (5 points)

Select one:
a. Add a colon to the end of the statement
b. Begin the statement with the keyword count
c. Change the parentheses around the test condition to quotation marks
d. Use quotation marks around the relational operator

Answers

For a while loop to function properly, it needs a colon after it.

Answer choice A is correct.

What is the difference between Information Technology and Communication Technology?​

Answers

Answer:

Explanation:

information tech is technology that teaches you information, and communication tech is tech that lets you talk to family and friends and meet new people.

Answer:

The main difference between information technology and communication technology is that Information technology is a subject that is use of computers to store, retrieve, transmit and manipulate data, or information, often in the context of business or other enterpise whereas a Communication technology is the use of computers to communicate with family and friends.

What is a clip art gallery

Answers

Clip art is a collection of pictures or images that can be imported into a document or another program. The images may be either raster graphics or vector graphics. Clip art galleries many contain anywhere from a few images to hundreds of thousands of images.

PLEASE HURRY!!!
Look at the image below!

Answers

Answer:

cde

Explanation:

You start counting from 0.

So letters are:

a b c d e f

0 1 2 3 4 5

We do include the 2, but not the 5. So answer is cde.

Your game design company has recently asked all employees to use a specific personal information management application (PIM) to increase workplace efficiency. The PIM is collaborative, so contacts, calendar entries, and notes are shared across the team. Several team members are resistant to the idea, saying it interrupts their workflow, and they prefer their own way of handing contacts, notes, etc. Others don’t want their own notes to be seen by their coworkers.

Answers

Answer:For example, an office worker might manage physical documents in a filing cabinet by placing them in folders organized alphabetically by project name, or might manage digital documents in folders in a hierarchical file system.

Explanation:

Write a program named palindromefinder.py which takes two files as arguments. The first file is the input file which contains one word per line and the second file is the output file. The output file is created by finding and outputting all the palindromes in the input file. A palindrome is a sequence of characters which reads the same backwards and forwards. For example, the word 'racecar' is a palindrome because if you read it from left to right or right to left the word is the same. Let us further limit our definition of a palindrome to a sequence of characters greater than length 1. A sample input file is provided named words_shuffled. The file contains 235,885 words. You may want to create smaller sample input files before attempting to tackle the 235,885 word sample file. Your program should not take longer than 5 seconds to calculate the output
In Python 3,
MY CODE: palindromefinder.py
import sys
def is_Palindrome(s):
if len(s) > 1 and s == s[::-1]:
return true
else:
return false
def main():
if len(sys.argv) < 2:
print('Not enough arguments. Please provide a file')
exit(1)
file_name = sys.argv[1]
list_of_palindrome = []
with open(file_name, 'r') as file_handle:
for line in file_handle:
lowercase_string = string.lower()
if is_Palindrome(lowercase_string):
list_of_palindrome.append(string)
else:
print(list_of_palindrome)
If you can adjust my code to get program running that would be ideal, but if you need to start from scratch that is fine.

Answers

Open your python-3 console and import the following .py file

#necessary to import file

import sys

#define function

def palindrome(s):

   return len(s) > 1 and s == s[::-1]

def main():

   if len(sys.argv) < 3:

       print('Problem reading the file')

       exit(1)

   file_input = sys.argv[1]

   file_output = sys.argv[2]

   try:

       with open(file_input, 'r') as file open(file_output, 'w') as w:

           for raw in file:

               raw = raw.strip()

               #call function

               if palindrome(raw.lower()):

                   w.write(raw + "\n")

   except IOError:

       print("error with ", file_input)

if __name__ == '__main__':

   main()

PLEASE HURRY!!!

Look at the image below!

Answers

Answer:A and E

Explanation:

The last three are strings while the other choices are integers.

Putting ' ' or " " around something makes it a string and the input is asking the user to input a string.

The IP address and the port are both numbers. Which statement is true?
A computer has many IP addresses and many ports.
A computer has one IP address and many ports.
A computer has one IP address and one port,
Acomputer has many IP addresses and one port.

Answers

Answer:

A computer has one IP address and many ports.

Explanation:

Answer:

A computer has one IP address and many ports.

Explanation:

WILL MARK AS BRAINLIEST
Describe the environmental issues in India and list ways that technology has been used to address these issues.

Answers

India has been having to engineer better technology to better prepare people in india for the brutal monsoon seasons in india

to save a copy of word online document to your hard drive which option should you select? Save as , save, rename or download and copy

Answers

Answer:

 The correct answer is Save as              

                                                                                                                                               

The option that is to select to save a copy of word online document to hard drive is the save as option.

What is word document?

The term “Word Document” is used to denote the document that is made in the Microsoft Word. This document is made in the proper format with the MS Word. This document can be safe electronically by selecting the save as option.

After saving that document, this will automatically save on the hard drive of the computer device of that user.

Therefore, option A is correct.

Learn more about the Word document, refer to:

https://brainly.com/question/15939168

#SPJ2

Which of the following is another word for a copyeditor?


microeditor

macroeditor

assignment editor

assistant editor

Answers

Answer: speaking of microeditor

Explanation: thats not the only thing i know of thats micro :0

Which of the following is another word for a copyeditor?


The answer: microeditor
Hope it helps:)

in programming and flowcharting, what components should you always remember in solving any given problem?

Answers

Answer:

you should remember taking inputs in variables

What issues will the Internet of Things present to Cybersecurity?

Answers

Answer:

The IoT offers new ways for businesses to create value, however the constant connectivity and data sharing also creates new opportunities for information to be compromised. Explore some of the more notable developments in the battle to combat cyber risks.

Explanation:

I hope this helps you. UwU. P.S. Plz mark me Brainlyest

Nowadays computer games are mostly available on external
hard disk.
Is it true or false?

Answers

Answer:

false

Explanation:

because a lot of times they are downloads without the disk

It is false that nowadays computer games are mostly available on external hard disk.

What is hard disk?

A hard disk drive (HDD) is a type of computer storage device that uses magnetic storage to store and retrieve digital information.

Hard disks are usually located inside the computer and are used to store the operating system, applications, and user data such as documents, pictures, and videos.

Computer games can be stored on a variety of devices, including internal hard drives, external hard drives, solid state drives, and even cloud storage.

While external hard drives may be a popular option for some users, computer games can be installed and played from a variety of storage devices depending on user preferences and hardware capabilities.

Thus, the given statement is false.

For more details regarding hard disk, visit:

https://brainly.com/question/9480984

#SPJ2

Which statements are true regarding file management? File management means grouping related files into folders. You can store multiple folders within a file. However, a single folder can only store a single file. You can also create subfolders. Related folders when grouped together are called subfolders. When you logically organize files, folders, and subfolders, you'll get a file hierarchy resemblinga tree.​

Answers

The statements that is true regarding file management are;

File management means grouping related files into folders. You can also create subfolders. Related folders when grouped together are called subfolders.

What is file management what does it include?

File Management is known to be one that is made up of the common operations done  on files or groups of files, such as creating, opening, renaming, and others

Note that in file management,  Each user are required to access to create, delete, read, write, and modify a file and also user need to have limitations to no access to others files.

Hence, The statements that is true regarding file management are;

File management means grouping related files into folders. You can also create subfolders. Related folders when grouped together are called subfolders.

Learn more about file management from

https://brainly.com/question/12736385

#SPJ1

Before inserting a preformatted table of contents, what must you do first?
apply heading styles to text
update the table of contents
navigate to the Review tab and the Table of Contents grouping
navigate to the Insert Table of Contents dialog box

Answers

Answer: apply heading styles to text.

Explanation:

Low level security is designed to detect and impede _____ some unauthorized external activity Some None Most All

Answers

Answer:

Low-level security is designed to detect and impede some unauthorized external activity.

Examples of low-level security systems include:

Basic physical obstacles to defense  Locks for increased-security  Simple lighting coverage  Standard alarm Systems

Explanation

Protection devices that prevent and track any unwanted external actions are called Low-Level security measures.

Other obstacles to the installation of the security system, such as reinforced doors, fences, high-security locks, and window bars and grates, are often installed after simple physical protection barriers and locks have been created.

Also, a simple lighting system that could not be more complex than the standard security lighting systems over windows and doors and a regular security warning system that will be an unattended unit that offers monitoring capability and sound warnings at the location of unwanted entry.

Storage facilities, convenience shops, and small business premises are some of the locations that incorporate low-level security devices.

Cheers

Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:

Answers

The complete question is:

Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:

a. Display the SMemberID and SMemberName for all staff members.

b. Display the CCID, CCName, and CCIndustry for all corporate clients.

c. Display the BuildingID, BNoOfFloors, and the manager’s MFName and MLName for all buildings.

d. Display the MFName, MLName, MSalary, MBDate, and number of buildings that the manager manages for all managers with a salary less than $55,000.

e. Display the BuildingID and AptNo, for all apartments leased by the corporate client WindyCT.

f. Display the InsID and InsName for all inspectors whose next inspection is scheduled after 1-JAN-2014. Do not display the same information more than once.

g. Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate location is Chicago. Do not display the same information more than once.

h. Display the CCName of the client and the CCName of the client who referred it, for every client referred by a client in the music industry.

i. Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that are not leased.

Also a schema of the HAFH database is attached.

Answer:

Using SQL's SELECT, FROM, WHERE syntax, find below the queries for each question.

a.

SELECT SMemberID , SMemberName  

FROM staffmember

b.

SELECT CCID, CCName, CCIndustry

FROM corpclient

c.

SELECT b.BuildingID, b.BNoOfFloors, m.MFName, m.MLName

FROM building b, manager m

WHERE b.ManagerID = m.ManagerID

d.  

SELECT m.MFName, m.MLName, m.MSalary, m.MBDate, count(*) as buildings

FROM building b, manager m

WHERE m.MSalary<55000

AND b.ManagerID = m.ManagerID

GROUP BY m.ManagerID

e.

SELECT b.BuildingID, a.AptNo

FROM building b, apartment a, corpclient c

WHERE c.CCName = "WindyCT"

AND c.CCID = a.CCID

AND a.BuildingID = b.BuildingID

f.

SELECT DISTINCT i.InsID, i.InsName  

FROM inspector i, inspecting x

WHERE i.InsID = x.InsID

AND x.DateNext > "2014-01-01"

g.

SELECT DISTINCT s.SMemberID, s.SMemberName  

FROM staffmember s, cleaning c, apartment a, corpclient cc

WHERE s.SmemberID = c.SmemberID

AND c.AptNo = a.AptNo

AND a.CCID = cc.CCID

AND cc.CCLocation = "Chicago"

h.

SELECT cc1.CCName, cc2.CCName  

FROM corpclient cc1, corpclient cc2

WHERE cc1.CCIDReferencedBy = cc2.CCID  

AND cc2.CCIndustry = "Music"

i.

SELECT a.BuildingID, a.AptNo, a.ANoOfBedrooms

FROM apartment a

WHERE a.CCID NOT IN (SELECT c.CCID FROM corpclient c)

Which of the following industries does not use technology?

Medicine

Marketing and advertising

Law enforcement

Arts and entertainment

None of the above

Answers

Answer:

None of the above

Explanation:

Medicine uses technology to research

Advertiseres use platforms like Instagram to share the product they are promoting

Law enforcement uses tech to pull up databases of people's records

Arts and entertainment use them to create (in some cases), share, and sell their art.

Hope this helps!

Answer:

E

Explanation: got it right on edge 2020

What information is required for a complete citation of a website source?
A: the title, volume number, and page numbers
B: the responsible person or organization and the website URL
C: the responsible person or organization, date accessed, and URL
D: the responsible person or organization and the date accessed

Answers

Answer:

C: the responsible person or organization, date accessed, and URL

Explanation:

which type of memory helps in reading as well as writing data and modify data

Answers

Answer:

RAM (Random access memory)helps in reading aswell as writing data

Cleary specifying the theme to be used for a site
before building it provides which main advantage:
site navigation
site consistency
O
a clear message
O O O
improved readability

Answers

Answer: site consistency

Answer:

B) Site Consistency

Explanation:

How to get passed administrattor on macbook air to get games and stuff.

Answers

Answer:

You need to use the name and password of the main owner of the computer/the account you made when you first got it. Then, you should be able to download apps and use it if you have your apple ID set up.

Explanation:

ASAP 20 Points please hurry

Answers

Answer:

All you got to do is type System.out printIn("Study English) etc...

Explanation:

Look at the answer to see if it is right.

Other Questions
3. Sugar cookies are my favorite: my sister likes chocolate chip cookies.4. She did not cheat on the test, for it was the moral thing to do.5.I think I want a red car, but I also like the blue one.6. It is starting to get dark, and we are not even there yet.I have never been to Europe. nor have I been to Asia.8. She only paints with pastel colors: she does not like bold colors.They got there early, and they got really good seats. PLEEEEEEEEEASE HEEEEEEELLLLLLPPPPP MEEEEEEEEEEE!!!!!!!!!!!!The gray figure is the image of the black figure after a dilation. Which represents the dilation?a ) (x, y) to (2x, 2y)b) (x, y) to (1.5x, 2y)c) (x, y) to (2x, 1.5y)d) (x, y) to (1.5x, 1.5y) Evaluate g(2) =[tex]g(2) =[/tex] Please research and find out about the MAJOR architectural achievements of the Roman REPUBLIC (509 BC 27AD) write a few lines (2-3). Name some important buildings and constructions, please help me i give brainliest Each grade level at a school for magic has 258 students. There are 13 grade levels. i dont feel like doing it Read the excerpt from Dr. King's "I Have a Dream" speech. The whirlwinds of revolt will continue to shake the foundations of our nation until the bright day of justice emerges. What are the "whirlwinds" King refers to? a destructive and violent force a swirl of dangerous activity a chaotic force of confusion an unstoppable demand for change el nino affects the weather worldwide.1 True2 False !!!! PLEASE ANSWER !!!!! What factors increase the likelihood that all alluvium will be deposited ??? 9) Which must be a mixture of substances?A) solidB) liquidC) gasD) solution Town M is 282 feet below sea level. Town R is 679 feet above sea level. How much higher, in feet is Town R than M? august vollmer was the first police chief to A stadium has 55,000 seats . Seats sell for $28 in Section A Who was silent Dogood What is 1 hundredth 10?1 hundredth 10 = What did the members aboard the Mayflower grant themselves in 1620? Is it true or false that the Temperature is a direct measurement of the energy stored in a substance? {(-2, 6), (2, 0), (3, 6), (4, -1), 5, 3)}Dom:Range:Function? In 3 words, describe the feelings of the Sons of Liberty as they participated in the Boston Tea Party. What did the Great Awakening inspire?OA. Support for the British kingO B. Aggression and violenceO C. Opposition to religionO D. Revolutionary ideas