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

Question : 26

How many worksheets can a workbook have?

a) 3

b) 8

c) 255

d) All of above

e) None of these

Answer: (d)

Question : 27

Which area In an Excel window allows entering values and formulas?

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

e) None of these

Answer: (c)

Question : 28

In Excel to view a cell comment

a) Click the edit comment command on the insert menu

b) Click the display comment command on the window menu

c) Position the mouse pointer over the cell

d) Click the comment command on the view menu

Answer: (c)

Question : 29

A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button......

a) nothing will print because some cells with data have been omitted

b) only the cells with gray back-ground will print

c) the whole sheet will print

d) only the cells with white background will print

e) None of these

Answer: (d)

Question : 30

In Excel what does SUMIF function do?

a) Adds up cell values based on a condition

b) Adds all the numbers in a range of cells

c) Returns a subtotal in a list or database

d) All of above

Answer: (a)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 11 Online Quiz

Click to Start..
417 microsoft excel qa based computer MCQ MS excel set 11 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

New 150+ Percentage Questions For IBPS Clerk Prelims 2024

Free Top Percentage Quants Aptitude based Multiple Choice Questions and Answers Practice Test Series, Quiz PDF & Mock Test for IBPS Clerk Prelims 2024 Exam

04-May-2024 by Careericons

Continue Reading »

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 »