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

Question : 6

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

a) Scenario Summary report

b) Goal Seek

c) Forecasting

d) Trend line

e) None of these

Answer: (d)

Question : 7

In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

a) Category axis

b) Data marker

c) Data point

d) Gridline

Answer: (d)

Question : 8

In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in...............

a) ascending order

b) descending order

c) alphabetical order

d) random order

e) None of these

Answer: (b)

Question : 9

A typical worksheet has .... Number of columns

a) 128

b) 256

c) 512

d) 1024

e) None of these

Answer: (b)

Question : 10

Pounding errors can occur

a) When you use multiplication, division, or exponentiation in a formula

b) When you use addition and subtraction in a formula

c) Because excel uses hidden decimal places in computation

d) When you show the results of formulas with different decimal places that the calculated results

e) None of these

Answer: (a)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 12 Online Quiz

Click to Start..
418 microsoft excel qa based computer MCQ MS excel set 12 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 »