2023-2024-Term1-ELECTIVE-ICT-SPREADSHEET-SHS3-Activity-1

What is the function of 'AutoSum' in Microsoft Excel?

• The function of 'AutoSum' in Microsoft Excel is to delete the content of selected cells.

• The function of 'AutoSum' in Microsoft Excel is to change the font style of selected cells.

• The function of 'AutoSum' in Microsoft Excel is to create a new worksheet in the workbook.

• The function of 'AutoSum' in Microsoft Excel is to automatically add up a range of cells and display the total in the selected cell.

Explain the term 'Cell' in Microsoft Excel.

• A cell in Microsoft Excel is a type of battery used to power the program

• A cell in Microsoft Excel is a small room where data is stored

• A cell in Microsoft Excel is a type of virus that can infect the program

• A cell in Microsoft Excel refers to the intersection of a row and a column, where data can be entered, edited, and manipulated.

What is the purpose of 'Filter' in Microsoft Excel?

• The purpose of 'Filter' in Microsoft Excel is to create new worksheets.

• The purpose of 'Filter' in Microsoft Excel is to change the color of selected cells.

• The purpose of 'Filter' in Microsoft Excel is to calculate formulas automatically.

• The purpose of 'Filter' in Microsoft Excel is to selectively display data that meets certain criteria, while hiding the data that does not meet the criteria.

Define 'Workbook' in the context of Microsoft Excel.

• A workbook in Microsoft Excel is a type of font used for formatting text

• A workbook in Microsoft Excel is a tool used for creating presentations

• A workbook in Microsoft Excel is a feature for creating animations

• A workbook in Microsoft Excel is a file that contains one or more worksheets where data is entered and manipulated.

What does 'Merge and Center' do in Microsoft Excel?

• It changes the font color of the selected cells

• It deletes the selected cells

• It combines selected cells into one and centers the content within the merged cell.

• It creates a duplicate of the selected cells

Explain the term 'Formula' in Microsoft Excel.

• A formula in Microsoft Excel is a type of font style

• A formula in Microsoft Excel is a type of data filter

• A formula in Microsoft Excel is a type of chart

• A formula in Microsoft Excel is an expression that calculates the value of a cell. It can perform mathematical operations, use functions, and reference other cells.

What is the use of 'Sort' in Microsoft Excel?

• The 'Sort' function in Microsoft Excel is used to arrange data in a specific order, such as alphabetically or numerically, making it easier to analyze and work with.

• The 'Sort' function in Microsoft Excel is used to calculate the average of the data

• The 'Sort' function in Microsoft Excel is used to change the font style of the data

• The 'Sort' function in Microsoft Excel is used to insert new rows into the spreadsheet

Define 'Function' in the context of Microsoft Excel.

• In Microsoft Excel, a function is a type of cell formatting

• In Microsoft Excel, a function is a feature for importing data from external sources

• In Microsoft Excel, a function is a tool for creating charts and graphs

• In Microsoft Excel, a function is a predefined formula that performs calculations using specific values in a particular order.

What is the significance of 'Chart' in Microsoft Excel?

• Charts in Microsoft Excel are used to visually represent data, making it easier to analyze and understand trends, patterns, and relationships within the data.

• Charts in Microsoft Excel have no significance

• Charts in Microsoft Excel are only for decorative purposes

• Charts in Microsoft Excel are used for word processing