{"id":330,"date":"2026-01-22T19:26:07","date_gmt":"2026-01-22T19:26:07","guid":{"rendered":"https:\/\/bliv-klogere.dk\/?page_id=330"},"modified":"2026-05-28T07:27:28","modified_gmt":"2026-05-28T07:27:28","slug":"2-beregninger-og-referencer","status":"publish","type":"page","link":"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/","title":{"rendered":"2. Beregninger og referencer"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Indholdsfortegnelse<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#1_De_4_regnearter\" >1. De 4 regnearter<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#Opgaver\" >Opgaver<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#11_FVU_mini_grundkursus\" >1.1 FVU mini grundkursus<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#12Traening_i_de_4_regnearter\" >1.2Tr\u00e6ning i de 4 regnearter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#13_Repetering_af_traening_i_de_4_regnearter\" >1.3 Repetering af tr\u00e6ning i de 4 regnearter<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#2_Fra_relative_til_absolutte_referencer\" >2. Fra relative til absolutte referencer<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#Opgaver-2\" >Opgaver&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#21_Din_forste_beregning\" >2.1 Din f\u00f8rste beregning&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#22_Brug_navne_som_absolutte_referencer\" >2.2 Brug navne som absolutte referencer&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/#23_Et_budget\" >2.3 Et budget&nbsp;<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_De_4_regnearter\"><\/span>1. De 4 regnearter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Excel fungerer ikke p\u00e5 samme m\u00e5de som en lommeregner. Faktisk er Excel en ganske elendig lommeregner. I stedet for tal regner Excel med referencer, dvs pegepinde til den \u00f8nskede celle. Du kan godt g\u00f8re som p\u00e5 en lommeregner I en celle I Excel, men det vil f\u00f8les akavet&nbsp;<\/li>\n\n\n\n<li>Indtast et tal f.eks 2 i celle B2 (1)&nbsp;<\/li>\n\n\n\n<li>Indtast et nyt tal, her igen 2 Ien ny celle, C2 (2)&nbsp;<\/li>\n\n\n\n<li>For at l\u00e6gge de 2 tal sammen I celle D2 skriver du f\u00f8lgende formel I cellen:&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">= B2 + C2&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2026 alts\u00e5 f\u00f8rst et lighedstegn, herefter den f\u00f8rste celles navn, s\u00e5 et plus, og til sidst den sidste celles navn (3)&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"613\" height=\"363\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-93.png\" alt=\"\" class=\"wp-image-331\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-93.png 613w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-93-300x178.png 300w\" sizes=\"auto, (max-width: 613px) 100vw, 613px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N\u00e5r du klikker p\u00e5 retur, s\u00e5 vil Excel finde et resultat til dig.&nbsp;<\/li>\n\n\n\n<li>Bem\u00e6rk: I stedet for at skrive cellens navn, f.eks. &#8220;B2&#8221;, s\u00e5 kan du bare klikke p\u00e5 den \u00f8nskede celle, n\u00e5r du f\u00f8rst har lavet et lighedstegn&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver\"><\/span>Opgaver<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_FVU_mini_grundkursus\"><\/span>1.1 FVU mini grundkursus<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Brug filen her:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-fc7cb899-ae9b-46d7-8179-371401fed915\" href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/05\/Excel-FVU-kursus.xlsx\">Excel FVU kursus<\/a><a href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/05\/Excel-FVU-kursus.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-fc7cb899-ae9b-46d7-8179-371401fed915\">Download<\/a><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12Traening_i_de_4_regnearter\"><\/span><strong>1.2Tr\u00e6ning i <\/strong>de 4 regnearter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">I vedh\u00e6ftede regneark kan du tr\u00e6ne b\u00e5de plus, minus, gange og dividere.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lav dine beregninger I de gr\u00f8nne felter og lav dine summeringer I de gule felter&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-3d4113b9-cbf2-4a89-b421-4945f4cf4df6\" href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Excel-grundkursus-de-4-regnearter.xlsx\">Excel grundkursus de 4 regnearter<\/a><a href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Excel-grundkursus-de-4-regnearter.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-3d4113b9-cbf2-4a89-b421-4945f4cf4df6\">Download<\/a><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"13_Repetering_af_traening_i_de_4_regnearter\"><\/span>1.3 Repetering af tr\u00e6ning i de 4 regnearter<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Her er flere ark til at tr\u00e6ne de 4 regnearter:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-69eb7ba7-c460-4b29-8bb8-56415bb918c6\" href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Repetition-4-regnearter-formatering-absolut-ref-og-budget-2-1.xlsx\">Repetition 4 regnearter, formatering, absolut ref og budget (2) (1)<\/a><a href=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/Repetition-4-regnearter-formatering-absolut-ref-og-budget-2-1.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-69eb7ba7-c460-4b29-8bb8-56415bb918c6\">Download<\/a><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Fra_relative_til_absolutte_referencer\"><\/span>2. Fra relative til absolutte referencer<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du kommer til at bruge referencer rigtigt meget I Excel n\u00e6sten uanset, hvad du foretager dig&nbsp;<\/li>\n\n\n\n<li>Du skal nu l\u00e6re, hvordan man kan l\u00e5se en reference p\u00e5 en bestemt celle&nbsp;<\/li>\n\n\n\n<li>Nedenfor har jeg indtastet et lille regneark med nogle varer\n<ul class=\"wp-block-list\">\n<li>I s\u00f8jle A st\u00e5r varens navn&nbsp;<\/li>\n\n\n\n<li>I s\u00f8jle B st\u00e5r varens indk\u00f8bspris&nbsp;<\/li>\n\n\n\n<li>I s\u00f8jle C skal du beregne varens indk\u00f8bspris gange avancen p\u00e5 10%.\n<ul class=\"wp-block-list\">\n<li>Avancen skal g\u00e5 igen I alle beregninger. S\u00e5 den skriver jeg I en celle for sig (1)&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>I s\u00f8jle D skal tallene fra s\u00f8jle B + C l\u00e6gges sammen. Det giver varens salgsprix ex moms&nbsp;<\/li>\n\n\n\n<li>I s\u00f8jle E skal der laves en momsberegning. Dvs. Salgsprisen ex moms I celle D gange momsen, som jeg lige som avancen skriver I en celle for sig (2)&nbsp;<\/li>\n\n\n\n<li>I s\u00f8jle F skal salgsprisen + moms l\u00e6gges sammen med momsen, s\u00e5 vi f\u00e5r en salgspris med moms&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Det ser s\u00e5dan ud alt I alt:&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"292\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-94.png\" alt=\"\" class=\"wp-image-335\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-94.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-94-300x86.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-94-768x219.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du kan se cellernes formler (1) ved at g\u00e5 ind p\u00e5 fanen Formler og klikke p\u00e5 knappen Vis formler (Show formulas) (2)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"303\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-121-1024x303.png\" alt=\"\" class=\"wp-image-405\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-121-1024x303.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-121-300x89.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-121-768x227.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-121.png 1455w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hvis jeg nu kopierer formlerne ned I s\u00f8jle C, s\u00e5 ser det helt forkert ud. De indsatte pile viser hvor refencerne peger hen\n<ul class=\"wp-block-list\">\n<li>Du kan inds\u00e6tte pile fra fanen Formler &gt; Spor afh\u00e6ngigheder&nbsp;&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"419\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-95.png\" alt=\"\" class=\"wp-image-336\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-95.png 820w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-95-300x153.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-95-768x392.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Det skyldes, at referencen til celle B4 skal flyttes, men det skal referencen til celle I3 med avancen ikke, og det g\u00f8r den.&nbsp;&nbsp;<\/li>\n\n\n\n<li>Cellereferencen til I3 skal derfor l\u00e5ses. Det g\u00f8res ved at s\u00e6tte dollartegn ind I formlen I celle C4 inden, at jeg kopierer den.&nbsp;&nbsp;<\/li>\n\n\n\n<li>I stedet for at skrive formlen I celle C4 som&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">= B4 * I3&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00e5 skal den skrives s\u00e5ledes&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">= B4 * $I$3&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>Tip: Du kan s\u00e6tte dollartegnene automatisk ved at have cellen markeret I formlen og klikke p\u00e5 F4&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nu regner den rigtigt (1). Hvis jeg igen s\u00e6tter pile p\u00e5, s\u00e5 peger pilene mod h\u00f8jre nu p\u00e5 den samme celle hvergang<\/li>\n\n\n\n<li>Formlerne i cellerne ser nu s\u00e5ledes ud:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"310\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122-1024x310.png\" alt=\"\" class=\"wp-image-406\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122-1024x310.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122-300x91.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122-768x233.png 768w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122-1536x465.png 1536w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-122.png 1539w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cellenavn som absolut reference<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I stedet for at bruge dollartegn kan man lave en absolut reference ud fra at give cellen et navn&nbsp;<\/li>\n\n\n\n<li>St\u00e5 I den celle, som du vil lave en reference til (1)&nbsp;<\/li>\n\n\n\n<li>I cellen under b\u00e5ndet st\u00e5r cellens navn, her &#8220;I3&#8221;. Slet &#8220;I3&#8221; og skriv I stedet et navn efter eget valg, f.eks. &#8220;Avance&#8221; (2)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-96.png\" alt=\"\" class=\"wp-image-337\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-96.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-96-300x96.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-96-768x246.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>N\u00e5r du efterf\u00f8lgende skriver udregningen, kan du I stedet for at skrive &#8220;$I$3&#8221; skrive &#8220;Avance&#8221;.&nbsp; &#8220;Avance&#8221; er en absolut reference, som du kan kopiere p\u00e5 kryds og tv\u00e6rs af dit regneark&nbsp;<\/li>\n\n\n\n<li>En anden fordel er, at ordet Avance er noget mere sigende for cellens indhold end $I$3&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opgaver-2\"><\/span>Opgaver&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21_Din_forste_beregning\"><\/span><strong>2.1 Din f\u00f8rste beregning<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Opret et skema, der ser cirka s\u00e5dan ud. Formateringen er selvf\u00f8lgelig frivillig, men det er rarest at have lidt farver p\u00e5<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-97.png\" alt=\"\" class=\"wp-image-338\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-97.png 1024w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-97-300x98.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-97-768x251.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>G\u00e5 vejledningen igennem, s\u00e5 du har b\u00e5de almindelige\/relative referencer f.eks. B4, B4 som kan flytte sig, og absolutte referencer som f.eks. $I$4 og $I$4 som altid peger p\u00e5 den samme celle&nbsp;<\/li>\n\n\n\n<li>Skriv f\u00f8rst v\u00e6rdierne I r\u00e6kke 4. Kopier dem herefter ned og tjek, at beregningerne er rigtige. Dette er en lille tabel og tidsbesparelsen er ikke helt s\u00e5 \u00e5benlys. Men havde du f.eks. 200 varer alle med hver deres avancer, s\u00e5 bliver du glad for, at du kan rette tingene et sted fra I den celle, som den absolutte reference peger p\u00e5&nbsp;<\/li>\n\n\n\n<li>Ret avancen til 20%. Retter alle tallene I regnearket sig ind?&nbsp;<\/li>\n\n\n\n<li>Afslut med at lave en p\u00e6n formatering af alle bel\u00f8bene, s\u00e5 der kommer kroner p\u00e5. F.eks. 2,25 Kr&nbsp;<\/li>\n\n\n\n<li>Hvis \u00f8velsen var sv\u00e6r, s\u00e5 g\u00f8r det igen med andre varer I et nyt ark. F.eks. Agurker, Tomater og Selleri, der hver koster 3, 4 og 5 kr.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22_Brug_navne_som_absolutte_referencer\"><\/span><strong>2.2 Brug navne som absolutte referencer<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kopier dit arbejde til et andet sted p\u00e5 dit regneark&nbsp;<\/li>\n\n\n\n<li>Marker cellen, hvor du har tallet for avancen&nbsp;<\/li>\n\n\n\n<li>Omd\u00f8b cellen, s\u00e5 den hedder Avance&nbsp;<\/li>\n\n\n\n<li>Erstat den absolutte reference til cellen med ordet Avance&nbsp;<\/li>\n\n\n\n<li>Se, at det virker&nbsp;<\/li>\n\n\n\n<li>G\u00f8r det samme for cellen Moms&nbsp;<\/li>\n\n\n\n<li>Se igen, at det virker&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ekstra. G\u00e5r cellenavne p\u00e5 tv\u00e6rs af dine ark<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hvis du ikke allerede har gjort det: D\u00f8b cellen for avancen, og kald den gerne for &#8220;Avance&#8221;&nbsp;<\/li>\n\n\n\n<li>Tjek, at du kan bruge den I en formel I dit ark&nbsp;<\/li>\n\n\n\n<li>I et nyt ark (ikke en ny fil, men et nyt ark) lav en kopi af tabellen men ikke af den celle, som har f\u00e5et navnet Avance&nbsp;<\/li>\n\n\n\n<li>I det nye ark lav en formel, som refererer til cellen &#8220;Avance&#8221;&nbsp;<\/li>\n\n\n\n<li>Se om det virker&nbsp;<\/li>\n\n\n\n<li>Ret indholdet I cellen avance. Sl\u00e5r \u00e6ndringerne igennem?&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"23_Et_budget\"><\/span><strong>2.3 Et budget<\/strong>&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Du skal nu lave et budget. Opstillingen ser s\u00e5dan ud\n<ul class=\"wp-block-list\">\n<li>I det bl\u00e5 omr\u00e5de skriver du overskrifterne (1). G\u00e5 gerne hele \u00e5ret ud, dvs. Januar \u2013 december. Jeg har kun vist for et halv\u00e5r&nbsp;&nbsp;<\/li>\n\n\n\n<li>Til venstre skriver du betegnelserne p\u00e5 r\u00e6kkerne (2)&nbsp;<\/li>\n\n\n\n<li>I det lyser\u00f8de\/orange omr\u00e5de skriver du bel\u00f8bet (3)&nbsp;<\/li>\n\n\n\n<li>I det gullige omr\u00e5de skal du bruge absolutte referencer (4)&nbsp;<\/li>\n\n\n\n<li>Til sidst skal du bruge sum I det bl\u00e5 omr\u00e5der&nbsp;<br>&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"818\" height=\"460\" src=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-98.png\" alt=\"\" class=\"wp-image-339\" srcset=\"https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-98.png 818w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-98-300x169.png 300w, https:\/\/bliv-klogere.dk\/wp-content\/uploads\/2026\/01\/image-98-768x432.png 768w\" sizes=\"auto, (max-width: 818px) 100vw, 818px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ideen er,\n<ul class=\"wp-block-list\">\n<li>at du fra det lyser\u00f8de\/orange omr\u00e5de (3) kan lave en rettelse, som s\u00e5 sl\u00e5r igennem I hele budettet&nbsp;<\/li>\n\n\n\n<li>At du kan se, hvilke m\u00e5neder betalingerne falder I. Husleje er typisk hver m\u00e5ned, mens forsikringer, licens mv. Ikke er hver m\u00e5ned&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Tag dig din tid, og g\u00f8r gerne dit budget s\u00e5 realistisk som muligt. Du er velkommen til efterf\u00f8lgende at gemme det og sende det hjem til dig selv&nbsp;<\/li>\n\n\n\n<li>Slut gerne din budget af med, at du I en celle skriver &#8220;Gennemsnitlig udgift pr m\u00e5ned&#8221;, og I nabocellen beregner du s\u00e5, hvad den gennemsnitlige udgift pr m\u00e5ned er.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ekstra: Semi-relative referencer&nbsp;<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>I r\u00e6kke 5 har du absoultte referencer, der alle ser s\u00e5dan ud her $B$5 og selvf\u00f8lgelig peger p\u00e5 celle B5&nbsp;<\/li>\n\n\n\n<li>Tilsvarende I r\u00e6kke 6 hedder dine referencer $B$6 osv.&nbsp;<\/li>\n\n\n\n<li>Hvis du laver en absolut reference I den f\u00f8rste r\u00e6kke hvor s\u00f8jlen er fast men hvor r\u00e6kken er relativ, dvs. $B5 I stedet for $B$5, s\u00e5 kan du kopiere formlen I hele det omr\u00e5de, hvor du har absolutte referencer&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ekstra: Brug navne<\/strong>&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tag en kopi af dit budget og s\u00e6t det ind I et nyt ark&nbsp;<\/li>\n\n\n\n<li>Omd\u00f8b cellerne med tallene for Husleje, Licens mv, s\u00e5 de ikke hedder B5, B6 osv men I stedet hedder &#8220;Husleje&#8221;, &#8220;Licens&#8221; mv.&nbsp;<\/li>\n\n\n\n<li>Brug nu de nye navne for cellerne som reference&nbsp;<\/li>\n\n\n\n<li>Hvad kunne fordelene ved at anvende navne I stedet for referencer v\u00e6re?&nbsp;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Link til <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\">toppen af siden<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. De 4 regnearter = B2 + C2&nbsp; Link til toppen af siden. Opgaver 1.1 FVU mini grundkursus Brug filen her: 1.2Tr\u00e6ning i de 4 regnearter I vedh\u00e6ftede regneark kan du tr\u00e6ne b\u00e5de plus, minus, gange og dividere.&nbsp; Lav dine beregninger I de gr\u00f8nne felter og lav dine summeringer I de gule felter&nbsp; Link til &hellip; <a href=\"https:\/\/bliv-klogere.dk\/index.php\/2-beregninger-og-referencer\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">2. Beregninger og referencer<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-330","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/comments?post=330"}],"version-history":[{"count":6,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/330\/revisions"}],"predecessor-version":[{"id":3558,"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/pages\/330\/revisions\/3558"}],"wp:attachment":[{"href":"https:\/\/bliv-klogere.dk\/index.php\/wp-json\/wp\/v2\/media?parent=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}