THE CALC FUNCTION COUNTS MATCHING RECORDS IN A DATABASE USING CRITERIA AND AN OPTIONAL FIELD

NIELIT O Level Exam

The CALC function counts matching records in a database using criteria and an optional field

CALC फ़ंक्शन मानदंड और एक वैकल्पिक फ़ील्ड का उपयोग करके डेटाबेस में मेल खाने वाले रिकॉर्ड की गणना करता है

A. DCOUNT

B. DCOUNTA

C. DSUM

D. SUM

Correct Answer is :

B. DCOUNTA

Explanation

In LibreOffice Calc, the function you're referring to is DCOUNTA. This function counts the number of non-empty cells in a database column that meet specified criteria.

O Level Online Exam

NIELIT O Level Exam

The CALC __________ function counts matching records in a database using criteria and an optional field

Correct Answer is :

Explanation