Explanation

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

****

ND30-4-2023

Explanation

A hyperlink points to a whole document or to a specific element within a document.

Explanation

• HTTPS (Hypertext Transfer Protocol Secure) is an extension of the Hypertext Transfer Protocol (HTTP) used for secure communication over the internet.
• It combines HTTP with an additional security layer, typically Secure Sockets Layer (SSL) or Transport Layer Security (TLS), to encrypt and protect the data being transmitted between a website and a user's browser.

Explanation

A mouse helps users select items and point to objects on the computer screen.

It is a primary input device for graphical user interfaces.

Explanation

Slide transitions can be applied to the current slide, previous slide, or new slide.

Transitions can be set to occur when entering or exiting any of these slides.

Explanation

Conditional formatting highlights cells automatically based on set conditions or rules (e.g., values greater than 100).

It helps in quickly analyzing data trends by using colors, icons, or data bars.

Explanation

Print Layout View header and footer are visible.

****

Headers and footers appear only in print layout view, print preview, and in printed documents.

Explanation

The process of combining two or more cells into a single cell in MS Word or Excel is called "merging."

This is commonly used for formatting tables or organizing data.

Explanation

Spooling allows the printer to receive data from the CPU and print at its own speed.

It manages multiple print jobs efficiently by queuing them in a buffer.