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

Question : 21

In Excel Multiple calculations can be made in a single formula using

a) array formula

b) standard formulas

c) smart formula

d) complex formulas

Answer: (a)

Question : 22

In Excel if you press …….., the cell accepts your typing as its contents.

a) TAB

b) Enter

c) Insert

d) Ctrl + Enter

Answer: (b)

Question : 23

In Excel you can use the formula palette to

a) Copy a range of cells

b) Enter assumptions data

c) Create and edit formulas containing functions

d) Format cells containing numbers

Answer: (c)

Question : 24

In Excel default header for a worksheet is

a) None

b) Your name

c) The sheet tab name

d) The date and time

Answer: (a)

Question : 25

In Excel to select an individual data marker or data label, you must

a) Click once to select the series markers or labels and click the desired marker or label again

b) Double click the data series

c) Double click the marker or label

d) Double click the data series

Answer: (c)

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

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 »

IBPS Profit and Loss Questions Solved Problems with PDF

Most important Profit and Loss multiple choice questions and answers with PDF for IBPS RRB PO. 100+ Aptitude MCQ Practice Exercises all competitive exams

28-Jun-2024 by Careericons

Continue Reading »

100+ Average Aptitude Questions Answers solutions MCQ PDF

New Average multiple choice questions and answers with PDF for IBPS RRB PO. 100+ Quantitative Aptitude MCQ Practice Exercises all competitive exams

28-Jun-2024 by Careericons

Continue Reading »