{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Readme","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","15.1","16","17","18","19","20","21","22","23","24","25","Shortcuts1","Shortcuts2"],"not_rendered":{"charts":4,"images":9,"macros":1,"external_links":3,"defined_names":30,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Readme","index":0,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel kursus"]
[]
[null,"De sidste år jeg var på arbejdsmarkedet underviste jeg mange kollegaer I Excel, "]
[null,"og denne fil repræsenterer den første af en række filer til brug ved dette kursus."]
[]
[null,"Filen hedder ABC for at indikere, at det er absolut grundlæggende stof og derfor "]
[null,"vil den sikkert være relativt uinteressant for mange."]
[]
[null,"Vær opmærksom på, at filen er udarbejdet for mere end 10 år siden, hvorfor den"]
[null,"ikke indeholder nogen af Excels nyere funktioner. Tværtimod kan den visse "]
[null,"steder sikkert forekomme en smule forældet."]
[]
[null,"I mange ark (første gang I ark 8) vil du finde noget i stil med følgende:"]
[]
[null,"Sæt x for hjælp   "]
[]
[null,"Hvis du sætter et x I den indrammede celle (altså ikke i dette ark) vil du få vist et "]
[null,"eksempel på, hvoran en given opgave kan løses. Behøver jeg nævne, at du selv-"]
[null,"følgelig får mest læring ud af det, hvis du selv prøver at løse opgaven inden du "]
[null,"sætter et x?"]
[]
[null,"Der vil muligvis også være en del læring at hente ved at studere, hvordan jeg "]
[null,"har opbygget teksten, rækkenumre og kolonnenavne i de lysegrå områder og"]
[null,"de forskellige løsningsforslag, herunder brug af betinget formatering."]
[]
[null,"Der er I filen en brugerdefineret funktion (lavet i VBA), kaldet myCell."]
[null,"Funktionen er brugt første gang i ark 1, celle D18. Og hvorfor så det, tænker du"]
[null,"måske. Forestil dig, at du, bevidst eller ubevidst, kom til at indsætte en ny række"]
[null,"før række 5.  Da ville der ske det, at alle cellereferencer under punkterne 1. til 4. "]
[null,"ville blive forkerte i forhold til det, jeg lægger op til i teksten. Det vil måske ikke"]
[null,"være den store ulykke i det konkrete tilfælde, men i andre situationer vil en "]
[null,"lignende handling (primært indsættelse/sletning af rækker) helt sikkert skabe "]
[null,"en masse forvirring. Funktionen myCell sikrer, at der refereres til korrekt celle."]
[]
[null,"Har du lyst til at studere filen nærmere vil jeg ønske dig god fornøjelse, men alt"]
[null,"er på eget ansvar, og jeg udelukker ikke, at der kan være fejl, selvom jeg har "]
[null,"anstrengt mig for at undgå det. Specielt kan der muligvis, hist og her, forekomme"]
[null,"en vis sprogforbistring, for eksempel at TRUE optræder i stedet for SAND, forår- "]
[null,"saget af, at jeg altid har brugt og stadigvæk bruger en engelsksproget version"]
[null,"af Excel."]
[]
[]
[null,"Hans K."]
[null,"April 2023"]

{"sheet":"1","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Indtastning og justering"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,{"$f":"ROW()","v":5}]
[null,null,{"$f":"ROW()","v":6}]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8}]
[null,null,{"$f":"ROW()","v":9}]
[null,null,{"$f":"ROW()","v":10}]
[null,null,{"$f":"ROW()","v":11}]
[null,null,{"$f":"ROW()","v":12}]
[null,null,{"$f":"ROW()","v":13}]
[null,null,{"$f":"ROW()","v":14}]
[null,null,{"$f":"ROW()","v":15}]
[null,null,{"$f":"ROW()","v":16}]
[]
[null,null,1,{"$f":"\"Indtast dit fornavn i celle \"&mycell(D5)&\". Gør skriften fed og skriftfarven rød.\"","v":"Indtast dit fornavn i celle D5. Gør skriften fed og skriftfarven rød."}]
[null,null,null,"Gør teksten venstrestillet."]
[]
[null,null,2,{"$f":"\"Indtast dit efternavn i celle \"&mycell(D6)&\". Gør skriften fed og kursiveret,\"","v":"Indtast dit efternavn i celle D6. Gør skriften fed og kursiveret,"}]
[null,null,null,"og gør skriftfarven blå og venstrestillet.."]
[]
[null,null,3,{"$f":"\"Skriv dine initialer i hver af cellerne \"&mycell(D8)&\", \"&mycell(D9)&\" og \"&mycell(D10)&\".\"","v":"Skriv dine initialer i hver af cellerne D8, D9 og D10."}]
[null,null,null,"Formater de nævnte celler så initialerne er henholdsvis venstre-"]
[null,null,null,"justeret, centreret og højrejusteret."]
[]
[null,null,4,{"$f":"\"Skriv A, B, og C i henholdsvis cellerne \"&mycell(E11)&\", \"&mycell(E12)&\" og \"&mycell(E13)&\" og \"","v":"Skriv A, B, og C i henholdsvis cellerne E11, E12 og E13 og "}]
[null,null,null,"formater de nævnte celler med henholdsvis et , to og tre klik på"]
[null,null,null,"ikonet \"Forøg indrykning\"."]

{"sheet":"2","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Lidt om formatering af tal"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"}]
[null,null,{"$f":"ROW()","v":5}]
[]
[]
[null,null,1,{"$f":"\"Indtast tallet 123456 i celle \"&mycell(D5)&\".\"","v":"Indtast tallet 123456 i celle D5."}]
[]
[null,null,2,{"$f":"\"Med celle \"&mycell(D5)&\" aktiveret, indsæt tusindadskiller og to decimaler.\"","v":"Med celle D5 aktiveret, indsæt tusindadskiller og to decimaler."}]
[]
[null,null,3,"Brug ikonet “Formindsk decimal\" til at angive tallet med nul"]
[null,null,null,"decimaler."]
[]
[null,null,4,{"$f":"\"Indtast tallet 456789 i celle \"&mycell(E5)&\".\"","v":"Indtast tallet 456789 i celle E5."}]
[]
[null,null,5,{"$f":"\"Med celle \"&mycell(E5)&\" aktiveret, indsæt tusindadskiller og nul decimaler.\"","v":"Med celle E5 aktiveret, indsæt tusindadskiller og nul decimaler."}]
[null,null,null,"(Genvej: Ctrl+1, fanebladet Tal)"]
[]
[null,null,6,{"$f":"\"Indtast tallet 0,25 i celle \"&mycell(F5)&\".\"","v":"Indtast tallet 0,25 i celle F5."}]
[]
[null,null,7,{"$f":"\"Med celle \"&mycell(F5)&\" aktiveret, tryk på ikonet \"\"Procenttypografi. Tryk\"","v":"Med celle F5 aktiveret, tryk på ikonet \"Procenttypografi. Tryk"}]
[null,null,null,"på ikonet \"Forøg decimal et par gange og derefter på \"For-"]
[null,null,null,"mindsk decimal, også et par gange."]

{"sheet":"3","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Relative kontra absolutte cellereferencer"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":5}]
[null,null,{"$f":"ROW()","v":6},null,"Tal","Kvadrat",null,"Tal",0.1,0.2]
[null,null,{"$f":"ROW()","v":7},null,10,null,null,100]
[null,null,{"$f":"ROW()","v":8},null,20,null,null,200]
[null,null,{"$f":"ROW()","v":9},null,30,null,null,300]
[null,null,{"$f":"ROW()","v":10},null,40,null,null,400]
[]
[]
[null,null,1,{"$f":"\"Aktiver celle  \"&mycell(F7)&\" og lav en formel der udregner kvadratet af tallet i celle\"","v":"Aktiver celle  F7 og lav en formel der udregner kvadratet af tallet i celle"}]
[null,null,null,{"$f":"mycell(E7)&\". Formlen kan se sådan her ud:\"","v":"E7. Formlen kan se sådan her ud:"}]
[null,null,null,{"$f":"\"=\"&mycell(E7)&\"*\"&mycell(E7)&\" eller =\"&mycell(E7)&\"^2. Kopier formlen nedad til og med \"&mycell(F10)&\".\"","v":"=E7*E7 eller =E7^2. Kopier formlen nedad til og med F10."}]
[]
[null,null,2,{"$f":"\"Aktiver celle  \"&mycell(I7)&\" og lav en formel der udregner den procentdel der står i\"","v":"Aktiver celle  I7 og lav en formel der udregner den procentdel der står i"}]
[null,null,null,"cellen oven for af tallet i cellen til venstre (altså i kolonne H)."]
[null,null,null,{"$f":"\"Kopier formlen til området \"&mycell(I7)&\":\"&mycell(J10)&\".\"","v":"Kopier formlen til området I7:J10."}]
[]
[null,null,3,{"$f":"\"Aktiver for eksempel celle  \"&mycell(I9)&\" og tryk på F2. Prøv nu med musen at \"","v":"Aktiver for eksempel celle  I9 og tryk på F2. Prøv nu med musen at "}]
[null,null,null,"markere for eksempel den sidste del af formlen og tryk på F4. Læg"]
[null,null,null,"mærke til, hvordan formlen ændrer sig. Tryk på F4 flere gange."]

{"sheet":"4","index":4,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Multiplikationstabel"]
[null,null,{"$f":"\"Lav en 10 x 10 gangetabel i området \"&mycell(D8)&\":\"&mycell(M17)&\". Cellerne må\"","v":"Lav en 10 x 10 gangetabel i området D8:M17. Cellerne må"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Når du har lavet 10-tabellen korrekt, så "]
[null,null,"kun indeholde formler, ikke tal. Lav en formel der kan",null,null,null,null,null,null,null,null,null,null,null,null,null,"prøv følgende:"]
[null,null,"kopieres til hele tabellen."]
[]
[null,null,null,{"$f":"U8","v":1},{"$f":"D7+$U$9","v":2},3,4,5,6,7,8,9,10]
[{"$f":"$C8*D$7","v":1},null,{"$f":"U8","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"Startværdi",null,null,null,1]
[null,null,{"$f":"C8+$U$9","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,"Trinværdi",null,null,null,1]
[null,null,3]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prøv at lave gangetabellen ved brug af"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,"ovenstående \"Startværdi\" og \"Trinværdi\""]
[null,null,6]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hint:"]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Celle \"&mycell(D8)&\": \"&_xlfn.FORMULATEXT(A8)","v":"Celle D8: =$C8*D$7"}]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Celle \"&mycell(D7)&\": =\"&mycell(U8)","v":"Celle D7: =U8"}]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Celle \"&mycell(E7)&\": =\"&mycell(D7)&\" + \"&mycell(U9,4)","v":"Celle E7: =D7 + $U$9"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Kopier formlen i \"&mycell(E7)&\" til og med \"&mycell(M7)&\".\"","v":"Kopier formlen i E7 til og med M7."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Samme princip i området \"&mycell(C8)&\":\"&mycell(C17)&\".\"","v":"Samme princip i området C8:C17."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prøv at eksperimentere med forskellige "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"start- og trinværdier."]
[]
[]
[null,null,"Referencetyper"]
[]
[null,null,"•","Relativ: ",null,null,null,"A1",null,"Når en formel kopieres tilpasser cellereferencerne"]
[null,null,null,null,null,null,null,null,null,"sig til den nye adresse."]
[]
[null,null,"•","Absolut",null,null,null,"$A$1",null,"Når en formel kopieres ændres cellereferencerne "]
[null,null,null,null,null,null,null,null,null,"ikke."]
[]
[null,null,"•","Række absolut,",null,null,null,"A$1",null,"Når en formel kopieres ændres kolonnereferencen,"]
[null,null,null,"kolonne relativ",null,null,null,null,null,"mens rækkereferencen ikke ændres."]
[]
[null,null,"•","Kolonne absolut,",null,null,null,"$A1",null,"Når en formel kopieres ændres rækkereferencen,"]
[null,null,null,"række relativ",null,null,null,null,null,"mens kolonnereferencen ikke ændres."]

{"sheet":"5","index":5,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Operatorer"]
[null,null,null,null,"Symbol","Navn","Funktion"]
[]
[null,null,"Aritmetiske operatorer",null,"+","Plus ","Addition"]
[null,null,"(samt tekstoperatoren &)",null,"-","Minus ","Subtraktion"]
[null,null,null,null,"/","Skråstreg","Division"]
[null,null,null,null,"*","Stjerne","Multiplikation "]
[null,null,null,null,"%","Procent","Division med 100"]
[null,null,null,null,"^","Caret","Potensopløftning"]
[null,null,null,null,"&","OG-tegn ","Tekstsammenkædning"]
[]
[]
[null,null,"Logiske operatorer",null,"=","Lighedstegn","x lig med y"]
[null,null,null,null,">","Større end tegn","x større end y"]
[null,null,null,null,"<","Mindre end tegn","x mindre end y"]
[null,null,null,null,">=","Større end eller lig med tegn","x større end eller lig med y"]
[null,null,null,null,"<=","Mindre end eller lig med tegn","x mindre end eller lig med y"]
[null,null,null,null,"<>","Ulighedstegn","x forskellig fra y"]
[]
[]
[null,null,"Referenceoperatorer",null,":","Kolon","Skaber en reference til alle celler\nmellem to referencer, for eksem- \npel A1:H10."]
[null,null,null,null,";","Semikolon","Foreningsmængdeoperator der\nkombinerer mange reference til én reference."]
[null,null,null,null,"Tryk på\nmellemrums-\ntasten","Mellemrum","Fællesmængdeoperator, der skaber en reference til celler der er fælles for to referencer."]

{"sheet":"6","index":6,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Aritmetiske og logiske operatorer"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,{"$f":"ROW()","v":5},"Operator","Tal1","Tal2","Resultat"]
[null,null,{"$f":"ROW()","v":6},"+",5,1]
[null,null,{"$f":"ROW()","v":7},"-",6,9]
[null,null,{"$f":"ROW()","v":8},"*",9,3]
[null,null,{"$f":"ROW()","v":9},"/",8,2]
[null,null,{"$f":"ROW()","v":10},"^",5,3]
[null,null,{"$f":"ROW()","v":11},"=",5,7]
[null,null,{"$f":"ROW()","v":12},">",9,8]
[null,null,{"$f":"ROW()","v":13},"<",8,6]
[null,null,{"$f":"ROW()","v":14},"<>",7,5]
[]
[null,null,1,{"$f":"\"Lav formler i cellerne \"&mycell(G6)&\":\"&mycell(G14)&\" der gør brug af\"","v":"Lav formler i cellerne G6:G14 der gør brug af"}]
[null,null,null,"operatoren i kolonne D og tallene i kolonne"]
[null,null,null,"E og F. En forholdsvis nem måde at oprette"]
[null,null,null,"formlerne på er at starte med at indtaste: "]
[null,null,null,{"$f":"\"=\"&mycell(E6)&\"+\"&mycell(F6)&\" i celle \"&mycell(G6)&\". Herefter trækker du fyld-\"","v":"=E6+F6 i celle G6. Herefter trækker du fyld-"}]
[null,null,null,{"$f":"\"håndtaget nedad til og med \"&mycell(G14)&\" for at kopiere.\"","v":"håndtaget nedad til og med G14 for at kopiere."}]
[null,null,null,{"$f":"\"formlen. Aktiver nu celle \"&mycell(G7)&\" og ret operator-\"","v":"formlen. Aktiver nu celle G7 og ret operator-"}]
[null,null,null,{"$f":"\"tegnet til -. Ret på tilsvarende måde operator-\"","v":"tegnet til -. Ret på tilsvarende måde operator-"}]
[null,null,null,{"$f":"\"tegnene i celle \"&mycell(G8)&\":\"&mycell(G14)&\".\"","v":"tegnene i celle G8:G14."}]
[]
[null,null,2,{"$f":"\"Prøv at skrive A i celle \"&mycell(E12)&\" og B i celle \"&mycell(F12)&\". \"","v":"Prøv at skrive A i celle E12 og B i celle F12. "}]
[null,null,null,{"$f":"\"Prøv at ændre til C i celle \"&mycell(E12)&\".\"","v":"Prøv at ændre til C i celle E12."}]
[]
[null,null,3,{"$f":"\"Prøv at skrive a i celle \"&mycell(E14)&\" og A i celle \"&mycell(F14)&\". \"","v":"Prøv at skrive a i celle E14 og A i celle F14. "}]

{"sheet":"7","index":7,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Operatoren &"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"}]
[null,null,{"$f":"ROW()","v":5}]
[null,null,{"$f":"ROW()","v":6}]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8}]
[null,null,{"$f":"ROW()","v":9}]
[null,null,{"$f":"ROW()","v":10}]
[null,null,{"$f":"ROW()","v":11}]
[null,null,{"$f":"ROW()","v":12}]
[null,null,{"$f":"ROW()","v":13}]
[]
[null,null,1,{"$f":"\"Indtast dit fornavn i celle \"&mycell(D6)&\" og dit efternavn i celle \"&mycell(E6)&\". Aktiver celle \"&mycell(F6)&\" og lav en formel der ved hjælp\"","v":"Indtast dit fornavn i celle D6 og dit efternavn i celle E6. Aktiver celle F6 og lav en formel der ved hjælp"}]
[null,null,null,"af &-operatoren sammenkæder dit fornavn og efternavn (mellemrum mellem fornavn og efternavn)."]
[]
[null,null,2,{"$f":"\"Gentag (i række \"&ROW(8:8)&\") det, der nævnes under 1., men nu ved brug af funktionen SAMMENKÆDNING i stedet\"","v":"Gentag (i række 8) det, der nævnes under 1., men nu ved brug af funktionen SAMMENKÆDNING i stedet"}]
[null,null,null,"for &-operatoren (igen skal der være mellemrum mellem fornavn og efternavn)."]
[]
[null,null,3,{"$f":"\"I celle \"&mycell(D10)&\" indtaster du teksten: \"\"Årets overskud var\"\" (uden anførselstegn), og i celle \"&mycell(E10)&\" indtaster du et\"","v":"I celle D10 indtaster du teksten: \"Årets overskud var\" (uden anførselstegn), og i celle E10 indtaster du et"}]
[null,null,null,"syv-cifret tal."]
[null,null,null,{"$f":"\"I celle \"&mycell(F10)&\" skal du herefter lave en formel der, ved sammenkædning af \"&mycell(D10)&\" og \"&mycell(E10)&\" frembringer en tekst der\"","v":"I celle F10 skal du herefter lave en formel der, ved sammenkædning af D10 og E10 frembringer en tekst der"}]
[null,null,null,"ser sådan her ud: \"Årets overskud var x.xxx.xxx\", altså med tusindadskiller."]
[]
[null,null,4,{"$f":"\"I celle \"&mycell(D12)&\" indtaster du teksten: \"\"Jeg er født den\"\" (uden anførselstegn), og i celle \"&mycell(E12)&\" indtaster du din\"","v":"I celle D12 indtaster du teksten: \"Jeg er født den\" (uden anførselstegn), og i celle E12 indtaster du din"}]
[null,null,null,"fødselsdato."]
[null,null,null,{"$f":"\"I celle \"&mycell(F12)&\" skal du herefter lave en formel der, ved sammenkædning af \"&mycell(D12)&\" og \"&mycell(E12)&\" frembringer en tekst \"","v":"I celle F12 skal du herefter lave en formel der, ved sammenkædning af D12 og E12 frembringer en tekst "}]
[null,null,null,"der ser ud som for eksempel: \"Jeg er født den 17. august 1985\".   "]

{"sheet":"8","index":8,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Referenceoperatorer"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"}]
[null,null,{"$f":"ROW()","v":5},null,"Danmark","Norge","Sverige","Finland"]
[null,null,{"$f":"ROW()","v":6},"Produkt 1",67150,55303,71884,69278]
[null,null,{"$f":"ROW()","v":7},"Produkt 2",37736,81026,41876,36387]
[null,null,{"$f":"ROW()","v":8},"Produkt 3",56639,22178,22446,92904]
[null,null,{"$f":"ROW()","v":9},"Produkt 4",47179,62422,37504,36594]
[]
[null,null,1,{"$f":"\"Lav en formel i celle \"&mycell(D14)&\" der ved hjælp af SUM-funktionen og operatoren \"\";\"\"\"","v":"Lav en formel i celle D14 der ved hjælp af SUM-funktionen og operatoren \";\""}]
[null,null,null,{"$f":"\"(semikolon) finder summen af \"&mycell(E6)&\", \"&mycell(F7)&\", \"&mycell(G8)&\" og trækker \"&mycell(H9)&\" fra.\"","v":"(semikolon) finder summen af E6, F7, G8 og trækker H9 fra."}]
[]
[{"$f":"SUM(E6,F7,G8,-H9)","v":134028},null,null,null,null,"Sæt x for hjælp   "]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H14=\"x\",showformula(A14),\"\")","v":""}]
[]
[]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"}]
[null,null,{"$f":"ROW()","v":21},null,"Danmark","Norge","Sverige","Finland"]
[null,null,{"$f":"ROW()","v":22},"Produkt1",67150,55303,71884,69278]
[null,null,{"$f":"ROW()","v":23},"Produkt2",37736,81026,41876,36387]
[null,null,{"$f":"ROW()","v":24},"Produkt3",56639,22178,22446,92904]
[null,null,{"$f":"ROW()","v":25},"Produkt4",47179,62422,37504,36594]
[]
[null,null,2,{"$f":"\"Lav en formel i celle \"&mycell(D34)&\" der ved hjælp af operatoren \"\"Mellemrum\"\" finder\"","v":"Lav en formel i celle D34 der ved hjælp af operatoren \"Mellemrum\" finder"}]
[null,null,null,"summen af hvor meget der er solgt i Norge i alt."]
[null,null,null,{"$f":"\"Før du kan gøre det skal du markere \"&mycell(E22)&\":\"&mycell(H25)&\", herefter trykke på Formler (på\"","v":"Før du kan gøre det skal du markere E22:H25, herefter trykke på Formler (på"}]
[null,null,null,"båndet), derefter på Opret ud fra markering (båndet i afsnittet Definerede"]
[null,null,null,"navne), sæt flueben ved Øverste række og Venstre kolonne, tryk OK."]
[]
[]
[{"$f":"SUM(Norge)","v":{"$error":"#NAME?"}},"",{"$f":"ROW()","v":34},null,{"$f":"IFERROR(\"Prøv formlen: \"&showformula(A34),\"\")","v":""}]
[{"$f":"SUM(Produkt2)","v":{"$error":"#NAME?"}},"",{"$f":"ROW()","v":35},null,{"$f":"IFERROR(\"Prøv formlen: \"&showformula(A35),\"\")","v":""}]
[{"$f":"SUM(Produkt4 Finland)","v":{"$error":"#NAME?"}},"",{"$f":"ROW()","v":36},null,{"$f":"IFERROR(\"Prøv formlen: \"&showformula(A36),\"\")","v":""}]
[]
[]
[]
[]
[null,null,{"$f":"ROW()","v":41},"Norge","Vælg land"]
[null,null,{"$f":"ROW()","v":42},"Produkt4","Vælg produkt"]
[null,null,{"$f":"ROW()","v":43},{"$f":"IFERROR(SUM(INDIRECT(D41) INDIRECT(D42)),\"\")","v":""},{"$f":"IF(D43=\"\",\"\",Resultat)","v":""}]

