0
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.
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.
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.
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.
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.
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.
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.
Please Wait you are being redirected....
You need to login to perform this action.You will be redirected in 3 sec
OTP has been sent to your mobile number and is valid for one hour
Your mobile number is verified.