Assement Exam 2011 - Office Skills

1. Excel is useful for

Writing Memos

Creating Slideshows

Making Charts

Excel is useful for making charts because it is a powerful tool that allows users to organize and analyze data efficiently. With Excel, users can easily input data into a spreadsheet and then use various functions and formulas to manipulate and calculate the data. This makes it easy to generate charts and graphs that visually represent the data in a clear and concise manner. Excel also provides a wide range of chart types and customization options, allowing users to create professional-looking charts that effectively communicate information.

Explanation

Excel is useful for making charts because it is a powerful tool that allows users to organize and analyze data efficiently. With Excel, users can easily input data into a spreadsheet and then use various functions and formulas to manipulate and calculate the data. This makes it easy to generate charts and graphs that visually represent the data in a clear and concise manner. Excel also provides a wide range of chart types and customization options, allowing users to create professional-looking charts that effectively communicate information.

2. To quickly print a file, you press

Control S

Control N

Control P

To quickly print a file, you press Control P. This keyboard shortcut is commonly used in many applications to initiate the printing process. By pressing Control P, you can quickly send the document to the printer without having to navigate through the print menu options.

Explanation

To quickly print a file, you press Control P. This keyboard shortcut is commonly used in many applications to initiate the printing process. By pressing Control P, you can quickly send the document to the printer without having to navigate through the print menu options.

3. In the formula =sum(B1:B5), how many cells are there?

5

2

4

The formula =sum(B1:B5) is a sum formula that adds the values in cells B1, B2, B3, B4, and B5. Therefore, there are 5 cells included in the formula.

Explanation

The formula =sum(B1:B5) is a sum formula that adds the values in cells B1, B2, B3, B4, and B5. Therefore, there are 5 cells included in the formula.

4. You can perform calculations in Excel using

*

@

#

In Excel, the asterisk (*) symbol is used to perform multiplication calculations.

Explanation

In Excel, the asterisk (*) symbol is used to perform multiplication calculations.

5. Which of the following is not true?

A new workbook is called "Book 1"

Excel Sheets have the extension *.doc

You can export data to csv format

The given correct answer is "Excel Sheets have the extension *.doc". This statement is not true because Excel Sheets have the extension *.xlsx, not *.doc. The file extension *.doc is used for Microsoft Word documents, not Excel Sheets.

Explanation

The given correct answer is "Excel Sheets have the extension *.doc". This statement is not true because Excel Sheets have the extension *.xlsx, not *.doc. The file extension *.doc is used for Microsoft Word documents, not Excel Sheets.

6. Buttons which do the same as Contol B, Control I and Control U can be found on the:

Menu Bar

Standard Toolbar

Formatting Toolbar

The correct answer is Formatting Toolbar because this toolbar typically contains buttons for formatting text, such as bold (Control B), italic (Control I), and underline (Control U). The Formatting Toolbar provides quick and easy access to these formatting options, allowing users to apply them to selected text without having to navigate through menus or use keyboard shortcuts.

Explanation

The correct answer is Formatting Toolbar because this toolbar typically contains buttons for formatting text, such as bold (Control B), italic (Control I), and underline (Control U). The Formatting Toolbar provides quick and easy access to these formatting options, allowing users to apply them to selected text without having to navigate through menus or use keyboard shortcuts.