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

Question : 26

To copy formatting from one area in a worksheet and apply it to another area you would use

a) The Edit>Copy Format and Edit>Paste Format commands form the menu.

b) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

c) There is no way to copy and apply formatting in Excel – You have to do it manually

d) The Format Painter button on the standard toolbar

Answer: (d)

Question : 27

You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. Which operator is that?

a) & (ampersand)

b) = (equal sign)

c) (space)

d) All of the above

e) None of these

Answer: (a)

Question : 28

The spelling dialog box can be involved by choosing spelling from ___ menu.

a) Insert

b) file

c) tools

d) view

e) None of these

Answer: (c)

Question : 29

A numeric value can be treated as label value If...... precedes It.

a) Apostrophe (')

b) Exclamation (!)

c) Hash (#)

d) Tilde(~)

e) None of these

Answer: (a)

Question : 30

The name box

a) Shows the location of the previously active cell

b) Appears to the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

e) None of these

Answer: (b)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 7 Online Quiz

Click to Start..
413 microsoft excel qa based computer MCQ MS excel set 7 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 »