MS Excel MCQ with Answers

51) Which of the following is a correct order of precedence in formula calculation

Answer is:

All of above

52) The Paste Special command lets you copy and paste:

Answer is:

The resulting values of a formula instead of the actual formula

53) The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

Answer is:

Click the Currency Style button on the formatting toolbar

54) Which of the following is not a valid data type in excel

Answer is:

Character

Explanation:

Following are the valid data types in excel:

1)Labels:- Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.

2)Values:- Values (numbers) are generally raw numbers or dates.

3)Formulas:- Formulas are instructions for Excel to perform calculations.

55) Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Answer is:

51) Which of the following is a correct order of precedence in formula calculation

All of above

52) The Paste Special command lets you copy and paste:

The resulting values of a formula instead of the actual formula

53) The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

Click the Currency Style button on the formatting toolbar

54) Which of the following is not a valid data type in excel

Character

55) Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Text boxes