{"sheet":"9","index":9,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Parenteser"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},null,"Operator forrang"]
[null,null,{"$f":"ROW()","v":5},"= 1 + 2/3",null,null,null,"Hvis du kombinerer flere operatorer i én formel, "]
[null,null,{"$f":"ROW()","v":6},"= (1 + 2)/3",null,null,null,"udføres handlingerne i den rækkefølge, de vises i, "]
[null,null,{"$f":"ROW()","v":7},"= (3 – 2) – 1",null,null,null,"i følgende tabel. Hvis en formel indeholder flere"]
[null,null,{"$f":"ROW()","v":8},"= 3 – (2 – 1)",null,null,null,"operatorer, for eksempel både en multiplikations- "]
[null,null,{"$f":"ROW()","v":9},"= 5^2",null,null,null,"og en divisionsoperator, læses operatorerne auto-"]
[null,null,{"$f":"ROW()","v":10},"= -5^2",null,null,null,"matisk fra venstre mod højre."]
[null,null,{"$f":"ROW()","v":11},"= -(5^2)"]
[null,null,{"$f":"ROW()","v":12},"= -5*2^2",null,null,null,"Operator","Beskrivelse"]
[null,null,null,null,null,null,null,": (kolon)","Referenceoperatorer"]
[null,null,1,{"$f":"\"Prøv i cellerne \"&mycell(E5)&\":\"&mycell(E12)&\" at skrive (som tekst) det,\"","v":"Prøv i cellerne E5:E12 at skrive (som tekst) det,"},null,null,null,"  (mellemrum)"]
[null,null,null,"du mener skal være resultatet af regnestykket",null,null,null,", (komma)"]
[null,null,null,"i cellen umiddelbart til venstre.",null,null,null,"-","Negation "]
[null,null,null,null,null,null,null,"%","Procent"]
[null,null,2,{"$f":"\"Prøv herefter i cellerne \"&mycell(F5)&\":\"&mycell(F12)&\" at oprette\"","v":"Prøv herefter i cellerne F5:F12 at oprette"},null,null,null,"^","Potensopløftning"]
[null,null,null,"formler svarende til dem der (som tekst) er",null,null,null,"* og /","Multiplikation og division"]
[null,null,null,{"$f":"\"vist i cellerne \"&mycell(D5)&\":\"&mycell(D11)&\".\"","v":"vist i cellerne D5:D11."},null,null,null,"+ og -","Addition og subtraktion"]
[null,null,null,null,null,null,null,"&","Forbinder to tekststrenge"]
[null,null,null,null,null,null,null,"= < > <= >= <>","Sammenligningsoperatorer"]

{"sheet":"10","index":10,"n_rows":103,"n_cols":8,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Et par øvelser med parenteser"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"}]
[]
[null,null,{"$f":"ROW()","v":6},null,{"$f":"\"Tænk på et helt tal og indtast tallet i celle \"&SUBSTITUTE(CELL(\"address\",D6),\"$\",\"\")&\". Aktiver nu\"","v":"Tænk på et helt tal og indtast tallet i celle D6. Aktiver nu"}]
[null,null,null,null,{"$f":"\"celle \"&mycell(D11)&\" og indtast en formel der tager udgangspunkt i\"","v":"celle D11 og indtast en formel der tager udgangspunkt i"}]
[null,null,null,{"$f":"IF(D6=36,\"JJJ\",\"\")","v":""},{"$f":"\"tallet i celle \"&SUBSTITUTE(CELL(\"address\",D6),\"$\",\"\")&\". Herefter udvides formlen i overensstem-\"","v":"tallet i celle D6. Herefter udvides formlen i overensstem-"}]
[null,null,null,null,"melse med instruktionerne herunder: "]
[]
[null,null,{"$f":"ROW()","v":11},null,{"$f":"\"•    læg 20 til det tal du indtastede i celle \"&mycell(D6)&\" oven for.\"","v":"•    læg 20 til det tal du indtastede i celle D6 oven for."}]
[null,null,null,null,"•    multiplicer resultatet med fire"]
[null,null,null,null,"•    træk otte fra resultatet"]
[null,null,null,null,"•    divider resultatet med to"]
[null,null,null,null,{"$f":"\"•    fratræk to gange det tal du indtastede i celle \"&mycell(D6)&\".\"","v":"•    fratræk to gange det tal du indtastede i celle D6."}]
[]
[null,null,"Læs kommentaren til den celle, hvor der er en lille rød trekant i højre hjørne."]
[]
[null,null,"Sæt x hvis du ønsker hjælp",null,null,null,null,{"$f":"((D6+20)*4-8)/2-2*D6","v":36}]
[]
[]
[]
[]
[null,null,"Hvis du føler dig fortrolig med at sætte parenteser korrekt, så prøv at \"scrolle\" ned til "]
[null,null,{"$f":"\"række \"&ROW(50:50)&\" og løs den opgave, du finder der.\"","v":"række 50 og løs den opgave, du finder der."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"Lav en formel i celle \"&mycell(H53)&\" der korrekt udregner udtrykket herunder:\"","v":"Lav en formel i celle H53 der korrekt udregner udtrykket herunder:"}]
[]
[null,null,null,null,null,null,null,"Fn"]
[null,null,null,null,null,null,1]
[]
[]
[]
[]
[null,null,"Hvis du er interesseret i matematik vil du vide, at de tal der genereres af denne formel"]
[null,null,"kaldes en Fibonacci sequence. De blev første gang omtalt af Leonardo af Pisa, eller "]
[null,null,"Fibonacci som han blev kaldt, i 1202, hvor de fremkommer som en elegant løsning på "]
[null,null,"et problem, om hvordan antallet af kaniner i en bestand – under nogle givne"]
[null,null,"forudsætninger – vokser."]
[]
[null,null,{"$f":"\"I celle \"&mycell(G53)&\" (den gule) kan du skiftevis indtaste tallene 1, 2, 3, ….. , 15. Hvis du får\"","v":"I celle G53 (den gule) kan du skiftevis indtaste tallene 1, 2, 3, ….. , 15. Hvis du får"}]
[null,null,"følgende resultater er din formel korrekt:"]
[null,null,"1 , 1 , 2 , 3 , 5 , 8 , 13 , 21, 34 , 55 , 89 , 144 , 233 , 377 , 610"]
[]
[null,null,"Hvis du umiddelbart får korrekt resultat har du en god forståelse af at sætte parenteser"]
[null,null,"korrekt."]
[]
[null,null,{"$f":"\"Ønsker du hjælp, kan du \"\"scrolle\"\" ned til række \"&ROW(100:100)&\".\"","v":"Ønsker du hjælp, kan du \"scrolle\" ned til række 100."}]
[]
[]
[null,null,"En anden måde at generere disse tal på er at indtaste 0 og 1 som her",null,null,null,null,0]
[null,null,null,null,null,null,null,1]
[null,null,{"$f":"\"og herefter i celle \"&mycell(H76)&\" at indtaste formlen \"&_xlfn.FORMULATEXT(H76)","v":"og herefter i celle H76 at indtaste formlen =H74+H75"},null,null,null,null,{"$f":"H74+H75","v":1}]
[null,null,"og så kopiere denne formel nedad.",null,null,null,null,{"$f":"H75+H76","v":2}]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"(1/SQRT(5)) *(((1+SQRT(5))/2)^G53 - ((1-SQRT(5))/2)^G53)","v":1},{"$f":"_xlfn.FORMULATEXT(C100)","v":"=(1/SQRT(5)) *(((1+SQRT(5))/2)^G53 - ((1-SQRT(5))/2)^G53)"}]
[]
[]
[null,null,{"$f":"(1/5^(1/2)) * (((1+5^(1/2))/2)^G53 - ((1-5^(1/2))/2)^G53)","v":1},{"$f":"_xlfn.FORMULATEXT(C103)","v":"=(1/5^(1/2)) * (((1+5^(1/2))/2)^G53 - ((1-5^(1/2))/2)^G53)"}]

