Spreadsheet Software | MCQs

Explanation

In MS Excel, all formulas and functions start with the equal sign (=).

This tells Excel to perform a calculation instead of treating the input as plain text.

Explanation

After = symbol you can enter either a calculation or functions

*****

*********

FIA VU CONSTABLE PAST PAPER 2021

Explanation

In MS Excel ready-made templates are available under file tab in new option .

When considering Microsoft Word, Microsoft Excel, Microsoft Power Point, the templates are in files tab

_____________________________________-

 Use Excel's Table command to convert a list of data into a named Excel Table.

These tables have useful features, like sorting and filtering, to help organize and view data.

Explanation

• A worksheet is an electronic spreadsheet that lets users to Calculate, Enter & Analyze data.
  

  A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.

  
  

Explanation

MS Excel (Microsoft Excel) is a popular spreadsheet software program used for data analysis, calculation, and visualization.

It allows users to create and edit spreadsheets, charts, and graphs.

It is widely used in various fields such as business, finance, and education.

MS Excel is a part of the Microsoft Office suite and is used for:

• Data entry and management
• Calculations and formulas
• Chart and graph creation
• Data analysis and visualization
• Budgeting and forecasting

In MS Excel you can enter 3 types of Data in a cell,labels, values and formulas.

Explanation

Microsoft Excel is a spreadsheet software widely used for creating tables of columns and rows for statistical or mathematical calculations.

It provides various features such as formulas, functions, charts, and pivot tables to manage and analyze data.

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

Formula Bar area in an Excel window allows entering values and formulas.

It is labeled with a function symbol (fx).

By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Explanation

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet

Explanation

For highlighting a column CTRL+space is used.

while

Shift + space is used for row.

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

***

Which is the shortcut key to display active cells in Excell?

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

***

Which key is used for the GO TO tab in Ms. Excel?

 F5 

***

Which key is used for excel column highlight?

CTRL + space

****

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

ND11-3-2023

ND29-5-2023