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 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-2
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-3
Which process is used for arranging data either in ascending or descending order?

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

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

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

Question-5
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-6
Which chart illustrates comparisons among individual items?

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

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

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

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

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

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

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

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