IGCSE Cambridge Secondary Grade 7 Study Materials, Online Learning, Question Papers, Classnotes, Practice Test, MCQ | Smartindia Educational Program : www.smartindia.net.in

Question-1
From which among the following sheet does the data can be imported to a worksheet?

(A) Spread	(B) Excel
(C) Work	(D) Chart

Question-2
Which menu contain the import external data option?

(A) Tool	(B) Table
(C) View	(D) Data

Question-3
Which chart illustrates comparisons among individual items?

(A) Column	(B) Line
(C) Bar	(D) Rice

Question-4
Which process is used for arranging data either in ascending or descending order?

(A) Filter	(B) Chart
(C) Sorting	(D) Import

Question-5 Which reference should have a fixed location that will not change when a formula is copied to another location?

(A) Absolute	(B)Relative
(C)Mixed	(D)Sort

Question-6 Which of the following identifies the location of a cell or group of cells in the spreadsheet?

(A) Relative reference	(B)Absolute reference
(C)Cell reference	(D)Mixed reference

Question-7
Which type of reference is known for an absolute column and a relative row, or absolute row and relative column?

(A) Absolute	(B) Filter
(C) Mixed	(D) Relative

Question-8
Which one of the following will convert the data into .xls format?

(A) Custom	(B) Char wizard
(C) Importing	(D) Filtering

Question-9
Which chart shows trends in data at equal intervals?

(A) Pie	(B) Bar
(C) Area	(D) Line

Question-10
Which among the following is used for arranging the data or records in an increasing order?

(A) Descending sort	(B) Data
(C) Ascending Sort	(D) Sorting

Click here to see your answersheet and detailed track records.

Cambridge Secondary Grade 7

IGCSE

Practice in Related Chapters
QBASIC - Graphics and Sound
Network and Communications
MS Excel Advanced Features
World Wide Web
QBASIC Programming Statements
Mail Merge
Animation in Presentation