Explanation

Line graphs are used to track changes over short and long periods of time.

When smaller changes exist, line graphs are better to use than bar graphs

Explanation

Equal to: =

Not equal to: <>

Greater than: >

Less than: <

Greater than or equal to: >=

Less than or equal to: <=

Explanation

When you type a zero (0) before a fraction, Excel will treat it as a numerical value rather than a date.

This is a quick way to ensure that your fractions are displayed correctly in your spreadsheet.

Example: 0 1/2 (Displays as a fraction)

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

When applying conditional formatting in spreadsheet software like Microsoft Excel, Google Sheets, or LibreOffice Calc, you can check conditions against:

• Cell value: You can specify a condition based on the value in a cell, such as "greater than", "less than", "equal to", etc.
• Formula: You can also specify a condition based on a formula, which can include references to other cells, functions, and operators.

Explanation

Hyperlinks can be used for text, drawing objects, and pictures.

They provide a way to navigate within a document, to a different document, or to a web page.

Explanation

Formulas are equations that perform calculations on values in your sheet.

All formulas begin with an equal sign (=).

You can create a simple formula by using constant and calculation operators.

For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.

Explanation

• None of these: The intended option when all choices share the same formatting status.

Additional information:

• B1*B2: Represents cell multiplication without an initial equals sign.
• 10+17:Represents raw number addition without an initial equals sign.
• B1*17: Represents mixed cell and number multiplication without an initial equals sign.

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

To activate a cell in MS Excel, you can use any of the following methods:

• Clicking the cell: Simply click on the cell you want to activate.
• Pressing an arrow key: Use the arrow keys (↑, ↓, ←, →) to navigate to the cell you want to activate.
• Pressing the Tab key: Pressing Tab will move the focus to the next cell in the worksheet, activating it.

Additionally, you can also activate a cell by:

• Using the mouse to right-click on the cell
• Using the keyboard shortcut Ctrl + Arrow key (e.g., Ctrl + →) to move to the next cell
• Using the keyboard shortcut F2 to edit the active cell