MS excel set 5 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 which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell

(a) Count

(b) Average

(c) Sum

(d) None of above

The correct answers to the above question in:

Answer: (c)

Read more questions on ms excel of set 5 question answer Click Here »

Practice microsoft excel q/a (MS excel set 5) 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

What excel feature can you use if you want to work with one record at a time?

a) Auto Complete

b) Auto Filter

c) Data Form

d) Sub Totals

Answer: (c)

Question : 2

The horizontal and vertical lines on a worksheet are called

a) cells

b) sheets

c) blocklines

d) gridlines

e) None of these

Answer: (a)

Question : 3

When the formula bar is active, you can see

a) The edit formula button

b) The cancel button

c) The enter button

d) All of the above

e) None of these

Answer: (d)

Question : 4

In Excel the Paste Special command lets you copy and paste

a) Multiply the selection by a copied value

b) Cell comments

c) Formatting options

d) The resulting values of a formula instead of the actual formula

Answer: (d)

Question : 5

You can add an image to a template by clicking the Insert Picture From File button on the .... Toolbar.

a) Standard

b) Formatting

c) Drawing

d) Picture

e) None of these

Answer: (d)

Question : 6

You can activate a cell by

a) Pressing the Tab key

b) Clicking the cell

c) Pressing an arrow key

d) All of the above

e) None of these

Answer: (d)

Need More Mcqs on microsoft excel q/a of MS excel set 5 Click Here »
GET microsoft excel q/a PRACTICE TEST EXERCISES

MS excel set 1

MS excel set 2

MS excel set 3

MS excel set 4

MS excel set 5

MS excel set 6

MS excel set 7

MS excel set 8

MS excel set 9

MS excel set 10

MS excel set 11

MS excel set 12

MS excel set 13
microsoft excel q/a Shortcuts and Techniques with Examples
Verbal Reasoning
Question & Answer Quiz
Non Verbal Reasoning
Question & Answer Quiz
Quantitative Aptitude
Question & Answer Quiz
Computer MCQ
Question & Answer Quiz
General English
Question & Answer Quiz
History GK
Question & Answer Quiz
Polity GK
Question & Answer Quiz
Geography GK
Question & Answer Quiz
Economy GK
Question & Answer Quiz
General Awareness GK
Question & Answer Quiz

Recently Added Subject & Categories For All Competitive Exams

100+ Quadratic Equation Questions Answers PDF for Bank

Quadratic Equation multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

IBPS Aptitude Linear Equations MCQ Questions Answers PDF

Linear equations multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

New 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »