Functions in Excel

Total Questions: 13

1 - What does the=Proper(TEXT) function do in MS Excel?

A ) All letters are capitalized
B ) First letter of the sentence is capitalized
C ) First letter of each word is capitalized ✅
D ) None of these

2 - ----- function in MS Excel that is used to search for a specific value in a range of cells and return relative position of that item within the range.

A ) To match the value ✅
B ) To Negate the value
C ) To compare the value
D ) To contrast the value

3 - Two common wildcard characters that Excel accepts/recognized are :
A ) / and \
B ) > and<
C ) *And? ✅
D ) +And -

4 - Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?

A ) SUM
B ) MAX
C ) COUNT ✅
D ) AVERAGE

5 - Which function in Excel returns a reminder of division:
A ) MOD ✅
B ) Divide
C ) ACOT
D ) None of these

6 - To return the reminder after the number is divided by a divisor in excel we use the function?

A ) =SUM
B ) =AVG()
C ) =MAX()
D ) None of these (MOD) ✅

7 - MOD() function is used in MS Excel to get

A ) Reminder ✅
B ) Quotient
C ) Divident
D ) None of these

8 - Which keyword is used to find the number of values in a column?

A ) Add
B ) Count ✅
C ) Sum
D ) Total

9 - Which function is used for find the related data in MS Excel?

A ) FLOOKUP
B ) RLOOKUP
C ) VLOOKUP ✅
D ) HLOOKUP

10 - The function is a ------which can calculate the value given in a specific order.

A ) Software
B ) Program
C ) Predefined formula ✅
D ) None of these

11 - The count function is used to find which type of cells:
A ) Alphanumeric cells
B ) Numeric cell ✅
C ) Non-empty cells
D ) None of these

12 - Questionnaire survey is a type of survey used to collect -----?
A ) Name
B ) Primary Data ✅
C ) Secondary Data
D ) Qualitative Data

13 - In MS Excel 2016,=Now () is used:
A ) To show time only
B ) To show current date and time ✅
C ) To show the date only
D ) To show day name
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