{"sheet":"11","index":11,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Undgå faste tal i en formel"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I"]
[null,null,{"$f":"ROW()","v":5}]
[null,null,{"$f":"ROW()","v":6},"Hvis du for eksempel laver en månedlig omkostningsopfølgningsrapport og denne rapport "]
[null,null,{"$f":"ROW()","v":7},"altid skal indeholde en overskrift, hvoraf den aktuelle måned fremgår, så kan du selv-"]
[null,null,{"$f":"ROW()","v":8},"følgelig lave noget i stil med følgende:"]
[null,null,{"$f":"ROW()","v":9}]
[null,null,{"$f":"ROW()","v":10},null,"Omkostningsopfølgning pr. 31-03-2011"]
[null,null,{"$f":"ROW()","v":11}]
[null,null,{"$f":"ROW()","v":12},"altså som en ren tekststreng. Langt bedre er det dog at indtaste den relevante dato i en"]
[null,null,{"$f":"ROW()","v":13},{"$f":"\"separat celle, for eksempel i \"&mycell(E15)&\" og så bruge en formel som vist i \"&mycell(E17)&\".\"","v":"separat celle, for eksempel i E15 og så bruge en formel som vist i E17."}]
[null,null,{"$f":"ROW()","v":14}]
[null,null,{"$f":"ROW()","v":15},null,"2011-03-31"]
[null,null,{"$f":"ROW()","v":16}]
[null,null,{"$f":"ROW()","v":17},null,{"$f":"\"Omkostningsopfølgning pr.  \"&TEXT(E15,\"dd-mm-åååå\")","v":"Omkostningsopfølgning pr.  31-03-2011"}]
[null,null,{"$f":"ROW()","v":18}]
[null,null,{"$f":"ROW()","v":19},"Når du skal lave rapporten for den næste måned vil du indse fordelen ved at bruge "]
[null,null,{"$f":"ROW()","v":20},{"$f":"\"formlen i celle \"&mycell(E17)&\" frem for tekststrengen i celle \"&mycell(E10)&\".\"","v":"formlen i celle E17 frem for tekststrengen i celle E10."}]
[null,null,{"$f":"ROW()","v":21}]
[null,null,{"$f":"ROW()","v":22},null,"Forsøg altid at undgå konstanter i formler!"]

{"sheet":"12","index":12,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Simple formler - 1"]
[]
[null,null,"Prøv i de grå celler nedenfor at opstille en formel der udregner spørgsmålet til venstre."]
[]
[null,null,1,"Hvad er is 16 gange 8",null,null,{"$f":"16*8","v":128},{"$f":"showformula(G6)","v":"=16*8"}]
[null,null,2,"Hvad er 84 divideret med 7",null,null,{"$f":"84/7","v":12},{"$f":"showformula(G7)","v":"=84/7"}]
[null,null,3,"Hvad er 220 DKK omregnet til USD,\nhvis kursen er 5,50",null,null,{"$f":"220/5.5","v":40},{"$f":"showformula(G8)","v":"=220/5,5"}]
[null,null,4,"Hvad er 25 opløftet til en halv",null,null,{"$f":"25^(1/2)","v":5},{"$f":"showformula(G9)","v":"=25^(1/2)"}]
[null,null,5,"Hvad er 25% af 100",null,null,{"$f":"25%*100","v":25},{"$f":"showformula(G10)","v":"=25%*100"}]
[null,null,6,"Hvad er 20% af 125",null,null,{"$f":"20%*125","v":25},{"$f":"showformula(G11)","v":"=20%*125"}]
[null,null,7,"Hvad er summen af 17, 19 og 28,\ndivideret med 8, ganget med 9",null,null,{"$f":"SUM(17,19,28)/8*9","v":72},{"$f":"showformula(G12)","v":"=SUM(17;19;28)/8*9"}]
[null,null,8,"Købspris 110, salgspris 250,- hvor\nmeget er 10% af bruttofortjnesten",null,null,{"$f":"(250-110)*0.1","v":14},{"$f":"showformula(G13)","v":"=(250-110)*0,1"}]
[null,null,9,"Hvad er summen af SAND og FALSK",null,null,{"$f":"TRUE+FALSE","v":1},{"$f":"showformula(G14)","v":"=TRUE+FALSE"}]
[null,null,"10.","Hvad er summen af SAND og SAND",null,null,{"$f":"TRUE+TRUE","v":2},{"$f":"showformula(G15)","v":"=TRUE+TRUE"}]
[null,null,"11.",{"$f":"\"Hvad er summen af tallene i\n området \"&mycell(E6)&\" til \"&mycell(E15)","v":"Hvad er summen af tallene i\n området E6 til E15"},null,null,{"$f":"SUM(G6:G15)","v":324},{"$f":"showformula(G16)","v":"=SUM(G6:G15)"}]
[]
[]
[null,null,"Hvis du du ønsker hjælp til ovenstående (og du ikke har"]
[null,null,{"$f":"\"ændret noget i området \"&mycell(D6)&\":\"&mycell(D16)&\"), så sæt et x her.\"","v":"ændret noget i området D6:D16), så sæt et x her."}]

{"sheet":"13","index":13,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3]]}
[]
[null,null,"Procentregning - 1"]
[]
[null,null,"Færdiggør tabellen herunder."]
[]
[null,null,"Gammel pris",null,120,385,null,750,null,null,455]
[null,null,"Prisnedsættelse",null,null,30,null,null,45,50]
[null,null,"I %",null,0.45,null,0.18,0.12,0.1]
[null,null,"Ny pris",null,null,null,875,null,null,925,420]
[]
[]
[null,null,"Hvis du ønsker hjælp - sæt x her."]
[]
[]
[null,null,"Gammel pris",null,120,385,1067,750,{"$f":"45/0.1","v":450},975,455]
[null,null,"Prisnedsættelse",null,{"$f":"E15-E18","v":54},30,{"$f":"G15-G18","v":192},{"$f":"H15*12%","v":90},45,50,{"$f":"K15-K18","v":35}]
[null,null,"I %",null,0.45,{"$f":"F16/F15","v":7.792207792207792E-2},0.18,0.12,0.1,{"$f":"J16/J15","v":5.128205128205128E-2},{"$f":"K16/K15","v":7.6923076923076927E-2}]
[null,null,"Ny pris",null,{"$f":"120*(1-45%)","v":66},{"$f":"F15-F16","v":355},875,{"$f":"H15-H16","v":660},{"$f":"I15-I16","v":405},925,420]
[]
[null,null,"Med følgende symboler:"]
[]
[null,null,null,"N = Ny pris"]
[null,null,null,"G = Gammel pris"]
[null,null,null,"dp = Prisnedsættelse "]
[null,null,null,"(dp/G)*100 = Prisnedsættelse i procent"]
[]
[null,null,"Kan du bruge følgende formel:  N = G - dp"]
[]
[null,null,"I det første tilfælde altså:  N = 120 - dp, idet vi har fået opgivet at dp/G = 45%, dvs. at dp = 45%*G."]
[null,null,"Dermed har vi, at N = 120- dp medfører at N =120 - 45%*120 = 120 - 54 = 66."]

{"sheet":"14","index":14,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,5,9,6]]}
[]
[null,null,"Procentregning - 2"]
[]
[null,null,"Færdiggør nedenstående oversigt."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},"F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8},null,"Salg af fødevarer"]
[null,null,{"$f":"ROW()","v":9}]
[null,null,{"$f":"ROW()","v":10},null,null,"Salg",null,"Diffe-","Diffe-","Andel af",null,null,{"$f":"F10","v":"Salg"},null,{"$f":"H10","v":"Diffe-"},"Diffe-","Andel af"]
[null,null,{"$f":"ROW()","v":11},null,"Butik","Faktisk","Budget","rence","rence i %","saml. salg",null,{"$f":"E11","v":"Butik"},{"$f":"F11","v":"Faktisk"},{"$f":"G11","v":"Budget"},"rence","rence i %","saml. salg"]
[null,null,{"$f":"ROW()","v":12},null,"Bilka",880,800,null,null,null,null,{"$f":"E12","v":"Bilka"},{"$f":"F12","v":880},{"$f":"G12","v":800},{"$f":"M12-N12","v":80},{"$f":"O12/N12","v":0.1},{"$f":"M12/$M$19","v":0.31814895155459144}]
[null,null,{"$f":"ROW()","v":13},null,"Brugsen",589,500,null,null,null,null,{"$f":"E13","v":"Brugsen"},{"$f":"F13","v":589},{"$f":"G13","v":500},{"$f":"M13-N13","v":89},{"$f":"O13/N13","v":0.17799999999999999},{"$f":"M13/$M$19","v":0.21294287780187998}]
[null,null,{"$f":"ROW()","v":14},null,"Aldi",182,210,null,null,null,null,"Aldi",182,210,-28,-0.13333333333333333,6.5798987707881423E-2]
[null,null,{"$f":"ROW()","v":15},null,"Netto",203,185,null,null,null,null,"Netto",203,185,18,9.7297297297297303E-2,7.3391178597252346E-2]
[null,null,{"$f":"ROW()","v":16},null,"Kvickly",243,280,null,null,null,null,"Kvickly",243,280,-37,-0.13214285714285715,8.7852494577006501E-2]
[null,null,{"$f":"ROW()","v":17},null,"Favør",254,300,null,null,null,null,"Favør",254,300,-46,-0.15333333333333332,9.1829356471438903E-2]
[null,null,{"$f":"ROW()","v":18},null,"Irma",415,350,null,null,null,null,"Irma",415,350,65,0.18571428571428572,0.15003615328994938]
[null,null,{"$f":"ROW()","v":19},null,"I alt",null,null,null,null,null,null,"I alt",{"$f":"SUM(M12:M18)","v":2766},{"$f":"SUM(N12:N18)","v":2625},{"$f":"SUM(O12:O18)","v":141},5.3714285714285714E-2,1]
[null,null,{"$f":"ROW()","v":20}]
[null,null,{"$f":"ROW()","v":21}]
[null,null,{"$f":"ROW()","v":22},null,"Hvis du ønsker hjælp - sæt x her."]

{"sheet":"15","index":15,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Procentregning - 3",null,"Forældet"]
[]
[null,null,"Udregn procent af total og procentvis ændring. Indsæt relevante formler i de grå celler."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8},null,null,"Valg 2007",null,null,"Valg 2005"]
[null,null,{"$f":"ROW()","v":9},"Parti","Liste","Afgivne\nstemmer","% af stemmer","% ændring\ni f.t. 2005","Afgivne\nstemmer","% af stemmer"]
[null,null,{"$f":"ROW()","v":10}]
[null,null,{"$f":"ROW()","v":11},"Socialdemokratiet","A",881037,null,null,867349,null,1,"Indsæt relevante formler i de blågrå celler."]
[null,null,{"$f":"ROW()","v":12},"Det Radikale Venstre","B",177161,null,null,308212,null,2,"Formater celler med procentudregninger som procent med én decimal."]
[null,null,{"$f":"ROW()","v":13},"Konservative Folkeparti","C",359404,null,null,344886,null,3,"Fremstil et cirkeldiagram der viser de enkelte partiers procentdel af afgivne antal "]
[null,null,{"$f":"ROW()","v":14},"Centrum Demokraterne","D",0,null,null,33880,null,null,"stemmer."]
[null,null,{"$f":"ROW()","v":15},"Socialistisk Folkeparti","F",450975,null,null,201047]
[null,null,{"$f":"ROW()","v":16},"Dansk Folkeparti","O",479532,null,null,444947]
[null,null,{"$f":"ROW()","v":17},"Kristendemokraterne","K",30013,null,null,58071]
[null,null,{"$f":"ROW()","v":18},"Venstre","V",908472,null,null,974636,null,null,"Hvis du ønsker hjælp til denne opgave, så gør følgende:"]
[null,null,{"$f":"ROW()","v":19},"Enhedslisten","Ø",74982,null,null,114123]
[null,null,{"$f":"ROW()","v":20},"Ny Alliance","Y",97295,null,null,0,null,null,"Tryk på Formater (på båndet), herefter på Skjul og vis og til sidst,"]
[null,null,{"$f":"ROW()","v":21},"Minoritetspartiet","M",0,null,null,8850,null,null,"Vis ark. Markér 15.1 og tryk på OK."]
[null,null,{"$f":"ROW()","v":22},"Uden for partierne ",null,549,null,null,1211]
[null,null,{"$f":"ROW()","v":23},"Blanke stemmer",null,15738,null,null,19478]
[null,null,{"$f":"ROW()","v":24},"Andre ugyldige stemmer",null,8375,null,null,7870]
[null,null,{"$f":"ROW()","v":25},null,null,null,null,null,null,null,null,"Hvis du har lyst, kan du prøve at gå på Internettet og finde de afgivne"]
[null,null,{"$f":"ROW()","v":26},"Stemmeberettigede",null,4022849,null,null,4003616,null,null,"stemmer mv. ved det nyligt afholdte folketingsvalg. Flyt 2007-tallene "]
[null,null,{"$f":"ROW()","v":27},"Afgivne stemmer",null,null,null,null,{"$f":"SUM(I11:I24)","v":3384560},null,null,"til kolonne I og indsæt 2011-tallene i kolonne F. Husk at tilrette "]
[null,null,{"$f":"ROW()","v":28},null,null,null,null,null,null,null,null,"overskrifterne med årstal."]
[null,null,{"$f":"ROW()","v":29},"Valgdeltagelse"]

