Answer:
SUMIFS
Explanation:
As we know that the excel is used to present the data in a very attractive way by applying the formulas, pie charts, functions as a pivot table, goal seeking, macros, etc
In order to determine the total sales for each and every sales person, production and location combination we use the SUMIFS function so that the total of each column could come in an easiest and better way
Answer:
Following are the program in the Python Programming language.
#define function
def negative_num(num_list):
#set list type variable
nlist=[]
#set the for loop
for n in num_list:
#check negative numbers
if(n<0):
#add the value of n in list
nlist.append(n)
#return list
return nlist
#set new list type variable that store list
newl=[-5,8,-6,3,-4,9,-7]
#print and call the function
print(negative_num(newl))
<u>Output</u>:
[-5, -6, -4, -7]
Explanation:
Here, we define the function "negative_num" and pass an argument "num_list" in its parameter and inside the function.
- Set new list data type variable "nlist".
- Set the for loop which iterate as the list.
- Set the if conditional statement to check the value of the list is less than 0 then, add that negative values in the variable "nlist".
- Then, return the new list.
Finally, we set a variable "newl" which store the list of negative and positive numbers then, we print and call the function.
The answer is B. Issue report cards of grades.
Answer:
File history
Explanation:
File history recovery method allows users to back up their personal files to an external drive or network share without administrative assistance. File History is a backup program that holds your personal files saved in the directories archives, desktop, favorites, and Contacts. It searches the file system regularly for changes, and copies modified files to a different location.
