Microsoft Excel Basics

What is Microsoft Excel primarily used for?

• Creating spreadsheets and organizing data

• Writing code and programming

• Creating presentations and slideshows

• Editing photos and images

How can you create a new spreadsheet in Excel?

• Open Excel, click on 'Edit', select 'New', choose 'Blank workbook'

• Open Excel, click on 'File', select 'New', choose 'Blank workbook'

Explain the difference between a row and a column in Excel.

• A row is vertical, and a column is horizontal in Excel.

• A row is horizontal, and a column is vertical in Excel.

• A row is for calculations, and a column is for formatting in Excel.

• A row is used for text, and a column is used for numbers in Excel.

What is the function of the SUM formula in Excel?

• It divides the numbers in the specified range

• It multiplies the numbers in the specified range

• It finds the average of the numbers in the specified range

• It calculates the total sum of the numbers in the specified range.

How can you change the font style and size in Excel?

• Right-click on cells -> Choose font style and size

• Go to 'Insert' tab -> Select font style and size

• Use 'Format Painter' tool to change font style and size

• Select cells -> Go to 'Home' tab -> Choose font style and size from 'Font' group

What is the purpose of using filters in Excel?

• To change the font style of the data

• To display specific data that meets certain criteria.

• To calculate mathematical formulas

• To insert images into the spreadsheet

Explain the difference between sorting and filtering data in Excel.

• Sorting groups data based on values, filtering groups data based on colors

• Sorting changes font style, filtering changes font size

• Sorting adds new rows, filtering deletes rows

• Sorting rearranges rows based on column values, filtering displays rows based on criteria.

How can you protect a workbook in Excel?

• Go to 'Format' tab -> Click on 'Protect Workbook' -> Choose protection options

• Go to 'Data' tab -> Click on 'Protect Workbook' -> Choose protection options

• Go to 'Insert' tab -> Click on 'Protect Workbook' -> Choose protection options

• Go to 'Review' tab -> Click on 'Protect Workbook' -> Choose protection options

What is the benefit of using charts in Excel for data analysis?

• Charts are not visually appealing

• Charts slow down the data analysis process

• Charts provide a visual representation of data, making it easier to identify trends, patterns, and outliers.

• Charts make the data harder to interpret

How can you share a workbook with others in Excel?

• Go to 'Data' tab -> Click on 'Share Workbook' -> Check 'Allow changes by more than one user at the same time' -> Enter email addresses of people to share with

• Go to 'Insert' tab -> Click on 'Share Workbook' -> Enter email addresses of people to share with

• Go to 'Format' tab -> Click on 'Share Workbook' -> Check 'Allow changes by more than one user at the same time' -> Enter email addresses of people to share with

• Go to 'Review' tab -> Click on 'Share Workbook' -> Check 'Allow changes by more than one user at the same time' -> Enter email addresses of people to share with