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

Question : 46

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells

Answer: (d)

Question : 47

Which of the following format you can decide to apply or not In AutoFormat dialog box?

a) Number format

b) Border format

c) Font format

d) All of above

e) None of these

Answer: (d)

Question : 48

In Excel what symbol is used before a number to make it a label?

a) “ (quote)

b) = (equal)

c) _ (underscore)

d) ‘ (apostrophe)

Answer: (b)

Question : 49

In Excel to select a column the easiest method is to

a) Double click any cell in the column

b) Drag from the top cell in the column to the last cell in the column

c) Click the column heading

d) Click the column label

Answer: (c)

Question : 50

In Excel data can be arranged in a worksheet in a easy to understand manner using

a) Auto formatting

b) Applying styles

c) Changing fonts

d) All of above

Answer: (d)

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 »