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

PPSC Past Papers

Latest MCQs

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

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Which is not the function of "Edit clear command"...?

(A) Delete cells
(B) Delete notes

(C) Delete contents
(D) None

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

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

(A) Average
(B) Count

(C) Min
(D) Max

Comments
Latest MCQs

How many characters can be typed in a single cell in Excel ...?

(A) 256
(B) 1024

(C) 32767
(D) 65535

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 CTRL+Q in Microsoft Word...?

(A) Paragraph formatting (Line Space and Paragraph Space)
(B) Close Word Application without saving Document

(C) Print Whole Document without confirmation
(D) Does nothing

Comments
Latest MCQs

What is used to split long text in excel within the cell...?

(A) Wrap text
(B) Click next

(C) All
(D) None

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

What is the function of CTRL+P in Microsoft Word...?

(A) Open Paragraph Dialog Box
(B) Open Page Format Dialog Box

(C) Open Save Dialog Box
(D) Open Print Dialog box

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

What is the function of CTRL+O in Microsoft Word...?

(A) Save Document
(B) Print Document

(C) Close Document
(D) Open Document

Comments
Latest MCQs

User-developed instructions for excel are called...?

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments
Latest MCQs

In MS Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that...?

(A) Name
(B) Space

(C) Ampersand
(D) None of these

Comments
Latest MCQs

Shortcut key of hide entire column in excel...?

(A) Ctrl + Shift + 0
(B) Ctrl + alt+ 0

(C) Shift + 0
(D) Ctrl+0

Comments
Latest MCQs

Which of following function is used to sum the values in a range that meet criteria that you specify...?

(A) SUM
(B) SUMIF

(C) SUMALL
(D) SUMANY

Comments
Latest MCQs

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

(A) Formula
(B) Command

(C) Operation
(D) None of these

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

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

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

Comments
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

Comments
Latest MCQs

In MS Excel, _____ function calculates the square root of a number....?

(A) SQR
(B) SQRT

(C) SQUARE
(D) None of these

Comments
Latest MCQs

Which Shortcut keys are used to strikethrough highlighted selection in Excel...?

(A) Ctrl+4
(B) Ctrl+5

(C) Ctrl+6
(D) None of the above.

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

Which of following function in Microsoft Excel is used to count items in a cell range...?

(A) Count
(B) SUM

(C) MAX
(D) Average

Comments
Latest MCQs

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching
(B) transpose

(C) matrix
(D) none

Comments
Latest MCQs

Where can you change automatic or manual collection mode in Excel ...?

(A) Double CAL indicator on status bar
(B) Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

(C) both
(D) none

Comments
Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments
Latest MCQs

What is the function of CTRL+N in Microsoft Word...?

(A) Save Document
(B) Open Document

(C) New Document
(D) Close Document

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

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

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

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

Comments
Latest MCQs

In MS Word, what is the function of CTRL + R...?

(A) Open the print dialogue
(B) Update the current web page

(C) Close the current window
(D) None of these

Comments
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

Comments
Latest MCQs

How a cell can be edit on Excel sheet...?

(A) Edit contents of cell directly in cell
(B) Edit by typing in formula bar

(C) Edit mode
(D) All above mentioned

Comments
Latest MCQs

in MS Excel what is function inside another function is called...?

(A) nested
(B) round

(C) switch
(D) none of these

Comments
Latest MCQs

_______ is the short key to select the entire column in Excel....?

(A) Alt + space bar
(B) Shift + space bar

(C) Control + space bar
(D) None of the above

Comments
Latest MCQs

Which of the following function is used to get the current date...?

(A) Exact ()
(B) Today ()

(C) Month ()
(D) Year ()

Comments
Latest MCQs

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

(A) F5
(B) F7

(C) F9
(D) Shift + F7

Comments
Latest MCQs

In MS Excel function to return one value if a condition is true and another value if it's false:...?

(A) If function
(B) Sum function

(C) Decimal function
(D) Info function

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

What is the function of Ctrl + B in Ms-Word...?

(A) It converts selected text into the next larger size of the same font
(B) It adds a line break to the document

(C) It makes tho selected text bold
(D) It applies Italic formatting t the selected text

Comments
Latest MCQs

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE
(B) SUM

(C) COUNT
(D) None of these

Comments
Latest MCQs

In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ...?

(A) Length
(B) Counter

(C) Count
(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

The thin black cross-shaped pointer in MS Excel is used to _____...?

(A) Move a group of cells
(B) Highlight duplicate cells

(C) Complete lists and fill patterns
(D) None of these

Comments
Latest MCQs

What is the function of Logical Unit in a computer...?

(A) To produce result
(B) To perform operations arithmetic and logic

(C) To control flow of information
(D) To store result data

Comments
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

Comments
Latest MCQs

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

(A) Cache
(B) Exe

(C) Cookies
(D) None of these

Comments
Latest MCQs

Which of the following functions in Microsoft Excel is used to count items in a cell range...?

(A) COUNT
(B) AVERAGE

(C) SUM
(D) MAX

Comments
Latest MCQs

A function inside another function in called _____...?

(A) Text function
(B) Sum function

(C) Round function
(D) Nested function

Comments
Latest MCQs

Which is not the function of the operating system...?

(A) Linux
(B) DOS

(C) Oracle
(D) Window

Comments
Latest MCQs

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

(A) Average
(B) Count

(C) Both A and B
(D) Table

Comments
Latest MCQs

What is the function of CTRL+R in Microsoft Word...?

(A) Open the Print dialog box
(B) Update the current Web page

(C) Close the current window
(D) None of these

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

While finding and replacing some data in Excel,which of following statement is valid...?

(A) You can Find and Replace within the sheet or workbook
(B) Excel does not have option to match case for find

(C) All
(D) None

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link