Basic Ms Excel

What is a function in Excel?

• A function in Excel is a random value generated by the software.

• A function in Excel is a feature used for inserting images into spreadsheets.

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

• A function in Excel is a type of formatting applied to cells.

How can you format cells in Excel?

• Open 'Insert' tab -> Click on 'Format Cells' -> Apply formatting options

• Right-click on cells -> Select 'Format Cells' -> Choose formatting options

• Select cells -> Go to 'Home' tab -> Choose formatting options

• Press Ctrl + F -> Type in formatting commands -> Press Enter

Define Workbook in Spreadsheet.

• A Workbook contains multiple Cells in Excel.

• A Worksheet contains multiple Workbooks in Excel.

• A Workbook contains multiple Worksheets in Excel.

• A Workbook contains multiple Rows in Excel.

What is the difference between a cell and a range in Excel?

• A cell is a group of cells, while a range is a single unit.

• A cell is used for text, while a range is used for numbers.

• A cell is horizontal, while a range is vertical.

• A cell is a single unit, while a range is a group of cells.

Explain the concept of Autofill in Excel.

• Autofill in Excel only works with numerical data, not text.

• Autofill in Excel is a manual process that requires entering data cell by cell.

• Autofill in Excel is a feature that automatically fills in a series of data or formulas into adjacent cells by recognizing patterns in the existing data.

• Autofill in Excel can only be used in one direction, either horizontally or vertically.

How do you use functions in Excel to perform calculations?

• Use a function name without parentheses

• Type the calculation directly into a cell without using functions

• Use a random number generator function

• Start with =, followed by function name and input range of cells or values within parentheses.

What are some common formatting options available in Excel?

• Font styles, cell alignment, borders, fill colors, merge cells, conditional formatting

• Page layout options

• Data validation

• Chart styles

How can you create a new worksheet in an Excel workbook?

• Press Ctrl + N

• Double-click on existing worksheet tab

• Go to File -> New Worksheet

• Right-click on existing worksheet tab -> Insert -> Worksheet

What is the purpose of a cell reference in Excel?

• To refer to a specific cell or range of cells within a worksheet.

• To add cell

• To add new worksheet

• To delete all cell content

How can you quickly fill a series of cells with data in Excel?

• Fill the first cell, select it, hover over the bottom right corner until the cursor changes, click and drag to fill the series of cells.

• Right-click on the first cell and select 'Fill Series'

• Use the 'Delete' key to clear the cells and start over

• Manually type the data into each cell