Class Test 06

Which one is an example of spreadsheet software?

• MS Excel

• MS Word

• MS Access

• MS PowerPoint

Answer explanation

MS Excel is a spreadsheet software used for data organization, analysis, and visualization. In contrast, MS Word is a word processor, MS Access is a database management system, and MS PowerPoint is for presentations.

Internet Explorer is used for:

• Viewing Movie

• Listing Music

• Viewing Web Pages

• Drawing

Answer explanation

Internet Explorer is primarily a web browser designed for viewing web pages. It is not intended for activities like viewing movies, listing music, or drawing, making 'Viewing Web Pages' the correct choice.

The extension of a text file (i.e. Notepad) is:

• .text

• .tet

• .txt

• .tft

Answer explanation

.txt is the correct file extension for text files created in Notepad. The other options, .text, .tet, and .tft, are not standard extensions for text files.

Formulas in Excel start with ______

• /

• F

• –

• =

Answer explanation

Formulas in Excel always start with an equal sign (=). This indicates to Excel that the following text is a formula that should be calculated, making '=' the correct choice.

In Microsoft Excel spreadsheets, rows are labelled as ______

• 1, 2, 3, …..

• A, B, C, ….

• A1, B1, C1….

• I, II, III, …..

Answer explanation

In Microsoft Excel, rows are labelled numerically as 1, 2, 3, etc. This distinguishes them from columns, which are labelled alphabetically (A, B, C, ...). Therefore, the correct answer is 1, 2, 3, ….

In Microsoft Excel spreadsheets, columns are labelled as ______

• 1, 2, 3, …..

• A, B, C, ….

• A1, B1, C1….

• I, II, III, …..

Answer explanation

In Microsoft Excel, columns are labelled with letters starting from A, B, C, and so on. This is the standard convention used to identify columns, making 'A, B, C, ….' the correct answer.

Which shortcut key is used to apply outline borders?

• Ctrl + Shift + 7

• Shift + F1

• Ctrl + Right Arrow key

• Shift + 7

Answer explanation

The shortcut key to apply outline borders in applications like Excel is Ctrl + Shift + 7. This combination quickly adds borders to selected cells, making it the correct choice among the options provided.

Which shortcut key is used to add new worksheet?

• Shift + F1

• Ctrl + Shift

• Shift + F11

• Ctrl + Right Arrow key

Answer explanation

The shortcut key to add a new worksheet in Excel is Shift + F11. This combination quickly inserts a new worksheet, making it a convenient option for users.

Which key is used to create chart in MS Excel?

• Shift + F4

• F11

• Shift + End

• F12

Answer explanation

In MS Excel, the F11 key is used to quickly create a chart based on the selected data. This shortcut allows users to generate a chart in a new worksheet, making it the correct choice for creating charts.

Which key is used to insert the current time?

• Shift + F7

• Shift + Alt + D

• Ctrl + Shift + ;

• Shift + F12

Answer explanation

The correct key combination to insert the current time in many applications is Ctrl + Shift + ;. This shortcut quickly adds the current time to your document.