{"sheet":"15.1","index":16,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Procentregning - 3"]
[]
[null,null,"Udregn procent af total og procentvis ændring. Indsæt relevante formler i de grå celler."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8},null,null,"Valg 2007",null,null,"Valg 2005"]
[null,null,{"$f":"ROW()","v":9},"Parti","Liste","Afgivne\nstemmer","% af stemmer","% ændring\ni f.t. 2005","Afgivne\nstemmer","% af stemmer"]
[null,null,{"$f":"ROW()","v":10}]
[null,null,{"$f":"ROW()","v":11},"Socialdemokratiet","A",881037,{"$f":"F11/$F$27","v":0.25291478507595594},{"$f":"IFERROR((F11-I11)/I11,\"\")","v":1.5781421319445807E-2},867349,{"$f":"I11/$F$27","v":0.24898544093022801}]
[null,null,{"$f":"ROW()","v":12},"Det Radikale Venstre","B",177161,{"$f":"F12/$F$27","v":5.0856702089516592E-2},{"$f":"IFERROR((F12-I12)/I12,\"\")","v":-0.42519759126834777},308212,{"$f":"I12/$F$27","v":8.8476842332195507E-2}]
[null,null,{"$f":"ROW()","v":13},"Konservative Folkeparti","C",359404,0.10317226792454672,4.2095069095295257E-2,344886,9.9004659924278024E-2]
[null,null,{"$f":"ROW()","v":14},"Centrum Demokraterne","D",0,0,-1,33880,9.7257583034235651E-3]
[null,null,{"$f":"ROW()","v":15},"Socialistisk Folkeparti","F",450975,0.12945908650786428,1.2431322029177256,201047,5.77135339323612E-2]
[null,null,{"$f":"ROW()","v":16},"Dansk Folkeparti","O",479532,0.13765679842849199,7.7728358658446961E-2,444947,0.12772865938115127]
[null,null,{"$f":"ROW()","v":17},"Kristendemokraterne","K",30013,8.6156783931715299E-3,-0.48316715744519639,58071,1.6670144936189783E-2]
[null,null,{"$f":"ROW()","v":18},"Venstre","V",908472,0.2607904101956261,-6.7885856873745681E-2,974636,0.27978377124603099]
[null,null,{"$f":"ROW()","v":19},"Enhedslisten","Ø",74982,2.1524699206236887E-2,-0.34297205646539258,114123,3.2760705869586994E-2]
[null,null,{"$f":"ROW()","v":20},"Ny Alliance","Y",97295,2.792997798499397E-2,"",0,0]
[null,null,{"$f":"ROW()","v":21},"Minoritetspartiet","M",0,0,-1,8850,2.5405242321516691E-3]
[null,null,{"$f":"ROW()","v":22},"Uden for partierne ",null,549,1.5759862185890015E-4,-0.54665565648224612,1211,3.4763557572154477E-4]
[null,null,{"$f":"ROW()","v":23},"Blanke stemmer",null,15738,4.5178271599551371E-3,-0.19201150015401991,19478,5.5914498298135825E-3]
[null,null,{"$f":"ROW()","v":24},"Andre ugyldige stemmer",null,8375,2.4041684117819466E-3,6.4167725540025408E-2,7870,2.2592006448625577E-3]
[null,null,{"$f":"ROW()","v":25}]
[null,null,{"$f":"ROW()","v":26},"Stemmeberettigede",null,4022849,null,null,4003616]
[null,null,{"$f":"ROW()","v":27},"Afgivne stemmer",null,{"$f":"SUM(F11:F24)","v":3483533},{"$f":"F27/$F$27","v":1},null,{"$f":"SUM(I11:I24)","v":3384560},{"$f":"I27/$F$27","v":0.9715883271379947}]
[null,null,{"$f":"ROW()","v":28}]
[null,null,{"$f":"ROW()","v":29},"Valgdeltagelse",null,{"$f":"F27/F26","v":0.86593680249991978},null,null,{"$f":"I27/I26","v":0.84537578029461369}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":38}]
[null,null,{"$f":"ROW()","v":39},null,null,"Valg 2007",null,null,"Valg 2005"]
[null,null,{"$f":"ROW()","v":40},"Parti","Liste","Afgivne\nstemmer","% af stemmer",null,"Afgivne\nstemmer","% af stemmer"]
[null,null,{"$f":"ROW()","v":41}]
[null,null,{"$f":"ROW()","v":42},"Socialdemokratiet","A",881037,{"$f":"F42/$F$51","v":0.2569476484590496},null,867349,{"$f":"I42/$F$27","v":0.24898544093022801}]
[null,null,{"$f":"ROW()","v":43},"Det Radikale Venstre","B",177161,{"$f":"F43/$F$51","v":5.1667639779775072E-2},null,308212,{"$f":"I43/$F$27","v":8.8476842332195507E-2}]
[null,null,{"$f":"ROW()","v":44},"Konservative Folkeparti","C",359404,0.10481740567850871,null,344886,9.9004659924278024E-2]
[null,null,{"$f":"ROW()","v":45},"Socialistisk Folkeparti","F",450975,0.13152338183733475,null,201047,5.77135339323612E-2]
[null,null,{"$f":"ROW()","v":46},"Dansk Folkeparti","O",479532,0.13985181071948735,null,444947,0.12772865938115127]
[null,null,{"$f":"ROW()","v":47},"Venstre","V",908472,0.26494885469156204,null,974636,0.27978377124603099]
[null,null,{"$f":"ROW()","v":48},"Enhedslisten","Ø",74982,2.1867922206168934E-2,null,114123,3.2760705869586994E-2]
[null,null,{"$f":"ROW()","v":49},"Ny Alliance","Y",97295,2.83753366281135E-2,null,0,0]
[null,null,{"$f":"ROW()","v":50}]
[null,null,{"$f":"ROW()","v":51},"Afgivne stemmer",null,{"$f":"SUM(F42:F49)","v":3428858},{"$f":"SUM(G42:G49)","v":1},null,{"$f":"SUM(I42:I49)","v":3255200},{"$f":"SUM(J42:J49)","v":0.93445361361583201}]

{"sheet":"16","index":17,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[17,2,17,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[29,2,29,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3]]}
[]
[null,null,"Salg af bluser og bukser"]
[]
[null,null,1,"Beregn salg af bluser pr. dag i kolonne G..  "]
[null,null,2,"Beregn salg af bukser pr. dag i kolonne J."]
[null,null,3,"Beregner salg i alt pr. dag (= salg af bluser + salg af bukser) i kolonne K."]
[null,null,4,"Lav totaler der viser solgt antal og salg for alle dagene."]
[]
[null,null,"Alle salgsbeløb formateres med nul decimaler og tusindadskiller. Sørg for at over-"]
[null,null,"skrifterne \"Bluser\" og \"Bukser\" er centreret over de tre relevante kolonner uden"]
[null,null,"at du gør brug af \"Flet og centrer\"."]
[]
[null,null,null,null,"Bluser",null,null,"Bukser"]
[null,null,"Dato",null,"Solgt\nantal ","Salgspris\npr. stk.",null,"Solgt\nantal ","Salgspris\npr. stk."]
[null,null,{"$f":"TODAY()-14","v":"2023-04-14"},null,16,300,null,10,500]
[null,null,{"$f":"C15+1","v":"2023-04-15"},null,12,300,null,10,500]
[null,null,{"$f":"C16+1","v":"2023-04-16"},null,12,300,null,11,500]
[null,null,{"$f":"C17+1","v":"2023-04-17"},null,15,300,null,15,500]
[]
[]
[null,null,"Hvis du ønsker hjælp - sæt x her."]
[]
[]
[null,null,null,null,"Bluser",null,null,"Bukser",null,null,"I alt"]
[null,null,"Dato",null,"Solgt \nantal  ","Salgspris\npr. stk.","Bluser\ni kroner","Solgt\nantal ","Salgspris\npr. stk.","Bukser\ni kroner","Salg\ni kroner"]
[null,null,{"$f":"TODAY()-14","v":"2023-04-14"},null,16,300,{"$f":"E26*F26","v":4800},10,500,{"$f":"H26*I26","v":5000},{"$f":"G26+J26","v":9800}]
[null,null,{"$f":"C26+1","v":"2023-04-15"},null,12,300,{"$f":"E27*F27","v":3600},10,500,{"$f":"H27*I27","v":5000},{"$f":"G27+J27","v":8600}]
[null,null,{"$f":"C27+1","v":"2023-04-16"},null,12,300,{"$f":"E28*F28","v":3600},11,500,{"$f":"H28*I28","v":5500},{"$f":"G28+J28","v":9100}]
[null,null,{"$f":"C28+1","v":"2023-04-17"},null,15,300,{"$f":"E29*F29","v":4500},15,500,{"$f":"H29*I29","v":7500},{"$f":"G29+J29","v":12000}]
[null,null,"I alt",null,{"$f":"SUM(E26:E29)","v":55},300,{"$f":"SUM(G26:G29)","v":16500},{"$f":"SUM(H26:H29)","v":46},500,{"$f":"SUM(J26:J29)","v":23000},{"$f":"G30+J30","v":39500}]

{"sheet":"17","index":18,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Budget på månedsbasis"]
[]
[null,null,1,"Opstil et budget for månederne januar til december under hensyntagen til nedenstående",null,null,null,null,null,null,null,null,"Varesalg",230000]
[null,null,null,{"$f":"\"forudsætninger samt den forudsætning, at Faste omkostninger udgør kr. \"&TEXT(N6,\"#.##0\")&\" pr.\"","v":"forudsætninger samt den forudsætning, at Faste omkostninger udgør kr. 9.500 pr."},null,null,null,null,null,null,null,null,"VO",0.45]
[null,null,null,{"$f":"\"måned med undtagelse af december, hvor de udgør \"&TEXT(N7,\"#.##0\")&\" kr.\"","v":"måned med undtagelse af december, hvor de udgør 12.000 kr."},null,null,null,null,null,null,null,null,"FO",9500]
[null,null,null,null,null,null,null,null,null,null,null,null,"FO, Dec",12000]
[null,null,2,"Udregn manglende årstotaler."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},"I","J","K","L","M","N","O","P","Q"]
[null,null,{"$f":"ROW()","v":11},null,"Året i alt","Jan","Feb","Mar","Apr","Maj","Jun","Jul","Aug","Sep","Okt","Nov","Dec"]
[null,null,{"$f":"ROW()","v":12},"Salgsfordeling",null,0.02,0.03,0.05,0.1,0.11,0.12,0.13,0.14000000000000001,0.15,0.05,0.05,0.05]
[null,null,{"$f":"ROW()","v":13},"Varesalg",230000]
[null,null,{"$f":"ROW()","v":14},"Variable omk. i % af salg",0.45]
[null,null,{"$f":"ROW()","v":15},"Variable omkostninger"]
[null,null,{"$f":"ROW()","v":16},"Dækningsbidrag"]
[null,null,{"$f":"ROW()","v":17},"Faste omkostninger"]
[null,null,{"$f":"ROW()","v":18},"Result før skat"]
[]
[null,null,"Hvis du ønsker hjælp - sæt x her."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},"I","J","K","L","M","N","O","P","Q"]
[null,null,{"$f":"ROW()","v":23},null,"Året i alt","Jan","Feb","Mar","Apr","Maj","Jun","Jul","Aug","Sep","Okt","Nov","Dec"]
[null,null,{"$f":"ROW()","v":24},"Salgsfordeling",null,0.02,0.03,0.05,0.1,0.11,0.12,0.13,0.14000000000000001,0.15,0.05,0.05,0.05]
[null,null,{"$f":"ROW()","v":25},"Varesalg",{"$f":"SUM(F25:Q25)","v":230000},{"$f":"$N$4*F24","v":4600},{"$f":"$N$4*G24","v":6900},11500,23000,25300,27600,29900,32200.000000000004,34500,11500,11500,11500]
[null,null,{"$f":"ROW()","v":26},"Variable omk. i % af salg",null,{"$f":"N5","v":0.45},{"$f":"F26","v":0.45},0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45]
[null,null,{"$f":"ROW()","v":27},"Variable omkostninger",{"$f":"SUM(F27:Q27)","v":103500},{"$f":"F25*F26","v":2070},{"$f":"G25*G26","v":3105},5175,10350,11385,12420,13455,14490.000000000002,15525,5175,5175,5175]
[null,null,{"$f":"ROW()","v":28},"Dækningsbidrag",{"$f":"SUM(F28:Q28)","v":126500},{"$f":"F25-F27","v":2530},{"$f":"G25-G27","v":3795},6325,12650,13915,15180,16445,17710,18975,6325,6325,6325]
[null,null,{"$f":"ROW()","v":29},"Faste omkostninger",{"$f":"SUM(F29:Q29)","v":116500},{"$f":"$N$6","v":9500},9500,9500,9500,9500,9500,9500,9500,9500,9500,9500,{"$f":"N7","v":12000}]
[null,null,{"$f":"ROW()","v":30},"Result før skat",{"$f":"SUM(F30:Q30)","v":10000},{"$f":"F28-F29","v":-6970},{"$f":"G28-G29","v":-5705},-3175,3150,4415,5680,6945,8210,9475,-3175,-3175,-5675]

