- 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
| Short form | Full form |
|---|---|
| OS | Operating System |
| GUI | Graphical User Interface |
| CLI | Command Line Interface |
| IDE | Integrated Development Environment |
| API | Application Programming Interface |
| SQL | Structured Query Language |
| DBMS | Database Management System |
| HTML | HyperText Markup Language |
| CSS | Cascading Style Sheets |
| XML | eXtensible Markup Language |
| AI | Artificial Intelligence |
| IoT | Internet of Things |
File formats
| Short form | Full form | Kind of file |
|---|---|---|
| Portable Document Format | Fixed-layout document | |
| JPEG | Joint Photographic Experts Group | Compressed photograph |
| GIF | Graphics Interchange Format | Simple or animated image |
| PNG | Portable Network Graphics | Image with sharp edges and transparency |
| MP3 | MPEG Audio Layer 3 | Compressed audio |
| MPEG | Moving Picture Experts Group | Video |
| RTF | Rich Text Format | Text with formatting |
| CSV | Comma Separated Values | Plain-text table |
| TXT | Text | Plain 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.
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. GUI stands for
- Graphical User Interface
- General User Interface
- Graphical Utility Interface
- Global User Internet
Show answer
Answer: A. GUI = Graphical User Interface.
-
2. A table of marks is saved as plain text with values separated by commas. Which format is it?
- GIF
- MP3
- CSV
Show answer
Answer: D. CSV = Comma Separated Values, a plain-text table.
-
3. You want a document to look exactly the same on every device. Which format should you save it in?
- CSV
- TXT
- GIF
Show answer
Answer: B. PDF, Portable Document Format, keeps a fixed layout.
-
4. SQL stands for
- Simple Query Language
- Structured Query Language
- Standard Question Language
- Sequential Query List
Show answer
Answer: B. SQL = Structured Query Language, used to work with databases.
-
5. PNG stands for
- Picture Network Graphics
- Portable New Graphics
- Printed Network Graphic
- 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.