MAKEUP

What is the use of Conditional formatting ? 

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

What is Fill Handle ? 

You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.

Select two cells and use fill handle to drag it and event vally series series will created. 

What is data Collection of Information ? 

Data collection is the process of gathering and measuring data, information or any variables of interest in a standardized and established manner that enables the collector to answer or test hypothesis and evaluate outcomes of the particular collection.

Data collection system (DCS) is a computer application that facilitates the process of data collection,

Steps to create Pie chart ? 

Create a Piechart

1. Select the data for which you want to create a chart.

2. Click INSERT > Recommended Charts.

3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends

for your data, and click any chart to see how your data will look.

If you don’t see a chart you like, click All Charts to see all the available chart types.

4. When you find the Piechart, click it > OK.

5. Use the Chart Elements, Chart Styles, and Chart Filters buttons, next to the upper-right

corner of the chart to add chart elements like axis titles or data labels, customize the look of

your chart, or change the data that is shown in the chart.

6. To access additional design and formatting features, click anywhere in the chart to add

the CHART TOOLS to the ribbon, and then click the options you want on

the DESIGN and FORMAT tabs.

Difference between sorting and Filtering ?

Sorting Data

Let’s say you had the spreadsheet above and wanted to sort by price. This process is fairly simple. You can either highlight the whole column or even click on the first cell in the column to get started. Then you will:

• Right click to open the menu
• Go down to the Sort option – when hovering over Sort the sub-menu will appear
• Click on Largest to Smallest
• Select Expand the selection
• Click OK

Filtering Data

The filter feature applies a drop down menu to each column heading, allowing you to select specific choices to narrow a table. Using the above example, let’s say you wanted to filter your table by Company and Salesperson.

Use following steps to print slides of power point presentation:-

1. Select File > Print.

2. For Printer, select the printer you want to print to.

3. For Settings, select the options you want:

A. Slides: From the drop-down, choose to print all slides, selected slides, or the

current slide. Or, in the Slides box, type which slide numbers to print, separated by a comma.

B. Print Layout: Choose to print just the slides, just the speaker notes, an outline, or

handouts.

The Outline prints only the text in the slides, without images. The Notes of a presentation show the slide

and the related speaker notes below it. If you choose to print Handouts, you can print several slides on

one page using a variety of layouts, some with space for note-taking.

C. Collated: Choose whether you want the sheets collated or uncollated.

D. Color: Choose whether you want color, grayscale, or pure black and white.

E. Edit Header & Footer: Select to edit the header and footer before printing.

4. For Copies, select how many copies you want to print.

5. Select Print.

 Printing of Notes pages:

1. Hit Ctrl+P for Print (or click File then Print)

2. Open the Print Layout options

3. Select the Notes Page layout

4. Click Print

Printing of Handouts:

A Handouts page consists of three slide thumbnail images on the left side and several printed lines for note-taking to the right of each thumbnail. 

To print handouts, follow these steps:

1. Click the File tab, and click Print.

2. Enter the desired number of copies.

3. Choose a different printer if needed from the Printer drop-down list.

4. Click Full Page Slides to open a menu.

5. Click one of the layouts in the Handouts section of the menu.

6. Adjust any other print settings as needed.

7. Click Print to print the handouts.

8. Click Print to submit the print job to your printer.

Difference Between Notepad and Wordpad
Notepad	WordPad
Definition: Notepad is a simple text editor for Microsoft Windows and a basic text-editing program which enables computer users to create documents.	Definition: WordPad is the basic word processor using which we can format and print text.
It was launched by Microsoft in the year 1983	It was launched by Microsoft along with Windows 95
No formatting related to the text can be done. Focus is completely on creating text files with minimum formatting features	Formatting options like bold, italics, font style and size, etc. are available
It is a better choice for creating webpages. It can only save .txt files	Files can be saved in the form of basic documents (.txt) and rich text documents (.rtf)
Minimalistic in terms of formatting the text	An unformatted file can be formatted using Wordpad
Images or graphics cannot be added in Notepad	Images can be added in Wordpad
Visually, a Notepad has only 5 options. This includes File, Edit, View, Format and Help	More options are visually available in a Wordpad
.rtf Wordpad files cannot be opened with Notepad	Any Notepad file (.txt) can be opened with Wordpad

Difference Btween Hardware and Software !

Hardware	Software
Hardware is further divided into four main categories:  Input Devices Output Devices Secondary Storage Devices Internal Components	Software is further divided into two main categories: Application Software System Software
Developed using electronic and other materials	Developed writing using instructions using a programming language
When damaged, it can be replaced with a new component	When damaged it can be installed once more using a backup copy
Hardware is physical in nature and hence one can touch and see hardware	The software cannot be physically touched but still can be used and seen
Hardware cannot be infected by Viruses	The software can be infected by Viruses
Hardware will physically wear out over time	Software does not wear out but it can be affected by bugs and glitches
An example of Hardware is hard drives, monitors, CPU, scanners, printers etc.	An example of software is Windows 10, Adobe Photoshop, Google Chrome etc.

Task Manager

Task Manager shows you what programs are running on your Windows computer and offers some limited control over those running tasks.

What Is Task Manager Used For?

For an advanced tool that can do an incredible number of things, most of the time the Windows Task Manager is used to do something very basic: see what's running right now.

Open programs are listed, of course, as are programs that are running "in the background" that Windows and your installed programs have started.

Task Manager can be used to forcefully end of any those programs. 

VDU (visual Display Unit)

Visual display unit and uses to describe any device to show text and pictures. For case, examples of VDU are a projector and a flat-panel display.  

The term VDU is often referred to use synonymously with "monitor," but it can also be used to describe the display as a digital projector. 

Types of Visual Display Units

1. Liquid Crystal Displays:

2. Cathode Ray Tube:

Plasma Screens:

Organic Light-Emitting Diode: The OLED screen.

Printers 

 A printer is an electromechanical device which converts the text and graphical documents from electronic form to the physical form and it used to print information on paper. 

A wide range of printers is available with a variety of features ranging from printing black and white text documents to high quality colored graphic images.

 Modern printers come with multipurpose function i.e. they are combination of printer, scanner, photocopier, fax, etc. 

Types of printer 

There are different types of printers and most commonly used printers are 

 Dot matrix printer 

 Inkjet printer 

 Laser printer

What is File ?

A file is an object on a computer that stores data, information, settings, or commands used with a computer program.

What is Data ?

In computing, data is information that has been translated into a form that is efficient for movement or processing. 

What is Information ? 

Information is organized or classified data, which has some meaningful values for the receiver. Information is the processed data on which decisions and action. 

What is CLI and GUI ?

Parameters	CLI	GUI
Ease of Use	It is comparatively more difficult to understand and use.	It is comparatively easier to understand and use.
Memory Consumption	CLI consumes comparatively less memory.	The GUI consumes comparatively more memory.
Level of Precision	Higher precision of work can be obtained using CLI.	GUI offers a lower level of precision.
Speed	It works at a higher speed as compared to the GUI.	It works at a much slower speed as compared to the CLI.
Keyboard and Mouse	Its OS only requires a user’s keyboard.	Its OS requires both keyboard and mouse to work.
Modification of Appearance	We cannot change or modify the CLI operating system’s appearance.	We can change or modify the GUI operating system’s appearance.

Memory Measurement Units