I'm assuming you are referring to Excel. There are a few ways to add A1 and B1.
First you could use '=SUM(A1+B1)'
You could also use '=SUM(A1:B1)' which adds the values of all the cells between A1 and B1, but since they are next to each other, this would work.
You could also use '=SUM(A1,B1)' where you list all the cells you want to add with commas in between.
Answer:
I've implemented this program using python
userinput = int(input("Length: "))
mylist = []
mylist.append(userinput)
for i in range(1,userinput+1):
userinp = int(input("Input: "))
mylist.append(userinp)
smallval = mylist[1]
for i in range(1,len(mylist)):
if smallval > mylist[i]:
smallval = mylist[i]
for i in range(1,len(mylist)):
mylist[i] = mylist[i] - smallval
for i in range(1,len(mylist)):
print(mylist[i],end=' ')
Explanation:
I've added the full source program as an attachment where I used comments to explain difficult lines
Answer:
UPDATE COMPANY
SET COMM=COMM + 500
WHERE SALES> 20000;
Explanation:
The update command is used for alter the record in the database management system in the table .The update command command modify the record on the some condition in the table in the database management system.
Following are syntax for using the update command .
UPDATE table-name
SET column name 1,column name 2 .........
Where condition
- In the given question table -name is "COMPANY" the condition is on the sales column and it update the table only when sales is more than 20000 and set the column COMM by 500.
Answer:
Option A - They are responsible for writing programming
Option B - They are usually strong problem-solvers
Explanation:
A software engineer needs to be a strong problem solver and he/she must be able to write program/code. He/She is not required to conduct experiments in labs and also it is not essential for them to hold masters degree as even the non computer science or IT background people are working as software engineer.
Hence, both option A and B are correct