Computer MCQs

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, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value...?

(A) =LARGE(A:A, 2)
(B) =LARGE(UNIQUE(A:A), 2)

(C) =INDEX(SORT(UNIQUE(A:A), , -1), 2)
(D) =SMALL(UNIQUE(A:A), 2)

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

Microsoft Excel 2019 files have a default extension of___________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

How to center elements in a slides of ppt...?

(A) select all elements, format > Align
(B) format > Align

(C) elements, format > Align
(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

C7:C9 indicates ______...?

(A) Cells C7 through C9
(B) Only cell C7

(C) Only cell C9
(D) None of these

Comments
Latest MCQs

Which of the following is an absolute cell reference...?

(A) $A$1
(B) #A#1

(C) !A1
(D) None of these

Comments
Latest MCQs

When you link data maintained in an excel workbook to a word document...?

(A) The word document contains a copy of the actual data
(B) The word document must contain a hyperlink

(C) The word document contains a reference to the original source application
(D) The word document cannot be edit

Comments
Latest MCQs

In MS-Excel if you accidentally erased a record on the sheet what command can be used to restore it immediately...?

(A) Undo
(B) Redo

(C) Insert
(D) None of these

Comments

Best of Luck

From ShineGk.com

Share our website's link