MS Excel
123 questions available
FILTER BY SUBTOPIC
Q1.What are Macros in MS Excel?
Correct Answer: A
Macros in Excel are automated scripts that record and replay sequences of actions.
Q2.To add value in excel we use formula:
Correct Answer: C
Q3.When working with formulas in Excel, how can you see the intermediate results of a calculation before the final answer is displayed:
Correct Answer: A
Q4.In MS Excel , mathematical formula contains:
Correct Answer: C
Q5.In MS Excel function to return one value if a condition is true and another value if it's false;
Correct Answer: A
Q6.Which command is used to add data in Excel?
Correct Answer: C
Q7.Which basic symbol is used to execute formulas in Ms Excel?
Correct Answer: B
Q8.Which of the following functions in Microsoft Excel is used to count items in a cell range:
Correct Answer: A
Q9.Which area in an excel window allows entering values and formulas?
Correct Answer: C
Q10.In MS Excel 2016, 'Conditional Formatting'. option is available in___ menu.
Correct Answer: D
Q11.Which of the following is not a function in Microsoft Excel?
Correct Answer: D
Q12.Cell Entry \"Jully 16,2016\" will be considered a ____ by Excel sheet:
Correct Answer: C
Q13..Which of the following is not a function in Microsoft Excel?
Correct Answer: D
Q14.Which of the following Excel feature allows users to evaluate values and return a result?
Correct Answer: A
Q15.Which of the following methods can not be used to enter data in an MS Excel cell:
Correct Answer: C
Q16.In MS Excel, to create a formula, you can use:
Correct Answer: D
Q17.In Excel, the "SUMIF" function.
Correct Answer: C
Q18.Where is the cell name shown in Microsoft Excel?
Correct Answer: D
Q19.Auto sum in Excel is used for ?
Correct Answer: B
Q20.In Excel formulas are written by starting with:
Correct Answer: C