Maharashtra Feeds MIS Executive Interview Questions and Answers

SUMIFS is a function in Excel used to sum values based on multiple criteria.

• Formula: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• Can sum values based on multiple criteria

• Example: =SUMIFS(B2:B10, A2:A10, "apples", C2:C10, ">10")

To add the value from cell A1 to A20 in an Excel sheet, you can use the SUM function.

• Enter the formula '=SUM(A1:A20)' in the desired cell to add the values from A1 to A20.

• Make sure that the cells A1 to A20 contain the values you want to add.

• You can also manually input the values in the formula instead of referencing the cells.

Bacteria and fungus are two types of microorganisms that can have both positive and negative effects on human health and the environment.

• Bacteria are single-celled microorganisms that can be beneficial, such as probiotic bacteria in the gut, or harmful, such as pathogenic bacteria like E. coli.

• Fungi are eukaryotic organisms that include yeasts, molds, and mushrooms. Some fungi are used in food production like yeast in ...read more

A fermentor is a vessel used for fermentation processes in industries like food, pharmaceuticals, and biotechnology.

• Fermentor is a vessel where microorganisms like bacteria, yeast, or fungi are used to produce products through fermentation.

• Types of fermentation include aerobic fermentation (with oxygen) and anaerobic fermentation (without oxygen).

• Examples of fermentation products include beer, wine, yogurt, and antibio...read more