Technology & Tools Flashcards

Which Excel function looks up a value in the first column of a range and returns a value from another column in the same row?

Answer: VLOOKUP

VLOOKUP searches the first column of a table array and returns a value from a specified column in the matching row.

When describing spreadsheet skills on a federal application, which statement is the strongest?

Answer: Built pivot tables in Excel to consolidate 12 monthly reports, cutting reporting time by 30%

Specific tools, actions, and measurable results demonstrate a skill far better than generic claims.

Which tool is best suited for creating a visual project timeline showing task dependencies?

Answer: Gantt chart

A Gantt chart displays tasks along a timeline and shows their dependencies and durations.

What is the primary purpose of a database primary key?

Answer: To uniquely identify each record in a table

A primary key guarantees each row in a table can be uniquely identified.

Which file format is most appropriate for submitting a resume that preserves layout across different devices?

Answer: PDF

PDF preserves fonts and layout regardless of the viewer's device or software, unless the agency requests another format.

In Microsoft Word, which feature lets multiple reviewers suggest edits that the author can accept or reject?

Answer: Track Changes

Track Changes records each insertion, deletion, and formatting change so edits can be reviewed.

Which practice best protects a shared document containing sensitive personnel data?

Answer: Restricting access by role and requiring authentication

Role-based access controls with authentication limit exposure to authorized people only.