Excel Functions and Network Topologies

Excel Functions and Formulas

• Excel functions used to perform calculations and manipulations on data within a spreadsheet.
• Absolute cell references remain constant upon copying or filling formulas.
• Relative cell references adjust automatically according to the position in the formula when copying.
• Formulas begin with an equals sign (=) to indicate a calculation or function.
• Functions like SUM, MAX, MIN, SQRT, and SIN perform various math calculations.
• Excel functions often take one or more arguments (values used in the calculation) as input.

Network Topologies

• Network topologies define how computers and devices are physically connected within a network.
• Star topology: All devices connected to a central hub or switch.
• Bus topology: A single cable connects all devices.
• Ring topology: Devices connected in a closed loop.
• Mesh topology: Multiple connections between devices for redundancy and high reliability.
• Wireless LAN (WLAN): Wireless local area networks that use radio waves to connect devices.
• WAN (Wide Area Networks): Networks covering large geographic areas.
• MAN (Metropolitan Area Networks): Networks spanning across a whole city, or a metropolitan area.
• LAN (Local Area Network): Networks covering a small geographic area, such as an office building.
• PAN (Personal Area Network): A network connecting devices used by a single person.
• Campus area network (CAN): a network serving a large campus or university.

Excel Spreadsheet Elements

• Cells are the individual boxes in an Excel spreadsheet.
• Sheets are collections of cells that compose a single worksheet.
• Rows and columns help to organize data within the worksheet.
• Addresses are used to locate cells using letters (column) and numbers (row).
• Absolute addresses remain constant when copied to different cells.
• Relative addresses automatically adjust based on the destination cell when copied.

Computer Programming Concepts

• Hypertext Markup Language (HTML): A standard markup language for creating web pages.
• HTML tags define the structure, content and layout of web pages.
• Formulas are equations or pre-defined logic that tells the spreadsheet how to perform calculations and other actions on data entered in a spreadsheet.
• Functions are predefined actions that help users perform specific tasks on the spreadsheet.
• Hypertext Management Language (HTML): A standard markup language for creating web pages.

General Computer Concepts

• Troubleshooting steps are systematic actions used to resolve errors in a program or system.
• Formulas are equations or pre-defined logic that tell the spreadsheet how to perform calculations and other actions on data.

Other

• Spreadsheet programs like Excel use cells and rows, columns, to store and organize data.
• Various functions and formulas can be used to do calculations and other operations on the data.
• Specific formulas and functions can be used to create calculations and summaries in spreadsheets.

Бұл викторинада Excel функциялары мен формулалары, сондай-ақ желілік топологиялардың түрлері туралы білім тексеріледі. Excel-де мәліметтермен жұмыс істеу үшін қолданылатын әдістер мен концепцияларды зерттеу жасаңыз. Желілік құрылымдарды түсіну желілерді жобалау мен басқаруда маңызды аудан болып табылады.