Excel Final Test
Authored by maruthi pothina
others
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When we open Excel workbook, what steps we follow
Removing Gridlines
Font Styling
Alignment
All the Above
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
"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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the mean of orientation?
Selection of Sheet Size
Converting Portrait to landscape
Converting landscape to portrait
B & C
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
"Remove Duplicates" tool contains in which tab?
Home
Insert
Formating
Data
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
