Excel 2010:Applying Formulas and Functions

This sections checks the candidates ability to use formulas and functions. This topic check the following skills, creating formulas, Enforcing precedence, Applying cell references in formulas, Applying conditional logic in a formula, Applying named ranges in formulas, Applying cell ranges in formulas.

Total 21 questions found in this category.

Submit Question   Show By Status: New Submissions   Pending   Deleted   Approved   

Question	Subject	Category
Can you name multiple cells in Excel 2010?	Excel 2010	Applying Formulas and Functions
Which of the following keyboard shortcuts will you use to name a cell range?	Excel 2010	Applying Formulas and Functions
On which of the following tabs will you be able to name a cell range?	Excel 2010	Applying Formulas and Functions
You have a named range with workbook scope called "marks" which spans the area from Columns D2 to D20 on sheet 'Sheet1' of your workbook. You want to calculate the sum of the values in this range and enter the values in the cell A5 of 'Sheet2'. Assuming that there is no named range with the same name, what shall you type in A5 of 'Sheet2'?	Excel 2010	Applying Formulas and Functions
You have created two sheets in the workbook. You want to use the name "marks" for the named range in both the sheets of the workbook. What will you change in the first named range? (Assuming that it has already been created and is functional)	Excel 2010	Applying Formulas and Functions
Where will you find the name manager so that you could create a new name for a range?	Excel 2010	Applying Formulas and Functions
What are named ranges used for?	Excel 2010	Applying Formulas and Functions
How to auto fill the values with the conditional formula given that the formula to be applied depends on the values in cells of the adjacent left hand side column?	Excel 2010	Applying Formulas and Functions
You want to state the grades for students in a subject. Which technique will you use to determine the Grades using a single formula when using the IF condition?	Excel 2010	Applying Formulas and Functions
Which of the following is the correct format of the IF conditional statement which can be used in the formulas?	Excel 2010	Applying Formulas and Functions
You have created a list of items to be sold and their prices in the columns A and B, respectively. You now want to calculate the VAT for the prices at the rate of 12.5% of the price. You have typed "=12.5%*B2" in the Cell C2. You want to apply the same formula to all the cells in column C with the appropriate calculation on the respective cell in Column B. Which of the following shall help you auto calculate the values in all those cells?	Excel 2010	Applying Formulas and Functions
You have created a list of items to be sold and their prices in the columns A and B, respectively. You now want to calculate the VAT for the prices at the rate of 12.5% of the price. You have typed "=12.5%*B2" in the Cell C2. You want to apply the same formula to all the cells in column C with the appropriate calculation on the respective cell in Column B. Which of the following shall you type in all those columns?	Excel 2010	Applying Formulas and Functions
Which of the following characters are used to separate the cell references when determining the cell range for a formula (such as AutoSum)?	Excel 2010	Applying Formulas and Functions
In the formula =(B4+25)/SUM(D5:F5) ,what is evaluated first?	Excel 2010	Applying Formulas and Functions
Which of the following pair of brackets can be used to override the precedence of the operators?	Excel 2010	Applying Formulas and Functions
Which of the following operators is the evaluated first?	Excel 2010	Applying Formulas and Functions
Which of the following operators is the evaluated first?	Excel 2010	Applying Formulas and Functions
Which of the following operators is the evaluated first?	Excel 2010	Applying Formulas and Functions
You want to get the average of more than one set of columns. Which of the following is the character you will use as a separator to the function arguments?	Excel 2010	Applying Formulas and Functions
Which of the following is not a category of formulas available in Excel 2010?	Excel 2010	Applying Formulas and Functions
What will you type in D10 if you were to find the average of all numbers from the dell D1 to D7?	Excel 2010	Applying Formulas and Functions

Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program