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

Question : 36

To add two cells (A1 and A2) together you use the following formula

a) =A1 + A2

b) =Add(AI+A2)

c) together (A 1:A2)

d) AlplusA2

e) None of these

Answer: (a)

Question : 37

In Excel 3-D reference in a formula

a) Cannot be modified

b) Only appears on summary worksheets

c) Limits the formatting options

d) Spans worksheets

Answer: (d)

Question : 38

Excel uniquely identifies cells within a worksheet with a cell name

a) Cell names

b) Column numbers and row letters

c) Column letters and row numbers

d) Cell locator coordinates

e) None of these

Answer: (c)

Question : 39

The Paste Special command lets you copy and paste:

a) Multiply the selection by a copied value

b) Cell comments

c) Formatting options

d) The resulting values of a formula instead of the actual formula

e) None of these

Answer: (d)

Question : 40

Files created with Lotus 1-2-3 have an extension

a) DOC

b) XLS

c) 123

d) WK1

e) None of these

Answer: (c)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 5 Online Quiz

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

Recently Added Subject & Categories For All Competitive Exams

SSC STENO: Time & Work Questions Solved Problems with PDF

Free Time and work Aptitude-based Practice multiple questions with solutions, Quiz series, Mock Test & Downloadable PDF for SSC Steno (Grade C & D) 2024 Exam

27-Apr-2024 by Careericons

Continue Reading »

SSC STENO 2024: Free Reading Comprehension MCQ Test PDF

Top Reading Comprehension English Section-wise multiple choice questions and answers, Full Mock Test Series & Online Quiz for SSC Steno Grade C & D 2024 Exam

26-Apr-2024 by Careericons

Continue Reading »

Free Percentage Questions Answers for SSC STENO 2024 Exam

Important Top Percentage Aptitude-based multiple choice questions and answers practice quiz series, Online Mock Test PDF for SSC Steno Grade C & D 2024 Exam

25-Apr-2024 by Careericons

Continue Reading »

Free Antonyms (English) MCQ Test for SSC STENO 2024 Exam

Top Antonyms General English Section-based multiple choice questions and answers, Free Full Test Series & Online Quiz PDF for SSC Steno Grade C & D 2024 Exam

24-Apr-2024 by Careericons

Continue Reading »