CPDS Quiz 2

In MS Excel spreadsheet, Data can be sorted using ________.

• Filter function
• ARRAY function
• Lookup function
• Operator function

The __ feature of ms excel quickly completes a series of data.

• Auto Filter
• Auto Complete
• Auto Fill
• Auto Sum

Which one is not a function in ms excel?

• PROPER
• AVERAGE
• COUNT
• CLEAR

In MS Excel_________feature makes it easier to add repetitive data to a worksheet

• Autosum
• Sort
• Filter
• Autocomplete

In MS Excel, Page border option is available under _______ tab.

• Insert
• Page Layout
• View
• None of the above

Which function is used to find the highest value in a range of cells?

• MAX
• MIN
• AVERAGE
• COUNT

What does the CONCATENATE function do in Excel?

• Adds up a range of cells.
• Concatenates two or more text strings together.
• Calculates the average of a range of cells
• Counts the number of cells that meet a specific condition

Which function can be used to convert a text string to a date format in Excel?

• TEXT
• VALUE
• DATEVALUE
• CONVERT

Which Excel feature allows you to filter data based on specified criteria?

• Conditional Formatting
• Data Validation
• Sorting
• AutoFilter

Which Excel feature is used to highlight cells that meet specific criteria?

• Conditional Formatting
• Data Validation
• Sorting
• AutoFilter