Fundamental Rights |  UNESCO Intengible Cultural Heritage From India |  Corruption |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India | International Airports in India  | United Nation International Years National Highways | National Birds of Countries | 
Types of Speciation |  Unisexual and Bisexual Flowers |  DISANET |  National Child Labour Project Scheme |  Tropical Deciduous Forest |  Hoolock Gibbon: National Parks |  Sectors of Indian Economy |  How Legislative Council is Formed |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India |
Animals and their Baby Names |  Veto Power of President & Types of Veto |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in World

Facebook

Follow @ Facebook #GKPlanet




Wednesday, 3 January 2018

Multiple calculations can be made in a single formula using

  By GK Planet Team       Wednesday, 3 January 2018
Q. Multiple calculations can be made in a single formula using

A. standard formulas
B. array formula
C. complex formulas
D. smart formula

Answer: array formula

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, you can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. You can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Array formulas are often referred to as CSE (Ctrl+Shift+Enter) formulas because instead of just pressing Enter, you press Ctrl+Shift+Enter to complete the formula.
logoblog

Thanks for reading Multiple calculations can be made in a single formula using

←Previous
« Prev Post
Next→
Next Post »

No comments:

Post a Comment

Write your answer here....

Recent Posts

Google+ Followers