Data Analysis & Visualisation Through Spread sheets (CSC1FM105)

What is the primary purpose of spreadsheets?

• To manage email communications efficiently.

• The primary purpose of spreadsheets is to organize and analyze data.

• To create visual presentations of data.

• To store large amounts of unstructured text.

Answer explanation

The primary purpose of spreadsheets is to organize and analyze data, allowing users to perform calculations, create charts, and manage information effectively, unlike the other options which do not reflect their main function.

Name two features of a spreadsheet application.

• Email integration features.

• Text formatting tools;

• 1. Data organization in rows and columns; 2. Formula-based calculations.

• Graphical data representation;

Answer explanation

The correct features of a spreadsheet application are data organization in rows and columns, which allows for structured data entry, and formula-based calculations, enabling users to perform mathematical operations on the data.

What are the main parts of the Excel window?

• Toolbar, Document, Page Layout

• Header, Footer, Chart Area

• Menu Bar, Data Table, Sidebar

• Ribbon, Workbook, Worksheet, Formula Bar, Status Bar

Answer explanation

The main parts of the Excel window include the Ribbon, which contains tools and commands, the Workbook that holds multiple Worksheets, the Formula Bar for entering data, and the Status Bar that displays information about the current state.

How do you insert a new row in Excel?

• Click on the 'Home' tab and select 'New Row'.

• Press Ctrl + N to create a new row.

• Use the 'Insert' menu and choose 'Row' option.

• Right-click on the row number and select 'Insert'.

Answer explanation

The correct method to insert a new row in Excel is to right-click on the row number and select 'Insert'. This directly adds a new row above the selected one, making it a quick and efficient way to modify your spreadsheet.

What is the difference between a worksheet and a workbook?

• A workbook is a single sheet in a worksheet.

• A worksheet is a type of software used for calculations.

• A worksheet contains multiple workbooks.

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

Answer explanation

A worksheet is a single sheet within a workbook, which is a collection of multiple worksheets. This distinction is crucial for understanding how data is organized in spreadsheet software.

How can you merge cells in a spreadsheet?

• Select the cells and press 'Ctrl + M'.

• Highlight the cells and click 'Format' then 'Align'.

• Right-click and choose 'Delete Cells' instead.

• Select the cells, right-click, and choose 'Merge Cells'.

Answer explanation

The correct method to merge cells in a spreadsheet is to select the desired cells, right-click, and choose 'Merge Cells'. This combines the selected cells into one, which is a common feature in spreadsheet applications.

What is a formula in Excel?

• A formula in Excel is a predefined template.

• A formula in Excel is a type of chart.

• A formula in Excel is an expression that calculates values.

• A formula in Excel is a way to format text.

Answer explanation

A formula in Excel is an expression that calculates values, allowing users to perform mathematical operations and manipulate data efficiently. The other options do not accurately describe what a formula is.

How can you visualize data using Excel?

• Using only tables to display data

• Utilizing external software for visualization

• Creating text documents for data analysis

• You can visualize data using charts, graphs, and PivotTables in Excel.

Answer explanation

You can visualize data in Excel effectively using charts, graphs, and PivotTables, which provide clear visual representations of data trends and summaries, unlike the other options that do not utilize Excel's visualization capabilities.

What are some common types of charts available in Excel?

• Column, Line, Pie, Bar, Area, Scatter, Doughnut

• Radar

• Histogram

• Waterfall

Answer explanation

The correct answer includes common chart types in Excel: Column, Line, Pie, Bar, Area, Scatter, and Doughnut. These charts are widely used for data visualization, while Radar, Histogram, and Waterfall are less common.

How can you apply conditional formatting in Excel?

• Right-click on the cell and select 'Format Cells'.

• Conditional formatting cannot be applied in Excel.

• Use the 'Insert' menu to add a new condition.

• Select the cells, go to 'Home' tab, and choose 'Conditional Formatting'.

Answer explanation

To apply conditional formatting in Excel, select the desired cells, navigate to the 'Home' tab, and click on 'Conditional Formatting'. This allows you to set rules for formatting based on cell values.