Topic :: Formula





Formula Interview Questions
Questions Answers Views Company eMail

What is ifna formula?

355

Can I use an if formula in conditional formatting?

357

What is a conditional formula?

347

How do I convert a formula to text?

381

How do I show formula in one cell?

346

What is the keyboard shortcut to show all formulas in a worksheet?

340

How do you paste a formula without changing the cell reference?

350

How do you drag formulas to the last row?

360

What is an array formula?

402

How do you keep a cell constant in a formula?

385

How do I apply a formula in conditional formatting?

375

What is formula in ms excel?

371

What is the formula to check duplicate in excel?

361

How do I use excel formulas in word?

363

What is the formula to separate first and last name in excel?

539




Related Topics


Un-Answered Questions { Formula }

What is the Formula of osmolarity calculation ?

3400


Write a flora formula for a flower which has a variable number of sepals, 8 petals united at the base, 8 stamens united by their anthers, and an inferior ovary of 4 united carpels.

1842


Can a formula column referred to columns in higher group ?

2172


Can a formula column be obtained through a select statement ?

1950


What is the structural formula of molybdenum blue?

3279






When we r doing data driven test with chkpts, i want to insert formulae in data sheet but i didn't get. How we wil do that plz. explain in detail.

1706


Perform the following tasks using MS-EXCEL: FUEL ESTIMATES COMPUTATIONS: This project is to compute the fuel needed for two types of airplanes, and the cost of the fuel. You must do all computations using formula, and do a chart. Use Page Setup to make the left margin 0.5 and the right margin 0.5 also. Put your name in the Title line, after "Fuel Estimates". Note the following: ? Col. D - H: You must enter correct formulas under Columns D through H (Flying Fuel, Reserve Fuel, Holding Fuel, Total Fuel Needed and Estimated Fuel Cost)!! Read and compute carefully! ? Cells C12, C13, C14, H13 or H14: When you use these cells in a formula, you must make them absolute cell references (F4 key after your type the cell reference, or enter the $ sign manually) ? Graph/Chart: Select cells A3:B8 (Plane and Flight). Hold down the "Control" key and select D3:D8. Hold down the "Control" key and select G3:G8. Create a chart (Insert- Chart, Finish) and position it in a pleasing way under the data for the flight. Print it on one sheet, in landscape mode. ? Print again, but with Formulae: There are two ways to show formulas: 1) Enter Control+` (the key with the ~ at the top left) or 2) Tools-Options, and under "Window Options" put a check mark beside "Formulas", then close the window.

11687


If P is the population on the first day of the year, B is the birth rate, and D is the death rate, the estimated population at the end of the year is given by the formula: The population growth rate is given by the formula: B – D Write a program that prompts the user to enter the starting population, birth and death rates, and n, the number of years. The program should then calculate and print the estimated population after n years. Your program must have at least the following functions: 1. growthRate: This function takes its parameters the birth and death rates, and it returns the population growth rate. 2. estimatedPopulation: This function takes its parameters the current population, population growth rate, and n, the number of years. It returns the estimated population after n years Your program should not accept a negative birth rate, negative death rate, or a population less than 2. please answer my question ....

1872


Q. 4 (a) To modify an, existing worksheet. What steps are involved for: 1. Inserting and deleting rows and columns. 2. Printing cell formulas 3Jld displayed values 3. Using the page setup command

1605


To modify an, existing worksheet. What steps are involved for: 1. Inserting and deleting rows and columns. 2. Printing cell formulas 3Jld displayed values 3. Using the page setup command

1871


1 Tarot 1.1 Purpose - Tarot tool will duplicate the tarot-reading process for the user online. - Tarot is a craft that uses a deck of 78 cards to predict a user’s past, present and future. - The cards are picked by the user and arranged in a specific spread, which represents points in his past, present, and future; based on the meanings of the cards selected, interpretations are given. 1.2 Scope Only for registered user. 1.3 User Interface User Interface: 1. Question – This is only for user experience, and has no bearing on the formulae / process. Simple long text box. 2. Selection of field – radio button selection of 1 of 3 choices(Love, Career, Personal), which affects 1 of 3 card- meaning databases to be used. After selection, the unselected databases do not affect or interact with the system. 3. Spread Selection – radio button selection of 1 of 3 choices(Celtic Cross, Horse Shoe, Simple 3 Card). This determines the number of cards being picked and the specific spread database to be used. This also affects the specific report format being used, as well as the card- selection GUI. 4. Card Selection – based on the input 3, a specific layout is shown where the user needs to identify X number of cards (X also determined by input 3) which are then shown in the spread. Every card selection identifies the spread position constants (A, B, C, etc) with specific variable values (Card numbers) creating an array. Report format will display on a separate new page, in the following sequence – - Statement of question asked - Selection of field - Selection of spread - Detailed description of position data, positions identified as per spread selection - Card meaning as picked in field selection 1.4.5 Interfacing/Sourcing Details 1.4.5 Rules and Conditions - Data needs to be calculated for all fields, but only a maximum of 3 cards data should be shown in the free report. For the rest, a payment would be required. - Payment reports not in phase 1 - The report needs to be emailable (so functionality to convert to text file / html document should exist, which will then be emailed to the user’s email address).

2375


alignment formulae for any two shafts for shim correction

1629


In any consulting firm, the time devoted doesn't matter. all that matters is the productivity. What kind of HR and leave policy will you formulate to ensure discipline and time line working along with the increased productivity?

1876


Is it possible to calculate a voltage for microwave energy generating in oven? Is there any formula relating frequency and voltage and it should be independent of speed?

1929


WHAT ARE 19 MODELS OF EDUCATIONAL COUNSELLING? What is the most essentila thing that you consider while formulating any HR policy? In any consulting firm, the time devoted doesn't matter. all that matters is the productivity. What kind of HR and leave policy will you formulate to ensure discipline and time line working along with the increased productivity what is databank in recruitment process why u choose MBA after sicence bacground in graduation what is patent rights and copy rights what is the difference between direct investment and FDI what is the difference between direct investment and FDI what is the difference between patent rights and copy rights what is quality of work life What is KRA and KPI? Wat is recruitment & How is the Recruitment Scenario in todays global market? what is meant by managerial grid why did u select HR as your carrier what is sensex and nifty,what is the difference between those two what is the difference between CEO,MD,PRESIDENT,CHAIRMAN why do u select to do MBA in HR after doing B.Sc in physics? what is the performance management and what are the methods to use in evaluating performance? What is Learning? Please do make a reply to this question: I am bored taking interviews. Please motivate me in taking interview of yours. Trade Unions? what is sensex and nifty,what is the difference between those two What are Incentives? What is Fringe Benefits? What is Employee Morale? what are your positives and negatives as a HR? What is the best way to develop pay systems that are understandable, workable, and acceptable to employees at all levels? What is Coordination? What is the Difference between salary and wage? what is ur great weekness what is the importance of hr in the life of business? What is wages? What are the key issues that should be addressed in the design, conduct, and evaluation of training programs? where u see yourself after 10 years As jobs become more team-oriented, assessment centers will be used more often for non-management jobs. Do you agree or disagree? What is HRD? What did you like in your previous job? What is Fringe Benefits? What are the latest employee evalution trends? What is the Difference between salary and wage? why do u select to do MBA in HR after doing B.Sc in physics? What is HCN?s? what is the importance of hr in the life of business? How much do you think we should pay you?Do you know how much other companies are paying? What is the best way to develop pay systems that are understandable, Workable, and acceptable to employees at all levels? Difference between Training and Development? What is Different between Recruitment and Selection What is "mutual gains negotiation"? Selection means? Trade Unions? what is 360 degree performance appraisal? what is meant by an organisation,explain me differently What is On the Job Training? Management Guru,Professor Lallus Rail , a book was written by? What is Workers Compensation? why should i select you? Roles and Responsibilities of a HR ? How much do you think we should pay you?Do you know how much other companies are paying? In a room there are 3bulbs, and in the net room there are 3 switches. one can not see through the rooms, then how can you know that which switch is for which bulb with out taking any one's help? Define Motivation? What are the key issues that should be addressed in the design, conduct, and evaluation of training programs? What is "mutual gains negotiation"? what is Persoanl Management? What is HRM? What are Incentives?

6495