The correct answer is Bullets and Numbering.

• Bullets and Numbering feature of MS Word help to create a list in a document.

Key Points

• Bullets and Numbering are used to create a list in documents in MS word.
• To create a list in MS Word:
  • Select text required to format as a list.
  • Click on Bullets or Numbering drop-down option on Home tab.
  • Select bullet or numbering style required, and it will appear in document.
  • 

Additional Information

• Word wrap is a word processing feature that automatically transfers a word that has no insufficient space from end of one line of text to beginning of next.
• Scaling in MS Word is anor text effect to make text larger or smaller.
• WordArt is used to create decorative effects to  text styles

The correct answer is Home Tab

Key PointsHome is one that contains commonly used formatting options like font style, size, and alignment. 

The correct answer is a - iv, b - iii, c - i, d - ii

Key Points

a. =LEFT("Microsoft Excel", 6)

• Extracts first 6 characters from "Microsoft Excel".
• Output: iv) Micros

b. =LOWER("HELLO WORLD")

• Converts string "HELLO WORLD" to all lowercase letters.
• Output: iii) hello world

c. =SUM(10, 5, 11)

• Sums up numbers 10, 5, and 11.
• Output: i) 26

d. =AVERAGE(100, 120, 150)

• Calculates average of numbers 100, 120, and 150.
• Output: ii) 123.33

An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store text and numbers and merged into a single workbook knows as a File. ?Workbooks are Excel files that one can open and share, while Excel worksheets are individual spreadsheets within m. Function Key Shortcuts:

• F2: Edit Cells
• F4: Anchor Cells
• F7: Spell Check
• F11: Generates a bar graph from values entered
• F12: Save As
• SHIFT + F2: Insert a Comment
• SHIFT + F8: Add to Selection
• SHIFT + F10: Right Click
• SHIFT+F11:  Insert a new worksheet
• CTRL +F2: Switch to Print Preview
• CTRL + F3: Name a Cell
• CTRL+F9 Minimize workbook window
• CTRL +N :Create a new workbook
• CTRL +W :Close a workbook
• Windows Flag + D: Minimize Programs
• ALT+N: Open Insert tab
• ALT+H: Go to Home tab

The correct answer is CTRL + N.

Key Points

• Create a new document with Ctrl+N. 

Additional Information

• Basic computer shortcut keys
  • Ctrl + M -- Indent paragraph.
  • Ctrl + B -- Bold highlighted selection.
  • Ctrl + D -- Font options.
  • Alt + F--File menu options in current program.
  • Alt + E--Edits options in current program.
  • F1--Universal help (for any sort of program).
  • Ctrl + A--Selects all text.
  • Ctrl + X--Cuts selected item.
  • Ctrl + Del--Cut selected item.
  • Ctrl + C--Copy selected item.
  • Ctrl + Ins-- Copy selected item.
  • Ctrl + V--Paste selected item.
  • Shift + Ins -- Paste selected item.
  • Home -- Takes user to beginning of current line.
  • Ctrl + Home--Go to beginning of document.
  • End -- Go to end of current line.
  • Ctrl + End -- Go to end of a document.
  • Shift + Home -- Highlight from current position to beginning of line.
  • Shift + End -- Highlight from current position to end of line.
  • Ctrl + (Left arrow) -- Move one word to left at a time.
  • Ctrl + (Right arrow) -- Move one word to right at a time.

The correct answer is Text.

• The 'LEN' function in MS-Excel belongs to text.

Key Points

• LEN function in excel is taken from length and is used to count number of characters is re in a cell.
• It considers special characters, spaces and alphabets and counts all se values if re is a selected cell.
• LEN function only counts character length for only one cell.
• Example to use LEN function:

?   

Additional Information

• Financial functions in EXCEL are FV Function, IPMT, XIRR in Excel, PMT Function, IRR Excel Function, RATE Function, NPV Function, etc.
• Logical functions in EXCEL are AND Function, NOT, OR Excel Function, TRUE Function, IFERROR Excel Function, Excel XOR Function and Excel Lo
• Math functions in EXCEL are EVEN Excel Function, SUM Function, POWER Function, SUMIF and LOG Excel Function.

The correct answer is  Title bar.

Key Points

• Microsoft Excel consists of basic components like an Active cell, title bar Column headings, a Formula bar, a Name box, a mouse pointer, Row headings, Sheet tabs, a Taskbar, Tab scrolling buttons, and Toolbars.
• The title bar displays both name of application and name of spreadsheet.?

Additional Information

• A toolbar is just a collection of icons that provides a shortcut to using a drop-down menu.
• A quick access toolbar shows options that are frequently used.
  • The user can add favorite options by adding new options to quick access toolbar.
• The Menu Bar at top of screen gives access to different commands that are used for tasks such as opening and closing files, printing documents, formatting data, and or operations.

?

The correct answer is Ctrl + click on a sentence to select it.

• Triple-click (Ctrl + click) on a sentence to select it is used to select a sentence in a paragraph in MS Word.

Mistake Points

• Double click can only select a single word but Ctrl+Click on a statement can select complete statement. Hence option 3 is correct and 4 is incorrect.

Key PointsShortcut in MS word for selection:

• To select current word, double-click on it.
• To select current paragraph, triple-click on paragraph.
• To select a sentence and not just a line, hold down [Ctrl] and click once in any place within sentence.
• To select a vertical block of text, click at start of block. Later, hold down [Shift] key and click a second time at opposite end of block. This trick is used when only want to copy one column of a tabular list

Approach (to find difference in shortcut)

These can be easily understood if you do it practically on MS word as it has very minute differences which you need to see while performing and reading each point. 

The correct answer is Ctrl + F2.

• Ctrl + F2 function key displays Print Preview window in Microsoft Office.

Key Points

• Print Preview function lets users see pages that are about to print and allows  users to see exactly how pages will look when y are printed.
• This feature allows you to see exactly how your pages will look when y are printed.
• We can print directly from Print Preview page by clicking on print button  or printer icon .

Additional Information

The correct answer is Shift + Space.

• Short-cut key to Select entire row in M.S. Excel Worksheet is Shift + Space.

Key Points

• This table lists most frequently used shortcuts in Excel.