What is the main function of MS Excel...? Mcqs

Latest MCQs

What is the main function of MS Excel...?

(A) organized data
(B) loss data

(C) gain data
(D) none of these

✅ Correct Answer: organized data

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which one is not a Function in MS Excel...?

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which function calculates the largest value in a set of numbers in Excel...?

(A) Average
(B) Count

(C) Minimum
(D) Maximum

✅ Correct Answer: Maximum

Comments

Source: This question is taken from the Assistant Sub Inspector (ASI) Punjab Police Service Quota

Latest MCQs

The freezing row and column in Excel is in which pane...?

(A) Freezing row
(B) Freezing column

(C) Freezing pane
(D) None of these

✅ Correct Answer: Freezing pane

Comments

Source: This question is taken from the Naib Tehsildar General Knowledge PPSC Past Paper

Latest MCQs

The ______ function in Excel returns the highest value in a set of data that you specify....?

(A) LRG
(B) AVG

(C) MAX
(D) None of these

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

In MS Excel formula and function start with ____...?

(A) +
(B) -

(C) =
(D) [

✅ Correct Answer: =

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Junior Clerk Deputy Commissioner Office BOR

Latest MCQs

What is the purpose of the VLOOUP function in Excel...?

(A) To create a chart
(B) To sort data

(C) To find a value in a table based on a matching value in the first column
(D) None

✅ Correct Answer: To find a value in a table based on a matching value in the first column

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

VLOOKUP is a built-in function in Excel used to:...?

(A) Increases the font of text
(B) Prints the content of an Excel sheet

(C) Searches for a value in the column
(D) Deletes a value in the column

✅ Correct Answer: Searches for a value in the column

Comments

Source: This question is taken from the Canal Patwari (BS-11) Irrigation ppsc past papers

Latest MCQs

What is the function of the VLOOKUP function in Excel...?

(A) To perform a vertical lookup and return a value based on a specified criteria
(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells
(D) To find the average of a range of cells

✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

✅ Correct Answer: AVG

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

What does the VLOOKUP function do in Excel...?

(A) Count the number of cells
(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values
(D) Sorts data in ascending order

✅ Correct Answer: Searches for a value in a column and returns a value in the same row

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which file stored in computer that perform functions quickly while browsing:...?

(A) Cache
(B) Exe

(C) Cookies
(D) None of these

✅ Correct Answer: Cache

Comments

Source: This question is taken from the Assistant BS-16 Special Education Department

Latest MCQs

Which function in Excel tells how many numeric entries are there...?

(A) NUM
(B) COUNT

(C) SUM
(D) CHKNUM

✅ Correct Answer: COUNT

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Function in MS Excel is known as ____...?

(A) Formula
(B) Command

(C) Operation
(D) None of these

✅ Correct Answer: Formula

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Latest MCQs

What is the function of the IF function in Excel...?

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

(C) To find the average of a range of cells
(D) To count the number of cells in a range

✅ Correct Answer: To perform a logical test and return a value based on the result

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

Latest MCQs

Which of the following function key activates the speller in Ms Word...?

(A) F5
(B) F7

(C) F9
(D) Shift + F7

✅ Correct Answer: F7

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words...?

(A) TRIM
(B) SUBSTITUTE

(C) CLEAN
(D) REPT

✅ Correct Answer: TRIM

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

✅ Correct Answer: To add up a range of cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

MS-Excel uses the _____ function when creating a data table....?

(A) Average
(B) Count

(C) Both A and B
(D) Table

✅ Correct Answer: Table

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

The ______________ function in Excel returns the highest value in a set of data that you specify...?

(A) AVG
(B) MAX

(C) LRG
(D) None of these

✅ Correct Answer: MAX

Comments

Source: This question is taken from the Assistant BS-16 & Junior Clerk BS-11 Agriculture Department

Latest MCQs

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________...?

(A) Smart tip
(B) Soft Tip

(C) Web Tip
(D) Cell Tip

✅ Correct Answer: Cell Tip

Comments

Source: This question is taken from the Microsoft Excel MCQs

Best of Luck

From ShineGk.com

Share our website's link