CIS 105 Final Exam Study Guide Updated 2023-2024, Exams of Software Development

Download CIS 105 Final Exam Study Guide Updated 2023-2024 and more Exams Software Development in PDF only on Docsity! CIS 105 Final Exam Study Guide Updated 2023-2024 User Interface ---------- Correct Answer ------- controls how you enter data and instructions and how information is displayed on the screen Graphic User Interface (GUI) ---------- Correct Answer ------- a user interface in which icons represent applications, files, and commands operating system ---------- Correct Answer ------- the software that supports a computer's basic functions, such as scheduling tasks, executing applications, and controlling peripherals. ROM BIOS ---------- Correct Answer ------- A computer chip which holds basic instructions and services in order to run basic hardware tests. Windows 10 - Desktop ---------- Correct Answer ------- "normal" Windows desktop with taskbar and notifications at bottom of screen Fuctions ---------- Correct Answer ------- Predefined worksheet formulas that enable you to perfprm complex calculations - use insert Fx Processor Management ---------- Correct Answer ------- Breaks down the work into manageable chunks and prioritizes them WWW vs. Internet ---------- Correct Answer ------- - The Internet is a global system of interconnected computer networks. ○ Carries a vast range of resources and services. - WWW is a global collection of documents and other resources accessed through the Internet using HTTP - one of many Internet communication protocols. ○ Documents are linked via hyperlinks and are identified by their URL Internet Networks ---------- Correct Answer ------- Linked networks that work much the same way- they pass data around in packets, each of which carries the addresses of its sender and receiver ISP (Internet Service Provider) ---------- Correct Answer ------- A company that provides customers access to the Internet. HTTP vs HTTPS ---------- Correct Answer ------- "s" stands for "secure website" peer-to-peer network ---------- Correct Answer ------- A type of network that connects two client computers directly together. client/server network ---------- Correct Answer ------- A network that uses centrally administered computers, known as servers, to enable resource sharing for and to facilitate communication between the other computers on the network. network adapter ---------- Correct Answer ------- A device that enables the computer (or peripheral) to communicate with the network using a common data communication language, or protocol. Hardware vs. Software ---------- Correct Answer ------- Hardware is the physical machine. Software are the instructions to the machine. CPU ---------- Correct Answer ------- Central Processing Unit; the brain of the computer. Processor (CPU) ---------- Correct Answer ------- interprets and carries out the basic instructions that operate a computer CPU chip ---------- Correct Answer ------- Where is CACHE memory located Microprocessor ---------- Correct Answer ------- The central processing unit that is generally made from a single integrated circuit. the speed of the microprocessor ---------- Correct Answer ------- Megahertz is a measurement of __. Internal clock speed ---------- Correct Answer ------- The speed at which the CPU executes internal commands, measured in megahertz (millions of clock ticks per second) or gigahertz (billions of clock ticks per second). Internal clock speeds can be as low as 1 MHz or more than 4 GHz system unit ---------- Correct Answer ------- The case that contains and protects the motherboard, hard disk drive, memory, and other electronic components of the computer from damage. Motherboard ---------- Correct Answer ------- A circuit board that contains all of the computer system's main components. buses ---------- Correct Answer ------- expansion card ---------- Correct Answer ------- An electronic circuit board that fits into a slot on your motherboard expanding the capabilities of your computer. i.e.: video card, internal modem, sound card. Ports ---------- Correct Answer ------- Places on the outside of the computer that connect to the motherboard and allows hardware to work Trojan Horse Virus ---------- Correct Answer ------- hides inside other software, usually as an attachment or a downloadable file Spyware ---------- Correct Answer ------- A type of Malware that locates and saves data from users without them knowing about it. Cell (Excel) ---------- Correct Answer ------- The intersection of a row and a column Formula in Excel ---------- Correct Answer ------- A combination of cell references, mathematical operators, values, and/or functions used to perform calculations Function (Excel) ---------- Correct Answer ------- Pre made formulas 3 types of data entered into spreadsheets ---------- Correct Answer ------- Absolute vs relative cell references ---------- Correct Answer ------- cell range ---------- Correct Answer ------- A cell range is identified by two or more cells within a table. SUM function ---------- Correct Answer ------- adds all the numbers in a range of cells MAX function ---------- Correct Answer ------- displays the highest value in a range MIN function ---------- Correct Answer ------- determines the lowest number in the range MEDIAN function ---------- Correct Answer ------- identifies the midpoint value in a set of values AVERAGE function ---------- Correct Answer ------- Sums numbers then divides by the number of values IF function ---------- Correct Answer ------- Used when you want to assign a value to a cell based on a logical test PMT function ---------- Correct Answer ------- calculates the periodic payment for a loan with a fixed interest rate and fixed term VLOOKUP function ---------- Correct Answer ------- looks up a value in a vertical lookup table and returns a related result from the lookup table DATE Function ---------- Correct Answer ------- creates a date value for the date represented by the year, month and day arguments database functions ---------- Correct Answer ------- allow you to evaluate numeric data in a table DSUM function ---------- Correct Answer ------- A database function that adds value in a database column based on specified conditions DAVERAGE function ---------- Correct Answer ------- finds the average of numbers in a table field that pass a test DMIN function ---------- Correct Answer ------- A database function that identifies the lowest value in a database column based on specific conditions DMAX function ---------- Correct Answer ------- A database function that identifies the highest value in a database column based on specific conditions Pivot Table ---------- Correct Answer ------- in most spreadsheet software it is the name of the tool used to create summary tables. PivotChart ---------- Correct Answer ------- A chart based on PivotTable data. macro in Excel ---------- Correct Answer ------- DBSM ---------- Correct Answer ------- database management system A database field can best be described as: ---------- Correct Answer ------- a category of information in a table. Primary Key ---------- Correct Answer ------- A field (or group of fields) that uniquely identifies a given entity in a table Foreign Key ---------- Correct Answer ------- A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables relationship database ---------- Correct Answer ------- databases that carry their data in the form of tables and that represent relationships using foreign keys query the database ---------- Correct Answer ------- Is the technical term for doing a search in a database Sort (ascending or descending) ---------- Correct Answer ------- (ascending) provides an alphabetical list of text data or a small-to-large list of numeric data. (Descending) arranges the records with the highest value listed first relational database ---------- Correct Answer ------- Database of tables with information on a specific subject Referential Integrity ---------- Correct Answer ------- A rule that prevents orphaned records. calculated field ---------- Correct Answer ------- a field that can be computed from other fields Types of access macros ---------- Correct Answer ------- What is VBA? ---------- Correct Answer ------- Coding specific buttons if statement ---------- Correct Answer ------- The common programming structure that implements "conditional statements". then statement ---------- Correct Answer ------- The statement or block of code following the condition in an if statement. else statement ---------- Correct Answer ------- if if statement isn't true (doesn't run) this will VBA procedure ---------- Correct Answer ------- Code Window ---------- Correct Answer ------- the window in Visual Basic Editor (VBE) that displays the Visual Basic code (commands) for a macro decision structure ---------- Correct Answer ------- another term for the selection structure Design time vs run time ---------- Correct Answer -------