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

microsoft excel q/a PRACTICE TEST [13 - 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

Question : 26

In Excel AutoCalculate will quickly add selected cells if you

a) right click on the status bar and select Sum

b) click the AutoCalculate button on the toolbar

c) use the key combination Ctrl+$

d) double click the selection

Discuss »

Answer: (b)

Question : 27

The Trace Dependence in auditing shows

a) Which cells are used in current formula

b) In which formula the current cell is used

c) Which cells are used in this formula and in which formula this cell is used

d) All of above

e) None of these

Discuss »

Answer: (b)

Question : 28

You can use the formula palette to

a) format cells containing numbers

b) create and edit formulas containing functions

c) entered assumptions data

d) copy a range of cells

e) None of these

Discuss »

Answer: (b)

Question : 29

The default and maximum number of sheets for a new workbook in Excel 2003 is

a) 3 and 255

b) 3 and 256

c) 1 and 255

d) 1 and 256

e) None of these

Discuss »

Answer: (b)

Question : 30

In Excel using the AutoSum button will replace in the selected cell

a) the sum of values in the cell’s column

b) nothing until you select a range of cells

c) the sum of the cell’s row unless you change the range

d) a formula which will add values in the range Excel guesses you want to add

Discuss »

Answer: (d)

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
microsoft excel q/a Shortcuts and Techniques with Examples
computer MCQ CATEGORIES
RECENT BLOGS
SSC CHSL Exam Centres 2023 Tier 1 & 2: State-Wise Apply Link
SSC CHSL Exam Centres 2023 Tier 1 & 2: State-Wise Apply Link Read more...
SSC CHSL 2023 Tier 2: Syllabus PDF & Exam Pattern [Changed]
SSC CHSL 2023 Tier 2: Syllabus PDF & Exam Pattern [Changed] Read more...
SSC CHSL Tier 1 Revised Syllabus 2023 & New Topics List PDF
SSC CHSL Tier 1 Revised Syllabus 2023 & New Topics List PDF Read more...
SSC CHSL 2023 Tier 2 New Revised Exam Pattern & Syllabus PDF
SSC CHSL 2023 Tier 2 New Revised Exam Pattern & Syllabus PDF Read more...

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 »