WorksheetsExcel Final Test
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
When we open Excel workbook, what steps we follow
a)
Removing Gridlines
b)
Font Styling
c)
Alignment
d)
All the Above
2.
What will "Text to Columns" Do?
a)
Arranging all text to alphabetical order
b)
Splitting text from one column to no of columns by using symbols
c)
Removing Duplicates
d)
Deleting Rows
3.
"Vlookup" Formula used to?
a)
Addition all the cell range
b)
Subtraction all the Cell Range
c)
Searching & Inserting a value/Text/ Symbols by using Criteria
d)
Searching & adding a value by using Criteria
4.
What is the mean of orientation?
a)
Selection of Sheet Size
b)
Converting Portrait to landscape
c)
Converting landscape to portrait
d)
B & C
5.
"Remove Duplicates" tool contains in which tab?
a)
Home
b)
Insert
c)
Formating
d)
Data
6.
What are the uses of "Pivot Table"?
a)
A powerful tool for summarizing, analyzing, and exploring large datasets
b)
Formatting same cell in another and content also
c)
Inserting Pictures and filtering data as per the data given
d)
Non of the above
7.
Which tool will be used to highlight Duplicates
a)
Data Tab > Data Tools > Remove Duplicates
b)
Home Tab > Conditional Formatting > Highlight Cell Rules > Duplicate Values
c)
Data Tab > Data Tools > Highlight Cells
d)
Home Tab > Conditional Formatting > Top Bottom Rules > Duplicate Values
8.
Find the Pie Chart
a)
Option 1
b)
Option 2
c)
Option 3
d)
Option 4
9.
Which formula will be used to addition the data
a)
=Sum(A2:B8)
b)
=Sum(A2-B8)
c)
=Sum(A2+B8)
d)
A & C
10.
Navigate how to Display the Formula Bar?
a)
View Tab > Show > Ruler
b)
View Tab > Zoom > Formula Bar
c)
View Tab > Show > Formula Bar
d)
View Tab > Window > Formula Bar
11.
Shortcut to insert Filter
a)
Alt + H + V + W
b)
Ctrl + Shift + L
c)
Alt + Shift + L
d)
Ctrl + Shift + S
12.
What the Slicers do?
a)
Filtering data as per the selected tab in slicer
b)
Filtering data that which are adding the formula
c)
Filtering formulas in an order
d)
Filtering data from one sheet to another
13.
"=iferror(sum(A2:A50),0)" using this formula what will be happened
a)
If there is an error in given the data it will be shown as '0'
b)
Addition all the Cell range given in the formula
c)
Finding Error
d)
All the above
14.
Basic Math formula are:
a)
A2*A3
b)
A2+A3
c)
A2-A3
d)
All the above
15.
Select a correct order for "requirements to prepare Dashboard"
a)
Proper Raw Data, Pivot Table, Slicers, Charts & Bars & Formats
b)
Proper Raw Data, Slicers & Formats
c)
Pivot Tables, Raw data, Charts & Bars & Formats
d)
Proper Raw Data, Slicers, Charts & Bars & Pivot Table
100 %
