10th Class Computers Science Analog and Digital Electronics Question Bank

done Assertion And Reason (MCQs) - Electronic Spreadsheet (Advanced) Total Questions - 7

• question_answer1)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Subtotal is a function that retunes a subtotal in a list.

  Reason (R): Subtotal allows us to make a total of given data into a group with row labels and column headers.

   
  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer2)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Macro is a pre-recorded set of actions or commands.

  Reason (R): The macro created once, cannot be deleted.

   
  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer3)
     

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Data Consolidation allows you to gather data from different worksheets into a master worksheet.

  Reason (R): The consolidate function lets you select data from its various locations and creates a table to summarize the information for you.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer4)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): What-if-analysis is a tool in that helps you runs reverse calculations, sensitivity analysis and scenarios comparison.

  Reason (R): Scenarios are a tool to test what-if questions. Each scenario is named, and can be edited and formatted separately.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer5)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Goal Seek is a tool that enables you to calculate a formula's input value when you want to work backwards from the formula's answer.

  Reason (R): You cannot replace the original value with Goal Seek resultant value.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer6)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): We can create only three scenarios for a given range of cells.

  Reason (R): Each scenario has a name.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow

• question_answer7)

  Direction: In the questions given below, there are two statements marked as Assertion (A) and Reason (R). Choose the correct option out of the choices given below in each question:

  Assertion (A): Spreadsheet software allows the user to share the workbook.

  Reason (R): We cannot unshare a spreadsheet, once it is shared.

  A)
  Both (A) and (R) are correct and (R) is correct explanation of (A). done clear
  B)
  Both (A) and (R) are correct and (R) is not the correct explanation of (A). done clear
  C)
  (A) is True but (R) is False. done clear
  D)
  (A) is False but (R) is True. done clear
  View Solution play_arrow