Microsoft Excel and SharePoint Fundamentals

SPSecurity.RunWithElevatedPrivileges executes the specified delegate under the context of the Sharepoint System Account (SHAREPOINT\SYSTEM), allowing users with insufficient permissions to run code that performs privileged operations. The other options do not elevate execution privileges.

The dynamic token ~masterurl/custom.master is used in SharePoint page layouts and site definitions to reference the custom master page of a site. Setting the MasterPageFile to this token allows the page to dynamically inherit the custom master page configured for the site.

In MOSS 2007, creating a hold prevents documents and records relevant to an active audit or litigation from expiring or being deleted, regardless of their standard retention policy. Record routing, database role modifications, and information management policies do not provide this specific temporary suspension of expiration.

Onet.xml defines the basic structure, lists, and document templates for a site definition, including custom navigation configurations. Schema.xml defines list schemas, VWStyles.xml defines view styles, and WebTemp.xml registers site templates with the system.

This is a specific SharePoint 2007-era question. The Single Sign-On (SSO) service for Business Data Catalog (BDC) was accessed through the Microsoft.SharePoint.Portal assembly namespace. The SSO provider enabled secure credentials storage for connecting to external business systems.

In spreadsheet applications like Excel, pressing CTRL+; (semicolon) enters the current date into the active cell. The similar shortcut CTRL+SHIFT+: (colon) enters the current TIME, not the date. CTRL+F8 and CTRL+F10 are not related to date/time entry. This is a useful shortcut for quickly timestamping data.

The Insert Function dialog box in Excel is accessed by clicking the Insert menu and then selecting Function. This opens a dialog that helps you search for and insert functions with their arguments. Right-clicking a cell and choosing Insert inserts cells or rows/columns, not functions. Typing $ creates an absolute reference, and typing = simply begins a formula entry.

The CONVERT function in Excel performs unit conversions between different measurement systems, such as miles to kilometers, kilograms to pounds, Celsius to Fahrenheit, and many others. It accepts three arguments: the value, the from_unit, and the to_unit. PRODUCT multiplies numbers, while CHANGE and CON are not valid Excel functions for unit conversion.

Solver is Excel's optimization tool used to find optimal solutions for models with constraints. It can maximize, minimize, or set a target value by adjusting variable cells within specified constraints. Scenario Manager only compares different scenarios but doesn't optimize. 'Target value' is not a tool but rather a parameter used within Goal Seek or Solver.

The AND function returns TRUE only when ALL its arguments evaluate to TRUE. This makes it perfect for checking that multiple conditions are all satisfied simultaneously. For example, =AND(A1>10, B1<20) returns TRUE only if both conditions are met. OR returns TRUE if ANY condition is true, IF evaluates a single condition, and VLOOKUP searches for values.

The IF function evaluates a condition and returns one value if TRUE and another if FALSE, allowing different results based on the entered condition. The syntax is =IF(condition, value_if_true, value_if_false). SUM simply adds values, SUMIF adds values meeting a condition, and TrueFalse is not a valid Excel function.

The split box in Excel is a small tool (usually located above the vertical scroll bar) that allows you to split the worksheet window into two or four panes. Each pane can independently scroll through different parts of the same worksheet, making it easier to compare distant sections or keep headers visible while scrolling through data. The title bar displays the filename, the scroll bar moves the view, and the toolbar contains command buttons.

Ctrl+Home is the universal keyboard shortcut in spreadsheet software like Microsoft Excel to jump to cell A1, which is the top-left corner of the worksheet. PageUp only moves up one screen at a time, while Ctrl+left arrow moves to the left edge of the current data region, not necessarily to the top.

To print column headings on each page in Excel, you need to use the 'Print titles' feature in Page Setup. This is found under the Sheet tab where you specify which rows contain the column headings. These rows will then repeat on every printed page, making large multi-page printouts easier to read. The other options either don't address this specific need or are incorrect menu paths.

To print only a selected area of a worksheet, you use the Print dialog and choose 'Selection' under the 'Print what' section. This tells Excel to only print the cells you've highlighted, not the entire worksheet. The 'Set Print Area' option defines a persistent print range but doesn't immediately print, while Custom Views is for saving different display configurations.

In Excel 2002, the Text-to-Speech feature is activated by pointing to Speech on the Tools menu and clicking Show Text To Speech Toolbar. This feature can read data as you enter it for verification.

To paste formula results (values only), you click the arrow on the Paste button and select Values. This pastes the calculated result without the underlying formula.

Format Painter copies formatting from one cell to others. Double-clicking Format Painter keeps it active for multiple cells. Clicking once applies it once; double-clicking allows applying to multiple cells sequentially.

The best method to balance a checkbook in Excel is to download the Checkbook Register template from Microsoft Office Online templates. This provides a pre-formatted template designed specifically for checkbook management.

The PMT (Payment) function calculates periodic payments needed to reach a future value. To save $60,000 in 18 years, PMT can determine the monthly savings amount required given an interest rate and time period.