in Education by
What are the steps to filter data using data validation in excel? Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
Select one or more cells to validate. On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas. … Make sure that the In-cell dropdown check box is selected.

Related questions

0 votes
    write the steps of changing the scale of value axis in excel. Select the correct answer from above options...
asked Dec 1, 2021 in Education by JackTerrance
0 votes
    Q.17 Writing, editing, storing, and printing a document using computer software, are known as * O Word ... O Excel Powerpoint Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance
0 votes
    ……………..are the types of data that can be entered in MS Excel. a) Label b) Values c) Formulas d) All of these Select the correct answer from above options...
asked Dec 19, 2021 in Education by JackTerrance
0 votes
    ……………..are the types of data that can be entered in MS Excel. a) Label b) Values c) Formulas d) All of these Select the correct answer from above options...
asked Dec 18, 2021 in Education by JackTerrance
0 votes
    How many data formats are available in Excel? Name some of them. Select the correct answer from above options...
asked Nov 27, 2021 in Education by JackTerrance
0 votes
    which of the following statement is not true for filtering the data in ms Excel Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    which of the following statement is not true for filtering the data in ms Excel Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    which of the following statement is not true for filtering the data in ms Excel Select the correct answer from above options...
asked Dec 21, 2021 in Education by JackTerrance
0 votes
    which of the following statement is not true about sorting data in ms Excel Select the correct answer from above options...
asked Dec 20, 2021 in Education by JackTerrance
0 votes
    which of the following statement is not true for filtering the data in ms. excel Select the correct answer from above options...
asked Dec 17, 2021 in Education by JackTerrance
0 votes
    when you insert an excel file into a word document the data is _______ a) hyperlinked b)linked c)embedded d)placed ina word document Select the correct answer from above options...
asked Dec 13, 2021 in Education by JackTerrance
0 votes
    write the steps to create a table in MS Acess using blank table (create table) option Select the correct answer from above options...
asked Dec 17, 2021 in Education by JackTerrance
0 votes
    write the steps to search the 13 from the following element using binary search 2,4,5,8,9,11,12,13,15,18,21,22,25,29,30 Select the correct answer from above options...
asked Dec 13, 2021 in Education by JackTerrance
0 votes
    explain the steps undertaken in the data stage…plz tell the ans Select the correct answer from above options...
asked Dec 6, 2021 in Education by JackTerrance
...