Skip to main content

Posts

Showing posts with the label MS Excel Test Answers Upwork

MS Excel Test Upwork Answers 2019

1. Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true? Answers: • All cloned copies of that slicer are also updated instantly. • Only the original slicer reflects the changes being made. • An error is displayed because no updations are allowed in slicers having cloned copies. • None of the above. 2. Microsoft Excel Services is a component of: Answers: • Microsoft SharePoint Technology • Microsoft Server Technology • Microsoft Virtualization Technology 3. Which of the following statements is NOT true regarding import of data into PowerPivot? Answers: • Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query. • The data being imported into PowerPivot can be filtered before the import. • The PowerPivot Import Wizard provides you with an SQL Query builder. ...