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

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

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

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

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

Question-3
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

Question-4
Which of the following is used for arranging the data or records in a descreasing order?

(A) Ascending sort	(B) Descending Sort
(C) Filtering	(D) Custom

Question-5 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-6
Which of the following is a graphical representation of information?

(A) Chart	(B) Line
(C) Map	(D) Spreadsheet

Question-7
Which menu contain the sort command for arranging the data in a specified order?

(A) Tools	(B) Data
(C) Table	(D) None of these

Question-8
Which option of auto filter is used when a range has to be specified or there is a specific condition to filter the data?

(A) Advanced	(B) Relative
(C) Custom	(D) Remove

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

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

Question-10
Which menu had the auto filter option for filtering the data?

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

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