---
author: Florian Fischer
lang: de
theme: metropolis
aspectratio: 169
header-includes: |
    \let\tightlist\relax
---

## {.standout}
Herzlich Willkommen!

Du kannst dich schon anmelden

\texttt{[v]orname.nachname}

und den Bildschirm ausschalten.

## \faIcon{chalkboard-teacher} Wiederholung

![](img/salary_copy.png){.center}

\Large

* Bequem Kopieren, wie ging das nochmal?

## \faIcon{chalkboard-teacher} Wiederholung: Zellbezüge

\Large

> - Was waren **relative** Zellbezüge und ihr Problem?
> - Wie hieß die andere Art und wie hat sie funktioniert?

::: {.columns align=center}
:::: {.column width=30%}
\pause
![](img/dollar.png)
::::

:::: {.column width=70%}
\pause
\begin{tabular}{| l | l |}
\hline
\Large \textbf{Relative} Adressierung & \Large A1 \\
\hline
\Large \textbf{Absolute} \textcolor{red}{Zeilen}adressierung & \Large A\textbf{\$}1 \\
\hline
\Large \textbf{Absolute} \textcolor{red}{Spalten}adressierung & \Large \textbf{\$}A1 \\
\hline
\Large \textbf{Absolute} Adressierung & \Large \textbf{\$}A\textbf{\$}1 \\
\hline
\end{tabular}
::::
:::

## \faIcon{chalkboard-teacher} Wiederholung: *kleines Ein-mal-Eins*

\large 
Erläutere die Formel um die *kleine Ein-mal-Eins* Matrix bequem zu befüllen?

\begin{center}
\begin{tikzpicture}
\only<1> { \node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/ein_mal_eins.png}}; }
\only<2-> { \node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/ein_mal_eins_formular.png}}; }
\only<3-> { \draw[line width=1pt, blue, -Triangle] (-3.7cm, 1.1cm) -- (-3.7cm, -2.2cm); }
\only<4-> { \draw[line width=1pt, red, -Triangle] (-2.4cm, 1.35cm) -- (5cm, 1.35cm); }
\end{tikzpicture}
\end{center}

##
\tikzset{
 clip even odd rule/.code={\pgfseteorule}, % Credit to Andrew Stacey 
 invclip/.style={
  clip,
  insert path=[clip even odd rule]{
   [reset cm](-\maxdimen,-\maxdimen)rectangle(\maxdimen,\maxdimen)
  }
 }
}

\begin{center}
\begin{tikzpicture}[overlay, remember picture]
\node {\includegraphics[keepaspectratio, width=\textwidth]{img/sallary_sum.png}};
\only<2->{
  \begin{scope}[even odd rule]
    \begin{pgfinterruptboundingbox}
    \path[invclip] (-2.4cm, -3.4cm) rectangle (6.8cm, -4.4cm);
    \end{pgfinterruptboundingbox} 
    \node[fill=bg, opacity=0.8, minimum width=1.1\textwidth, minimum height=1.1\textheight] {};
  \end{scope}
  \node[draw=red,minimum width=9.2cm, minimum height=0.55cm, line width=1pt] (bar) at (2.2cm, -4.075cm){};
}
\only<3>{
  \node[yshift=1.5cm, xshift=1cm, left=of bar] (q) {\phantom{\textcolor{red}{\Large \textbf{Geht das leichter?}}}};
  \draw[red, -{Triangle[scale=0.5]}, line width=0.3cm] (q.center) -- (bar.north west);
  \node[draw=red, fill=bg, yshift=1.5cm, xshift=1cm, left=of bar] {\textcolor{red}{\Large \textbf{Geht das leichter?}}};
}
\end{tikzpicture}
\end{center}

## Vordefinierte Funktionen

Ein **TKS** stellt zahlreiche **vordefinierte Funktionen** zur Verfügung, die sich auf vielfältigste Weise einsetzen lassen:

