Beginners Guide To Work On Excel

 

 1. An Excel file in other words called as_____

Your answer is.    ✅ workbook

2. The basic unit of a worksheet into which the data in Excel entered is called a _______

Your answer is.    ✅  cell

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. The intersection of a column and a row on a worksheet is known as________ 

Your answer is.      ✅ cell

2. In MS-Excel columns are labelled as

Your answer is.    ✅ A, B, C,___

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. Under what ribbon menu and grouping of commands will you find the insert and delete options?

Your answer is.      ✅ Home > Cells

2. To add a column between A and B column. Choose the correct option

Your answer is. 

 

      ✅  Select column A then go to Home> Cells and Insert

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. Where can we find all of the tabs (Home Tab, Insert Tab, etc.)?

Your answer is.    ✅  Ribbon

2. How do you wrap text in a cell?

Your answer is.      ✅  Format cells alignment

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. Which of the following options is not available in Insert Tab?

Your answer is.      ✅  Graph

2. What Tab appears when you insert a picture?

Your answer is.      ✅  Picture Tools Format Tab

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. The Hyperlink Icon can be found in the Toolbar.

Your answer is.      ✅  Insert

2. What operations can we perform in data consolidation?

Your answer is.       ✅  All of the given options

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. Data Validation can ...

Your answer is.     ✅ All of the given options

2. Data Validation is a feature that restricts user input to a worksheet. True or False?

Your answer is.     ✅  True

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

1. The Save As command will not allow you to

Your answer is.    ✅   Save As a template

2. To save an existing document with a different file name, click.

Your answer is.     ✅ Save As on the File menu

▬▬▬▬▬▬▬▬▬▬👇▬▬▬▬▬▬▬▬▬▬

1. A workbook by default consists _______worksheet.

Your answer is    ✅ 1

2. In Microsoft Excel spreadsheets, cells are labelled as

Your answer is.    ✅  A1, B1, C1,_____

3. MS Excel stands for

Your answer is.    ✅  Microsoft Excel

4. Which of the following does not cut the information?

Your answer is.     ✅  Pressing Ctrl + C

5. Data in spreadsheet is organized in _______.

Your answer is.    ✅  rows and columns

6. Which of the following is not a valid data type in MS - Excel?

Your answer is.     ✅  Labels

7. ______ cells involves creating a single cell by combining two or more selected cells.

Your answer is     ✅  Merging

8. Which of the following is not a term used in MS-Excel?

Your answer is.    ✅  Block

9. ______ is used to display values in ascending or descending order.

Your answer is.     ✅  Sorting

10. Which of the following is an extension of database file in excel is

Your answer is.       ✅ .xls