Q4 ICT05 Lesson 1-4 Assessment

What is a spreadsheet?

• A document editor

• A drawing tool

• A browser window

• A file that arranges data in tabular format using rows and columns

Answer explanation

A spreadsheet is specifically designed to organize data in a tabular format, using rows and columns. This allows for easy data manipulation and analysis, distinguishing it from document editors, drawing tools, or browser windows.

What is the most popular spreadsheet program today?

• MS Excel

• Google Docs

• MS Word

• Adobe Reader

Answer explanation

MS Excel is the most widely used spreadsheet program, known for its powerful features and extensive functionality, making it the preferred choice for both personal and professional use.

What is an MS Excel file called?

• Workbook

• Worksheet

• Filebook

• Spreads

Answer explanation

An MS Excel file is called a 'Workbook'. It contains one or more 'Worksheets', which are the individual pages where data is organized. The other options, like 'Filebook' and 'Spreads', are not correct terms used in Excel.

Which of the following is not part of the MS Excel window?

• Command Prompt

• Ribbon

• Formula bar

• Zoom controls

Answer explanation

The Command Prompt is not part of the MS Excel window. The Ribbon, Formula bar, and Zoom controls are all integral components of the Excel interface, while Command Prompt is a separate application used for command-line operations.

What is used to open a new workbook from the desktop?

• Double-click the Excel icon

• Right-click the desktop

• Open Task Manager

• Press Ctrl+Alt+Del

Answer explanation

To open a new workbook from the desktop, you simply double-click the Excel icon. This action launches the Excel application, allowing you to create or open workbooks directly.

Which is the correct order to open Excel 2013 from the Start menu?

• Start > All apps > Microsoft Office 2013 > Excel 2013

• Start > Excel 2013 > Microsoft Office

• Start > Settings > Office 2013

• Start > Control Panel > Excel

Answer explanation

The correct order to open Excel 2013 is through the Start menu by selecting 'All apps', then 'Microsoft Office 2013', and finally 'Excel 2013'. This path accurately leads to the application.

What screen appears after opening Excel 2013?

• Start screen

• Home screen

• Setup screen

• Login screen

Answer explanation

The screen that appears after opening Excel 2013 is the Start screen, which provides options to create a new workbook or open existing files. This distinguishes it from other screens like Home, Setup, or Login.

What is the first step to save a new workbook?

• Select the File tab on the Ribbon

• Click Close

• Open Google

• Right-click on desktop

Answer explanation

The first step to save a new workbook is to select the File tab on the Ribbon. This opens the menu where you can choose the save options.

Which shortcut can be used to save changes?

• Ctrl+S

• Ctrl+Z

• Ctrl+O

• Ctrl+X

Answer explanation

The shortcut Ctrl+S is universally used to save changes in most applications. Ctrl+Z is for undo, Ctrl+O is for opening files, and Ctrl+X is for cutting. Therefore, Ctrl+S is the correct choice for saving.

How do we exit MS Excel?

• Click the Close button on the Title bar

• Press Ctrl+E

• Right-click the sheet

• Click on Zoom controls

Answer explanation

To exit MS Excel, simply click the Close button on the Title bar. This is the standard method for closing applications, while the other options do not perform this action.