Data Tab

Total Questions: 9

1 - Which query due you use to answer the question "which employees earn more than 5000$ a month? "
A ) Search query
B ) Search tab query
C ) Select query ✅
D ) None of these

2 - In MS Excel to delete duplicate values which menu is used?

A ) Data ✅
B ) Edit
C ) View
D ) File

3 - Which of the following is not one of Excel's "what-if" functions?

A ) Data table
B ) Auto outline ✅
C ) Goal seeks
D ) Scenario manager

4 - "If function" typically refers to a function used in----:
A ) Mathematics
B ) Spreadsheets
C ) Databases ✅
D ) Programming

5 - Which Excel tool allows you to set specific conditions for data entry ensuring accuracy and consistency in your analysis?

A ) Goal seeks
B ) Data Validation ✅
C ) Pivot Table
D ) Scenario Manager

6 - From which tab in MS Excel is a drop-down list created?

A ) Conditional formatting
B ) Remove Duplicate
C ) Data validation ✅
D ) None of these

7 - Which command can be set to prohibit or allow a cell entry?

A ) Data validation ✅
B ) Evaluate formula
C ) Background error checking
D ) Go to special

8 - In excel what is used to access restricted data by applying limits to show specific information?

A ) Sort
B ) Highlight
C ) Search
D ) Filtering ✅

9 - If the company wants to check the customer preferences than it will use the following option
A ) Experience
B ) Revenue Component
C ) Data Sorting
D ) None of these (Drop-down list) ✅
Past Papers
PPSC 2025 Past Papers
PPSC Past Papers
FPSC Past Papers
NTS Past Papers
Lecture PPSC Past Papers
Punjab Police PPSC Past Papers
PMS Past Papers
IB Past Papers
Junior Clerk PPSC Past Papers
OTS Past Papers
Assistant Past Papers
Ziladar Past Papers
PPSC 2024 Past Papers
PPSC 2023 Past Papers
MCQs
Current Affairs MCQs
General Knowledge MCQs
English MCQs
Computer MCQs
Biology MCQs
Physics MCQs
Chemistry MCQs
Pak Study MCQs
Urdu MCQs
Everyday Science MCQs
World Record MCQs
Abbreviation MCQs
Economics MCQs
Sports MCQs
History of Pakistan MCQs
Electrical Engineering MCQs
Pedagogy MCQs
Educators
General Knowledge MCQs for Educators
Pakistan Affairs MCQs for Educators
Geography MCQs for Educators
Islamic Studies MCQs for Educators
Everyday Science MCQs for Educators
Computer MCQs for Educators
English MCQs for Educators
Current Affair MCQs for Educators
Mathematics MCQs for Educators
Urdu MCQs for Educators
Pedagogy MCQs for Educators
Head Teacher Preparation SED