CBSE Class 10 Computer Science Charts in Calc MCQs

(1) ........ is also considered as a graphical presentation of numerical data.

(A) Fontwork (B) A chart (C) A function (D) Legend

(2) The chart would be helpful in your business, but you need to know.........

(A) when to use a particular type of chart (B) what information it conveys

(C) which type of decisions can be made using such chart. (D) all of these

(3) According to ........ a chart type should be selected.

(A) the nature of applications (B) requirements

(C) both (A) and (B) (D) none of these Charts are used for .........

(4) ....... shows the usage of charts.

(A) For comparisons, for demonstration of distribution.

(B) For understating of situation, for analysis of trend over the time.

(C) For investigating deviations, for identifying and understanding the relationship between entities.

(D) All of these

(5) Making chart attractive is known as ........

(A) editing (B) renaming (C) formatting (D) deleting

(6) ........ is the first step to create a chart.

(A) Formatting data (B) Preparing data (C) Editing data (D) Deleting data

(7) Once ........ in a spreadsheet document, you can view it in a graphical manner.

(A) data are entered (B) data are formatted (C) data are renamed (D) data are saved

(8) ........ is useful to insert a chart.

(A) File -> Chart (B) Edit -> Chart (C) Insert -> Chart (D) Format -> Chart

(9) Chart tool button is on........tool bar.

(A) standard toolbar (B) formatting toolbar (C) drawing toolbar (D) database toolbar

(10) What is done before inserting a chart ?

(A) Chart is selected (B) Data range is selected (C) Data base is selected (D) Data is saved

(11) ........ dialog box is displayed when we select the option to insert a chart.

(A) Chart Type (B) Chart Data (C) Chart Wizard (D) Chart Database

(12) To make chart in spreadsheet is .........

(A) easy (B) friendly (C) sequence of steps (D) all of these

(13) User has just........while making a chart using wizard.

(A) to select data range (B) to select form range (C) to format data (D) to edit data

(14) Chart wizard has ........ steps.

(A) 3 (B) 4 (C) 5 (D) 6

(15) Which is the step of chart wizard ?

(A) Chart Type (B) Data Range, Data Series (C) Chart Elements (D) All of these

(16) Which is the first step of chart wizard ?

(A) Chart Type (B) Data Range (C) Data Series (D) Chart Elements

(17) ........ shows the usage of chart type.

(A) To select type of chart (B) To select 3D Look (C) To select shape (D) All of these

(18) We can also see preview of how a typical column chart looks. Choose the correct optic

(A) True (B) False (C) Can't say (D) None of these I

(19) Which is the type of chart ?

(A) Column, Bar, Pie (B) Area, Line, XY (Scatter) (C) Bubble, Net, Stock, Column and Line (D) All of these

(20) There are ........ types of charts in Calc.

(A) 10 (B) 11 (C) 12 (D) 13

(21) ........can be selected after selecting the chart.

(A) Look (B) Shape (C) Both (A) and (B) (D) Data Selection

(22) In chart type......type of look can be selectd

(A) 2D (B) 3D (C) 4D (D) 5D

(23) In........type of chart, 3D look can be select?

(A) column, bar (B) pie, area (C) both (A) and (B) (D) none of these

(24) ........ are the shapes in chart type.

(A) Box, Cylinder (B) Cone, Pyramid (C) Oval, Rectangle (D) both (A) and (B)

(25) What does the column show in the step chart type ?

(A) Chart Type (B) Look (C) Shape (D) None of these

(26) As soon as we select the first step of chart wizard, by default graph is displayed in the background. Choose the correct option.

(A) True (B) False (C) Can't say (D) None of these

(27) After completing the first step of chart wizard, calc displays the chart in which part ? 

(A) Upper part (B) In the background part (C) In another worksheet (D) Displays the chart after all the steps completed

(28) To display the predefined chart after which step a button is clicked ?

