CSC 105 Lecture Notes - Lecture 6: Parallel Computing, Program Counter, Instruction Set

• School: University of Victoria
• Department: Computer Science
• Course: CSC 105
• Professor: Little Rich

Document Summary

Ascii: american standard code for informaion interchange: represents each character as a unique 8-bit code. Unicode: a 16-bit character encoding scheme allowing characters from all major world languages, file size is double that of ascii. Muliple inputs are separated by commas: sum funcion: #n can be a number , range, or funcion. Vlookup: v sands for verical, so your data must be stored verically in the spreadsheet, syntax: Vlookup(source cell, range of table, column of table) Vlookup(a2, :, 2: a2 = cell reference, : = table, 2 = column. Boolean = true or false: true: range, false: exact value. A selecion needs to be made: =if(evaluate condiion, do if condiion is true, do if condiion is false, ex. =if(and(eval condiion a, eval condiion b, ), do if condiion is true, do if condiion is false) =if(or(eval condiion a, ), do if condiion is true, do if condiion is false)