أسئلة حول إخفاء الأعمدة في Excel

Microsoft Office 2016

• This is a presentation for Microsoft Excel 2016
• Course material for Computer Science
• For the second-stage students in Arabic and Chemistry departments.
• Instructor: Ms. Hanan Anwar Al-Sfar

Microsoft Excel 2016

• A significant program in the Microsoft Office suite, also known as a spreadsheet program
• Focuses on entering and manipulating various data types, including numeric and textual
• Contains extensive built-in functions, such as mathematical, trigonometric, text, time/date, and logical ones.

Running the Program

• After installation (from a disk, flash drive, or the internet), the program can be launched from the Task bar.
• Or use a shortcut if there is one on the desktop.
• Or search for it using the search box on the Task bar.
• When launched, the following interface will appear:
• Recent files appear on the left side, under the "Recent" heading.
• Below that is "Open other workbook" for opening pre-existing files.
• The right portion has a search box labeled "Search for online template" to find ready-made templates from the Microsoft Office website.
• There's also an option called "Blank workbook" to create a new Excel file named "Book".

Main Screen of Excel

• Similar to the Microsoft Word screen.
• The top bar displays zoom/minimize/close options.
• The Quick Access Toolbar can be displayed under the tabs.
• To customize it, click the arrow at its end and select "Show below the ribbon".
• Display ribbon options:
  • Auto Hide ribbons: Hides all screen content, leaving only the document page. Tabs are still visible.
  • Show tabs: Displays only tab names, not the commands within.
  • Show tabs and commands: Displays tab names and their commands.

Formula Bar and Name Box

• Located below the tabs, the formula bar displays entered values, formulas, and functions for cells.
• The adjacent name box displays the name of the active cell.

Excel File Structure

• An Excel file is comprised of sheets.
• Each sheet contains multiple columns (lettered) and rows (numbered).
• The intersection of columns and rows forms cells.
• Each cell has a name and a value.
• One cell is active at a time, which is denoted by the name box.

File Tab

• Contains critical file management commands:
• Info: Provides detailed information about the file.
• New (CTRL + N): Creates a new file.
• Open (CTRL + O): Opens a pre-existing file.
• Save (CTRL + S): Saves the file and prompts for location and name.
• Save As (F12): Creates a copy of the file, optionally changing the name or saving to a different location.

Entering Data

• Manually inputting data by clicking inside the relevant cells and pressing Enter.
• Using the formula bar and the cells to enter data and store it via the input tool.

Formatting Data

• Formatting can occur using the Font options in the Home tab.

Hiding and Unhiding

• Rows and columns can be hidden.
• To hide, right-click the row/column header; choose "Hide".
• To unhide, select the rows before and after each hidden row/column. In the context menu, choose "Unhide".
• This action can also be accessed through the "Visibility" command in the "Format" option.

Deleting Data

• Deleting rows/columns/sheets.
• This action can be done via the context menu or the "Home" -> "Format" --> "Visibility" command.
• Specific commands to delete are delete sheet rows and delete sheet columns and delete sheet

Clearing Data

• Data from cells can be cleared in several ways:
  • Clear content: Removes cell values.
  • Clear formats: Removes cell formatting without affecting values.
  • Clear comments (if present)
  • Clear all: Removes both values and formatting.

Controlling Row Height and Column Width

• To adjust row height, access the "Row Height" command via the context menu.
• To adjust column width, use the "Column Width" command.

Conditional Formatting

• Formatting data based on specific conditions.
• Available options include greater than, less than, between, and equal to.

Functions in Excel

• Excel has various functions for numerical, statistical, trigonometric, text, and date/time manipulation.
• These are often accessed from formulas, but can be called from the main menu with "Insert Function".
• Common functions include max, min, sum, average, count, counta, and if.

Exporting/Printing

• Exporting a file to other formats (e.g., PDF).
• Printing a file.

Microsoft Word

• A word processor for creating, editing, and printing documents.
• Supports multiple columns, various writing styles, and editing official documents.
• Has a simple and adaptable interface.

Microsoft Word Features

• Writing in multiple languages (Arabic and other).
• Spell and grammar check.
• Page setup (margins, orientation, paper size).
• Formatting (font styles, sizes, text alignment, background color.)
• Adding images, shapes, graphs, tables.
• Search and replace text.
• Protecting documents using password protection.
• Saving as a web page or template.
• Previewing documents before printing.
• Managing references and citations

Running and Using Word

• The most common method is to locate the application using search bar in the OS, and open the application to start work on the document.

Word Interface Components

• File tab to manage document tasks.
• Home tab to format text and paragraphs.
• Insert tab to add objects like images and tables.
• Design tab to apply themes and styles.
• Layout tab to manage page layout settings.
• Page setup (margins, orientation, paper size).
• Review tab for grammar and spelling checks.
• View tab to change document view (e.g., print layout, full screen).

Word- Specific

• Insert Point (cursor)
• Work Area (the main blank space which work on)
• Scroll Bars (vertical/horizontal bars to navigate throughout the document).
• Saving files and closing with "File" Tab.
• Saving a new file to a new format of page.

Microsoft PowerPoint 2016

• A presentation software for creating and delivering slideshows

PPT 2016 Features (brief)

• Creating slideshows
• Inserting media (video, audio, images)
• Formatting text, images, and slides
• Adding transitions and animations between slides

Internet Related

• A complex network of interconnected computer networks.
• Two fundamental services: e-mail and browsing.

Computer Network Types

• LAN (Local Area Network): Covers a small area (e.g., a room or a building).
• MAN (Metropolitan Area Network): Spans across a city or municipality.
• WAN (Wide Area Network): Encompasses a large geographical area (country or continent, or even across continents).

Network Protocols

• TCP/IP: Used for data transfer across the internet or local networks.
• FTP (File Transfer Protocol): Used for transferring large files.
• HTTP (Hypertext transfer protocol): Used primarily for transferring webpages and related information

WWW (World Wide Web)

• A set of interconnected webpages that uses HTML (HyperText Markup Language)
• Accessible through web browsers.

Web Browsers

• Software applications for viewing web pages. Examples include Internet Explorer, Google Chrome, and Mozilla Firefox.

HTML (HyperText Markup Language)

• The standard language used for creating web pages.

Additional Notes

• Modem (modulator-demodulator): Converts analog signals to digital and vice-versa, allowing for internet access.
• Router: Connects multiple devices to a single internet connection.
• Switch: Connects multiple devices on a network to share data and resources.
• Hub: A similar device to switch, but less efficient with network traffic.
• URL (Uniform Resource Locator): A web address uniquely identifying a webpage.
• E-mail (Electronic Mail): A system for exchanging messages electronically.
• Browser (Internet Browser): software for the web, displays webpages, facilitates interactions between users and the web.
• Search Engine: Software that facilitates searching for information across the internet.
• E-commerce (Electronic Commerce): Business transactions conducted electronically.
• A process of creating a new email account.
• How to send an email.

هذا الاختبار يختبر معرفتك بإجراءات إخفاء وإظهار الأعمدة في ملف Excel. سيتضمن الأسئلة خيارات متعددة حول كيفية التعامل مع الأعمدة المخفية والخلايا. إذا كنت تتطلع إلى تحسين مهاراتك في استخدام Excel، فهذا الاختبار مناسب لك.