Brilliants Computer Training Institute

To register for a course you can either visit our office or you can contact us on the phone number mentioned below

Our Website: https://www.brilliantscomputer.org/

Hurry!! Seats are filling up fast!!

You can download android app for MS-CIT demo exam:
https://play.google.com/store/apps/details?id=com.nxg.mscit.exam.demo

MSCIT Online Exam Practice

Brilliants Computer Rangoli and Mehendi Champs 2014

Held at: Mahalaxmi Mandir, Uday Co-op Housing Society, near Mantri
Hospital, near Mhatre Bridge, Erandwane Pune 411 004

Held On: 1st June 2014(Sunday) i.e Tomorrow from 10am to 12pm

If you are interested please Contact: 9822541816 or 020 25450885

EXCEL : Calculate the number of days, months, or years between two dates

The DATEDIF function can be used for this.

The syntax for the DATEDIF function is:

= DATEDIF ( start_date , end_date , unit )

• start_date - First or starting date (eg. DATE OF BIRTH)
• end_date - Second or last date (eg. TODAYS DATE)
• unit - Function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates

Try it out.

ADVANCE EXCEL TIPS:
The “IF” function is a simple and powerful one and helps automate decision making in your spreadsheet. The “IF” function checks if the specified condition is true or false, does one thing if it’s true, does another if it’s false.

The syntax for IF function is:

=IF(logical_test, [value_if_true], [value_if_false])

For example, let’s say we have a spreadsheet of a few students and we need to find out quickly who passed the test. We have their Roll Nos. and Marks in columns B & C respectively. In the ‘Status’ column (Column D), we can create a simple IF function that will tell us whether or not the student passed. (Let’s assume 50 or higher is the passing score).

In cell D4, we would enter =IF(C4>49,"PASS","FAIL"). This tells Excel to look in cell C4 (Marks) and test to see if its greater than 49. If it is, excel enters the word "PASS" in cell D4. If the marks obtained are 49 or lower, the word "FAIL" is entered instead.

Simply drag down the cell with the formula, till the last student and get the Pass / Fail Status of each.

Try it out.

WORD : HOW TO PASSWORD-PROTECT A WORD DOCUMENT ?

1. Click the OFFICE BUTTON (@ Top Left) , go to PREPARE and then click ENCRYPT DOCUMENT.

2. In the ENCRYPT DOCUMENT dialog box, type a PASSWORD and click OK.

3. In the CONFIRM PASSWORD dialog box, re-enter password, and click OK.

4. Save the file.

Note : Do not forget your password, it cannot be recovered

Program to print a semicolon without using semicolon in the code in C.
Solution:


int main(void) {
//prints the character with ascii value 59, i.e., semicolon
if (printf("% c\n", 59)) //prints semicolon
{
//do Nothing
}
return 0;
}

Output:
;

Program to print something without using semicolon (;) in C
Solution:


int main(){
//printf returns the length of string being printed
if (printf("Hello World\n")) //prints Hello World
{
//do nothing
}
return 0;
}

Output:
Hello World

Monsoon Offer: 25% Discount on following courses:
C,C++,java,.net,c #,DTP,Tally,Spoken English.
Contact: 9822541816

Fun With Google......

1> Barrel Roll

in google search results,if u search for "do a barrel roll",
before u complete the string, your results page will be spinning!!

2> Google Gravity

Search for "google gravity" & in suggessions box which appears, click "i'm feeling lucky"....
now u'll see google homepage & when u'll move ur mouse a bit, all elements on page will fall down to taskbar!!!

3> Zerg Rush

Google “zerg rush” and prepare to defend your browser against hordes of the letter ‘o’ in Google’s logo,
which will start to destroy your search results. They’re apparently undefeatable, but you can try to fight
them off by clicking on them and share your high score on Google +.
Just search for "zerg rush" & before u press enter, it has started!!

4> You’ll never find Chuck Norris

Because Chuck Norris jokes never get old, there is a warning hidden in Google search results to ward off those
who dare to attempt to find him. Just search ‘find Chuck Norris’ and hit ‘I’m feeling lucky’ and you’ll see what
I mean!!!

5> Askew

If you run a Google search for the word “askew”, you may think you’ve somehow broken your monitor or telepathically
adjusted your display settings. But really, Google has just shifted a few degrees

6> Goglogo

Ever wanted your own personal version of Google, complete with a customised logo?
you can type “goglogo” into your Google search bar and hit “I’m feeling lucky”...
You'll get google search with your name!!!

7> Google Sphere

Google sphere transforms your Google Image search page into an interactive spinning orb.
To access it, search for “google sphere” and click “I’m feeling lucky”.

8> The Loneliest Number

In case you weren’t aware of this, Google’s built-in calculator will confirm it for you:
the loneliest number is one.

9> Quing Ming Festival

If you search for “qingming” (a traditional Chinese festival), Google will decorate your search
results page accordingly, painting the white space with watercolour plants, occasional rippling
water and some children perched atop blinking cows. If you look closely, you may spot a fish or
two leaping from the ‘water’.

10> Current Time

If u type "what time is it" followed by the name of some place, google will show you the exact time at
that place in search results

SAGA-220 is a supercomputer built by the Indian Space Research Organisation(IS RO).
As of May 2011, it is the fastest supercomputer in the nation with a maximum theoretical speed of 220 TFlops. The name SAGA-220 stands for Supercomputer for Aerospace with GPU Architecture-22 0 teraflops

https://www.facebook.com/kalamBillionbeats Dr Kalam is on facebook.. He has created this page to communicate with us:

"Billionbeats" Dr APJ Abdulkalam's Billion beats - an initiative to inspire the youth towards realizing the Developed India Vision 2020