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 of the following is used to create a chart?

(A) Insert	(B) Chart wizard
(C) Data	(D) Spreadsheet

Question-2
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-3
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-4
Which menu had the auto filter option for filtering the data?

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

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

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

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

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

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

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

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 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-10
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

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