microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

Which of the following is not a valid data type in Excel?

a) Number

b) Character

c) Label

d) Date/Time

e) None of these

Answer: (b)

Question : 2

In Excel the function calculates depreciation at the same amount each year over an asset’s useful life

a) DB (fixed-declining balance)

b) SLN (straight line)

c) DDB (double-declining)

d) All of above

Answer: (b)

Question : 3

Which of the following is not true about Find and Replace in Excel

a) You can search for bold and replace with italics

b) You can decide whether to look for the whole word or not

c) You can search in formula too

d) You can search by rows or columns or sheets

e) None of these

Answer: (d)

Question : 4

A worksheet range is a

a) A command used for data modeling

b) A range of values such as from 23 to 234

c) A group of cells

d) A group of worksheets

Answer: (c)

Question : 5

Which of the following is not a way to complete a cell entry?

a) Pressing enter

b) Pressing any arrow key on the keyboard

c) Clicking the Enter button on the Formula bar

d) Pressing spacebar

e) None of these

Answer: (d)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 13 Online Quiz

Click to Start..
425 microsoft excel qa based computer MCQ MS excel set 13 question answer with explanation pdf

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 »