Microsoft Excel M0200

Describe the “Proper” function in excel.

• The Proper function is used to capitalise the first letter.
• The Proper function is used for the currency, percentage and social security number.
• The Proper function makes all the characters in a small format.
• The Proper function is used to manipulate numeric data.

Which of the following shortcut key is used to add an outline border?

• CTRL+SHIFT+&
• CTRL+SHIFT+#
• CTRL+SHIFT+%
• CTRL+SHIFT+*

What is the CRTL + K in excel?

• CRTL + K is used for inserting a hyperlink in a cell.
• CRTL + K is used for inserting the current time.
• CRTL + K is used for inserting the character value.
• CRTL + K is used for inserting the numerical value.

Which of the following is not an attribute of the VLOOKUP?

• Calc index
• Lookup value
• Table array
• Col index

work on the principle of testing a range of cells, with the result being dependent on the test outcome.

• Logical functions
• Text functions
• Financial functions
• Lookup functions

Define the IF function.

• The IF function runs the logical test and returns only one value for the TRUE result and another for the FALSE result.
• The IF function specifies which value argument is selected.
• The IF function is an exhaustive list of methods for correcting every possible formula error.
• The IF function refers to individual cells or ranges of cells.

Describe the Sparklines.

• The Sparklines feature creates mini graphs that represent a row of highlighted data.
• The Sparklines feature adds all numbers in a range of cells.
• The Sparklines feature allows you to explore various functions.
• The Sparklines is a text reference to a cell.

What is the advantage of a pivot table?

• You can quickly rearrange and delete data fields.
• There are no automatic updates in a pivot table.
• The Pivot table can be a time-consuming venture.
• The Pivot table takes time to learn to understand data and metrics.

What is the syntax of the ROUND function?

• ROUND(number, num_digits)
• ROUND CELL(number, num_digits)
• CELL ROUND(num_digits, number)
• ROUND(num_digits, number)

Which shortcut key is used to open the Find and Replace panel?

• CTRL+H
• CTRL+J
• CTRL+T
• CTRL+N