# Computers-MS-Excel [NCO- Cyber Olympiad (SOF) Class 9]: Questions 9 - 12 of 13

Access detailed explanations (illustrated with images and videos) to 522 questions. Access all new questions- tracking exam pattern and syllabus changes. View the complete topic-wise distribution of questions. Unlimited Access for Unlimited Time!

View Sample Explanation or View Features.

Rs. 350.00 or

How to register?

## Question number: 9

» Computers » MS-Excel » Data Tools

Edit

Appeared in Year: 2011

MCQ▾

### Question

For a social studies report, Farhan needs to illustrate the products of Big Bazaar with pictures and comparison graphs. He would most likely use which software programs?

### Choices

Choice (4)Response

a.

Clip art and drawing

b.

Graphing and clip art

c.

d.

## Question number: 10

» Computers » MS-Excel » Formula Auditing

Edit
MCQ▾

### Question

The first character that you should write in formula bar of MS-Excel is ________.

### Choices

Choice (4)Response

a.

+

b.

-

c.

@

d.

=

## Question number: 11

» Computers » MS-Excel » Data Tools

Edit
MCQ▾

### Question

To change the name of MS-Excel worksheet

(1) Right click on worksheet ‘sheet 1’

(2) Left click on worksheet ‘sheet 1’

(3) Double click on worksheet ‘sheet 1’

### Choices

Choice (4)Response

a.

2 & 3

b.

1 & 3

c.

1 & 2

d.

Question does not provide sufficient data or is vague

## Question number: 12

» Computers » MS-Excel » Working with Cell Range

Edit

Appeared in Year: 2011

MCQ▾

### Question

This spreadsheet is used to record the rental fee for each student in the middle school band. How would the total cost per year for all the instruments be calculated?

 A B C D E 1 Name Instrument Fee Per Month Number of Months Total Cost 2 Debbie Saxophone Rs. 45.00 10 Rs. 450.00 3 Kia Clarinet Rs. 35.00 10 Rs. 350.00 4 Samrat Trumpet Rs. 60.00 5 Rs. 300.00 5 Rohan Drums Rs. 55.00 0.00 6 Ben Flute Rs. 42.00 0.00 7 Total Rental Fee Rs. 1100.00

### Choices

Choice (4)Response

a.

By adding cells C7 through E7

b.

By adding cells C2 through C6

c.

By adding cells E2 through E6

d.

By adding cells D2 through D6

Developed by: