IF function used in Excel for _____...? Mcqs

PPSC Past Papers

Latest MCQs

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

Comments
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

Comments
Latest MCQs

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

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Autosave default time in MS Excel is ________....?

(A) 10 hours
(B) 10 minutes

(C) 10 second
(D) None of these

Comments
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

Comments
Latest MCQs

Function of a_________ is similar to that of a mouse...?

(A) Joystick
(B) Keyboard

(C) Camera
(D) Monitor

Comments
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

Comments
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

Comments
Latest MCQs

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

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

The valid data type in MS Excel is _____...?

(A) Boolean
(B) Tupal

(C) Dictionary
(D) None of these

Comments
Latest MCQs

What is active cell in MS-Excel ______...?

(A) Rectangular box
(B) Pointer

(C) Nearing point of view
(D) None of the above

Comments
Latest MCQs

Maximum zoom percentage in Excel is _________...?

(A) 100%
(B) 300%

(C) 400%
(D) 500%

Comments
Latest MCQs

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

(A) NUM
(B) COUNT

(C) SUM
(D) CHKNUM

Comments
Latest MCQs

Shortcut key to insert a new worksheet in Excel is _______...?

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments
Latest MCQs

Actual working area of Computer’s Microsoft Excel is ________ ...?

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

Comments
Latest MCQs

The Function ________ in Excel is used to look up information in a table and extract the corresponding data....?

(A) FETCH
(B) GET

(C) VLOOKUP
(D) LET

Comments
Latest MCQs

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

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

The Maximum number of rows in MS-Excel is ______...?

(A) 1200000
(B) 1048576

(C) 1020239
(D) None of these

Comments
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

Comments
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

Comments
Latest MCQs

In Excel, to calculate the product of numbers, the function used is _____...?

(A) =MULTIPLY()
(B) =PRODUCTSUM()

(C) =PRODUCE()
(D) =PRODUCT()

Comments
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

Comments
Latest MCQs

In Excel, to perform addition, the function used is _____...?

(A) =ADD()
(B) =SUM()

(C) =TOTAL()
(D) =PLUS()

Comments
Latest MCQs

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

(A) organized data
(B) loss data

(C) gain data
(D) none of these

Comments
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

Comments
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

Comments
Latest MCQs

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box
(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar
(D) You can not set page border in Excel

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___________...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

The formula = (B3+B4+B5+B6)/4 would have the same result as the function _______...?

(A) =SUM (B3:B6)
(B) =AVERAGE (B3:B6)

(C) =MAX (B3:B6)
(D) None of these

Comments
Latest MCQs

In MS Excel ______ shortcut key is used for hiding rows....?

(A) Ctrl+H
(B) Ctrl+7

(C) Ctrl+9
(D) None of the above

Comments
Latest MCQs

Move to the next cell in the row in MS Excel _____...?

(A) Tab
(B) Shift

(C) Space
(D) None of these

Comments
Latest MCQs

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

(A) Formula
(B) Command

(C) Operation
(D) None of these

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link