MS excel set 2 Detailed Explanation And More Example

MOST IMPORTANT computer mcq - 13 EXERCISES

Top 20,000+ Computer Memory Based Exercises

The following question based on microsoft excel q/a topic of computer mcq

Questions : What does the VLOOKUP function do?

(a) Looks up text that contain V

(b) Checks whether text is the same in one cell as in the next

(c) Finds related records

(d) All of above

e) None of these

The correct answers to the above question in:

Answer: (c)

Practice microsoft excel q/a (MS excel set 2) Online Quiz

Discuss Form

Valid first name is required.
Please enter a valid email address.
Your genuine comment will be useful for all users! Each and every comment will be uploaded to the question after approval.

Read more ms excel Based Computer Questions and Answers

Question : 1

Which of the following is a popular DOS based spreadsheet package?

a) Word

b) Smart cell

c) Excel

d) Lotus 1-2-3

e) None of these

Answer: (d)

Question : 2

In Excel you can activate a cell by

a) Pressing the Tab key

b) Clicking the cell

c) Pressing an arrow key

d) All of above

Answer: (d)

Question : 3

You can move a sheet from one workbook into new book by

a) From Edit menu choose Move or Copy sheet mark the Create a copy and Click OK

b) From Edit menu choose Move of Copy then choose {Move to end) and click OK

c) From Edit menu choose Move or Copy then select {new book) from To Book list and click OK

d) All of above

e) None of these

Answer: (c)

Question : 4

This type of software is similar to an accountant's worksheet

a) Word processing

b) Database

c) Spreadsheets

d) Graphics

e) None of these

Answer: (c)

Question : 5

Gridlines

a) May be turned off for display but turned on for printing

b) May be turned on or off for printing

c) The be turned off for display and printing

d) a, b and c

e) None of these

Answer: (d)

Question : 6

You can open the scenario Manager dialog box by choosing scenarios from the ..... menu.

a) View

b) Insert

c) Format

d) Tools

e) None of these

Answer: (d)

Recently Added Subject & Categories For All Competitive Exams

Classification Reasoning MCQ For IBPS Clerk Prelims 2024

Most Important 100+ Classification based Verbal Reasoning Ability Multiple choice questions and answers PDF, Free New Mock tests For IBPS Clerk Prelims 2024

03-May-2024 by Careericons

Continue Reading »

Ratio and Proportion Questions with Solutions, IBPS Clerk

New Ratio and Proportion Quants Aptitude based Multiple Choice Questions and Answers Practice Test Series, Quiz & Mock Test for IBPS Clerk Prelims 2024 Exam

02-May-2024 by Careericons

Continue Reading »

Top Analogy Reasoning Ability For IBPS Clerk Prelims 2024

Most Important Analogy based Verbal Reasoning Multiple choice questions and answers practice quiz series PDF, Free New Mock tests For IBPS Clerk Prelims 2024

01-May-2024 by Careericons

Continue Reading »

SSC STENO: Mensuration Area & Volume Questions Test PDF

Free Mensuration Area and Volume Aptitude-based Practice multiple questions with solutions, Quiz, Full Mock Test & PDF for SSC Steno (Grade C & D) 2024 Exam

30-Apr-2024 by Careericons

Continue Reading »