CPDS Quiz 3

How can you create a data validation rule to allow only numeric entries in a cell?

• Select the cell, go to Data Validation, and choose “Whole Number” as the validation criteria

• Select the cell, go to Data Validation, and choose “Text Length” as the validation criteria.

• Select the cell, go to Data Validation, and choose “Decimal” as the validation criteria.

• Select the cell, go to Data Validation, and choose “Custom” as the validation criteria.

In VLOOKUP, the column # refers to the column in the:

• table array

• worksheet

• workbook

• list

The rearrangement of data in ascending (A-Z) or descending (Z-A) orders is called _______________ .

• Filtering

• Clear Rules

• Sorting

• Custom Filter

When data is arranged in ascending or descending order for only 1 column is called __________ .

• Multiple Column Sorting

• Single Column Sorting

• One Bar Sorting

• None of the above

sorting makes the data______________ to read.

• difficult

• easier

• complex

• none

The Sort & Filter option is present under which tab of Microsoft Excel?

• Insert Tab

• Data tab

• Formula Tab

• View tab

In Excel you can get validation on which tab?

• Edit

• Data

• Insert

• Formulas

What data validation should I write to ensure the car registration field is inputted correctly?

• Text = 8

• Text > 1

• Text does not contain A

The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.

• Array

• Row Index Number

• Price

• Worksheet number

What is the first step to create a formula?

• Select the cell you want to place the formula into

• Type the equals sign (=) to tell Excel that you're about to enter a formula

• Enter the formula using any input values and the appropriate mathematical operators that make up your formula

• Choose the new command from the file menu