While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named 'Sheet5'?

Which tab should you select to make choices about how and when a video plays, if you have inserted or linked to a video on a video-sharing social media platform such as YouTube?

By default, how many worksheets are there in a new Microsoft Excel 2016 workbook?

The coach of the national cricket team wants to analyze the strengths and weaknesses of the team players. He has selected 4 major areas to analyze: fitness, flexibility, attitude and punctuality. Which of the following chart types will be most suitable in this situation?

Which is the correct method of consolidating data in Microsoft Excel 2016?

John wants to use a SmartArt graphic to create a chart for his organization. He wants to show the reporting relationships of his organization, such as managers of the departments and non-management employees. Which of the following SmartArt graphic types will be the most suitable for him to use?

Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?

How would you assign a macro to a graphic?

The default chart colors are determined by what?