MS excel set 1 Detailed Explanation And More Example

MOST IMPORTANT computer mcq - 13 EXERCISES

Top 20,000+ Computer Memory Based Exercises

The following question based on microsoft excel q/a topic of computer mcq

Questions : 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

The correct answers to the above question in:

Answer: (b)

Practice microsoft excel q/a (MS excel set 1) Online Quiz

Discuss Form

Valid first name is required.
Please enter a valid email address.
Your genuine comment will be useful for all users! Each and every comment will be uploaded to the question after approval.

Read more ms excel Based Computer Questions and Answers

Question : 1

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 : 2

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 : 3

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)

Question : 4

Excel uses the …. Function when creating a data table

a) Count

b) Table

c) Average

d) Sum

Answer: (b)

Recently Added Subject & Categories For All Competitive Exams

Classification MCQ Test: IBPS RRB PO 2024 Scale-1 Prelims

Free 150+ Classification Verbal Reasoning Multiple choice questions and answers practice test series PDF, Free Quiz For IBPS RRB PO Officer Scale 1 Level 2024

28-Mar-2024 by Careericons

Continue Reading »

100+ Analogy Verbal Questions Answers PDF For IBPS RRB PO

Most Important Analogy Verbal Reasoning Multiple choice questions and answers practice test series PDF & Free Quiz For IBPS RRB PO Officer Scale 1 Level 2024

27-Mar-2024 by Careericons

Continue Reading »

IBPS RRB Clerk 2024 Seating Arrangement Questions Answers

Seating Arrangement: Verbal Reasoning Practice multiple choice questions and answers test & Quiz PDF for IBPS RRB (Assistant Multipurpose) Clerk Prelims 2024

26-Mar-2024 by Careericons

Continue Reading »

Top Aptitude Time & Distance Questions PDF: IBPS RRB Clerk

Important Aptitude Time and Distance multiple choice questions answers practice test PDF for IBPS RRB Clerk (Office Assistant Multipurpose) Prelims 2024 Exam

25-Mar-2024 by Careericons

Continue Reading »