Excel Basics for Beginners

What steps are followed for saving an Excel workbook?

What action will take place when you click on the 'X' button of the menu bar in MS Excel?

What is the extension of a MS-Excel file?

What is the worksheet which is currently in use called?

Microsoft Excel is a/an _______ program.

Which button does 'X' in the given picture denote?

Identify the keyboard shortcut to navigate between different worksheets.

What are the steps to insert a new row in a worksheet?

Which of the following statements is NOT true?

Which of these is/are the data types of MS-Excel?

What does a spreadsheet contain?

What is the smallest unit of a worksheet in Excel?

In a school, the marks details of class-VI students are entered in Excel sheet. What is the quickest way to access the details of a particular student of a worksheet?

How many sheets does an Excel window display by default?

Which of the following components displays the contents of the active cell?

Saving an Excel Workbook

To save an Excel workbook, click the save icon in the Quick Access Toolbar, type the file name and click OK.
You can also use File > Save > Type the file name > OK to save the workbook.

Exiting Excel

Clicking the "X" button on the Excel window's menu bar exits Excel.

Excel File Extension

The extension for an MS-Excel file is .xls.

Active Worksheet

The worksheet currently being used is called the active worksheet.

Excel Program Type

Microsoft Excel is a spreadsheet program.

"X" Button Function

The "X" button in the given image represents the "Cancel" button.

Navigating Worksheets

Use Ctrl + PgUp to move between different worksheets.

Inserting a New Row

To insert a new row in a worksheet, use Insert > Row.

Excel Cell Contents

Cell contents in MS Excel can be modified using edit commands.
The Cancel and Enter buttons are found on the formula bar.
Double-clicking a cell allows for minor modifications.
Calculations in MS Excel can be performed using both formulae and functions.

Data Types in Excel

Excel data types include numbers, text, and formulae.

Spreadsheet Components

A spreadsheet contains columns, rows, and cells.

Smallest Unit of a Worksheet

The smallest unit of a worksheet in Excel is a cell.

Accessing Student Details by Name

To quickly access a student's details in an Excel sheet, type the student's name into the Name Box.

Default Number of Sheets

An Excel window displays one sheet by default.

Displaying Active Cell Contents

The Formula Bar displays the contents of the active cell.

This quiz covers fundamental concepts of Microsoft Excel, including saving workbooks, navigating worksheets, and understanding file extensions. Perfect for beginners looking to enhance their spreadsheet skills.