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

Recently Added Subject & Categories For All Competitive Exams

Top 149+ Biology General Knowledge Practice MCQ Test

Top Biology Ecology & Environment Awareness General Knowledge Multiple Choice Questions And Answers. General Science GK Practice Test For Competitive Exams

December-16-2022 by Careericons

Continue Reading »

Important General Science Biology Practice MCQ Questions

Top General Science Biology In Human Welfare Based Multiple Choice Questions And Answers, Practice MCQ Test For All Competitive Exams, NEET, SSC, Interview

December-06-2022 by Careericons

Continue Reading »

Top 199+ General Science Biology Practice Test, MCQ PDF

Most Important General Science Biology Human Welfare Multiple Choice Questions And Answers (MCQ) PDF, Practice Test For All Competitive Exams, SSC, NEET, RRB

December-01-2022 by Careericons

Continue Reading »

New General Science Biology MCQ Online Practice Test, PDF

Top Most General Science Biology Food Production Multiple Choice Questions And Answers (MCQ), Online GK Practice Test, PDF For All Competitive Exams, NEET

November-29-2022 by Careericons

Continue Reading »