Which of the following is not a function in Microsoft Excel?...? Mcqs

PPSC Past Papers

Latest MCQs

Which of the following is not a function in Microsoft Excel?...?

(A) SUM
(B) MAX

(C) MIN
(D) AVG

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

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 ______ 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 a windows pc, the shortcut key for redoing the last action in Microsoft PowerPoint is __________...?

(A) CTRL+R
(B) CTRL+Z

(C) CTRL+Y
(D) CTRL+ O

Comments
Latest MCQs

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.
(B) A1, A2, etc.

(C) A, B, C, etc.
(D) None of these

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

How many ways you can save a document in Microsoft word...?

(A) 3
(B) 2

(C) 1
(D) 5

Comments
Latest MCQs

What is the extension of a Microsoft Excel file...?

(A) .msxcl
(B) .xcl

(C) .xlsx
(D) .xlsm

Comments
Latest MCQs

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

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

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

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

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

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

In Microsoft Excel, press___________ key to enter a new line within a cell...?

(A) Ctrl+ Enter
(B) Alt+ Enter

(C) Shift+ Enter
(D) Ctrl+Shift+Enter

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

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

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

Which of the following is Page Orientation in Microsoft Word...?

(A) Landscape
(B) Portrait

(C) Gutter
(D) Only A & B

Comments
Latest MCQs

In Microsoft Excel, the file you create and edit is called:...?

(A) A form
(B) A ledger

(C) A table
(D) A workbook

Comments
Latest MCQs

Which of these software applications was not part of the first version of Microsoft Office...?

(A) PowerPoint
(B) Outlook

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

How many columns are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments
Latest MCQs

In a Windows PC, the shortcut key for redoing the last action in Microsoft PowerPoint is:...?

(A) CTRL + R
(B) CTRL + Z

(C) CTRL + Y
(D) CTRL + O

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

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

(A) SUM
(B) AVG

(C) MAX
(D) MIN

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

#Value! Error in Microsoft Excel represents:...?

(A) The width of the cell is less to display the answer
(B) Parameter provided to the function is of wrong data type

(C) Value of the answer needs to be round off
(D) When Excel does not recognize the format

Comments
Latest MCQs

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments
Latest MCQs

In Microsoft Excel, the file you create and edit is called...?

(A) A ledger
(B) A table

(C) A workbook
(D) None of these

Comments
Latest MCQs

What is main purpose of Format Painter in Microsoft applications...?

(A) To insert images into a documents
(B) To change the font size

(C) to create the new styles
(D) To copy formatting from one place and paste it to another place

Comments
Latest MCQs

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

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

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

How many rows are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

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 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

Which option in Microsoft Excel will help you arrange, summarize and group large sets of data...?

(A) Illustrations
(B) Pivot table

(C) Sparkline
(D) Filter

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