How many maximum characters are possible in Microsoft Excel password?.

When a workbook is marked as final the options without editorial rights are still enabled such as:.

Typing, editing commands and proofing marks are disabled and turned off.

When a workbook is marked as final it becomes read-only.

Microsoft Excel cells that you cannot change values in are called:.

Microsoft Excel offers a hierarchy of security features enabling users to protect their work.

You can export data to a text file simply by saving the worksheet with a:.

Examples of storing data in an external data source include:.

In Microsoft Excel вЂњWhat IF analysisвЂќ is carried out using the following tool:.

SUMIF (sum_range, criteria_range1, criteria1, вЂ¦).

IF (logical_test, value_if_true, value_if_false).

IF(value_if_false, logical_test, value_if_true).

IF(logical_test, value_if_false, value_if_true).

IF(value_if_true, logical_test, value_if_false).

The general syntax of the IF function of Microsoft Excel is:.

Which of the following is a вЂGo To SpecialвЂ™ option?.

Select the cells that contain number between 0 and 100 then click Red color on Text Color tool.

Apply Conditional Formatting option from Home tab.

Use = if () function to format the required numbers red.

In Microsoft Excel, when all the numbers between 0 and 100 in a range are to be displayed in Red Color, you may apply the following:.

Which sales clerks achieved PKR 300,000 sales this month.

Which of the following is a use of Conditional formatting?.

To apply a percent style format to a cell in Microsoft Excel using shortcut keys, press the following:.

In MS Excel, if the number format of a cell has been customized to вЂњ+#-42#-#вЂќ and 12325678 is entered in the cell, it will be displayed as:.

This is available as a вЂspecialвЂ™ number format accessible from which of the following dialog box.

Microsoft Excel provides a special number format that allows a number to be entered as a Phone number.

In Microsoft Excel, the small black square located in the lower-right corner of the heavy border around the active cell is called:.

Limited by the available amount of memory.

The number of Microsoft Excel worksheets that you can add to a workbook is:.

The horizontal and vertical lines on Microsoft Excel worksheet are called:.

Which keyboard key is used to display a key tip badge in Microsoft Excel?.

If today is Saturday then what will be the result of this Microsoft Excel function =WEEKDAY (TODAY (),1).

To enter a time or date that stays current when you reopen a worksheet use the:.

Use the sort button on the Data tab on the ribbon.

Right-click the table and then point to Sort on the shortcut menu.

Click the Sort & Filter button on the Home tab on the ribbon.

You can sort data in Microsoft Excel table using which of the following techniques?.

The basic unit of a Microsoft Excel worksheet into which you enter data is called:.

It is a feature of Microsoft Excel that works behind the scenes, correcting different types of common mistakes.To enter a number as text in Microsoft Excel worksheet, start the entry with:.

More than one worksheet at the same time.There are numerous options for manually entering data into worksheet cells.The Keyboard shortcut key for Print Preview is:.A template is a _ workbook designed for a specific purpose such as tracking sales or budgeting.Microsoft Excel opens a new workbook with how many default worksheets?.Open a new workbook in addition to the already open workbook.If Excel is already open click New + Blank workbook on the File tab.You can press CTRL +N whilst in an existing workbook to quickly create a new, blank workbook.The basic components of an Excel workbook include the following except:.A workbook is a file that contains _ worksheets (also called spreadsheets) that can be used to organize various kinds of related information.Animate your slides to give them greater visual impact.Which of the following is not a use of Microsoft Excel?.

Merge and center in excel is grayed out