Excel Final Test

When we open Excel workbook, what steps we follow

• Removing Gridlines
• Font Styling
• Alignment
• All the Above

What will "Text to Columns" Do?

• Arranging all text to alphabetical order
• Splitting text from one column to no of columns by using symbols
• Removing Duplicates
• Deleting Rows

"Vlookup" Formula used to?

• Addition all the cell range
• Subtraction all the Cell Range
• Searching & Inserting a value/Text/ Symbols by using Criteria
• Searching & adding a value by using Criteria

What is the mean of orientation?

• Selection of Sheet Size
• Converting Portrait to landscape
• Converting landscape to portrait
• B & C

"Remove Duplicates" tool contains in which tab?

• Home
• Insert
• Formating
• Data

What are the uses of "Pivot Table"?

• A powerful tool for summarizing, analyzing, and exploring large datasets
• Formatting same cell in another and content also
• Inserting Pictures and filtering data as per the data given
• Non of the above

Which tool will be used to highlight Duplicates

• Data Tab > Data Tools > Remove Duplicates
• Home Tab > Conditional Formatting > Highlight Cell Rules > Duplicate Values
• Data Tab > Data Tools > Highlight Cells
• Home Tab > Conditional Formatting > Top Bottom Rules > Duplicate Values

Find the Pie Chart

• 
• 
• 
• 

Which formula will be used to addition the data

• =Sum(A2:B8)
• =Sum(A2-B8)
• =Sum(A2+B8)
• A & C

Navigate how to Display the Formula Bar?

• View Tab > Show > Ruler
• View Tab > Zoom > Formula Bar
• View Tab > Show > Formula Bar
• View Tab > Window > Formula Bar