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 menu contain the sort command for arranging the data in a specified order?

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

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

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

Question-3
Which filter helps to filler the list based on a specified criteria or to copy the filtered data to a different location?

(A) Auto	(B) Filtering
(C) Data	(D) Advanced

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

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

Question-5
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-6
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-7
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-8 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-9
Which menu had the auto filter option for filtering the data?

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

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