1. What is an array in Excel?

एक्सेल में ऐरे क्या है?

a) A range of cells containing numbers

b) A single cell containing a formula

c) A collection of values or cells arranged in rows and columns

d) A function used to sum cells

Answer: c) A collection of values or cells arranged in rows and columns

2. Which of the following functions can be used with arrays in Excel?

एक्सेल में ऐरे के साथ निम्नलिखित में से किस फ़ंक्शन का उपयोग किया जा सकता है?

a) SUM

b) AVERAGE

c) MAX

d) All of the above

Answer: d) All of the above

3. What happens when you perform an array operation in Excel?

जब आप एक्सेल में ऐरे ऑपरेशन करते हैं तो क्या होता है?

a) The operation is performed on each individual element of the array

b) The operation is applied to the entire array as a single entity

c) The array is split into separate cells

d) Excel throws an error

Answer: a) The operation is performed on each individual element of the array

4. Which symbol is used to denote an array formula in Excel?

एक्सेल में किसी ऐरे फॉर्मूला को दर्शाने के लिए किस प्रतीक का उपयोग किया जाता है?

a) $

b) @

c) {}

d) &

Answer: c) {}

5. What is the maximum number of elements an array can contain in Excel?

Excel में किसी सारणी में तत्वों की अधिकतम संख्या कितनी हो सकती है?

a) 255

b) 512

c) 1024

d) Unlimited

Answer: b) 512

6. What does the CEILING function do in Excel?

एक्सेल में CEILING फ़ंक्शन क्या करता है?

a) Rounds a number up to the nearest integer or multiple of significance

b) Rounds a number down to the nearest integer or multiple of significance

c) Rounds a number to the nearest integer

d) Calculates the average of a range of numbers

Answer: a) Rounds a number up to the nearest integer or multiple of significance

7. Which of the following statements about the FLOOR function is true?

FLOOR फ़ंक्शन के बारे में निम्नलिखित में से कौन सा कथन सत्य है?

a) It rounds a number down to the nearest integer or multiple of significance

b) It rounds a number up to the nearest integer or multiple of significance

c) It calculates the square root of a number

d) It calculates the average of a range of numbers

Answer: a) It rounds a number down to the nearest integer or multiple of significance

8. What is the syntax of the FORECAST function in Excel?

एक्सेल में FORECAST फ़ंक्शन का सिंटैक्स क्या है?

a) FORECAST(x, known_y's, known_x's)

b) FORECAST(known_x's, known_y's, x)

c) FORECAST(known_y's, x, known_x's)

d) FORECAST(x, known_x's, known_y's)

Answer: a) FORECAST(x, known_y's, known_x's)

9. In the FORECAST function, what does 'x' represent?

FORECAST फ़ंक्शन में, 'x' क्या दर्शाता है?

a) The known y-values

b) The known x-values

c) The value for which you want to forecast

d) The slope of the regression line

Answer: c) The value for which you want to forecast

10. Which of the following functions is used to calculate the ceiling of a number?

निम्नलिखित में से कौन सा फ़ंक्शन किसी संख्या की अधिकतम सीमा की गणना करने के लिए उपयोग किया जाता है?

a) CEIL

b) ROUNDUP

c) CEILING

d) CEILUP

Answer: c) CEILING

11. What does the CUBE function in Excel primarily do?

एक्सेल में CUBE फ़ंक्शन मुख्य रूप से क्या करता है?

a) Calculates the cube of a number

b) Retrieves data from an external database

c) Performs calculations on cube-shaped ranges

d) Sorts data in a cube format

Answer: b) Retrieves data from an external database

12. Which Excel feature allows you to connect to external data sources like OLAP cubes?

कौन सी एक्सेल सुविधा आपको OLAP क्यूब्स जैसे बाहरी डेटा स्रोतों से कनेक्ट करने की अनुमति देती है?

a) PivotTables

b) Formulas

c) Data Validation

d) Data Analysis ToolPak

Answer: a) PivotTables

13. What is the purpose of an OLAP cube in Excel?

 एक्सेल में OLAP क्यूब का उद्देश्य क्या है?

a) To store text data

b) To perform complex mathematical calculations

c) To organize and analyze multidimensional data

d) To create charts and graphs

Answer: c) To organize and analyze multidimensional data

14. In Excel, which function is used to retrieve data from an OLAP cube?

एक्सेल में, OLAP क्यूब से डेटा पुनर्प्राप्त करने के लिए किस फ़ंक्शन का उपयोग किया जाता है?

a) CUBEVALUE

b) VLOOKUP

c) SUMIF

d) INDEX

Answer: a) CUBEVALUE

15. Which of the following statements about Excel's cube functions is true?

 एक्सेल के क्यूब फंक्शन के बारे में निम्नलिखित में से कौन सा कथन सत्य है?

a) They can only be used with text data.

b) They allow you to perform calculations on OLAP cube data.

c) They are used for drawing shapes and diagrams.

d) They are only available in the Mac version of Excel.

Answer: b) They allow you to perform calculations on OLAP cube data.

16. What does the DB function do in Excel?

एक्सेल में DB फ़ंक्शन क्या करता है?

a) Deletes a specified range of cells

b) Calculates the depreciation of an asset for a specified period using the declining balance method

c) Finds the average of a range of numbers

d) Checks for duplicate entries in a range of cells

Answer: b) Calculates the depreciation of an asset for a specified period using the declining balance method

17. In the DB function, what does the 'cost' parameter represent?

डीबी फ़ंक्शन में, 'लागत' पैरामीटर क्या दर्शाता है?

a) Salvage value of the asset

b) Initial cost of the asset

c) Annual depreciation rate

d) Period for which depreciation is calculated

Answer: b) Initial cost of the asset

18. Which argument of the DB function is optional?

DB फ़ंक्शन का कौन सा तर्क वैकल्पिक है?

a) salvage

b) period

c) factor

d) None,

all arguments are required

Answer: a) salvage

19. What does the 'life' argument in the DB function represent?

DB फ़ंक्शन में 'life' तर्क क्या दर्शाता है?

a) Salvage value of the asset

b) Initial cost of the asset

c) Useful life of the asset

d) Depreciation factor

Answer: c) Useful life of the asset

20. How does the DB function handle negative values for the 'period' argument?

डीबी फ़ंक्शन 'पीरियड' तर्क के लिए नकारात्मक मानों को कैसे संभालता है?

a) It ignores negative values

b) It returns an error

c) It treats negative values as positive

d) It rounds negative values to the nearest integer

Answer: b) It returns an error