\scalebox{1.8}{
\begin{tikzpicture}[scale=1.5]
\node[draw=blue] at (-2, 0.3) {MITTELWERT()};
\node[draw=orange] at (-1.6, -0.3) {RUNDEN()};
\node[draw=yellow] at (-0.3, -0.1) {SUMME()};
\node[draw=gray] at (0, 0.5) {ANZAHL()};
\node[draw=teal] at (1.5, 0) {WENN()};
\node[draw=red] at (1.7, -0.5) {MAX()};
\end{tikzpicture}
}

## Vordefinierte Funktionen

In **LibreOffice Calc** sind \boldred{vordefinierte Funktionen} wie folgt zu finden:

\begin{center}
\begin{tikzpicture}
\only<-2> {
\node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/inputbar.png}};
}
\only<2>{
\node[draw=red, minimum size=0.75cm, line width=1pt] (box) at (1.1cm, 0.65cm) {};
\node[scale=2, single arrow, draw=red!80, fill=red!80,
  minimum width = 10pt, single arrow head extend=3pt,
  minimum height=10mm, rotate=180, left of=box] {};
}
\only<3>{
\node {\includegraphics[keepaspectratio, width=0.8\textwidth, trim={0 5cm 0 0}, clip]{img/quick_functions.png}};
}
\end{tikzpicture}
\end{center}

## Vordefinierte Funktionen - Funktions-Assistent

\begin{center}
\begin{tikzpicture}
\node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/inputbar.png}};
\only<2>{
\node[draw=red, minimum size=0.75cm, line width=1pt] (box) at (0.4cm, 0.65cm) {};
\node[scale=2, single arrow, draw=red!80, fill=red!80,
  minimum width = 10pt, single arrow head extend=3pt,
  minimum height=10mm, rotate=180, left of=box] {};
}
\only<3-5>{
\node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/function_assistant.png}};
}
\only<6->{
\node {\includegraphics[keepaspectratio, width=0.8\textwidth]{img/function_assistant_sel.png}};
}
\only<4> {
\node[draw=red, minimum height=0.55cm, minimum width=3.1cm, line width=1pt] (box) at (-3.8cm, 2.1cm) {};
\node[scale=1.5, single arrow, draw=red!80, fill=red!80,
  minimum width = 10pt, single arrow head extend=3pt,
  minimum height=10mm, right=of box, rotate=180] {};
}

\only<5,6> {
\node[draw=red, minimum height=0.5cm, minimum width=3.2cm, line width=1pt] (box) at (-3.81cm, 2.97cm) {};
\node[scale=1.5, single arrow, draw=red!80, fill=red!80,
  minimum width = 10pt, single arrow head extend=3pt,
  minimum height=10mm, right=of box, rotate=180] {};
}

\only<7> {
\node[draw=red, minimum height=5.6cm, minimum width=7.4cm, line width=1pt] (box) at (1.6cm, 1.3cm) {};
}
\end{tikzpicture}
\end{center}

## \faIcon{desktop} Arbeitsauftrag - 25 min

**Kopiere** das Dokument \boldred{Funktionen Teil1.ods} aus ByCS Drive.

**Bearbeite anschließend [alle]{.underline} Teilaufgaben (Rechenblätter) des Dokuments.**

\vspace{1cm}

![](img/rechenblaetter1.png){.center}

\begin{tikzpicture}[overlay, remember picture]
\node[draw=red, line width=1pt, minimum width=11.4cm, minimum height=0.5cm, anchor=west, xshift=3.5cm, yshift=3cm] at (current page.south west) {};
\end{tikzpicture}


## \faIcon{desktop} Arbeitsauftrag

**Kopiere** das Dokument \boldred{Funktionen Teil2.ods} aus ByCS Drive.

**Bearbeite anschließend die [ersten vier]{.underline} Aufgaben (Rechenblätter) des Dokuments.**

\vspace{0.5cm}

![](img/rechenblaetter2.png){.center}

\begin{tikzpicture}[overlay, remember picture]
\node[draw=red, line width=1pt, minimum width=7.5cm, minimum height=0.5cm, anchor=west, xshift=4.5cm, yshift=4.3cm] at (current page.south west) {};
\end{tikzpicture}

\vspace{0.2cm}

### \faIcon{earlybirds} Für Schnelle

Bearbeite die \textit{Vertiefungs}-Aufgaben des Dokuments.