Essential Computer Concepts and Software Functions
Classified in Technology
Written on in 
English with a size of 2.29 KB
1. Definitions of Computing Terms
- Computer: An electronic device including hardware and software used to work, play, and communicate.
- Hardware: The physical, external components that control the computer.
- Software: The intangible part of the computer that administers the components of the CPU.
- Application: A collection of code that creates a program, such as mobile apps or Microsoft Office.
- File: A computer resource used for recording data.
- File Format: A standard that defines the way information is encoded in a computer file.
- Computer Program: A collection of instructions that process data.
2. Functions of Excel Formulas
- SUM: Used to add or subtract numerical values.
- COUNT: Counts the number of cells that contain numbers.
- AVERAGE: Returns the arithmetic mean of the provided numbers.
3. Document Types by Program
- Microsoft Word: Pages
- Microsoft Excel: Spreadsheets
- Microsoft PowerPoint: Slides
4. Software Categories
- Operating System: Linux, Windows, iOS
- Word Processor: Microsoft Word, Pages
- Spreadsheet: Excel, Numbers
- Database: Microsoft Access, MySQL
- Email Service: Outlook, Gmail
- Photo Editor: Photoshop, Photoscape
- Presentation: Microsoft PowerPoint, Keynote
- Antivirus: AVG, Norton Antivirus
- Web Browser: Google Chrome, Mozilla Firefox
- Communication: Skype
5. Common File Formats
- Microsoft Word: .doc, .docx, .pdf, .txt
- Microsoft Excel: .xls, .xlsx, .csv
- Microsoft PowerPoint: .ppt, .pptx, .jpg, .gif, .png
6. Excel Formula Examples
=SUM(C3:C6)=COUNT(C3:C7)=SUM(C3:C7)=AVERAGE(C3:C5)