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

Question : 36

To select an entire column in MS-EXCEL, press?

a) CTRL + C

b) CTRL + Arrow key

c) CTRL + S

d) All of the above

e) None of these

Answer: (d)

Question : 37

What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

a) 5,430.00

b) 5,436.80.

c) 5,436.8

d) 6.8

e) None of these

Answer: (b)

Question : 38

Text formulas:

a) Replace cell references

b) Return ASCII values of characters

c) Concatenate and manipulate text

d) Show formula error value

e) None of these

Answer: (c)

Question : 39

In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

a) Edit

b) Insert

c) Format

d) Tools

Answer: (d)

Question : 40

In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a) Unfreeze panes command on the window menu

b) Freeze panes command on the window menu

c) Hold titles command on the edit menu

d) Split command on the window menu

Answer: (b)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 3 Online Quiz

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

Recently Added Subject & Categories For All Competitive Exams

New 150+ Percentage Questions For IBPS Clerk Prelims 2024

Free Top Percentage Quants Aptitude based Multiple Choice Questions and Answers Practice Test Series, Quiz PDF & Mock Test for IBPS Clerk Prelims 2024 Exam

04-May-2024 by Careericons

Continue Reading »

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 »