Excel | MCQs

Explanation

A collection of related worksheets is called a workbook.

A workbook is a file that contains one or more worksheets that are used to organize data.

Explanation

Explanation

• In MS Excel, you can copy data or formulas using Edit menu commands, shortcut menu options, or toolbar buttons like "Copy" and "Paste."
• These methods offer flexibility for users to quickly replicate data or formulas across cells or worksheets.

Additional Points:

• Keyboard Shortcuts: Use Ctrl + C (Copy) and Ctrl + V (Paste) for efficiency.
• Drag and Drop: Copy formulas by dragging the fill handle at the corner of a selected cell.
• Right-Click Menu: Provides quick access to copy/paste commands directly.
• Paste Special: Allows pasting specific attributes (e.g., values, formats) using Alt + E + S.

Explanation

In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells.

COUNT Function:
The COUNT function counts the number of cells that contain numeric values within a specified range.

For example: =COUNT(A1:A10)
This formula will return the number of cells containing numbers in the range A1 through A10.

Explanation

The maximum function calculates the largest value in a set of numbers in Excel.

Explanation

20 x 10 = 200

200 / 5 = 40

40 x 8 = 320

So, Excel evaluates the formula and returns 320.

Explanation

To sum up a range of cells in Excel, you use the SUM function.

This function adds together all the numbers in the specified range of cells.

• AVERAGE function calculates the average of the numbers in a range.
• COUNT function counts the number of cells that contain numbers.
• MAX function finds the highest value in a range of cells.

Explanation

In Ms Excell, the horizontal scroll bar is located on the bottom right of the screen.

There are two scroll bars in Excel:

1. vertical scroll bar is used to view the data in Excel from up and down,
2. horizontal scroll bar used to view the data from left to right.
   

Explanation

How do I use Print titles in Excel?

To print titles, execute the following steps.

On the Page Layout tab, in the Page Setup group, click Print Titles. The Page Setup dialog box appears.

To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.

Click OK. ...

On the File tab, click Print for a print preview.

Explanation

A function is a predefined formula that performs calculations using specific values in a particular order.

All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.