MS-Excel | MCQs

Explanation

The =NOW() function in MS Excel returns the current date and time.
It is updated automatically whenever the worksheet is opened or calculations are performed.

Some other important functions in MS Excel include:

1. =TODAY() - returns the current date (without time)

2. =YEAR() - returns the year from a given date

3. =MONTH() - returns the month from a given date

4. =DAY() - returns the day from a given date

5. =HOUR() - returns the hour from a given time

6. =MINUTE() - returns the minute from a given time

7. =SECOND() - returns the second from a given time

Explanation

In an Excel worksheet, the first cell is labeled as A1 due to the following reasons:

1. Grid System: Excel uses a grid to organize cells, with rows and columns.
2. Rows Labeled by Numbers: Rows are labeled using numbers (1, 2, 3, etc.).
3. Columns Labeled by Letters: Columns are labeled using letters (A, B, C, etc.).
4. First Cell Location: The first cell is located at the intersection of row 1 and column A, hence labeled A1.

Explanation

In MS Excel, you can use the horizontal and vertical scroll bars to view different rows and columns in a worksheet.

The scroll bars are located on the right side and bottom of the Excel window, respectively.

• The vertical scroll bar allows you to scroll up and down to view different rows.
• The horizontal scroll bar allows you to scroll left and right to view different columns.

Explanation

The maximum number of rows in MS Excel is 1,048,576, starting from row 1.

Excel has a maximum of 16,384 columns, labeled from A to XFD.

Explanation

Excel spreadsheets are typically saved in the .xlsx format, 

It is the default file format introduced with Excel 2007.

Explanation

To move between worksheets in a workbook in MS Excel, you can use the following shortcuts:

• Ctrl+Page Up: Move to the previous worksheet
• Ctrl+Page Down: Move to the next worksheet

Explanation

In an Excel worksheet, the active cell is indicated by a dark, wide border.

The active cell is the cell that is currently selected and receives user interaction.

It is the cell that you type into when you begin working on a spreadsheet.

You can select any cell as the active cell by clicking on it.

Explanation

A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue.

Pie Chart: Shows how different components contribute to a whole.

Dot Chart: Displays a small number of data points.

Column Chart: Compares performance metrics side-by-side.

Line Chart: Shows trends over time.

Explanation

In older versions of Excel (up to 2003), a worksheet contains 256 columns.

Newer versions have expanded this limit to 16,384 columns.

A single worksheet in Excel contains 65,536 rows.

Explanation

When we open a new workbook in MS Excel, the Title bar appears on the topmost portion of the screen.

It displays the name of the open document.