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

Question : 1

Excel uses the …. Function when creating a data table

a) Count

b) Table

c) Average

d) Sum

Answer: (b)

Question : 2

In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?

a) Click the arrow on the paste button on the standard toolbar, then click formulas

b) Click the arrow on the paste button on the standard toolbar, then click values.

c) Click the Paste button on the standard toolbar

d) All of above

Answer: (b)

Question : 3

You cannot link Excel worksheet data to a Word document

a) With a hyperlink

b) With the copy and paste special commands

c) With the copy and paste buttons on the standard toolbar

d) With the right drag method

Answer: (c)

Question : 4

In Excel To select several cells or ranges that are not touching each other, you would … while selecting

a) hold down the Shift key

b) hold down the Alt key

c) hold down Ctrl + Shift key

d) hold down the Ctrl key

Answer: (d)

Question : 5

In Excel which of the following formulas will Excel not be able to calculate?

a) =SUM(A1:A5)-10

b) =SUM(A1:A5)/(10-10)

c) =SUM(A1:A5)*.5

d) =SUM(Sales)-A3

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 1 Online Quiz

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

Recently Added Subject & Categories For All Competitive Exams

100+ One Word Substitution Practice Test, PDF for SSC

Learn more One Word Substitution questions and answers, PDF for SSC. The most important General English MCQ Practice exercise for all competitive exams

11-Jul-2024 by Careericons

Continue Reading »

Top Para Jumbled Sentences Questions PDF for SSC Exams

New Para-Jumbles or Jumbled-Sentences Questions and Answers with PDF for SSC. General English Rearrangement of Sentences model exercise for all Bank Exams

11-Jul-2024 by Careericons

Continue Reading »

Top Permutation and Combination Practice Questions PDF

Top Permutation and Combination Questions and Answers with Solutions, PDF for SSC. Best Aptitude MCQ Practice Exercise for all competitive, Govt exams

10-Jul-2024 by Careericons

Continue Reading »

Top 100+ Probability MCQ Questions and Answers PDF: SSC

Recent Probability Multiple Choice Questions and Answers with Detailed Solution, download PDF for SSC. Aptitude practice exercise for all Government exams

10-Jul-2024 by Careericons

Continue Reading »