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

Coded Inequalities Reasoning Questions & Answers For Bank

New 150+ Coded Inequalities Verbal Reasoning Multiple-Choice Questions and Answers Free Practice Test & Online Quiz PDF For All IBPS PO SO & CLERK 2024 Exams

28-Nov-2023 by Careericons

Continue Reading »

150+ Problem Solving Questions and Answers For Bank Exams

Problem-Solving Verbal Reasoning Concepts based Multiple Choice Questions and Answers Mock Test & Online MCQ Quiz for All 2024 Upcoming IBPS PO Clerk SO Exam

28-Nov-2023 by Careericons

Continue Reading »

New 150+ Syllogism Verbal MCQ Test PDF For IBPS RRB Exams

Free Syllogism Practice Multiple Choice Questions with Solved Answer PDF and All Verbal Reasoning Topics Online Mock Test For IBPS RRB PO & Clerk Exams 2024.

27-Nov-2023 by Careericons

Continue Reading »

New 200+ Syllogism Questions & Answers PDF For SSC Exams

Free Verbal Reasoning Syllogism Multiple Choice Questions with Solved Answer PDF & Online Mock Test. Prepare for all upcoming SSC CGL, CHSL, MTS Exams 2024

25-Nov-2023 by Careericons

Continue Reading »