Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

Case-sensitive sorting of text in Excel2007 can be performed.

Which type of additional information is stored within the digital signature?

When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

If you have a workbook with links to another workbook, but the links haven't updated automatically, how can you update them manually?

What is the Mini Toolbar used for?

How will you apply restrictions on data entry except the whole number to selected cells on the worksheet?

How do you create a range for a sum function that anchors itself on A1, but will increase in range downwards as you drag and drop the formula?

Cell A1 contains the formula =$F39. Copying that formula to cell B2 will result in: