UIT 1111 (COPTPA) TOPIC 2.3

Front

What is the objective of the Microsoft Excel module UIT 1111?

Back

Students should be able to use functions in Microsoft Office based on instructions given at the workplace.

Front

What are the key components of the Excel interface?

Back

Tab Ribbon, Command Group, Title, Name Box, Formula Bar, Active Cell, Worksheet, Scroll Bars, View Mode, Zoom Control.

Front

How do you create a new blank workbook in Excel?

Back

Select the File tab, then select New, and click Blank workbook.

Front

What is the difference between 'Save' and 'Save As' in Excel?

Back

Save updates the existing file, while Save As creates a copy of the workbook with a new name or location.

Front

What is the purpose of the Freeze Panes feature in Excel?

Back

It allows you to keep certain rows or columns visible while scrolling through the rest of the worksheet.

Front

How can you sort data in Excel?

Back

Select a cell in the column you wish to sort by, then use the Data tab to choose Ascending or Descending sort.

Front

What types of charts can you create in Excel?

Back

Column, Line, Pie, Bar, Area, and Surface charts.

Front

How do you insert a chart in Excel?

Back

Select the cells you want to chart, then click the desired Chart command from the Insert tab.

Front

What is the function of the Formula Bar in Excel?

Back

It displays the contents of the active cell, including formulas.

Front

What is the purpose of the Zoom Slider in Excel?

Back

It allows you to zoom in or out of the worksheet for better visibility.