What is an excel array?



What is an excel array?..

Answer / Sri Ram Yadav

An Excel array is a collection of cells treated as a single unit. Arrays are used in advanced functions to perform multiple calculations at once. They can be defined by enclosing the cell range within curly braces {}. For example, if you have the numbers 1, 2, and 3 in cells A1, A2, and A3 respectively, you could define an array as ={A1, A2, A3}.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I split data in an excel cell?

1 Answers  


How to turn on formulas in excel?

1 Answers  


How many cells are in an excel sheet?

1 Answers  


How do you subtract using excel?

1 Answers  


What is ctrl y excel?

1 Answers  


How average is calculated in excel?

1 Answers  


How do you copy a formula in excel but keep one cell constant?

1 Answers  


What is a range in excel?

1 Answers  


How do I find the path in excel?

1 Answers  


How do you do a vlookup step by step?

1 Answers  


How do you find the sum of numbers?

1 Answers  


How do I convert a value to a number in excel?

1 Answers  


Categories