Explanation

All elements of a worksheet can be protected from accidental modification.

To protect a worksheet in Excel 2007 and higher versions, click the Review tab, click Protect Worksheet (or Protect Sheet), and click OK.

Excel 2003 and Earlier Versions click Tools > Protection, click Protect Sheet, and click OK.

Explanation

In Excel, a Data Series is defined as a collection of related data.

Explanation

To edit an embedded Excel worksheet's contents or resize in the future in Word,

you must return to editing mode.

 by double-clicking the embedded Excel worksheet object in the document to switch back to Excel.

Press and hold the Ctrl key on your keyboard.

Select the next worksheet you want in the group.

Explanation

Explanation

The purpose of inserting header and footer in the document to allow page headers and footers to appear on the document when it is printed.

دستاویز میں ہیڈر اور فوٹر داخل کرنے کا مقصد صفحہ کے ہیڈر اور فوٹر کو دستاویز کے پرنٹ ہونے پر ظاہر ہونے کی اجازت دینا ہے۔

Explanation

A constant is a set value that doesn't change and that's directly inserted into a cell.

It's not a formula and it's not calculated by a formula.

*******

VU CBT FIA  PAPER 19-12-2021

Explanation

• Pressing the Esc key cannot be used to enter data in a cell in MS Excel
  
• Esc key is used to interrupt or cancel the current process or running program, or to close a pop-up window.

Explanation

The Format Painter copies formatting from one place and applies it to another.

Explanation

A function is a predefined formula that performs calculations using specific values in a particular order.

All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.

Explanation

 Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.