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

Simplification Questions Test PDF For SSC STENO C, D 2024

Free New Simplification Aptitude-based multiple choice questions & answers practice test series. Online Quiz PDF for SSC Stenographer (Grade C, D) 2024 Exam

16-Apr-2024 by Careericons

Continue Reading »

New Classification - Verbal MCQ Test SSC STENO 2024 Exam

Free Classification Verbal Reasoning-based multiple choice questions answers practice test series, Online MCQ Quiz PDF for SSC Steno (Grade C & D) 2024 Exam

15-Apr-2024 by Careericons

Continue Reading »

Idioms and Phrases Question Test PDF SSC STENO C & D 2024

Free General English Idioms and Phrases-based multiple choice questions and answers practice test series. Online Quiz PDF for SSC Steno Grade C & D 2024 Exam

13-Apr-2024 by Careericons

Continue Reading »

Number System Questions Test PDF For SSC STENO C & D 2024

Free New Number System Aptitude-based multiple choice questions and answers practice test series. Online Quiz PDF for SSC Stenographer (Grade C, D) 2024 Exam

12-Apr-2024 by Careericons

Continue Reading »