{"sheet":"18","index":19,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Sofies budget",null,"Forældet"]
[]
[null,null,"Sofie Hansen er netop flyttet ind i en ny ungdomsbolig, og hun skal selv betale for sin uddannelse.",null,null,null,null,null,null,null,null,null,"Sæt x her hvis du"]
[null,null,"Hun har allerede fået tilsagn om at kunne få S.U., men hun har også erkendt, at det er nødvendigt at",null,null,null,null,null,null,null,null,null,"ønsker hjælp."]
[null,null,"arbejde ved siden af, hvis hun skal få råd til alt det, hun gerne vil. Derfor har hun fået et fritidsjob i det"]
[null,null,"lokale supermarked. Her kan hun arbejde lige så mange timer, som hun ønsker. Sofie regner med, "]
[null,null,"at hun vil have følgende indbetalinger og udbetalinger:"]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"L"},"M","N","O","P","Q"]
[null,null,{"$f":"ROW()","v":11},"Sofies budget",null,null,null,null,null,null,null,"Sofies budget"]
[null,null,{"$f":"ROW()","v":12},"Indbetalinger:",null,null,null,null,null,null,null,"Indbetalinger:"]
[null,null,{"$f":"ROW()","v":13},"Timeløn i supermarked",111," pr. time",null,null,null,null,null,"Timeløn i supermarked",{"$f":"E13","v":111}," pr. time"]
[null,null,{"$f":"ROW()","v":14},"S.U.",3320," hver måned",null,null,null,null,null,"S.U.",{"$f":"E14","v":3320}," hver måned"]
[null,null,{"$f":"ROW()","v":15}]
[null,null,{"$f":"ROW()","v":16},null,"Januar","Februar","Marts","April","Maj",null,null,null,"Januar","Februar","Marts","April","Maj"]
[null,null,{"$f":"ROW()","v":17},"Indbetalinger:",null,null,null,null,null,null,null,"Nødvendige antal timer i supermarked",{"$f":"M18/$E$13","v":25.846846846846848},{"$f":"N18/$E$13","v":26.72072072072072},{"$f":"O18/$E$13","v":23.477477477477478},{"$f":"P18/$E$13","v":29.09009009009009},{"$f":"Q18/$E$13","v":23.477477477477478}]
[null,null,{"$f":"ROW()","v":18},null,null,null,null,null,null,null,null,"Løn i supermarked",{"$f":"M30-M19","v":2869},{"$f":"N30-N19","v":2966},{"$f":"O30-O19","v":2606},{"$f":"P30-P19","v":3229},{"$f":"Q30-Q19","v":2606}]
[null,null,{"$f":"ROW()","v":19},null,null,null,null,null,null,null,null,"S.U.",{"$f":"$M$14","v":3320},{"$f":"$M$14","v":3320},{"$f":"$M$14","v":3320},{"$f":"$M$14","v":3320},{"$f":"$M$14","v":3320}]
[null,null,{"$f":"ROW()","v":20}]
[null,null,{"$f":"ROW()","v":21},"Udbetalinger:",null,null,null,null,null,null,null,"Udbetalinger:"]
[null,null,{"$f":"ROW()","v":22},"Husleje",2022,2022,2022,2022,2022,null,null,"Husleje",{"$f":"E22","v":2022},2022,2022,2022,2022]
[null,null,{"$f":"ROW()","v":23},"Transport",504,504,504,504,504,null,null,"Transport",504,504,504,504,504]
[null,null,{"$f":"ROW()","v":24},"Forsikringer",263,null,null,263,null,null,null,"Forsikringer",263,0,0,263,0]
[null,null,{"$f":"ROW()","v":25},"Sport",null,360,null,360,null,null,null,"Sport",0,360,0,360,0]
[null,null,{"$f":"ROW()","v":26},"Telefon",600,600,600,600,600,null,null,"Telefon",600,600,600,600,600]
[null,null,{"$f":"ROW()","v":27},"Tøj",600,600,600,600,600,null,null,"Tøj",600,600,600,600,600]
[null,null,{"$f":"ROW()","v":28},"Mad m.v.",1200,1200,1200,1200,1200,null,null,"Mad m.v.",1200,1200,1200,1200,1200]
[null,null,{"$f":"ROW()","v":29},"Fester m.v.",1000,1000,1000,1000,1000,null,null,"Fester m.v.",1000,1000,1000,1000,1000]
[null,null,{"$f":"ROW()","v":30},"I alt",null,null,null,null,null,null,null,"I alt",{"$f":"SUM(M22:M29)","v":6189},{"$f":"SUM(N22:N29)","v":6286},{"$f":"SUM(O22:O29)","v":5926},{"$f":"SUM(P22:P29)","v":6549},{"$f":"SUM(Q22:Q29)","v":5926}]
[null,null,{"$f":"ROW()","v":31},null,null,null,null,null,null,null,null,"Resultat",{"$f":"M18+M19-M30","v":0},{"$f":"N18+N19-N30","v":0},{"$f":"O18+O19-O30","v":0},{"$f":"P18+P19-P30","v":0},{"$f":"Q18+Q19-Q30","v":0}]
[]
[null,null,"Færdiggør budgettet, så det fremgår, hvor mange timer Sofie skal arbejde på sit fritidsjob hver"]
[null,null,"måned, hvis hun skal kunne klare alle de forventede udbetalinger i måneden."]
[]
[null,null,{"$f":"\"Du kan gå til celle \"&mycell(M8)&\", hvis du ønsker hjælp.\"","v":"Du kan gå til celle M8, hvis du ønsker hjælp."}]

{"sheet":"19","index":20,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Lav en faktura"]
[]
[null,null,{"$f":"\"Lav en faktura (start i celle \"&mycell(J9)&\") svarende til den, der er vist herunder.\"","v":"Lav en faktura (start i celle J9) svarende til den, der er vist herunder."}]
[null,null,"Beløb i I alt kolonnen skal fremkomme ved hjælp af formler. Alt andet skal"]
[null,null,"indtastes. “kr.” under Stykpris og I alt skal fremkomme via formatering."]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"J"},{"$f":"CHAR(COLUMN()+64)","v":"K"},{"$f":"CHAR(COLUMN()+64)","v":"L"},{"$f":"CHAR(COLUMN()+64)","v":"M"},{"$f":"CHAR(COLUMN()+64)","v":"N"},null,"Ingen hjælp her."]

{"sheet":"20","index":21,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Målsøgning"]
[null,null,null,null,null,null,null,null,null,null,"Rhinens længde = R"]
[null,null,"Du ved følgende:",null,null,null,null,null,null,null,"Volgas længde = V"]
[null,null,"1.","Floden Volga er 2,651515  gange så lang som floden Rhinen.",null,null,null,null,null,null,"Donaus længde = D"]
[null,null,"2.","Donau er 643 km kortere end Volga."]
[null,null,"3.","Gennemsnitslængden af de tre floder er 2.559 km",null,null,null,null,null,null,"1.","R = x"]
[null,null,null,null,null,null,null,null,null,null,"2.","V = 2,65515*x"]
[null,null,"Benyt Målsøgning til at finde længden af de tre floder.",null,null,null,null,null,null,null,"3.","D = V - 643"]
[null,null,null,null,null,null,null,null,null,null,"4.","(R+V+D)/3 = 2559"]
[]
[null,null,"Rhinen",null,null,null,1320,null,null,null,"I udtrykket 4. ganger vi med 3 på"]
[null,null,"Volgas længde",null,null,null,{"$f":"2.651515*G12","v":3499.9997999999996},null,null,null,"begge sider af lighedstegnet:"]
[null,null,"Donaus længde",null,null,null,{"$f":"G13-643","v":2856.9997999999996},null,"Hjælp?"]
[null,null,"Gennemsnitslængden",null,null,null,{"$f":"AVERAGE(G12:G14)","v":2558.9998666666665},null,"Nej",null,"5.","R+V+D = 3*2559 = 7677"]
[null,null,null,null,null,null,null,null,null,null,"Dette er ét udtryk for summen af "]
[null,null,null,null,null,null,null,null,null,null,"de tre floders længde. Et andet"]
[null,null,"Når du har løst opgaven kan du tjekke dit svar her:",null,null,null,null,null,null,null,"udtryk for det samme får vi ved "]
[null,null,"https://lex.dk/.search?query=europas+l%C3%A6ngste+floder",null,null,null,null,null,null,null,"at lægge 1., 2. og 3. sammen."]
[null,null,null,null,null,null,null,null,null,null,"6. ","R+V+D = x +2,65515*x +2,65515*x-643"]
[null,null,null,null,null,null,null,null,null,null,null,"R+V+D = 6,3103*x - 642"]
[null,null,{"$f":"\"Bemærk, at hvis du aktiverer celle \"&mycell(I15)&\" får du mulighed for at vælge mellem \"\"Nej\"\" og \"\"Ja\"\".\"","v":"Bemærk, at hvis du aktiverer celle I15 får du mulighed for at vælge mellem \"Nej\" og \"Ja\"."},null,null,null,null,null,null,null,"Ved at kombinere 5. og 6. får vi:"]
[null,null,null,null,null,null,null,null,null,null,"7.","7677 = 6,3103*x - 642"]
[null,null,null,null,null,null,null,null,null,null,null,"8319 = 6,3103*x"]
[null,null,null,null,null,null,null,null,null,null,null,"x = 1318,3208"]
[null,null,null,null,null,null,null,null,null,null,"Altså:"]
[null,null,null,null,null,null,null,null,null,null,"R = x = 1318,3208"]
[null,null,null,null,null,null,null,null,null,null,"V = 2,65515*x = 3500,3395"]
[null,null,null,null,null,null,null,null,null,null,"D = V- 643 = 3500,3395 - 643 = 2857,3395"]

{"sheet":"21","index":22,"n_rows":123,"n_cols":11,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Målsøgning 2"]
[]
[null,null,"Der afholdes fest med spisning. Deltagerne skal selv betale.",null,null,null,null,null,null,null,"Spørgsmål"]
[null,null,"Udgangspunktet er, at børn skal betale 50% af en voksenbillet.",null,null,null,null,null,null,null,"Hvad skal hver voksen betale, for at regnskabet lige akkurat"]
[null,null,"Der er udgifter til indkøb af papirduge, engangsbestik ",null,null,null,null,null,null,null,"balancerer (så indtægterne lige akkurat dækker udgifterne)?"]
[null,null,"og engangsglas. Desuden skal der indkøbes hvid- og rødvin, "]
[null,null,"danskvand samt sodavand og platter.",null,null,null,null,null,null,null,"Det viser sig, at der tilmelder sig 70 voksne og 50 børn. Der "]
[null,null,null,null,null,null,null,null,null,null,"skal være 1 glas hvidvin til hver af de voksne samt ca. ½ "]
[null,null,{"$f":"\"Lav en opstilling, begyndende i \"&mycell(G13)&\" svarende til opstillingen\"","v":"Lav en opstilling, begyndende i G13 svarende til opstillingen"},null,null,null,null,null,null,null,"flaske rødvin og 2 danskvand. Til børnene skal der være "]
[null,null,"herunder.",null,null,null,null,null,null,null,"3 sodavand. Hver deltager skal have en platte."]
[]
[null,null,null,null,null,null,null,null,null,null,"Prøv at opstille et budget, der ikke giver underskud."]
[]
[null,null,null,null,null,null,null,null,null,null,"Det overvejes at børnene skal betale 75 % af voksenprisen. "]
[null,null,null,null,null,null,null,null,null,null,"Til gengæld skal der være 4 sodavand til hvert barn. Prøv "]
[null,null,null,null,null,null,null,null,null,null,"at rette budgettet ind."]
[]
[null,null,null,null,null,null,null,null,null,null,"Fra række 100 og nedefter kan du se et løsningsforslag, men"]
[null,null,null,null,null,null,null,null,null,null,"prøv nu først på egen hånd."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Budget for en festaften"]
[]
[null,null,null,null,null,null,"Indtægter"]
[]
[null,null,null,null,null,null,null,"Antal","Stykpris","I alt"]
[]
[null,null,null,null,null,null,"Voksne",60,80,{"$f":"H106*I106","v":4800}]
[null,null,null,null,null,null,"Børn",46,{"$f":"I106*50%","v":40},{"$f":"H107*I107","v":1840}]
[]
[null,null,null,null,null,null,null,null,"Indtægter i alt",{"$f":"SUM(J106:J107)","v":6640}]
[]
[]
[null,null,null,null,null,null,"Udgifter"]
[]
[null,null,null,null,null,null,null,"Antal","Stykpris","I alt"]
[]
[null,null,null,null,null,null,"Papirduge mv.",null,null,400]
[null,null,null,null,null,null,"Flasker hvidvin",10,43.85,{"$f":"H117*I117","v":438.5}]
[null,null,null,null,null,null,"Flasker rødvin",25,48.5,{"$f":"H118*I118","v":1212.5}]
[null,null,null,null,null,null,"Danskvand",{"$f":"H106*2","v":120},2.5,{"$f":"H119*I119","v":300}]
[null,null,null,null,null,null,"Sodavand",150,2.85,{"$f":"H120*I120","v":427.5}]
[null,null,null,null,null,null,"Platter",{"$f":"H106+H107","v":106},48.5,{"$f":"H121*I121","v":5141}]
[]
[null,null,null,null,null,null,null,null,"Udgifter i alt",{"$f":"SUM(J116:J122)","v":7919.5}]

{"sheet":"22","index":23,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Autosum"]
[]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"\"Vælg \"&mycell(E14)&\" og tryk på Autsum-ikonet. Excel indsætter et ligheds-\"","v":"Vælg E14 og tryk på Autsum-ikonet. Excel indsætter et ligheds-"}]
[null,null,{"$f":"ROW()","v":6},null,null,{"$f":"\"tegn og en SUM funktion og foreslår \"&mycell(E7)&\":\"&mycell(E13)&\" som det område\"","v":"tegn og en SUM funktion og foreslår E7:E13 som det område"}]
[null,null,{"$f":"ROW()","v":7},"Sverige",10,"der skal summeres. Hvis området er korrekt så tryk på Autosum"]
[null,null,{"$f":"ROW()","v":8},"Norge",20,"igen (eller \"fluebenet til venstre for formelfeltet eller Enter) for"]
[null,null,{"$f":"ROW()","v":9},"Finland",30,"at færdiggøre formlen."]
[null,null,{"$f":"ROW()","v":10},"Holland",40]
[null,null,{"$f":"ROW()","v":11},"Frankrig",50,"Note:  I stedet for at bruge Autosum ikonet kan du bruge føl-"]
[null,null,{"$f":"ROW()","v":12},"England",60,{"$f":"\"gende genvej:  Alt+=. Prøv det i celle \"&mycell(E14)&\".\"","v":"gende genvej:  Alt+=. Prøv det i celle E14."}]
[null,null,{"$f":"ROW()","v":13},"Schweiz",70,"(Alt+Shift+tryk på 0)."]
[null,null,{"$f":"ROW()","v":14},"I alt"]
[]
[]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},null,null,{"$f":"CHAR(COLUMN()+64)","v":"K"},{"$f":"CHAR(COLUMN()+64)","v":"L"}]
[null,null,{"$f":"ROW()","v":19},null,"Produkt 1","Produkt 2","Produkt 3","I alt",null,null,1,1]
[null,null,{"$f":"ROW()","v":20},"Øst",40,50,100,null,null,null,2,2]
[null,null,{"$f":"ROW()","v":21},"Vest",60,50,200,null,null,null,3,3]
[null,null,{"$f":"ROW()","v":22},"Nord",30,100,300,null,null,null,4,4]
[null,null,{"$f":"ROW()","v":23},"Syd",50,200,400,null,null,null,5,5]
[null,null,{"$f":"ROW()","v":24},"I alt"]
[]
[null,null,{"$f":"\"Marker \"&mycell(E20)&\":\"&mycell(H24)&\" (eller \"&mycell(D19)&\":\"&mycell(H24)&\") \"","v":"Marker E20:H24 (eller D19:H24) "},null,null,null,null,null,null,null,{"$f":"\"Marker området \"&mycell(K19)&\":\"&mycell(L23)&\", klik\"","v":"Marker området K19:L23, klik"}]
[null,null,"og tryk på AutoSum ikonet. ",null,null,null,null,null,null,null,{"$f":"\"på pil ned til højre for navne\"","v":"på pil ned til højre for navne"}]
[null,null,"SUM-formler indsættes i ét trin.",null,null,null,null,null,null,null,"boksen, indtast \"Data\" og afslut"]
[null,null,null,null,null,null,null,null,null,null,"med Enter."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"I celle \"&mycell(L24)&\" indtast følgende:\"","v":"I celle L24 indtast følgende:"}]
[null,null,null,null,null,null,null,null,null,null,"=SUM(Data)"]
[]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},"F","G","H",null,{"$f":"\"Vælg området \"&mycell(D35)&\":\"&mycell(D39)&\", hold Ctrl-tasten\"","v":"Vælg området D35:D39, hold Ctrl-tasten"}]
[null,null,{"$f":"ROW()","v":35},1,null,6,null,9,null,{"$f":"\"nede, vælg herefter området \"&mycell(F35)&\":\"&mycell(F39)&\",\"","v":"nede, vælg herefter området F35:F39,"}]
[null,null,{"$f":"ROW()","v":36},2,null,7,null,9,null,"hold stadigvæk Ctrl-tasten nede og vælg"]
[null,null,{"$f":"ROW()","v":37},3,null,8,null,9,null,{"$f":"\"området \"&mycell(H35)&\":\"&mycell(H39)&\". Klik på pil ned til højre\"","v":"området H35:H39. Klik på pil ned til højre"}]
[null,null,{"$f":"ROW()","v":38},4,null,9,null,9,null,"for navneboksen, indtast Data_2 og "]
[null,null,{"$f":"ROW()","v":39},5,null,10,null,9,null,"afslut ved at trykke på Enter."]
[]
[null,null,null,null,null,null,null,null,null,"I en tom celle indtaster du: =SUM(Data_2) "]

