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

Question : 1

Which of the following is not true regarding Conditional Formatting?

a) You can add more than one condition to check

b) You can set condition to look for Bold and apply Italics on them.

c) You can apply Font, border and pattern formats that meets the specified conditions

d) You can delete any condition from Conditional Formatting dialog box if it is not required

e) None of these

Answer: (b)

Question : 2

In Excel when you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell

Answer: (b)

Question : 3

In Excel Documentation should include

a) Destination and users of the output data

b) Source of input data

c) Information on the purpose of the workbook

d) All of the above

Answer: (d)

Question : 4

Where can you change automatic or manual calculation mode in Excel?

a) Double CAL indicator on status bar

b) Go to Tools > > Options > > Calculation and mark the corresponding radio button

c) Both of above

d) Press F7

e) None of these

Answer: (b)

Question : 5

On an excel sheet the active cell In Indicated by...

a) A dark wide boarder

b) A dotted border

c) A blinking border

d) All of above

e) None of these

Answer: (a)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 7 Online Quiz

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