Spreadsheet Software | MCQs

Explanation

The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.

****

ND20-1-2023

Explanation

•  In a computer spreadsheet, a function that is used to count a number of entries in a given range is called length
• ***
• COUNTA: To count cells that are not empty.
• COUNT: To count cells that contain numbers.
• COUNTBLANK: To count cells that are blank.
• COUNTIF: To count cells that meet specified criteria.

Explanation

ALT is not a valid function in MS EXCEL

'Alternate' is the full form of Alt on the keyboard of the computer.

while 

The SUM () adds individual values, cell references or ranges, or a mix of all three 

The MAX Function[1] is categorized under Excel Statistical functions. 

MIN will return the minimum value in a given list of arguments.

Explanation

Microsoft Excel is Microsoft's general-purpose spreadsheet program for Windows, used for data analysis and display.

It is commonly used in a business environment since it is part of the Microsoft Office package.