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

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 of the following is NOT an option in clipboard in MS 2007:...?

(A) Page Setup
(B) Format Painter

(C) Paste
(D) Cut

Comments
Latest MCQs

How many options does a binary choice offer...?

(A) One
(B) two

(C) three
(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
Latest MCQs

The main window in a computer spreadsheet is called...?

(A) workbook
(B) work

(C) account book
(D) worksheet

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy value from above cell...?

(A) Ctrl + “
(B) Ctrl+ E

(C) Ctrl+ E
(D) Ctrl+ D

Comments
Latest MCQs

In MS PowerPoint we can go to next slide by:...?

(A) Enter Button
(B) Mouse

(C) Spacebar
(D) All of these

Comments
Latest MCQs

we can add chart from __________ tab...?

(A) File
(B) Chart

(C) Insert
(D) empty

Comments
Latest MCQs

In a computer spreadsheet, block of cells is called __________ ...?

(A) Workbook
(B) Function

(C) Column
(D) Range

Comments
Latest MCQs

Which element is deficient in milk _________...?

(A) Iron
(B) Phosphorus

(C) Sodium
(D) Calcium

Comments

Best of Luck

From ShineGk.com

Share our website's link