KSA Technology & Tools 2

Question 1

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?

Accepted Answer

VLOOKUP

Answer

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

Question 2

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

Accepted Answer

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

Answer

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

Question 3

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

Accepted Answer

Gantt chart

Answer

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

Question 4

What is the primary purpose of a database primary key?

Accepted Answer

To uniquely identify each record in a table

Answer

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

Question 5

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

Accepted Answer

PDF

Answer

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

KSA - Knowledge, Skills, and Abilities Practice Test