1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Readme [11.4K]
4 years ago
8

What is a formula? What is a function? (In the context of Excel)

Computers and Technology
1 answer:
mel-nik [20]4 years ago
4 0

Answer: A formula is an expression which calculate the value of a cell .A funcation is a predefined formula that performs calculations using specific values in particular order.According to context of excel.

You might be interested in
Define the missing function. licenseNum is created as: (100000 * customID) licenseYear, where customID is a function parameter.
Mumz [18]

Answer:

Written in Python:

def licenseNum(licenseYear, customID):

    output = 100000 * customID + licenseYear

    print("Dog license: "+str(output))

 

Explanation:

This line defines the function with parameters licenseYear and customID

def licenseNum(licenseYear, customID):

This calculates the output as stated in the question

    output = 100000 * customID + licenseYear

This displays the output

    print("Dog license: "+str(output))

To call the function, make use of: licenseNum(2014, 777)

Where 2014 and 777 can be replaced with other digits as required

6 0
3 years ago
A _____ is sent to companies that are hiring to get an interview. résumé brochure business report newsletter plz hurry need it n
frozen [14]

Answer:

A application

Explanation:

3 0
3 years ago
Read 2 more answers
Create a Person Class that:
alekssr [168]

Answer:

See explaination

Explanation:

#Create a person class

class Person:

#Constructor

def __init__(self,firstName,lastName,age,gender):

if firstName=="":

raise Exception('First name should not be empty')

self.firstName=firstName

if lastName=="":

raise Exception('Last name should not be empty')

self.lastName=lastName

if(age<0 or age>100):

raise Exception('Age should be within range 0-100')

self.age=age

if(gender!='M' and gender!='F' and gender!='T'):

raise Exception('Gender should be M/F/T')

self.gender=gender

#Create a student class as a subclass of Person

class Student(Person):

#constructor

def __init__(self,firstName,lastName,age,gender,gpa):

Person.__init__(self,firstName,lastName,age,gender)

if(gpa<0 or gpa>4):

raise Exception('GPA should be 0-4')

self.gpa=gpa

#Function to display graduation status

def gradStatus(self):

print('Getting There!!')

#Create a graduate class as a subclass of Student

class Graduate(Student):

#constructor

def __init__(self,firstName,lastName,age,gender,gpa,gradYear,jobStatus):

Student.__init__(self,firstName,lastName,age,gender,gpa)

if(not gradYear.isdigit()):

raise Exception('Graduation year should be integer')

self.gradYear=gradYear

if(jobStatus!='Y' and jobStatus!='N'):

raise Exception('Job status should be Y/N')

self.jobStatus=jobStatus

#Function to display graduation status

def gradStatus(self):

print('I am Finished!!')

#Function to calculate total graduate student

def totalGraduates(graduate):

return len(graduate)

#Average gpa

def avgGpa(graduate):

sum=0

for grad in graduate:

sum+=grad.gpa

return sum/len(graduate)

#Average age

def avgAge(graduate):

avg=0

count=0

for grad in graduate:

if grad.gender=='M' or grad.gender=='F':

avg+=grad.age

count+=1

return avg/count

#Total Number of Male and Female Graduated Students who have jobs.

def totalJob(graduate):

count=0

for grad in graduate:

if grad.jobStatus=='Y':

count+=1

return count

#Test method

def main():

#Create 5 graduates

graduate=[]

graduate.append(Graduate("Adorn",'Antony',20,'M',3.0,"2011",'Y'))

graduate.append(Graduate("Amelia",'Anus',20,'F',3.5,'2011','Y'))

graduate.append(Graduate("Bambi",'Antony',20,'F',3,'2011','N'))

graduate.append(Graduate("Stephen",'Josh',20,'M',2,'2011','N'))

graduate.append(Graduate("Milli",'Markos',20,'F',4,'2011','Y'))

#Total Number of Graduated Students (use a dunder method to display this).

print('Total Number of Graduated Students: ',totalGraduates(graduate))

#Average GPA of all Graduated Students

print('Average GPA of all Graduated Students: %.2f'%avgGpa(graduate))

#Average Age of the Male and the Female Graduated Students

print('Average age of the Male and the Female Graduated Students: %.2f'%avgAge(graduate))

#Total Number of Male and Female Graduated Students who have jobs.

print('Total Number of Male and Female Graduated Students who have jobs: ',totalJob(graduate))

main()

6 0
3 years ago
________ symbol is used in the "Advanced" section of the time range picker to round down to nearest unit of specified time.
liberstina [14]

Answer:

@(at sign) is the correct answer to the following statement.

Explanation:

Because the following symbol is the "at sign" symbol that is used for the Advanced section in the time range picker that lets the user search for the specified time for the round down the closest entity of a particular period. So, that's why the following answer is correct for the following statement.

8 0
4 years ago
What is an example of using the internet of things (iot) to deliver innovative cloud-based solutions to customers?
Elina [12.6K]

Answer:

Wearable technology

Explanation:

An example of using the Internet of Things (IoT) to deliver innovative cloud-based solutions to customers is the wearable technology that provides customers with on-the-spot personalized experiences.

4 0
2 years ago
Other questions:
  • #Write a function called "angry_file_finder" that accepts a #filename as a parameter. The function should open the file, #read i
    13·1 answer
  • Assume that a two-dimensional rectangular array of integers called matrix has been declared with six rows and eight columns. Wri
    13·1 answer
  • how can you repin an image on your Pinterest pin board A. click on the "repin" button B. click on the "add pin" button C. click
    7·2 answers
  • Please help me out with my essay
    15·1 answer
  • It's safe to download files from the internet if u perform regular Windows security updates, that is all u need to protect your
    10·2 answers
  • Computers that have multiple CPUs within a single computer, sharing some or all of the system's memory and I/O facilities, are c
    15·1 answer
  • Which of the following is an accurate definition of a computer system? A computer system consists of the operating system that t
    6·1 answer
  • Write a program that prompts the user to enter an oligonucleotide sequence, such as TATGAGCCCGTA.
    7·1 answer
  • "queries are questions", true or false?
    8·2 answers
  • Draw the final structure that will house the electronic system​
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!