Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

SH31-07-23

ND30-4-2023

Explanation

MS-Excel is based on Windows.

MS-Excel is a spreadsheet

Developed by Microsoft for Windows.

It is a program that stores and retrieves numerical data in rows and columns of grid format.

Explanation

Times New Roman and Arial are examples of font faces, or typefaces:

Times New Roman

• A transitional serif typeface designed by Stanley Morison and Victor Lardent for The Times newspaper in 1931.

Arial

• A sans-serif typeface designed by Robin Nicholas and Patricia Saunders in 1982.

Explanation

When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked.

In Embedded objects file become part of document and does not get updated when source file is updated.

Explanation

MS Excel is an application software, designed for tasks.

Like creating spreadsheets, data analysis, and calculations.

Explanation

The Enter key was originally the "Return key" on a typewriter,

which caused the carriage to return to the beginning of the next line on the paper.

Explanation

Ctrl + Shift + P is used to change the font size.

Explanation

A constant is a set value that doesn't change and that's directly inserted into a cell.

It's not a formula and it's not calculated by a formula.

*******

VU CBT FIA  PAPER 19-12-2021

Explanation

Selecting "No Outline" removes or hides the border of a shape.

This option is available in applications like MS Word or PowerPoint.

It leaves the shape without a visible border.

Explanation

A Word template stores the structure of a document.

Such as predefined formatting, styles, and layout, to maintain consistency across similar documents.

It helps in creating documents with the same framework.