Excel | MCQs

Explanation

The VLOOKUP is used when data is listed in columns.

This function searches for a value in the left-most column 

You can use VLOOKUP to find data in a sorted or unsorted table.

VLOOKUP stands for Vertical Lookup function

Explanation

"Link to home" is not a valid option to insert a hyperlink in Excel.

Additional information:

To insert a hyperlink in Excel, you can follow these steps:

1. Select the cell or text where you want to insert the hyperlink.

2. Right-click on the selected cell or text and choose "Hyperlink" from the context menu. 

3. In the "Insert Hyperlink" dialog box, you will see different options to choose from.

- "Existing File or Web Page"

Explanation

Freeze columns and rows in Excel

• Select the row below the row(s) you want to freeze (select row 6 if you want to freeze rows 1 to 5).
• On the View tab, click Freeze Panes > Freeze Panes.

Explanation

The cell margin is the distance between the cell border

Cell contents and is specified for all four sides of a cell

How to Change Margins in Excel?

Click on Page layout tab.

Explanation

By default, Excel uses the A1 reference style,

which refers to columns as letters

 and refers to rows as numbers

 These letters and numbers are called row and column headings.

Type the column letter followed by the row number.

Explanation

 press Ctrl+1 to open the Format Cells dialog box.

In the Format Cells dialog box, in the Category list, click Currency or Accounting.

ND7-5-2023

CTRL+Shift+4 is used for Currency Format. CTRL+Shift+1 is used for decimal Format Shift +1 is used to insert ! CTRL+1 is used to open "Format Cells" Dialogue Box

Explanation

•  In a computer spreadsheet, each cell contains a Label, value, formula
• in a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of formulas
• n a computer spreadsheet block of numbers is called a range
• In a computer, spreadsheet rows are labeled: By numbers
• In a spreadsheet, letters are used to represent Columns
  
• In a computer spreadsheet, a function that is used to count a number of entries in a given range is called length
• 
  

Explanation

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

Explanation

The F5 key is a function key found at the top of almost all computer keyboards.

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

VU  FIA SUB INSPECTOR  PAPER 30-1-2021

Explanation

• statistical calculation and preparation of tables and graphs can be done using  excel 
• **
• Explanation:
• The MS-Excel is a part of the office package or software which is used for the calculation or manipulation of data with the help of mathematics formulas.
• It is also used to hold the records in the form of rows and tables.
• It also presents the data in the form of a graph.