• Foundation
  • About 12 min
  • 5 practice questions

Software, language and file-format abbreviations

Master the full forms used in software, programming and common file formats.

If something looks wrong, please tell us.

The second big group covers software terms and the formats you see at the end of file names.

Software and language terms

Software terms
Short formFull form
OSOperating System
GUIGraphical User Interface
CLICommand Line Interface
IDEIntegrated Development Environment
APIApplication Programming Interface
SQLStructured Query Language
DBMSDatabase Management System
HTMLHyperText Markup Language
CSSCascading Style Sheets
XMLeXtensible Markup Language
AIArtificial Intelligence
IoTInternet of Things

File formats

Formats
Short formFull formKind of file
PDFPortable Document FormatFixed-layout document
JPEGJoint Photographic Experts GroupCompressed photograph
GIFGraphics Interchange FormatSimple or animated image
PNGPortable Network GraphicsImage with sharp edges and transparency
MP3MPEG Audio Layer 3Compressed audio
MPEGMoving Picture Experts GroupVideo
RTFRich Text FormatText with formatting
CSVComma Separated ValuesPlain-text table
TXTTextPlain text

Worked examples

Example 1. A table of marks is saved as a plain-text file in which values are separated by commas. Which format is it? CSV, Comma Separated Values.

Example 2. You want a document to look exactly the same on every device. Save it as a PDF.

Example 3. Which language describes the structure of a web page? HTML, HyperText Markup Language.

HTML structures a page, CSS styles it, SQL queries databases.

— Remember

Key takeaways

  • Group formats by what they hold: image, audio, video, document.
  • HTML, CSS and XML are web and data languages.
  • SQL queries databases.

Check your understanding

  1. 1. GUI stands for

    1. Graphical User Interface
    2. General User Interface
    3. Graphical Utility Interface
    4. Global User Internet
    Show answer

    Answer: A. GUI = Graphical User Interface.

  2. 2. A table of marks is saved as plain text with values separated by commas. Which format is it?

    1. PDF
    2. GIF
    3. MP3
    4. CSV
    Show answer

    Answer: D. CSV = Comma Separated Values, a plain-text table.

  3. 3. You want a document to look exactly the same on every device. Which format should you save it in?

    1. CSV
    2. PDF
    3. TXT
    4. GIF
    Show answer

    Answer: B. PDF, Portable Document Format, keeps a fixed layout.

  4. 4. SQL stands for

    1. Simple Query Language
    2. Structured Query Language
    3. Standard Question Language
    4. Sequential Query List
    Show answer

    Answer: B. SQL = Structured Query Language, used to work with databases.

  5. 5. PNG stands for

    1. Picture Network Graphics
    2. Portable New Graphics
    3. Printed Network Graphic
    4. Portable Network Graphics
    Show answer

    Answer: D. PNG = Portable Network Graphics, an image format with sharp edges and transparency.

Sign in to keep track of the lessons you finish.

Next lesson → Internet and networking abbreviations

Privacy · Terms · Refunds · Delivery