SNAx Training

A careful, systematic exercise hat requires focus to generate information useful for decision making and appropriate response.

• Data Management

• Data Enhancement

• Data Analysis

• Data Correction

The following are examples of Qualitative Variable Types:

• a. Ordinal and Continuous

• b. Nominal and Discrete

• c. Nominal and Ordinal

• d. Continuous and Discrete

A method of eliminating a dataset's redundant data is called what?

• Deduplication

• Conditional Validation

• Data formatting

• Data Elimination

Identify part of an excel sheet:

• 1. Formula bar

• Name box

• Name Ribbon

• Location tab

keyboard shortcut for flash-fill:

• Ctrl + E

• Ctrl + F4

• Ctrl + D

• Ctrl + Shift

Uses colors and borders to highlight/emphasize cells based on criteria

• Conditional Formatting

• Data Validation

• Flash Fill

• Text to Columns

The ___ sybmbol is used at the beginning of a string to start a formula.

• ( ) - parenthesis

• = - equals sign

• " " - double quotation marks

• [ ] - square brackets

Answer explanation

Case Definition- are set of criteria that is standardized for deciding whether to classify a person as having a particular disease.

Keyboard shortcut to lock a cell in a string formula

• Ctrl + E

• F4

• Ctrl + F

• F2

A function that displays the value that appears the most often.

• Mean

• Median

• Mode

• Average

A function that combines values into one cell

• Concatenate

• Vlookup

• rank

• Countifs