InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.	How to display right or cross sign in excel?
Answer» How to DISPLAY right or CROSS sign in excel? There is some setting which need to be done in excel to display some thing in below given screen. And to do that we do some very SMALL setting:- (1)First change the Font Name "Wingdings 2" where you need to add right sign (2)Use (SHIFT + P) for Right and (shift + o) for wrong as given below

2.	Random number in Excel can we also set some range in random number?
Answer» RANDOM NUMBER in Excel can we also set some range in random number? There are some inbuilt function available in excel mainly a METHOD is "rand()" and its default range is 0 to 1. And you will get below number after selecting rand() method as given below. And if we want to display random number WITHIN specific range as given below.

3.	Tricks to Highlights all the blank cells from sheet given?
Answer» Tricks to Highlights all the blank cells from sheet given? As we all knows excel is capable to HANDLE large ammount of data in it sheets. So it is HARD to identify the blank cells from it. SO best way is apply a cell color that will help to display it uniquely. (1)First we need to select all the sheets by shortcut CTRL + A. (2)After first step select Home Tab -> Editing -> Find & Select -> Go to Special. (3)After getting select "Go To Special" then "Blank" as per below screen then CLICK ok. (4)After this POINT we will get screen something like below.