{"sheet":"23","index":24,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Autosum/Funktionsguide"]
[]
[null,null,"I denne opgave skal du prøve at bruge henholdsvis SUM-ikonet"]
[null,null,"og Funktionsguiden til at oprette forskellige formler."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,{"$f":"ROW()","v":8}]
[null,null,{"$f":"ROW()","v":9},null,null,650]
[null,null,{"$f":"ROW()","v":10},null,null,50]
[null,null,{"$f":"ROW()","v":11},null,null,1500]
[null,null,{"$f":"ROW()","v":12},null,null,-200]
[null,null,{"$f":"ROW()","v":13},null,null,500]
[null,null,{"$f":"ROW()","v":14}]
[null,null,{"$f":"ROW()","v":15},null,"Sum"]
[null,null,{"$f":"ROW()","v":16},null,"Middel"]
[null,null,{"$f":"ROW()","v":17},null,"Maksimum"]
[null,null,{"$f":"ROW()","v":18},null,"Minimum"]
[]
[null,null,1,"Brug SUM-ikonet til at oprette en formel i celle"]
[null,null,null,{"$f":"mycell(F15)&\" der udregner summen af tallene i\"","v":"F15 der udregner summen af tallene i"}]
[null,null,null,{"$f":"\"området \"&mycell(F9)&\":\"&mycell(F13)&\".\"","v":"området F9:F13."}]
[]
[null,null,2,"Brug SUM-ikonet (plus pil ned til højre for) til at"]
[null,null,null,{"$f":"\"indsætte funktioner i \"&mycell(F16)&\", \"&mycell(F17)&\" og \"&mycell(F18)&\" der\"","v":"indsætte funktioner i F16, F17 og F18 der"}]
[null,null,null,"beregner henholdsvis gennemsnit, mindste værdi"]
[null,null,null,"og største værdi."]
[]
[null,null,3,"Brug Funktionsguiden til at oprette tilsvarende"]
[null,null,null,{"$f":"\"formler i \"&mycell(G15)&\", \"&mycell(G16)&\", \"&mycell(G17)&\" og \"&mycell(G18)&\".\"","v":"formler i G15, G16, G17 og G18."}]

{"sheet":"24","index":25,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,3,19,3],[8,9,19,9]]}
[]
[null,null,"SUM, MAKS, MIN og MIDDEL"]
[]
[null,null,"Brug funktionerne SUM, MAKS, MIN og MIDDEL til at færdiggøre nedenstående salgsstatistik."]
[]
[null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,null,{"$f":"ROW()","v":7}]
[null,null,{"$f":"ROW()","v":8},"Salgsstatistik",null," Odense"," Århus"," København"," Ålborg"]
[null,null,{"$f":"ROW()","v":9},{"$f":"YEAR(TODAY())-1","v":2022},"Jan",6388,7184,13817,4407,"Totaler for alle byer"]
[null,null,{"$f":"ROW()","v":10},null,"Feb",6260,7040,13540,4319]
[null,null,{"$f":"ROW()","v":11},null,"Mar",6135,6899,13270,4232]
[null,null,{"$f":"ROW()","v":12},null,"Apr",6012,6761,13004,4148]
[null,null,{"$f":"ROW()","v":13},null,"Maj",4028,4530,8713,2779]
[null,null,{"$f":"ROW()","v":14},null,"Jun",2699,3035,5838,1862]
[null,null,{"$f":"ROW()","v":15},null,"Jul",1808,2033,3911,1247]
[null,null,{"$f":"ROW()","v":16},null,"Aug",3255,3660,7040,2245]
[null,null,{"$f":"ROW()","v":17},null,"Sep",5859,6589,12672,4042]
[null,null,{"$f":"ROW()","v":18},null,"Okt",5624,6325,12165,3880]
[null,null,{"$f":"ROW()","v":19},null,"nov",5399,6072,11679,3725]
[null,null,{"$f":"ROW()","v":20},null,"Dec",5183,5829,11212,3576]
[null,null,{"$f":"ROW()","v":21},null,"Samlet salg  "]
[null,null,{"$f":"ROW()","v":22},null,"Største salg  "]
[null,null,{"$f":"ROW()","v":23},null,"Mindste salg  "]
[null,null,{"$f":"ROW()","v":24},null,"Gennemsn. salg  "]

{"sheet":"25","index":26,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[9,8,9,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9]]}
[]
[null,null,"Resumé"]
[]
[]
[null,null,"Hvad kan en celle indeholde",null,null,null,null,null,"Eksempler"]
[null,null,null,null,null,null,"Tal",null,123]
[null,null,null,null,null,null,"Tekst",null,"Excel"]
[null,null,null,null,null,null,"Logisk værdi",null,true]
[null,null,null,null,null,null,"Fejlværdi",null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,"Matriks",null,"=RÆKKKE(1:10)"]
[]
[]
[null,null,"Hvad karakteriserer en formel",null,null,null,"En formel starter altid med et lighedstegn."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Referencetyper"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Operatorer",null,null,null,"Operatorer angiver den beregningstype, der skal udføres på en formels"]
[null,null,null,null,null,null,"elementer. Se ark 5."]
[]
[null,null,null,null,null,null,"Der findes en standardrækkefølge, som beregninger udføres i, men du"]
[null,null,null,null,null,null,"kan ændre denne rækkefølge ved hjælp af parenteser."]
[null,null,null,null,null,null,"Se ark 9."]
[]
[null,null,"Cirkeldiagram",null,null,null,"Se ark 15 (+ eventuelt ark 15.1)"]
[]
[]
[]
[null,null,"Målsøgning",null,null,null,"Målsøgning finder du ved at trykke på Data (på Båndet), herefter på "]
[null,null,null,null,null,null,"ikonet \"Hvad-hvis-analyse\" og \"Målsøgning\"."]
[null,null,null,null,null,null,{"$f":"\"(Prøv eventuelt vælge \"\"Ja\"\" i valgboksen i celle \"&mycell(I15) &\" i ark 20).\"","v":"(Prøv eventuelt vælge \"Ja\" i valgboksen i celle I15 i ark 20)."}]
[]
[]
[]
[null,null,"Shortcuts",null,null,null,"Shortcuts1 findes på både dansk og engelsk. Det er sat op så det umiddel-"]
[null,null,null,null,null,null,"bart kan udskrives."]
[null,null,null,null,null,null,"Shortcuts2 viser en række anvendelser."]

