MS Excel

1. ___________________ the text will automatically modify a cell’s row height, allowing cell contents to be displayed on multiple lines.

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

3. In MS Excel, if you want to copy formatting from one cell to another, you can use the _________________ command.

1. The ______________ is a section of workbook that appears in the top margin, while _______________ appears in the bottom margin.

• Page Layout/Spreadsheet

• Auto Fit/ Wrap Text

• Header/Footer

2. _______________ combines a cell with adjacent empty cells to create one large cell.

• Concatenate

• Auto Fit

• Merging

3. The _____________ function can be used to find the total of numbers entered in a range of cells.

• Max

• Sum

• Min

1. Average function is used to calculate arithmetic mean of the numbers.

• True

• False

2. Borders are used for merging the cells.

• True

• False

3. If some of the content is being cut off by the printer, you can use scaling to fit your workbook to the page automatically.

• True

• False

Q1. Why do we use MS Excel? Give any two examples?