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.

Spreadsheet and database

d.

Spreadsheet and statistical

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?

Table of the record the rental fee for each student

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: