FINAL SHIT FINISH AND UR GOOD IF NOT UR COOKED Flashcards
(23 cards)
What does the MIN function do in Excel?
Finds the smallest value in a range.
What does the MAX function do in Excel?
Finds the largest value in a range.
What does the SUM function do?
Adds all numbers in a range.
What does the AVERAGE function return?
The mean of numbers in a range.
What does the COUNT function do?
Counts only numeric values in a range.
What does COUNTA do?
Counts all non-empty cells.
What is the purpose of COUNTIF?
Counts cells that meet a condition.
What does an IF function do?
Tests a condition and returns one of two values.
What is a Nested IF?
An IF function used inside another IF.
What is a primary key?
A unique identifier for each record in a table.
What is a foreign key?
A field that links to a primary key in another table.
What is a relationship in databases?
A connection between two or more tables.
What does DBMS stand for?
Database Management System.
What is even parity?
Number of 1s in the byte is even.
What is odd parity?
Number of 1s in the byte is odd.
What does a parity check do?
Detects errors during data transmission.
What is a parity block?
A method to detect errors in both rows and columns of data.
What is the fetch-decode-execute cycle?
The CPU fetches, decodes, and executes instructions in a loop.
What does memory management do?
Controls data movement between RAM and CPU and allocates memory.
What is file management?
Organizes, saves, renames, moves, and deletes files.
How does the OS perform power management?
Saves battery by turning off hardware, enabling battery saver, or sleep mode.
What is device management?
Tracks and manages hardware devices, sends data, and updates drivers.
What is utility software?
Software that helps maintain the computer (e.g., antivirus, defrag).
