Computer

Correct answer: A

I is correct: Starting content at the top of a new page → Page break. It is more reliable than inserting many blank paragraphs. II is correct: Text repeated at the top of printed pages → Header. Headers are separate from ordinary body paragraphs.

Correct answer: D

Connected observations emphasise temporal trends.

Correct answer: C

I is incorrect: Adding values that meet one condition → SUMIF. It sums entries satisfying a criterion. II is correct: Counting cells that meet one condition → COUNTIF. It counts matching cells rather than adding their values.

Correct answer: B

Styles provide consistent reusable formatting rules.

Correct answer: B

I is incorrect: Keeping a row visible while scrolling → Freeze panes. It changes the view without duplicating the row's data. II is correct: Recording proposed edits for review → Track changes. It preserves insertions and deletions for acceptance or rejection.

Correct answer: D

Formatting updates when the rule's condition changes.

Correct answer: B

I is correct: Text repeated at the top of printed pages → Header. Headers are separate from ordinary body paragraphs. II is correct: Restricting cell entry to allowed values → Data validation. It can provide a dropdown and reject invalid entries.

Correct answer: D

I is incorrect: Counting cells that meet one condition → COUNTIF. It counts matching cells rather than adding their values. II is incorrect: Showing the relationship between two numeric variables → Scatter plot. Each point represents an x-y pair.

Correct answer: B

Bar lengths encode magnitudes for categories.

Correct answer: D

I is incorrect: Keeping a row visible while scrolling → Freeze panes. It changes the view without duplicating the row's data. II is incorrect: Repeating identical formatting in a document → Styles. Styles provide consistent reusable formatting rules.

Correct answer: B

It preserves insertions and deletions for acceptance or rejection.

Correct answer: D

I is correct: Adding values that meet one condition → SUMIF. It sums entries satisfying a criterion. II is incorrect: Starting content at the top of a new page → Page break. It is more reliable than inserting many blank paragraphs.

Correct answer: B

It counts matching cells rather than adding their values.

Correct answer: D

I is incorrect: Text repeated at the top of printed pages → Header. Headers are separate from ordinary body paragraphs. II is incorrect: Keeping a row visible while scrolling → Freeze panes. It changes the view without duplicating the row's data.

Correct answer: A

It sums entries satisfying a criterion.

Correct answer: C

I is correct: Adding values that meet one condition → SUMIF. It sums entries satisfying a criterion. II is correct: Selecting between two outcomes according to a condition → IF. The function returns one result when true and another when false.

Correct answer: A

I is incorrect: Colouring cells according to values or rules → Conditional formatting. Formatting updates when the rule's condition changes. II is incorrect: Adding values that meet one condition → SUMIF. It sums entries satisfying a criterion.

Correct answer: A

I is incorrect: Virtual memory → Address-space abstraction backed by physical memory and sometimes storage. It lets programs use managed virtual addresses. II is correct: Device driver → Software enabling the operating system to control a device. Drivers translate system requests into device-specific operations.

Correct answer: B

It limits alteration rather than guaranteeing secrecy.

Correct answer: A

I is correct: Recycle bin → Temporary retention area for many deleted files. Not every deletion route uses it. II is incorrect: File extension → Suffix commonly indicating a file's format or association. Changing it alone does not convert the file's contents.

Correct answer: B

Commands are entered rather than chosen only through graphical controls.

Correct answer: D

I is correct: Absolute path → Path starting from a filesystem root or equivalent base. It does not depend on the current working directory. II is incorrect: Thread → An execution sequence within a process. Threads can share a process's address space.

Correct answer: C

It can help identify a resource-intensive program.

Correct answer: A

I is correct: Clipboard → Temporary holding area for copied or cut content. Paste retrieves content from the clipboard. II is incorrect: Booting → Starting a computer and loading its operating system. Firmware begins the startup sequence.

Correct answer: C

I is correct: Process → A program in execution. A process has execution state and allocated resources. II is correct: File archive → Container combining files, often with compression. ZIP is a common archive format.