Spreadsheet for Data Analysis I - 2

Which sign is used for absolute addressing?

• @

•  $

• &

• *

Which one is not a Function in MS Excel ?

• SUM

• AVG

• MAX

• MIN

What does the VLOOKUP function do?

• Looks up text that contain V

• Checks whether text is the same in one cell as in the next

• Finds related records

• All of above

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

A circular reference is

• Geometric modeling tool

• A cell that points to a drawing object

• A formula that either directly or indirectly depends on itself

• Always erroneous

Which of the following features cannot be found in the Data ribbon?

• What-If Analysis

• Pivot Table

• Data Validation

• Text to Columns

Which one is not a function in ms excel?

• PROPER

• AVERAGE

• COUNT

• CLEAR

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

• DATE VALUE

• CONVERT