Explanation

DATE: returns the serial date value for a date

TODAY: returns today's date

NOW: returns the current date and time

TIME: assemble a proper time.

***

RY24012023

Explanation

F11 Creates a chart of the data in the current range in a separate Chart sheet.

Some important shortcuts used in MS Excel

•F1 Opens Excel Help

•F2 Edit contents of an excel

•F3 Paste Named Range or Named List

•F4 Toggles between cell references - Absolute, Relative, and Mixed Reference

•F5 Displays the "Go To" dialog box

•F6 Switch between the panes of an Excel workbook if you have a split window

•F7 Opens the "Spelling" option in Excel using which you can check the spellings in your workbook

•F8 Enables and disables the "Extend Mode" selection in Excel.

•F9 Recalculates the output of all formulas in your Excel workbook.

• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips

• F12 Opens the "Save As" dialog box like the "Alt + F2" keys

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

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

Getting data from a cell located in a different sheet is called Cell reference.

There are Three types of Cell reference in Excel

1. Relative
2. Absolute
3. Mixed

****

RY17-012-23

Explanation

Goal Seek, Solver, and Scenario Manager are all tools in Excel used for What-If Analysis.

It helping to analyze different possible outcomes.

Goal Seek adjusts a single input to reach a desired result.

Solver handles complex optimizations.

Scenario Manager compares multiple data scenarios.

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

Data, sort is used for arranging data in ascending/descending order in MS Excel

 Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

 Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

***

ND11-12-2022

Explanation

In MS Excel 2016, you can split the window into two panes using the following steps:

• Go to the "View" tab in the ribbon
• Click on "Window" in the "Window" group
• Select "Split" from the dropdown menu

Alternatively, you can also use the shortcut key:

Alt + W + S

Explanation

A formula in Excel always begins with an equal sign (=).

Excel interprets the characters that follow the equal sign as a formula

. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.

Calculation operators separate these.