(A) First (B) Second (C) Third (D) Fourth

(29) What does second step of chart wizard show ?

(A) Give data range (B) To decide type of chart

(C) To select shape of chart (D) To decide elements of chart

(30) In........step, we have to select the range of dxata for chart.

(A) first (B) second (C) third (D) fourth

(31) ........is given after deciding the type of chart.

(A) Necessary data for chart (B) Necessary components for chart

(C) Necessary legend for chart (D) Necessary database for chart

(32) At what time data range can be given ?

(A) Data range can be selected previously (B) Second step of Insert —> Chart

(C) Both (A) and (B) (D) None of these

(33) What can be selected for data range ?

(A) Existing data of document (B) Data of any other document

(C) Both (A) and (B) (D) None of these

(34) Data range of other document can also be given while creating a chart. Choose the correct option.

(A) True (B) False (C) Can't say (D) None of these

(35) After entering the data in........, we can get its copy of spreadsheet.

(A) Writer (B) Draw (C) Impress (D) All of these

(36) ........sign is useful for absolute cell addresses.

(A) @ (B) % (C) $ (D) #

 (37) If the data is described in columns, which option is useful ?

(A) First row as label (B) First column as label (C) Data series in rows (D) Data series in columns

(38) If the data is described in rows, which option is useful ?

(A) First row as label (B) First column as label (C) Data series in rows (D) Data series in columns

(39) Data range can be selected as per user's choice. Choose the correct option.

(A) True (B) False (C) Can't say (D) None of these

(40) What does the third step of chart wizard show ?

(A) To select type of chart (B) To select data series (C) To select data range (D) To select shape of chart

(41) Which step of chart wizard give the feature of selecting data series.

(A) First (B) Second (C) Third (D) Fourth

(42) Which is the option of Data Series step.

(A) Data Series (B) Data Ranges (C) Range for name (D) All of these

(43) If we click select button in Data Series step, will make the chart .........

(A) small (B) medium (C) big (D) any of these

(44) If we click select button in Data Series sti where it will the user ?

(A) Chart Area (B) Worksheet Area (C) Data series Area (D) Database Area

(45) In Data Series, if we forget cell addresses ........ is useful.

(A) Data (B) Display (C) Select (D) Cell

(46) What does the fourth step of chart wizard ?

(A) To select data elements (B) To select data series

(C) To give data range (D) To select the data shape

(47) Fourth step of chart wizard gives the feature of selecting.........

(A) chart type (B) data range (C) chart elements (D) data series

(48) Which is the option of chart elements ?

(A) Title, Subtitle (B) X-axis, Y-axis, Z-axis (C) Display grids, Display legend (D) All of these

(49) Which step is used for titles, axis, legends, grid etc?

(A) Chart type (B) Data range (C) Chart elements (D) Data series

(50) Which option is used to give title to chart in chart elements ?

(A) Title(B) Subtitle (C) Add Title (D) Add Subtitle

(51) Which option is used to give sub title to chart in chart elements ?

(A) Title (B) Subtitle (C) Add Title (D) Add Subtitle

(52) How many axis are there for chart ?

(A) 1 (B) 2 (C) 3 (D) 4

(53) Which type of grid is available in chart wizard ?

(A) X-axis (B) Y-axis (C) Z-axis (D) All of these

(54) Which check box is selected for displaying legend ?

(A) Add legend (B) Show legend (C) Display legend (D) View legend

(55) How many options are there in display legend of chart elements ?

(A) 2 (B) 3 (C) 4 (D) 5

(56) Where the legend is displayed by default ?

(A) Left side (B) Right side (C) Top (D) Bottom

(57) When we click finish button, where the chart is displayed ?

(A) In the desired sheet (B) In the current worksheet (C) In sheetl (D) As per user's selected sheet

(58) Which of the following shows the component of a chart ?

(A) Chart area, data range, data series (B) Chart title, sub title, chart floor

