microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 11

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

Answer: (c)

Question : 12

Long text can be broken down into many lines within a cell. You can do this through We have 83

a) Wrap Text in Format > > Cells guests online

b) Justify in Edit > > Cells

c) Text Wrapping in Format » Cells, Layout tab

d) All of above

e) None of these

Answer: (a)

Question : 13

In help menu of Excel, which of the following tabs are found?

a) Contents tab

b) Answer Wizard tab

c) Index tab

d) all of the above

e) None of these

Answer: (d)

Question : 14

What happens when dollar signs (S) are entered In a cell address?

a) An absolute eel I address is created.

b) Cell address will change when it is copied to another cell.

c) The sheet tab is changed.

d) The status bar does not display the eel I address.

e) None of these

Answer: (a)

Question : 15

In Excel, the Fill Color button on the Formatting toolbar is used for what?

a) To insert a background.

b) To add borders.

c) To select a distribution of figures.

d) To add shading or color to a cell range.

e) None of these

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 2 Online Quiz

Click to Start..
143 microsoft excel qa based computer MCQ MS excel set 2 question answer with explanation pdf

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 »