ICT Ms. Excel 2016

Microsoft Excel is what kind of software?

• Word Processing Software

• Spreadsheet Software

• Database Software

• Presentation Software

Answer explanation

Microsoft Excel is classified as Spreadsheet Software because it is designed for organizing, analyzing, and storing data in tabular form, allowing users to perform calculations and create graphs.

The letters in Excel represent the...

• Rows

• Columns

• Cells

• Data

Answer explanation

In Excel, letters (A, B, C, etc.) represent columns, while numbers represent rows. Therefore, the correct answer is 'Columns'.

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

Answer explanation

The numbers in Excel represent the rows, which are horizontal collections of cells. Each row is identified by a number, making 'Rows' the correct answer.

Excel is part of

• Access

• Microsoft Office

• PowerPoint

• Windows

Answer explanation

Excel is a spreadsheet application that is part of the Microsoft Office suite, which includes other programs like Word and PowerPoint. Therefore, the correct answer is Microsoft Office.

An Excel file format extension is

• doc

• xls

• txt

• mp3

Answer explanation

The correct Excel file format extension is 'xls', which is used for older versions of Excel files. The other options, 'doc', 'txt', and 'mp3', correspond to Word documents, text files, and audio files, respectively.

What is the name given to the intersection of a row and a column in a spreadsheet? 

• cell

• block

• cube

• square

Answer explanation

The intersection of a row and a column in a spreadsheet is called a 'cell'. Each cell can hold data, making it a fundamental component of spreadsheet functionality.

What are lines that can be applied around worksheet cells or objects?

• Gridlines

• Borders

• Underlines

• Boundaries

Answer explanation

Borders are lines that can be applied around worksheet cells or objects to define their edges, making them distinct. Gridlines are for layout guidance, underlines are for text, and boundaries are not a standard term in this context.

How do you change column width?

• Single-click the boundary to the left of the column heading

• Double-click the boundary to the right of the column heading

• Press ALT and single-click anywhere in the column

• Double-click the boundary to the right of the column heading and Single-click the boundary to the left of the column heading

Answer explanation

To change column width, double-click the boundary to the right of the column heading. This action automatically adjusts the column to fit the content, making it the quickest and most efficient method.

Letters of the alphabet going across the top of the spreadsheet.

• Title Bar

• Column Labels

• Row Labels

• Status Bar

Answer explanation

The letters of the alphabet at the top of a spreadsheet represent the columns, which are referred to as Column Labels. This distinguishes them from Row Labels, which are found on the left side of the spreadsheet.

Numbers down the left side of the spreadsheet.

• Status Bar

• Formula Bar

• Column Labels

• Row Labels

Answer explanation

The numbers down the left side of a spreadsheet are called Row Labels. They help identify each row, while Column Labels are at the top. The Status Bar and Formula Bar serve different functions and do not represent the left-side numbers.