{"sheet":"Shortcuts1","index":27,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[[7,6,7,7],[7,9,7,10],[19,6,19,7],[19,9,19,10],[27,6,27,7],[27,9,27,10],[66,6,66,7],[66,9,66,10],[74,6,74,7],[74,9,74,10],[35,6,35,7],[35,9,35,10],[46,6,46,7],[46,9,46,10],[58,6,58,7],[58,9,58,10]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"Microsoft Excel – Genveje"]
[]
[]
[null,null,null,null,null,null,"NAVIGERING",null,null,"REDIGERING"]
[null,null,null,null,null,null,"Celle A1","CTRL HOME",null,"Klip","CTRL X"]
[null,null,null,null,null,null,"Sidste celle med data","CTRL END",null,"Kopier","CTRL C"]
[null,null,null,null,null,null,"Til begyndelsen af række","HOME",null,"Sæt ind","CTRL V"]
[null,null,null,null,null,null,"Første indtastning i række","CTRL ←",null,"Fortryde seneste handling","CTRL Z"]
[null,null,null,null,null,null,"Sidste indtastning i række","CTRL →",null,"Annullere fortryd","CTRL Y"]
[null,null,null,null,null,null,"Første indtastning i kolonne","CTRL ↑",null,"Gentage seneste handling","F4"]
[null,null,null,null,null,null,"Sidste indtastning i kolonne","CTRL ↓",null,"Udfylde nedad","CTRL D"]
[null,null,null,null,null,null,"Foregående ark","CTRL PGUP",null,"Udfylde til højre","CTRL R"]
[null,null,null,null,null,null,"Næste ark","CTRL PGDN",null,"Udfylde område","CTRL ENTER"]
[null,null,null,null,null,null,"Gå til","F5",null,"Slette celleindhold","DELETE"]
[]
[null,null,null,null,null,null,"VÆLGE CELLER",null,null,"KOLONNER OG RÆKKER"]
[null,null,null,null,null,null,"Markere kolonnen","CTRL SPACE",null,"Skjul række","CTRL 9"]
[null,null,null,null,null,null,"Mmarkere rækken","SHIFT SPACE",null,"Vis række","CTRL SHIFT 9"]
[null,null,null,null,null,null,"Markere hele arket","CTRL A",null,"Skjul kolonne","CTRL 0"]
[null,null,null,null,null,null,"Markere aktuelle område","CTRL *",null,"Vis kolonne","CTRL SHIFT 0"]
[null,null,null,null,null,null,"Markere synlige celler","ALT ;",null,"Indsæt kolonne/række","CTRL +"]
[null,null,null,null,null,null,"Celler med kommentarer","CTRL SHIFT O",null,"Slet kolonne/række","CTRL -"]
[]
[null,null,null,null,null,null,"CELLE FORMATERING",null,null,"FIL-KOMMANDOER"]
[null,null,null,null,null,null,"Redigere aktive celle","F2",null,"Ny fil","CTRL N"]
[null,null,null,null,null,null,"Fed","CTRL F",null,"Åbn fil","CTRL O"]
[null,null,null,null,null,null,"Kursiv","CTRL K",null,"Udskriv","CTRL P"]
[null,null,null,null,null,null,"Formater celler dialogboks","CTRL 1",null,"Gem fil","CTRL S"]
[null,null,null,null,null,null,"Tilføj ydre kanter","CTRL SHIFT &",null,"Gem som","F12"]
[null,null,null,null,null,null,"Fjern ydre kanter","CTRL SHIFT -",null,"Luk fil","CTRL F4"]
[]
[null,null,null,null,null,null,"TAL FORMATERING",null,null,"ANDRE KOMMANDOER"]
[null,null,null,null,null,null,"Komma (2 decimaler)","CTRL SHIFT !",null,"Skifte, værdier og formler","CTRL `"]
[null,null,null,null,null,null,"Valuta (2 decimaler)","CTRL SHIFT $",null,"Indtaste datoen","CTRL ;"]
[null,null,null,null,null,null,"Procent (0 decimaler)","CTRL SHIFT %",null,"Indtaste klokkeslæt","CTRL :"]
[null,null,null,null,null,null,"Dato (dd-mmm-åå)","CTRL #",null,"Anvende autosum","ALT ="]
[null,null,null,null,null,null,null,null,null,"Indsæt nyt ark","SHIFT F11"]
[]
[]
[null,null,null,null,null,null,"Microsoft Excel – Shortcuts"]
[]
[]
[null,null,null,null,null,null,"NAVIGATION KEYS",null,null,"EDIT COMMANDS"]
[null,null,null,null,null,null,"Cell A1","CTRL HOME",null,"Cut","CTRL X"]
[null,null,null,null,null,null,"Last Cell With Data","CTRL END",null,"Copy","CTRL C"]
[null,null,null,null,null,null,"Start of Row","HOME",null,"Paste","CTRL V"]
[null,null,null,null,null,null,"First Entry in Row","CTRL ←",null,"Undo last Command","CTRL Z"]
[null,null,null,null,null,null,"Last Entry in Row","CTRL →",null,"Redo Last Command","CTRL Y"]
[null,null,null,null,null,null,"First Entry in Column","CTRL ↑",null,"Repeat Last command","F4"]
[null,null,null,null,null,null,"Last Entry in Column","CTRL ↓",null,"Fill Down","CTRL D"]
[null,null,null,null,null,null,"Previous Worksheet","CTRL PGUP",null,"Fill Right","CTRL R"]
[null,null,null,null,null,null,"Next Worksheet","CTRL PGDN",null,"Fill Range ","CTRL ENTER"]
[null,null,null,null,null,null,"Go to","F5",null,"Clear Cell Contents","DELETE"]
[]
[null,null,null,null,null,null,"SELECTING CELLS",null,null,"COLUMNS & ROWS"]
[null,null,null,null,null,null,"Current Column","CTRL SPACE",null,"Hide Row","CTRL 9"]
[null,null,null,null,null,null,"Current Row","SHIFT SPACE",null,"Unhide Row","CTRL SHIFT 9"]
[null,null,null,null,null,null,"Entire Worksheet","CTRL A",null,"Hide Column","CTRL 0"]
[null,null,null,null,null,null,"Current Range","CTRL *",null,"Unhide Column","CTRL SHIFT 0"]
[null,null,null,null,null,null,"Visible Cells Only","ALT ;",null,"Insert Column or Row","CTRL +"]
[null,null,null,null,null,null,"Cells Containing Comments","CTRL SHIFT O",null,"Delete Column or Row","CTRL -"]
[]
[null,null,null,null,null,null,"CELL FORMATTING",null,null,"FILE COMMANDS"]
[null,null,null,null,null,null,"Edit Active Cell","F2",null,"New File","CTRL N"]
[null,null,null,null,null,null,"Bold","CTRL B",null,"Open Existing File","CTRL O"]
[null,null,null,null,null,null,"Italics","CTRL I",null,"Print Document","CTRL P"]
[null,null,null,null,null,null,"Format Cells Dialog","CTRL 1",null,"Save File","CTRL S"]
[null,null,null,null,null,null,"Add Outline Border","CTRL SHIFT &",null,"Save As","F12"]
[null,null,null,null,null,null,"Remove Border","CTRL SHIFT -",null,"Close File","CTRL F4"]
[]
[null,null,null,null,null,null,"NUMBER FORMATTING",null,null,"OTHER COMMANDS"]
[null,null,null,null,null,null,"Comma (2 decimals)","CTRL SHIFT !",null,"Toggle Value/Formula","CTRL `"]
[null,null,null,null,null,null,"Currency (2 decimals)","CTRL SHIFT $",null,"Insert Current Date","CTRL ;"]
[null,null,null,null,null,null,"Per cent (0 decimals)","CTRL SHIFT %",null,"Insert Current Time","CTRL :"]
[null,null,null,null,null,null,"Date (dd-mmm-yy)","CTRL #",null,"Apply AutoSum","ALT ="]
[null,null,null,null,null,null,null,null,null,"Insert New Worksheet","SHIFT F11"]

{"sheet":"Shortcuts2","index":28,"n_rows":404,"n_cols":14,"rows_kept":404,"cut":false,"hidden":false,"merged":[[227,6,227,8],[234,6,234,8],[235,6,235,8],[236,6,236,8],[237,6,237,8],[289,5,289,6],[297,11,297,12],[298,11,298,12],[299,11,299,12],[286,5,286,6],[287,5,287,6],[288,5,288,6]]}
[]
[]
[]
[]
[null,null,null,null,null,"Genveje"]
[]
[]
[null,null,null,null,null,"Vælg celleområde"]
[]
[null,null,null,null,null,"I tabellen herunder, prøv følgende:"]
[]
[null,null,null,null,null,1,"Flytte fra top til bund",null,null,null,"Ctrl+Pil ned"]
[null,null,null,null,null,2,"Flytte fra bund til top",null,null,null,"Ctrl+Pil op"]
[null,null,null,null,null,3,"Flytte fra venstre til højre",null,null,null,"Ctrl+Pil til højre"]
[null,null,null,null,null,4,"Flytte fra højre til venstre",null,null,null,"Ctrl+Pil til venstre"]
[]
[null,null,null,null,null,1,69,81,56,57,28,45,66,19]
[null,null,null,null,null,2,18,30,94,80,70,77,93,77]
[null,null,null,null,null,3,8,37,86,62,12,89,81,44]
[null,null,null,null,null,4,40,95,31,67,70,42,6,45]
[null,null,null,null,null,5,1,13,48,78,36,60,34,52]
[null,null,null,null,null,6,55,45,48,4,10,70,49,36]
[null,null,null,null,null,7,82,3,1,32,38,81,66,100]
[null,null,null,null,null,8,83,14,17,87,75,15,62,39]
[null,null,null,null,null,9,84,63,45,74,71,76,46,13]
[null,null,null,null,null,10,93,6,33,86,61,4,47,38]
[null,null,null,null,null,11,36,94,100,95,90,77,84,12]
[null,null,null,null,null,12,82,92,72,51,83,81,65,52]
[null,null,null,null,null,13,47,98,8,17,35,14,95,13]
[]
[null,null,null,null,null,"Prøv også følgende i tabellen oven for:"]
[]
[null,null,null,null,null,1,"Lodret område fra top til bund",null,null,null,"Ctrl+Shif+Pil ned"]
[null,null,null,null,null,2,"Vandret område fra bund til top",null,null,null,"Ctrl+Shif+Pil op"]
[null,null,null,null,null,3,"Vandret område fra venstre til højre",null,null,null,"Ctrl+Shif+Pil til højre"]
[null,null,null,null,null,4,"Vandret område fra højre til venstre",null,null,null,"Ctrl+Shif+Pil til venstre"]
[null,null,null,null,null,"5.","Det aktuelle område",null,null,null,"Ctrl+*  (eller Ctrl+A)"]
[]
[]
[]
[null,null,null,null,null,"Første celle",null,null,"Tryk Ctrl+Home for at gå til A1 fra en hvilken som helst celle."]
[]
[null,null,null,null,null,"Sidste celle",null,null,"For at finde den sidste celle i det brugte område i et ark, tryk"]
[null,null,null,null,null,null,null,null,"Ctrl+End."]
[]
[null,null,null,null,null,null,null,null,"Eksempel: Vælg et tomt ark, gå til for eksempel celle F1000. Ind-"]
[null,null,null,null,null,null,null,null,"tast et eller andet i cellen, tryk Enter og slet det herefter igen."]
[null,null,null,null,null,null,null,null,"Tryk på Ctrl+Home for at gå til A1. Prøv nu at trykke Ctrl+End. Du"]
[null,null,null,null,null,null,null,null,"vil se, at sidste celle er F1000."]
[]
[null,null,null,null,null,"Gå til",null,null,"Hvis du ønsker at gå til for eksempel celle K1487, så aktiver nav-"]
[null,null,null,null,null,null,null,null,"nefeltet(feltet helt til venstre for formelfeltet), skriv K1487 og "]
[null,null,null,null,null,null,null,null,"tryk på Enter. Husk at du let kommer tilbage til A1 ved at trykke "]
[null,null,null,null,null,null,null,null,"Ctrl+Home."]
[]
[]
[null,null,null,null,null,"Marker hel kolonne",null,null,"Ctrl+Space"]
[]
[null,null,null,null,null,"Marker hel række",null,null,"Shift+Space"]
[]
[null,null,null,null,null,"Marker hele arket",null,null,"Ctrl+A"]
[]
[]
[null,null,null,null,null,"Næste ark",null,null,"Ctrl+PgDn"]
[]
[null,null,null,null,null,"Foregående ark",null,null,"Ctrl+PgUp"]
[]
[null,null,null,null,null,"Til venstre for arkfanerne på den vandrette rullepanel er der fire små pile. Placer musemar-"]
[null,null,null,null,null,"køren over en af pilene og højreklik. Her kan du hurtigt vælge et bestemt ark, specielt hvis der"]
[null,null,null,null,null,"er mange."]
[]
[]
[null,null,null,null,null,"Indsæt en række",null,null,"Vælg først en række (Shift+Space)"]
[null,null,null,null,null,null,null,null,"Tryk Ctrl + (Ctrl og plus tasten)"]
[]
[null,null,null,null,null,"Slette en række",null,null,"Vælg en række (Shift+Space)"]
[null,null,null,null,null,null,null,null,"Tryk Ctrl - (Ctrl og minus tasten)"]
[]
[null,null,null,null,null,null,null,null,"Prøv det neden for ved at vælge rækken med rød farve og tryk"]
[null,null,null,null,null,null,null,null,"Ctrl + (Ctrl og + tasten) tre gange."]
[null,null,null,null,null,null,null,null,"Tryk herefter Ctrl - (Ctrl og minus tasten) tre gange."]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Indsæt en kolonne",null,null,"Vælg først en kolonne (Ctrl+Space)"]
[null,null,null,null,null,null,null,null,"Tryk Ctrl + (Ctrl og plus tasten)"]
[]
[null,null,null,null,null,"Slette en kolonne",null,null,"Vælg en kolonne (Ctrl+Space)"]
[null,null,null,null,null,null,null,null,"Tryk Ctrl - (Ctrl og minus tasten)"]
[]
[]
[]
[]
[null,null,null,null,null,"Fyldhåndtaget"]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,null,null,null,{"$f":"ROW()","v":99},1,{"$f":"\"Vælg celle \"&mycell(G99)&\" og træk fyldhåndtaget til og med celle \"&mycell(G107)&\".\"","v":"Vælg celle G99 og træk fyldhåndtaget til og med celle G107."}]
[null,null,null,null,null,{"$f":"ROW()","v":100},null,"Tryk på Ctrl+Z (alternativt: Fortryd-ikonet på hovedmenuen). "]
[null,null,null,null,null,{"$f":"ROW()","v":101}]
[null,null,null,null,null,{"$f":"ROW()","v":102},null,{"$f":"\"Vælg igen celle \"&mycell(G99)&\" og dobbeltklik på fyldhåndtaget.\"","v":"Vælg igen celle G99 og dobbeltklik på fyldhåndtaget."}]
[null,null,null,null,null,{"$f":"ROW()","v":103},null,"Tryk på Ctrl+Z."]
[null,null,null,null,null,{"$f":"ROW()","v":104}]
[null,null,null,null,null,{"$f":"ROW()","v":105},null,{"$f":"\"Vælg igen celle \"&mycell(G99)&\" hold Ctrl-tasten nede og træk fyldhåndtaget\"","v":"Vælg igen celle G99 hold Ctrl-tasten nede og træk fyldhåndtaget"}]
[null,null,null,null,null,{"$f":"ROW()","v":106},null,{"$f":"\"til og med celle \"&mycell(G107)&\".\"","v":"til og med celle G107."}]
[null,null,null,null,null,{"$f":"ROW()","v":107}]
[]
[]
[]
[]
[null,null,null,null,null,"Kopier, klip, indsæt"]
[]
[null,null,null,null,null,"Kopier",null,null,"Ctrl+C"]
[]
[null,null,null,null,null,"Klip",null,null,"Ctrl+X"]
[]
[null,null,null,null,null,"Indsæt, med mulighed for"]
[null,null,null,null,null,"at gentage operationen",null,null,"Ctrl+V"]
[]
[null,null,null,null,null,"Indsæt, uden mulighed for"]
[null,null,null,null,null,"at gentage operationen",null,null,"Enter"]
[]
[null,null,null,null,null,"Udfyld nedad",null,null,"Ctrl+D"]
[]
[null,null,null,null,null,"Udfyld til højre",null,null,"Ctrl+R"]
[]
[null,null,null,null,null,"Udfyld område",null,null,"Ctrl+Enter"]
[]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"}]
[null,null,null,null,null,{"$f":"ROW()","v":132},"ABC",null,{"$f":"\"Vælg \"&mycell(G132)&\" og tryk Ctrl+C, vælg celle \"&mycell(H132)&\" og tryk Enter.\"","v":"Vælg G132 og tryk Ctrl+C, vælg celle H132 og tryk Enter."}]
[null,null,null,null,null,{"$f":"ROW()","v":133},"JKL",null,{"$f":"\"Vælg \"&mycell(G133)&\" (Ctrl+C) og indsæt (Ctrl+V) til \"&mycell(H134)&\", derefter til \"","v":"Vælg G133 (Ctrl+C) og indsæt (Ctrl+V) til H134, derefter til "}]
[null,null,null,null,null,{"$f":"ROW()","v":134},null,null,{"$f":"mycell(G135)&\" and \"&mycell(H136)&\".\"","v":"G135 and H136."}]
[null,null,null,null,null,{"$f":"ROW()","v":135}]
[null,null,null,null,null,{"$f":"ROW()","v":136}]
[null,null,null,null,null,{"$f":"ROW()","v":137}]
[null,null,null,null,null,{"$f":"ROW()","v":138},"pqr",null,{"$f":"\"Vælg \"&mycell(G138)&\" tryk Ctrl+X, flyt én celle til højre og tryk\"","v":"Vælg G138 tryk Ctrl+X, flyt én celle til højre og tryk"}]
[null,null,null,null,null,{"$f":"ROW()","v":139},null,null,"Ctrl+V."]
[null,null,null,null,null,{"$f":"ROW()","v":140}]
[null,null,null,null,null,{"$f":"ROW()","v":141},null,null,{"$f":"\"Vælg området \"&mycell(G141)&\":\"&mycell(H146)&\" og indtast FOF, hold Ctrl-tasten nede.\"","v":"Vælg området G141:H146 og indtast FOF, hold Ctrl-tasten nede."}]
[null,null,null,null,null,{"$f":"ROW()","v":142},null,null,"og tryk på Enter."]
[null,null,null,null,null,{"$f":"ROW()","v":143}]
[null,null,null,null,null,{"$f":"ROW()","v":144}]
[null,null,null,null,null,{"$f":"ROW()","v":145}]
[null,null,null,null,null,{"$f":"ROW()","v":146}]
[null,null,null,null,null,{"$f":"ROW()","v":147}]
[null,null,null,null,null,{"$f":"ROW()","v":148},{"$f":"2+2","v":4},null,{"$f":"\"Vælg celle \"&mycell(H148)&\" og tryk Ctrl+R.\"","v":"Vælg celle H148 og tryk Ctrl+R."}]
[null,null,null,null,null,{"$f":"ROW()","v":149}]
[null,null,null,null,null,{"$f":"ROW()","v":150},"XYZ"]
[null,null,null,null,null,{"$f":"ROW()","v":151},null,null,{"$f":"\"Vælg celle \"&mycell(G151)&\" og tryk Ctrl+D.\"","v":"Vælg celle G151 og tryk Ctrl+D."}]
[null,null,null,null,null,{"$f":"ROW()","v":152}]
[]
[]
[]
[]
[null,null,null,null,null,"Kopier formler"]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"},"H","I","J","K","L"]
[null,null,null,null,null,{"$f":"ROW()","v":160},null,10,null,null,10]
[null,null,null,null,null,{"$f":"ROW()","v":161},null,20,null,null,20]
[null,null,null,null,null,{"$f":"ROW()","v":162},null,30,null,null,30]
[null,null,null,null,null,{"$f":"ROW()","v":163},null,40,null,null,40]
[null,null,null,null,null,{"$f":"ROW()","v":164},null,50,null,null,50]
[null,null,null,null,null,{"$f":"ROW()","v":165}]
[null,null,null,null,null,{"$f":"ROW()","v":166},null,{"$f":"H160+H161+H162","v":60},null,null,{"$f":"K160+K161+K162","v":60}]
[null,null,null,null,null,{"$f":"ROW()","v":167},null,{"$f":"H161+H162+H163","v":90},null,null,{"$f":"K160+K161+K162","v":60}]
[null,null,null,null,null,{"$f":"ROW()","v":168}]
[null,null,null,null,null,{"$f":"ROW()","v":169},null,{"$f":"IF(H167=\"\",\"\",_xlfn.FORMULATEXT(H167))","v":"=H161+H162+H163"},null,null,{"$f":"IF(K167=\"\",\"\",_xlfn.FORMULATEXT(K167))","v":"=K160+K161+K162"}]
[null,null,null,null,null,{"$f":"ROW()","v":170}]
[null,null,null,null,null,{"$f":"ROW()","v":171},null,"Prøv at trykke",null,null,"Prøv at trykke"]
[null,null,null,null,null,{"$f":"ROW()","v":172},null,"Ctrl+D og Enter",null,null,"Ctrl+ ' og Enter"]
[null,null,null,null,null,{"$f":"ROW()","v":173},null,{"$f":"\"i celle \"&mycell(H167)","v":"i celle H167"},null,null,{"$f":"\"i celle \"&mycell(K167)","v":"i celle K167"}]
[null,null,null,null,null,{"$f":"ROW()","v":174}]
[null,null,null,null,null,{"$f":"ROW()","v":175}]
[null,null,null,null,null,{"$f":"ROW()","v":176},null,"Læg mærke til den forskellige virkemåde af Ctrl+D og Ctrl+ '"]
[null,null,null,null,null,{"$f":"ROW()","v":177}]
[null,null,null,null,null,{"$f":"ROW()","v":178}]
[null,null,null,null,null,{"$f":"ROW()","v":179}]
[]
[]
[]
[]
[null,null,null,null,null,"Kopier/Indsæt speciel"]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},"Prøv at bruge funktionen STORE.BOGSTAVER i kolonne H"]
[null,null,null,null,null,{"$f":"ROW()","v":187},"John",null,"for at skrive JOHN, JETTE o.s.v."]
[null,null,null,null,null,{"$f":"ROW()","v":188},"Jette ",null,"Lad os nu sige, at du faktisk ønsker, at navnene med "]
[null,null,null,null,null,{"$f":"ROW()","v":189},"Jørgen",null,"store bogstaver skal stå i kolonne G og ikke i kolonne H."]
[null,null,null,null,null,{"$f":"ROW()","v":190},"Bodil",null,"Hvordan vil du løse det?"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,null,null,null,{"$f":"ROW()","v":195},{"$f":"ROW()*2","v":390},null,{"$f":"\"Celle \"&mycell(G195)&\" indeholder formlen: \"&showformula(G195)&\". Lignende form- \"","v":"Celle G195 indeholder formlen: =ROW()*2. Lignende form- "}]
[null,null,null,null,null,{"$f":"ROW()","v":196},{"$f":"ROW()*2","v":392},null,{"$f":"\"ler findes i \"&mycell(G196)&\":\"&mycell(G205)&\". Lad os sige, at du ønsker at kopiere\"","v":"ler findes i G196:G205. Lad os sige, at du ønsker at kopiere"}]
[null,null,null,null,null,{"$f":"ROW()","v":197},394,null,{"$f":"mycell(G195)&\":\"&mycell(G210)&\" og indsætte som værdier i det samme område\"&\".\"","v":"G195:G210 og indsætte som værdier i det samme område."}]
[null,null,null,null,null,{"$f":"ROW()","v":198},396]
[null,null,null,null,null,{"$f":"ROW()","v":199},398,null,{"$f":"\"1.  Vælg celle \"&mycell(G195)&\":\"&mycell(G210)&\".\"","v":"1.  Vælg celle G195:G210."}]
[null,null,null,null,null,{"$f":"ROW()","v":200},400,null,"2.  Tryk Ctrl+C"]
[null,null,null,null,null,{"$f":"ROW()","v":201},402,null,"3.  Højreklik musen og vælg Indsæt speciel."]
[null,null,null,null,null,{"$f":"ROW()","v":202},404,null,"4.  Vælg Værdier og tryk på OK."]
[null,null,null,null,null,{"$f":"ROW()","v":203},406]
[null,null,null,null,null,{"$f":"ROW()","v":204},408,null,"En hurtigere måde:"]
[null,null,null,null,null,{"$f":"ROW()","v":205},410,null,{"$f":"\"1.  Vælg celle \"&mycell(G195)&\":\"&mycell(G210)&\".\"","v":"1.  Vælg celle G195:G210."}]
[null,null,null,null,null,{"$f":"ROW()","v":206},412,null,"2.  Peg på den ydre kant til højre i en vilkårlig celle i området."]
[null,null,null,null,null,{"$f":"ROW()","v":207},414,null,"3.  Højreklik musen og træk én kolonne til højre, så der vises"]
[null,null,null,null,null,{"$f":"ROW()","v":208},416,null,{"$f":"\"      en ramme om området \"&mycell(H195)&\":\"&mycell(G210)&\". Træk tilbage igen og \"","v":"      en ramme om området H195:G210. Træk tilbage igen og "}]
[null,null,null,null,null,{"$f":"ROW()","v":209},418,null,"      slip musen. Herefter dukker der en række valgmuligheder "]
[null,null,null,null,null,{"$f":"ROW()","v":210},420,null,"      op. Vælg: \"Kopier kun værdier hertil\"."]
[]
[null,null,null,null,null,null,null,null,"En endnu hurtigere måde er én gang for alle at lave en stump"]
[null,null,null,null,null,null,null,null,"VBA-kode og så lade Ctrl+Shift+V kalde denne kode."]
[]
[null,null,null,null,null,null,null,null,"Sub CopyPasteValues()"]
[null,null,null,null,null,null,null,null,"    If TypeName(Selection) = \"Range\" Then"]
[null,null,null,null,null,null,null,null,"        Selection.Copy"]
[null,null,null,null,null,null,null,null,"        Selection.PasteSpecial xlPasteValues"]
[null,null,null,null,null,null,null,null,"        Application.CutCopyMode = False"]
[null,null,null,null,null,null,null,null,"    End If"]
[null,null,null,null,null,null,null,null,"End Sub"]
[]
[]
[]
[]
[null,null,null,null,null,"Hurtig indsætning af tekst fra en liste med tidligere indtastninger"]
[]
[null,null,null,null,null,{"$f":"ROW()","v":228},"Fixed assets"]
[null,null,null,null,null,{"$f":"ROW()","v":229},"Anlægsaktiver"]
[null,null,null,null,null,{"$f":"ROW()","v":230},"Current assets"]
[null,null,null,null,null,{"$f":"ROW()","v":231},"Omsætningsaktiver"]
[null,null,null,null,null,{"$f":"ROW()","v":232},"Alllocated provisions"]
[null,null,null,null,null,{"$f":"ROW()","v":233},"Hensatte forpligtelser",null,null,"1.  Vælg den tomme celle under sidst udfyldte celle."]
[null,null,null,null,null,{"$f":"ROW()","v":234},"Cash flow",null,null,"2.  Tryk på Alt+Pil ned."]
[null,null,null,null,null,{"$f":"ROW()","v":235},"Pengestrøm"]
[null,null,null,null,null,{"$f":"ROW()","v":236}]
[null,null,null,null,null,{"$f":"ROW()","v":237}]
[null,null,null,null,null,{"$f":"ROW()","v":238}]
[]
[]
[]
[]
[null,null,null,null,null,"Formatering"]
[]
[null,null,null,null,null,"Excel tilbyder en lang række talformater, så du kan vælge det format der bedst opfylder dine"]
[null,null,null,null,null,"ønsker. Talformater sættes under fanen Tal i dialogboksen \"Formater celler\". For at vise denne"]
[null,null,null,null,null,"dialogboks kan du bruge en af følgende metoder:"]
[]
[null,null,null,null,null,"•","Tryk Ctrl+1."]
[null,null,null,null,null,"•","Højreklik på en celle og vælg \"Formater celler\"."]
[null,null,null,null,null,"•","Fra menuen, vælg \"Formater\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Brugerdefinerede formater som du laver, gemmes i dialogboksen under \"Brugerdefineret\" i"]
[null,null,null,null,null,"den projektmappe, og kun den, hvor du lavede dem."]
[]
[]
[null,null,null,null,null,"Kolding",null,{"$f":"\"Vælg \"&mycell(F282)&\" og tryk Ctrl+F (flere gange).\"","v":"Vælg F282 og tryk Ctrl+F (flere gange)."}]
[]
[null,null,null,null,null,"Fredericia",null,{"$f":"\"Vælg \"&mycell(F284)&\" og tryk Ctrl+K (flere gange).\"","v":"Vælg F284 og tryk Ctrl+K (flere gange)."}]
[]
[]
[null,null,null,null,null,12345678,null,"Tryk på Ctrl+Shift+1 (her og neden for, Ctrl+Z for at fortryde)"]
[null,null,null,null,null,{"$f":"TODAY()","v":45044},null,"Tryk på Ctrl+Shift+3"]
[null,null,null,null,null,98765432,null,"Tryk på Ctrl+Shift+4"]
[null,null,null,null,null,0.875,null,"Tryk på Ctrl+Shift+5"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Genveje til indtastning adf dato/tidspunkt"]
[]
[null,null,null,null,null,"•","Indsæt dags dato",null,null,"CTRL+ ;"]
[]
[null,null,null,null,null,"•","Indsæt tidspunkt",null,null,"CTRL+ :"]
[]
[]
[]
[]
[null,null,null,null,null,"Indsæt nyt ark",null,null,null,"Shift+F11"]
[]
[null,null,null,null,null,"Da det er så let (Shift+F11) at indsætte et nyt ark er der ingen grund til at starte nye projekt-"]
[null,null,null,null,null,"mapper med en masse ark."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"I det felt der er omringet med rødt kan du anføre hvor mange ark Excel skal indeholde når du "]
[null,null,null,null,null,"åbner en ny projektmappe."]
[]
[]
[]
[]
[null,null,null,null,null,"Autoudfyld"]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},{"$f":"CHAR(COLUMN()+64)","v":"I"},{"$f":"CHAR(COLUMN()+64)","v":"J"},{"$f":"CHAR(COLUMN()+64)","v":"K"}]
[null,null,null,null,null,{"$f":"ROW()","v":344},null,null,null,null,"Middel"]
[null,null,null,null,null,{"$f":"ROW()","v":345},"Type 1",296,280,100,{"$f":"AVERAGE(H345:J345)","v":225.33333333333334}]
[null,null,null,null,null,{"$f":"ROW()","v":346}]
[null,null,null,null,null,{"$f":"ROW()","v":347},null,240,305,140,null,"For at få samme formel i"]
[null,null,null,null,null,{"$f":"ROW()","v":348},null,null,null,null,null,{"$f":"\"celle \"&mycell(K345)&\", \"&mycell(K347)&\", \"&mycell(K349)&\", \"","v":"celle K345, K347, K349, "}]
[null,null,null,null,null,{"$f":"ROW()","v":349},null,165,100,230,null,{"$f":"mycell(K351)&\" \"&mycell(K353)&\" og \"&mycell(K355)&\", marker\"","v":"K351 K353 og K355, marker"}]
[null,null,null,null,null,{"$f":"ROW()","v":350},null,null,null,null,null,{"$f":"mycell(K345)&\":\"&mycell(K346)&\" og træk fyld-\"","v":"K345:K346 og træk fyld-"}]
[null,null,null,null,null,{"$f":"ROW()","v":351},null,120,340,230,null,{"$f":"\"håndtaget til celle \"&mycell(K355)&\".\"","v":"håndtaget til celle K355."}]
[null,null,null,null,null,{"$f":"ROW()","v":352}]
[null,null,null,null,null,{"$f":"ROW()","v":353},null,320,190,210,null,"Gentag ovennævnte procedure"]
[null,null,null,null,null,{"$f":"ROW()","v":354},null,null,null,null,null,{"$f":"\"på området \"&mycell(G345)&\":\"&mycell(G355)&\".\"","v":"på området G345:G355."}]
[null,null,null,null,null,{"$f":"ROW()","v":355},null,489,705,484]
[]
[]
[]
[]
[null,null,null,null,null,"Udfyld område med Ctrl+Enter"]
[]
[null,null,null,null,null,"•",{"$f":"\"Aktiver området \"&mycell(G372)&\":\"&mycell(G382)&\", indtast 200 og afslut ved at holde Ctrl tasten nede\"","v":"Aktiver området G372:G382, indtast 200 og afslut ved at holde Ctrl tasten nede"}]
[null,null,null,null,null,null,"før du trykker på Enter."]
[]
[null,null,null,null,null,"•",{"$f":"\"Aktiver området \"&mycell(I374)&\":\"&mycell(K380)&\", indtast formlem: =SLUMPMELLEM(1;100) og afslut\"","v":"Aktiver området I374:K380, indtast formlem: =SLUMPMELLEM(1;100) og afslut"}]
[null,null,null,null,null,null,"ved at holde Ctrl tasten nede før du trykker på Enter."]
[null,null,null,null,null,null,"Husk efterfølgende at trykke Ctrl+Z (fortryde)"]
[]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"},{"$f":"CHAR(COLUMN()+64)","v":"H"},{"$f":"CHAR(COLUMN()+64)","v":"I"},{"$f":"CHAR(COLUMN()+64)","v":"J"},{"$f":"CHAR(COLUMN()+64)","v":"K"}]
[]
[null,null,null,null,null,{"$f":"ROW()","v":372}]
[null,null,null,null,null,{"$f":"ROW()","v":373}]
[null,null,null,null,null,{"$f":"ROW()","v":374}]
[null,null,null,null,null,{"$f":"ROW()","v":375}]
[null,null,null,null,null,{"$f":"ROW()","v":376}]
[null,null,null,null,null,{"$f":"ROW()","v":377}]
[null,null,null,null,null,{"$f":"ROW()","v":378}]
[null,null,null,null,null,{"$f":"ROW()","v":379}]
[null,null,null,null,null,{"$f":"ROW()","v":380}]
[null,null,null,null,null,{"$f":"ROW()","v":381}]
[null,null,null,null,null,{"$f":"ROW()","v":382}]
[]
[]
[]
[]
[null,null,null,null,null,"Søg og erstat"]
[]
[null,null,null,null,null,null,{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,null,null,null,null,{"$f":"ROW()","v":390},"01.01.11",null,"Data som vist til venstre kunne være noget der er importeret"]
[null,null,null,null,null,{"$f":"ROW()","v":391},"10.02.11",null,"fra et andet system, for eksempel SAP og hvor det er mening-"]
[null,null,null,null,null,{"$f":"ROW()","v":392},"16.03.11",null,"en, at data skal forstås som datoer. Sådan opfatter Excel det"]
[null,null,null,null,null,{"$f":"ROW()","v":393},"25.04.11",null,"imidlertid ikke. Excel opfattter det derimod som tekst, hvilket"]
[null,null,null,null,null,{"$f":"ROW()","v":394},"01.05.11",null,"du kan få bekræftet, for eksempel ved hjælp af en formel som"]
[null,null,null,null,null,{"$f":"ROW()","v":395},"08.05.11",null,{"$f":"\"=ER.TEKST(\"&mycell(G390)&\").\"","v":"=ER.TEKST(G390)."}]
[null,null,null,null,null,{"$f":"ROW()","v":396},"31.05.11",null,"For at konvertere til noget Excel opfatter som datoer kan du "]
[null,null,null,null,null,{"$f":"ROW()","v":397},"20.06.11",null,"gøre følgende:"]
[null,null,null,null,null,{"$f":"ROW()","v":398},"15.07.11",null,null,"","",""]
[null,null,null,null,null,{"$f":"ROW()","v":399},"10.08.11",null,{"$f":"\"1. Vælg celle \"&mycell(G390)&\":\"&mycell(G404)","v":"1. Vælg celle G390:G404"}]
[null,null,null,null,null,{"$f":"ROW()","v":400},"15.09.11",null,"2.  Vælg Find og vælg, Erstat"]
[null,null,null,null,null,{"$f":"ROW()","v":401},"01.10.11",null,"3.  Indtast . i feltet Søg efter"]
[null,null,null,null,null,{"$f":"ROW()","v":402},"01.12.11",null,"4.  Indtast - i feltet Erstat med"]
[null,null,null,null,null,{"$f":"ROW()","v":403},"10.12.11",null,"5.  Tryk på Erstat alle."]
[null,null,null,null,null,{"$f":"ROW()","v":404},"20.12.11",null,"6.  Tryk på Luk."]