Advanced Excel

Which function checks whether a condition is true or false.

• POWER( )

• IF( )

• ELSE( )

• NONE OF THESE

The Sort & Filter Command is present under the _________ group.

• Editing

• Cells

• Number

• Both (i) and (ii)

Under which group is Conditional Formatting command present.

• Editing

• Style

• Font

• Cells

Sort & Filter command is present under which tab?

• Editing

• Style

• Font

• Cells

---

button is used to add another level of sorting.

• Add Stage

• Another Level

• Add Level

• Level Up

Which key combination is used to Filter the data?

• Ctrl + Shift + F

• Ctrl + Shift + L

• Ctrl + L

• Shift + L

The physical arrangement of data in ascending or descending order is known as ____________

• Arranging

• Sorting

• Linear

• Systematic

__________ option shows only the desired data temporarily while hiding the rest of it.

• Filter

• Sorting

• Conditional Formatting

• Editing

Which function calculates the total of a sum of values?

• POWER ( )

• SUM ( )

• IF ( )

• AVERAGE ( )

Chirag wants to see the children having samme age as him. Which function of Excel should he use?

• Sorting

• Filtering

• Conditional Formatting

• None of these