Which of the following returns the sum of range A1:D1?
Correct Answer: =SUM(CHOOSE(1, A1:D1, A2:D2, A3:D3))
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
In the case of synchronizing changes between Table and model, a linked table is a live connection between the range or named table that contains the data values, and the Data Model that powers the report, by default. The Data Model is updated automatically if changes occur in _____?
What could you do to stop the pivot table from losing the column width upon refreshing?
Which option allows you to choose different Chart style options?
To create a drop down list box which only allows you to choose the value defined in range O1:O12 you need to setup:
Which table option gives you different background color for odd/even rows?
Which feature of Excel allows the user to limit the number of text characters in a cell?
By default, all cells in a workbook are:
Which of the following is not a predefined replacement for the [format] portion of the following expression? FORMAT (expression, [format])
One column of your PivotTables lists 500 dates over 2 years. How can you interactively filter the table to show just a range of dates?
Which of the following is an example of how you would use a data table?