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

Question : 1

In Excel circular reference is

a) Geometric modeling tool

b) A cell that points to a drawing object

c) A formula that either directly or indirectly depends on itself

d) Always erroneous

Answer: (c)

Question : 2

The short cut key Ctrl +R is used in Excel to

a) Right align the content of cell

b) Remove the cell contents of selected cells

c) Fill the selection with active t cells to the right

d) All of above

e) None of these

Answer: (c)

Question : 3

The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

a) DB1-G10

b) B1.G10

c) B1;G10

d) B1:G10

e) None of these

Answer: (d)

Question : 4

The box on the chart that contains the name of each Individual record Is called the__.

a) cell

b) title

c) axis

d) legend

e) None of these

Answer: (d)

Question : 5

Which of the following is invalid regarding the Protection in Excel?

a) Protect Sheet

b) Protect Workbook

c) Protect Workspace

d) All of above are valid

e) None of these

Answer: (c)

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 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »

IBPS Profit and Loss Questions Solved Problems with PDF

Most important Profit and Loss multiple choice questions and answers with PDF for IBPS RRB PO. 100+ Aptitude MCQ Practice Exercises all competitive exams

28-Jun-2024 by Careericons

Continue Reading »

100+ Average Aptitude Questions Answers solutions MCQ PDF

New Average multiple choice questions and answers with PDF for IBPS RRB PO. 100+ Quantitative Aptitude MCQ Practice Exercises all competitive exams

28-Jun-2024 by Careericons

Continue Reading »