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

Classification Reasoning MCQ For IBPS Clerk Prelims 2024

Most Important 100+ Classification based Verbal Reasoning Ability Multiple choice questions and answers PDF, Free New Mock tests For IBPS Clerk Prelims 2024

03-May-2024 by Careericons

Continue Reading »

Ratio and Proportion Questions with Solutions, IBPS Clerk

New Ratio and Proportion Quants Aptitude based Multiple Choice Questions and Answers Practice Test Series, Quiz & Mock Test for IBPS Clerk Prelims 2024 Exam

02-May-2024 by Careericons

Continue Reading »

Top Analogy Reasoning Ability For IBPS Clerk Prelims 2024

Most Important Analogy based Verbal Reasoning Multiple choice questions and answers practice quiz series PDF, Free New Mock tests For IBPS Clerk Prelims 2024

01-May-2024 by Careericons

Continue Reading »

SSC STENO: Mensuration Area & Volume Questions Test PDF

Free Mensuration Area and Volume Aptitude-based Practice multiple questions with solutions, Quiz, Full Mock Test & PDF for SSC Steno (Grade C & D) 2024 Exam

30-Apr-2024 by Careericons

Continue Reading »