Computer – Samasto

Nov 30

Simple tricks to get results in Excel or Google Sheet

How to identify two same color cells in a single row in google sheet? Step 1: Select Cells (A2:A5) -> Format -> Conditional formatting Step 2: Paste formula =Countif($A$2:$A$5,A2)>1 at Format rules then change formatting style fill color by Color 1 cell Read more

Apr 06

Database

What is Database? The database is an organized collection of related information. We have stressed “ORGANISED”, because only organized information is a database. Any unorganized information is just like a pile or dump, and it cannot be called a database. Read more

Mar 21

Microsoft Visual FoxPro 6.0 Database Table

Microsoft Visual FoxPro 6.0 Database Table (.dbf) How to Create Database Table STARTàAll ProgramsàMicrosoft Visual Studio 6.0àMicrosoft Visual FoxPro 6.0 Write in Command Window CREATE SCHOOL <ENTER> 1. Create the following table. Field Name Data Type Width Dec Read more

Mar 20

Microsoft Visual FoxPro 6.0 Form

Microsoft Visual FoxPro 6.0 Form (.scx) *Note: Visual FoxPro Form support only Windows XP operation system. Step-2 TEXT5 GOTFOCUS A=THISFORM.TEXT3.VALUE B=THISFORM.TEXT4.VALUE C=A*B THISFORM.TEXT5.VALUE=C Step-3 (.dbf File Making) Field Name Type Width Dec PRODCODE Character 8 PRODNAME Character 20 Read more

Mar 19

Algorithm

Planning a program involves defining its logic (the correct sequence of instructions needed to solve the problem at hand) called Algorithm. It is a step-by – step description of how to arrive at a solution to a given problem. Algorithm Read more

Jan 29

Microsoft Office Excel

Microsoft Office Excel (.xls, .xlsx) Microsoft Excel is a spreadsheet developed by Microsoft. This application is available in Microsoft Office Software. It has two types of Extension .xls and .xlsx. In old version, up to 2003 is .xls and now Read more

Jan 29

Microsoft Office Word

Microsoft Office Word (.doc) Header and Footer: The information which appears at the top of every page is called Header and at the bottom is called Footer. Drop Cap: Drop cap is called initial cap to decorate first letter or Read more

Jan 29

Computer Keyboard Shortcuts

Here the all Computer Keyboard Shortcuts: A. Basic Shortcuts 1. Alt + F {File menu options in current program} 2. Alt + E {Edit options in current program} 3. F1 {Universal help for all programs} 4. Ctrl + A {Select Read more

Jan 29

List of File Extension

NAME DOCUMENT TYPE APPLICATION .rtf Rich Text Format WordPad .docx Microsoft Word Document MS Word .txt Text Document Notepad .bat Batch File Command Prompt .bmp Bitmap Image Paint .jpg / .jpeg Joint Photographic Experts Group Paint .xlsx Microsoft Excel Worksheet Read more

Jan 29

List of Full Form

ALU=Arithmetic Logic Unit. CAD=Computer Aided Design. CD=Carrier Detect or Compact Disc. CD-R=Compact Disc-Recordable. CD-ROM=Compact disc read-only memory. CD-RW=Compact Disc-ReWritable. CMOS=Complementary Metal-Oxide Semiconductor. COMPUTER=Common Oriented Machine Particularly Used for Trade Education and Research. CPU=Central Processing Unit. CRT=Cathode Ray Tube. CU=Control Unit. Read more