Excel Basics for Second-Year Students

What is the primary function of Excel?

• The primary function of Excel is to organize and analyze data.

• To create presentations

• To send emails

• To edit photos

How do you create a new spreadsheet in Excel?

• Open Excel, go to View > New Window.

• Right-click on the desktop and select New > Excel Spreadsheet.

• Open Excel, go to File > Save > New Workbook.

• Open Excel, go to File > New > Blank Workbook.

What is a cell in Excel?

• A cell in Excel is a basic unit of storage for data.

• A cell in Excel is a graphical element.

• A cell in Excel is a type of formula.

• A cell in Excel is a programming language.

How can you format a cell in Excel?

• Double-click the cell to edit the text directly.

• Use the 'Insert' menu to add a new cell format.

• Select the cell and press 'Delete' to clear formatting.

• Right-click the cell, select 'Format Cells', and choose the desired format.

What is the purpose of a formula in Excel?

• To format text and images

• To store data in tables

• The purpose of a formula in Excel is to perform calculations and analyze data.

• To create charts and graphs

How do you insert a new row in a table?

• Use the SQL command 'INSERT INTO table_name (column1, column2) VALUES (value1, value2);'

• Run 'DELETE FROM table_name WHERE column1 = value1;'

• Use the command 'ADD ROW table_name (value1, value2);'

• Execute 'UPDATE table_name SET column1 = value1;'

What is the difference between a worksheet and a workbook?

• A worksheet is a collection of multiple sheets, while a workbook is a single sheet.

• A worksheet is used for calculations, while a workbook is for data storage.

• A worksheet is a single sheet, while a workbook is a collection of multiple worksheets.

• A worksheet can only contain text, while a workbook can contain images.

How can you sort data in Excel?

• Right-click and choose 'Delete'

• Use the 'Insert' tab to add a chart

• Click 'File' and select 'Export'

• Select data range, go to 'Data' tab, click 'Sort'.

What function would you use to add numbers in a range of cells?

• SUM

• MAX

• COUNT

• AVERAGE

How do you save your work in Excel?

• Click 'Edit' > 'Save As'

• Select 'Home' > 'Save'

• Click 'File' > 'Save' or use Ctrl + S.

• Use Alt + F4 to save