HomeLearn Fast select Course
Change UnitChange SubjectLast Menu
CBSE-IX-Foundation of Information Technology .

11: MS-Excel 2007

 digibest Free NCERT Solutions with no signup needed page 5

Note: Please signup/signin free to get personalized experience.

Note: Please signup/signin free to get personalized experience.

10 minutes can boost your percentage by 10%

Note: Please signup/signin free to get personalized experience.

  
  • Qstn #17
    If you type =2 * (6-4) in cell Al, what value will be display?
    (a) 2 (b) 4 (c) 6 (d) 8
    digAnsr:   b
    Ans : (b) = 2*(6-4) = 2*(2) = 4
  • Qstn #18
    You can place the chart legend in the chart at .................
    (a) Bottom (b) Corner
    (c) Top, Right and Left (d) All of these
    digAnsr:   d
    Ans : (d) You can place the chart legend in the chart at Bottom, Corner, Top, Right and Left.
  • Qstn #19
    In Excel chart, text displayed at data points to indicate the specific category is called .................
    (a) data point (b) data series
    (c) data label (d) legends
    digAnsr:   c
    Ans : (c) Text displayed at data points to indicate the specific category is called data label.
  • Qstn #20
    You have used a spreadsheet to calculate the average marks of a class in Mathematics. Which input is essential to find the average marks?
    (a) Marks of each student of class in Science
    (b) Marks of each student of class in Mathematics
    (c) Average marks in Mathematics of each student of class
    (d) Names and roll numbers of each student of class
    digAnsr:   b
    Ans : (b) Marks of each student tor Mathematics will be required for calculating average marks of mathematics.
  • Qstn #21
    A chart is created on the basis of values in ..................
    (a) mail merge (b) database
    (c) spreadsheet (d) document
    digAnsr:   c
    Ans : (c) A chart is a pictorial representation of data that created on the basis of values in a spreadsheet.
  • Qstn #22
    Which of the following charts is used for comparing the changes in data over a period of time?
    (a) Bar chart (b) Area chart
    (c) Scatter chart (d) Line chart
    digAnsr:   d
    Ans : (d) Line chart emphasizes on rate of change rather than volume of change over time.
  • Qstn #23
    Which of the following chart selects only one range of the data series?
    (a) Line chart (b) Pie chart
    (c) Scatter Chart (d) Bar chart
    digAnsr:   b
    Ans : (b) Pie chart can select only one range of the data series.
  • Qstn #24
    The another name for the XY chart is ...................
    (a) Column chart (b) Net chart
    (c) Bar chart (d) Scatter chart
    digAnsr:   d
    Ans : (d) XY chart is also called Scatter chart.
  • Qstn #25
    Which of the following shortcut keys brings the cursor to the last cell on the sheet that contains data?
    (a) Ctrl+Home (b) Ctrl+End
    (b) Ctrl + Page down (d) Ctrl+down arrow
    Ans : (b) Ctrl+End shortcut is used to bring the cursor to the last cell.
  • Qstn #26
    For selecting a non-continuous range of cells, you need to do what?
    (a) Press Alt key (b) Press Shift key
    (c) Press Esc key (d) Press Ctrl key
    digAnsr:   b
    Ans : b By pressing Ctrl key and clicking on the desired cells a non-continuous cell range can be selected.
  • Qstn #27
    For selecting the entire worksheet in Excel, you need to press ...................
    (a) Alt + Shift +eSpacebar
    (b) Ctrl + Shift + Spacebar
    (c) Shift + Spacebar
    (d) None of the above
    digAnsr:   b
    Ans : (b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.
  • Qstn #28
    The sample of an Excel worksheet on the screen can be seen by ....................
    (a) Print preview
    (b) Print
    (c) Review
    (d) None of the above
    digAnsr:   a
    Ans : (a) Print preview enables you to view the sample of worksheet before printing it on a paper.
  • #
    Section : F
    Fill in the Blanks
  • Qstn #1
    Excel is a ................... software package.
    Ans : spreadsheet
  • Qstn #2
    When you ............. or ................ , the selected range gets surrounded by a moving border.
    Ans : copy, cut
next page