Rekenblad

Sjabloon:Manual Page

Dit artikel betreft van de GeoGebra gebruikers interface.

Hoofdcomponenten

• Menubalk
• Gereedschappenbalk
• Invoerveld
• Context Menu
• Navigatiebalk
• Virtueel Keyboard

Views

• Algebra venster
• CAS venster
• Tekenvenster
• Rekenblad
• Schermindelingen

Menu's

• Bestandsmenu
• Menu bewerken
• Bekijk Menu
• Opties Menu
• Macromenu
• Venster Menu
• Helpmenu

Dialogen

• Eigenschappen dialoogvenster
• Constructie Protocol
• Macro dialoogvenster
• Macro Manager dialoogvenster
• Verfijn dialoogvenster
• Opties uitleg
• Exporteer uitleg bij tekenvenster
• Exporteer werkblad uitleg
• Afdrukvoorbeeld

Rekenblad

Standaard wordt het Rekenblad geopend naast het Tekenvenster. De Knoppenbalk wordt bovenaan het scherm getoond met de knoppen Ongedaan maken / Onieuw in de rechterbovenhoek.

Rekenblad

Het Rekenblad hoort bij de Schermindeling Rekenblad, maar je kunt het ook toevoegen in andere schermindelingen via het menu Beeld.

Het Rekenblad aan passen

Je kunt het Rekenblad aanpassen:

• Klik op het icoon Voorkeuren en selecteer Rekenblad (GeoGebra Desktop)
• Open de opmaakwerkbalk van het Rekenblad en selecteer and selecting Voorkeuren (GeoGebra Web en Tablet Apps)

In het dialoogvenster kan je de opmaak aanpassen volgende opties selecteren:

• Toon Invoerveld
• Toon roosterlijnen
• Toon koppen van kolommen en/of koppen van rijen
• Show verticale of horizontale schuifbalken

Je kunt het Rekenblad ook aanpassen door

• Gebruik knoppen en aanvinkvakjes of Tooltips toe te staan
• een "=" te vragen voor commandso'
• Automatisch Aanvullen te gebruiken

Wiskundige Objecten creëren

In het Rekenblad heeft elke cel een specifieke naam.

Voorbeeld: De cel in kolom A en rij 1 heet A1.

Nota: Deze celnamen kan je gebruiken in uitdrukkingen en Commando's om de inhoud van een specifieke cel te bepalen.

Direct Input and Commands

In the Spreadsheet Cells you can enter not only numbers, but all types of General Objects and Geometrical Objects that are supported by GeoGebra (e. g., coordinates of points, Functions, Commands).

Relative Cell Names

If you copy content from one cell to another, by default all references are changed accordingly to the target position.

Voorbeeld: Let A1=1, A2=2. In B1 put (A1, A1). By copying B1 to B2 (either via Sjabloon:KeyCode, Sjabloon:KeyCode or by dragging the cell corner) you get (A2, A2) in B2.

To prevent this behavior, you can insert $ before the column and/or row of the referenced cell.

Nota: On Mac OS the Copy & Paste shortcuts are Sjabloon:KeyCode and Sjabloon:KeyCode

Input Data into the Spreadsheet View

Manual Entry, Commands, and Tracing

Besides manually adding entries into the Spreadsheet View cells, you may use the commands FillColumn, FillRow or FillCells. You can also enter data by using the feature Tracing to Spreadsheet.

Copy Data from the Algebra View

With a simple drag and drop operation it is also possible to copy objects from the Algebra View to the Spreadsheet View. If you drag a list, its elements will be pasted horizontally, starting from the cell in which you release the left mouse button. Pressing the Sjabloon:KeyCode key while dragging opens a dialog window when the mouse button is released, allowing you to choose whether the pasted objects will be Free or Dependent, as well as to choose the vertical placement of the copied objects (check option Transpose).

Copy Data from Other Spreadsheet Software

GeoGebra allows you to import data from other spreadsheet software into the Spreadsheet View.

• Select and copy the data you want to import. For example, you may use the keyboard shortcut Sjabloon:KeyCode (Mac OS: Sjabloon:KeyCode) in order to copy the data to your computer’s clipboard.
• Open a GeoGebra window and show the Spreadsheet View.
• Click on the spreadsheet cell that should contain the first data value (e.g. cell A1)
• Paste the data from your computer’s clipboard into GeoGebra’s Spreadsheet View. For example, you may select a cell and use the keyboard shortcut Sjabloon:KeyCode (Mac OS: Sjabloon:KeyCode) in order to paste the data into the highlighted spreadsheet cell.

.

Import Data Files from other Applications

You can also import data from other applications, if stored using .txt, .csv and .dat formats. Simply right click on a free cell of the Spreadsheet View, then choose the Import Data File... option.

Nota: GeoGebra uses the dot Sjabloon:KeyCode as decimal separator, and the comma Sjabloon:KeyCode as field separator. Ensure to check if your data file matches these settings before importing.

Spreadsheet View Toolbar

The Spreadsheet View Toolbar provides a range of Tools that can be operated with the mouse and allow you to create objects in the Spreadsheet View. Every icon in the Toolbar represents a Toolbox that contains a selection of related Tools. In order to open a Toolbox, you need to click on the corresponding default Tool shown in the Spreadsheet View Toolbar (GeoGebra Web and Tablet Apps) or on the small arrow in the lower right corner of the Toolbar icon (GeoGebra Desktop).

Nota: The Tools of the Spreadsheet View Toolbar are organized by the nature of resulting objects or their functionality. For example, you will find Tools that analyze data in the Data Analysis Toolbox.

Display of Mathematical Objects

Display of Spreadsheet Objects in other Views

If possible, GeoGebra immediately displays the graphical representation of the object you entered in a Spreadsheet Cell in the Graphics View as well. Thereby, the name of the object matches the name of the Spreadsheet Cell used to initially create it (e. g., A5, C1).

Nota: By default, Spreadsheet Objects are classified as Auxiliary Objects in the Algebra View. You can show or hide these Auxiliary Objects by selecting Auxiliary Objects from the Context Menu or by clicking on the icon in the Algebra View Style Bar

Using Spreadsheet Data in other Views

You may process the Spreadsheet Data by selecting multiple cells and right-clicking (Mac OS: Sjabloon:KeyCode-clicking) on the selection. In the appearing Context Menu, choose the submenu Create and select the appropriate option (List, List of points, Matrix, Table, Polyline and Operation table).

Operation Table

For a function with two parameters you can create an Operation Table with values of the first parameter written in the top row and values of second parameter written in the left column. The function itself must be entered in the top left cell.

After entering the function and the parameter values in the appropriate cells, select the rectangular area of the desired Operation Table with the mouse. Then, right click (Mac OS: Sjabloon:KeyCode-click) on the selection and choose option Create > Operation Table of the appearing Context Menu.

Voorbeeld: Let A1 = x y, A2 = 1, A3 = 2, A4 = 3, B1 = 1, C1 = 2 and D1 = 3. Select cells A1:D4 with the mouse. Then, right click (Mac OS: Sjabloon:KeyCode-click) on the selection and choose Create > Operation Table in the Context Menu to create a table containing the results of substitution of the inserted values in the given function.

Spreadsheet View Style Bar

The Spreadsheed View Style Bar provides buttons to

• show / hide the Input Bar (GeoGebra Desktop)
• change the text style to bold or italic
• set the text alignment to left, center, or right
• change the background color of a cell
• change the cell borders (GeoGebra Desktop)
• open the Properties Dialog (GeoGebra Web and Tablet Apps)
• display additional Views in the GeoGebra window (GeoGebra Web and Tablet Apps)