Ribbon can be customized by creating new tabs that house your desired commands. Which of the following statements is/are correct about Ribbon customization?

Robert inserts a PivotTable in Sheet 2 of a worksheet. He drags the 'Days' field from the PivotTable Fields to Values section. Which of the following options will be the default selection under Values?

Which of the following is NOT a valid option for language settings?

Which statement is correct about Microsoft Excel Online?

Mary wants to copy a worksheet from WorkBook1 to WorkBook2. Which of the following is correct about this scenario?

Which is not a type of expansion slot?

We can use Excel's _____________ feature to see how the pivot table would look in any style

Which of the following sorting options is NOT available under the Sort On dropdown menu in Sort dialog box while sorting the data of a table in an Microsoft Excel 2013 worksheet?

Keyboard shortcut used to switch between relative and absolute cell references while writing a formula in a worksheet?

Which option should be used if you want to prevent other users from opening a file? i) File encryption ii) Mark as Final

While creating a new workbook or editing an existing one, some personal information might get added to the file automatically. If you want to share this workbook with others, then which of the following options will you use to remove such additional personal information?