(C) Chart axis, chart legends (D) All of these

(59) When data series is selected,........is displayed

(A) web of horizontal lines (B) web of vertical lines (C) Both (A) and (B) (D) web of cross lines

(60) ........is useful to know the values when values not displayed with chart.

(A) Axis with values (B) Data range with axis (C) Title and sub title (D) Chart area

(61) Which type of title can be given to the chart.

(A) Title (B) Sub title (C) Both (A) and (B) (D) Optional title

(62) What is the purpose of subtitle ?

(A) To display extra information (B) To display use of graph

(C) To display task given to the chart (D) Both (A) and (B)

(63) In which part of chart area, a chart is included ?

(A) Data series (B) Chart floor (C) Data range (D) Chart wall

(64) Data area is also known as .........

(A) Chart wall (B) Chart (C) Data series (D) Chart floor

(65) ........is the main component in chart area.

(A) Chart (B) Legend (C) Chart floor (D) Chart wall

(66) Chart is on........ part of area.

(A) left side (B) right side (C) in the middle (D) any of these

(67) Chart is also known as .........

(A) data series (B) data area (C) data floor (D) data wall

(68) Which type of data should be there in the chart ?

(A) Content related to data (B) Information related to chart (C) Textual data (D) All of these

(69) For each data series which type of color is selected ?

(A) Same (B) Different (C) User is asked to select color (D) None of these

(70) In which type of chart, chart floor is very important ?

(A) Bar chart (B) Column chart (C) Both (A) and (B) (D) Pie chart

(71) ........ can be used for mentioning series I units and objects on X and Y-axis.

(A) Data series (B) Data area (C) Chart area (D) Legend

(72) Where can legend be given ?

(A) On X-axis (B) On Y-axis (C) Both (A) and (B) (D) None of these

(73) Which method can be used to create a chart .

(A) Insert -> Chart (B) Chart Tool button (C) Both (A) and (B) (D) None of these

(74) A chart is insert ........before clicking finish button.

(A) in the previous worksheet (B) in the next worksheet (C) in the current worksheet (D) in sheetl

(75) Which option is true for charts ?

(A) Its location can be changed. (B) It can be copied (C) It can be moved (D) All of these

(76) Which mode is usedful to modify the charts ?

(A) Modify (B) Display (C) Edit (D) Change

(77).........is done to take chart to edit mode.

(A) Click on chart area (B) Double click on chart area (C) Right click on chart area (D) Drag the chart area

(78) If we take chart to edit mode, borders become in .......... color.

(A) gray (B) black (C) red (D) green

(79) To change parameters..........is done on chart.

(A) click (B) double click (C) right click (D) drag

(80) ..........is useful to change the type of graph.

(A) Edit -> Chart Type (B) Format -> Chart Type (C) View -> Chart Type (D) Tools -> Chart Type

(81) Chart Type dialog box gives ........feature.

(A) chart type (B) chart 3D look (C) chart shape (D) all of these

(82) Chart Type dialog box give how many types of charts ?

(A) 8 (B) 9 (C) 10 (D) 11

(83) Chart Type dialog box has which type of chart ?

(A) Column, Bar, Pie, Area (B) Line, XY (Scatter), Bubble

(C) Net, Stock, Column and line (D) All of these

(84) Chart Type dialog box has which types of shapes ?

(A) Box, Cylinder (B) Cone, Pyramid (C) Both (A) and (B) (D) Bar, Pie, Column

(85) By default the border of chart is .........

(A) visible (B) not visible (C) both (A) and (B) (D) none of these

(86) The style of border is.........

(A) continuous line (B) dotted line (C) thick line (D) all of these

(87) The chart area can be filled up using .........

(A) color (B) gradient (C) bitmap image (D) all of these

(88) Using font effect tab, which type of effectH be given ?

(A) Font color, Underline (B) Outline, Shadow (C) Overlining, Strikethrough (D) All of these

