MS | MCQs

Explanation

We can use the format painter multiple times before we turn it off by double clicking the format painter button.

Explanation

Explanation

Explanation

Explanation

F11 Creates a chart of the data in the current range in a separate Chart sheet.

Some important shortcuts used in MS Excel

•F1 Opens Excel Help

•F2 Edit contents of an excel

•F3 Paste Named Range or Named List

•F4 Toggles between cell references - Absolute, Relative, and Mixed Reference

•F5 Displays the "Go To" dialog box

•F6 Switch between the panes of an Excel workbook if you have a split window

•F7 Opens the "Spelling" option in Excel using which you can check the spellings in your workbook

•F8 Enables and disables the "Extend Mode" selection in Excel.

•F9 Recalculates the output of all formulas in your Excel workbook.

• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips

• F12 Opens the "Save As" dialog box like the "Alt + F2" keys

Explanation

 Columns are denoted and identified by a unique alphabetical header letter,

which is located at the top of the worksheet.

*************

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

• You can detect spelling and grammar errors by press F7
• ***
• F7 is commonly used to spell check and grammar check a document in Microsoft programs such as Microsoft Word, Outlook, etc.

• **** 

  RY18012023

  SH4-9-2023

  
  

Explanation

DATE: returns the serial date value for a date

TODAY: returns today's date

NOW: returns the current date and time

TIME: assemble a proper time.

***

RY24012023

Explanation

With format painter, you can copy all of the formatting from one object and

apply it to another one—think of it as copying and pasting for formatting.

Explanation

Ctrl-D deletes all characters to the right of the cursor (including the character under it).

This is called `Delete to end of the line'.

*****
The cursor is a Thin Blinking Line