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

Question : 21

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

a) AutoFill

b) Auto correct

c) Auto sum

d) Auto format

e) None of these

Answer: (c)

Question : 22

To drag a selected range of data to another worksheet in the same workbook, use the

a) Tab key

b) Alt key

c) Shift key

d) Ctrl key

e) None of these

Answer: (d)

Question : 23

Using the Fl 1 shortcut key to create a chart on chart sheet creates

a) A default chart

b) A 2-dimensional column chart

c) A 2-dimensional bar chart

d) A 3-dimensional line chart

e) None of these

Answer: (b)

Question : 24

You can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on a shortcut menu

c) With buttons on the standard toolbar

d) All of the above

e) None of these

Answer: (d)

Question : 25

What is the keyboard shortcut {button or buttons to be pressed) for creating a chart from the selected cells?

a) F3

b) F5

c) F7

d) F11

e) None of these

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 8 Online Quiz

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

Recently Added Subject & Categories For All Competitive Exams

Series Completion Questions & Answers PDF IBPS Clerk 2024

Top Alphabet Number Series Completion based Verbal Reasoning Multiple choice questions with answers PDF, & Free IBPS Mock tests For IBPS Clerk Prelims 2024

06-May-2024 by Careericons

Continue Reading »

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 »