Which of the following options is used for displaying all the formulas in a spreadsheet?

Suppose you created an Excel table as shown in the image. You applied a formula on cell D2: =B2*C2. What will happen if you select cell D2 and drag the fill handle up to cell D6?

What happens when the Freeze Panes option is used on a few rows and columns?

Which option allows us to copy content without formatting?

By default, after how many minutes does Excel 2013 auto save a user's workbook?

If we make a right click on the 'Red Square box' as shown in the given image, it opens which of the following dialog boxes?

The Split command enables a user to view a worksheet in how many panes?

What is the correct function of the Format Painter option?

Sam wants to generate a Pivot table based on the data given in the image. He wants to show the count of employees for the values given in the Days column. For example, Days 5 = 3, Days 6 = 2, etc. Which of the following options will be the correct fields

Keyboard shortcut used to display or hide the ribbon in Microsoft Excel 2016?

Which cell reference in a formula should be used for making sure that a column value does not change when copied?