Microsoft Excel | MCQs

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.

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.

Explanation

The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.

****

ND20-1-2023

Explanation

The active cell displays the results of its formula while we see the formula itself in the Formula Bar. 

Explanation

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data.

Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

Explanation

• move to the next cell in the sheet in ms excel: shift + page down
• ***
• move to the next cell in the row in ms excel: Tab
• ***
• MS Excel stands for Microsoft Excel
  

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

   Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

• In MS Excel, automatically total a column or row of values: SUM

Explanation

• ctrl +', keys are used in ms excel to copy formulas from the above cell
• ***
• 
  
  

Explanation

Data Source is a name given to the connection set up to a database from a server. 

Explanation

Right-click the tab and choose Delete from its shortcut menu in All version of excel.

In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS

Microsoft Excel 2007 and earlier Press ‘ALT’ + ‘E’, then the ‘L’ key.

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

vu FIA CBT PAPER 15-12-2021