(89) X-axis dialog box gives the feature of ....... formatting.

(A) location of axis (B) labels of axis (C) font size (D) all of these

(90) Scale of X-axis are set by........ .

(A) user (B) automatic (C) administrator (D) any of these

(91) How are the axis labels ?

(A) Short (B) Descriptive (C) (A) or (B) (D) None of these

(92) Which is the tab of chart wall dialog box ?

(A) Borders (B) Area (C) Transparency (D) All of these

(93) Which feature is provided in chart wall dialog box ?

(A) Hide or unhide borders (B) Type and color of border (C) Thicness of border (D) All of these

(94) ........chart is circular.

(A) Column (B) Area (C) Pie (D) Stock

(95)........type of formatting can be done in a chart.

(A) Chart type, chart area (B) Data series, fonts, font effects

(C) Legend, chart floor , chart wall (D) All of these

(96) What does hyperlink show ?

(A) Data relation (B) Data option (C) Data address (D) Data axis

(97) Hperlink is connected to .........

(A) document (B) a part of document; (C) both (A) and (B) (D) source of document

(98) The text or document connected to hyperlink is known as.........

(A) Hyperweb (B) Hypertext (C) Hypersource (D) Hyerfont

(99) Hyperlink can be connected to .........

(A) chart (B) a part of chart (C) both (A) and (B) (D) chart type

(100) LAN stands for .........

(A) Logic Area Network (B) Local Area Network (C) Lanbase Area Network (D) Layout Area Network

(101) Chart can be connected to .........

(A) with current document (B) with new document (C) with a webpage (D) all of these

(102) ........ is useful to create hyperlink.

(A) View —> Hyperlink (B) Format -» Hyperlink (C) Insert —> Hyperlink (D) Edit -* Hyperlink

(103) ........ is the option of Hyperlink dialog box.

(A) Internet (B) Mail & News

(C) Document, New Document (D) None of these

(104) ........ type of link can be given in Hyperlink type dialog box.

(A) Web (B) FTP (C) Telnet (D) All of these

(105) FTP stands for ........ .

(A) File Transfer Protocol (B) Folder Transfer Protocol

(C) Frame Transfer Protocol (D) Form Transfer Protocol

(106) ........ is necessary to experiment hyperlink with a chart.

(A) Connection of e-mail (B) Connection of user

(C) Connection of internet (D) Connection of source

(107) ........ short cut key is important to follow hyperlinks.

(A) Ctrl + Alt (B) Ctrl + Enter (C) Ctrl + Shift (D) Ctrl + Tab

(108) To export the document having chart is having........extension.

(A) DOC (B) XLS (C) PDF (D) ODT

(109) PDF stands for.........

(A) Portable Document Format (B) Portable Document File

(C) Portable Document Folder (D) Portable Document Form

(110) ........is useful to export the file.

(A) Format -> Export (B) Edit -> Export (C) Tools -> Export (D) File -> Export

(111) Chart can be exported as ........ .

(A) PDF, DOC (B) PDF, XHTML (C) XHTML, DOC (D) XHTML, ODS \

(112) Exporting of chart can be done with ........ extension.

(A) .html (B) .xhtml (C) .pdf (D) All of these

(113) ........ type of information is given in PDF options dialog box to export chart as PDF. 

(A) Number of pages (B) Image forma (C) Bookmark (D) All of these

(114) Chart can be copied to which program ?

(A) Writer (B) Impress (C) Both (A) and (B) (D) All of these

(115) How to delete the chart ?

(A) Select the chart and press delete button (B) Select Edit -> Delete

(C) Right click on chart and select delete. (D) All of these

(116) How to print the chart ?

(A) File -> Print as (B) File -» Print (C) File —> Print preview (D) File -> Print view

(117) ........ is used to see the preview of chart ?

(A) Print preview (B) Page preview (C) document preview (D) graph preview