Question

von worksheet data to display the rows that satisfy
Apply Autofilter on the given worksheet
the following criteria.
(a) Display the names of books that fall in the categ
s of books that fall in the category 'Motivational.
mes of books whose price is greater than 100 but less than 300
(b) Display the names of books whose
(c) Display the names of books by JK Rowling.
Booki - Microsoft Excel
Dats
Formulas
Page Layout
Revies
View
Home
Insert
- 11 - A
Calibri
*
-
Wisp Text
General
T
IT
A
E
S
.
Merge
Center
$
%
cut
La COPY
Format Painter
Cipboard
E18
Conditional en
Formatting as Table
Styles
Font
Alignment
Styles
Number
Price (Rs.)
120
200
500
200
125
Book Name
5.No.
You Can Win
The Diary of a Young Gir
Harry Potter and Chamber of Secret
Mein Kampf
3 Malgudi Days
6 The True Joy of Positive Thinking
My Experiments with Truth
Alice in Wonderland
Harry Potter and the Goblet of Fire
10 How to stop Worrying and Start Living
1 The Power of Positive Thinking
12 The Great Gatsby
13 The Hunger Games
14 The Da Vind code
Books List
Category
Motivational
Fiction
Fiction
Autobiography
Fiction
Motivational
Autobiography
Fiction
Fiction
Motivational
Motivational
Fiction
Fiction
Fiction
Author
Shiv Khera
Anne Frank
J.K. Rowling
Adolf Hitler
R.K. Narayan
Norman Vincent Pesle
M.K.Gandhi
Lewis Carolt
J.K. Rowling
Date Csmegle
Norman Vincent peale
F. Scott Fitzgerald
Suzanne Collins
Dan Brown
200
210
320
&tis EGEHREN
110
115
190
179​

Answer 1

please mark me as brainlest

and

also

click thank your plesse