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

Question : 11

Multiple calculations can be made In a single formula using....

a) Standard Formulas

b) Array Formula

c) Complex Formulas

d) Smart Formula

Answer: (b)

Question : 12

In Excel how do you change column width to fit the contents?

a) Single-click the boundary to the left to the column heading

b) Double click the boundary to the right of the column heading

c) Press Alt and single click anywhere in the column

d) All of above

Answer: (b)

Question : 13

To make a number In cell Cl 10% smaller than the number In C3 you enter

a) -03*1.10

b) +C3*110

c) -C3%10

d) -C3*.90

e) None of these

Answer: (d)

Question : 14

You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?

a) F9

b) F5

c) F8

d) F11

e) None of these

Answer: (a)

Question : 15

When you link data maintained in Excel workbook to a Word document

a) The Word document cannot be edited

b) The Word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

Answer: (b)

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 »