Assement Exam 2011 - Office Skills
The 'Assement Exam 2011 - Office Skills' tests proficiency in basic office software functionalities, focusing on Excel. It covers operations like printing, formatting, and calculations, essential for efficient office management and data handling.
- 1.
In the formula =sum(B1:B5), how many cells are there?
- A.
5
- B.
2
- C.
4
Correct Answer
A. 5Explanation
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.Rate this question:
-
- 2.
To quickly print a file, you press
- A.
Control S
- B.
Control N
- C.
Control P
Correct Answer
C. Control PExplanation
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.Rate this question:
-
- 3.
You can perform calculations in Excel using
- A.
*
- B.
@
- C.
#
Correct Answer
A. *Explanation
In Excel, the asterisk (*) symbol is used to perform multiplication calculations.Rate this question:
-
- 4.
Excel is useful for
- A.
Writing Memos
- B.
Creating Slideshows
- C.
Making Charts
Correct Answer
C. Making ChartsExplanation
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.Rate this question:
-
- 5.
Which of the following is not true?
- A.
A new workbook is called "Book 1"
- B.
Excel Sheets have the extension *.doc
- C.
You can export data to csv format
Correct Answer
B. Excel Sheets have the extension *.docExplanation
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.Rate this question:
-
- 6.
Buttons which do the same as Contol B, Control I and Control U can be found on the:
- A.
Menu Bar
- B.
Standard Toolbar
- C.
Formatting Toolbar
Correct Answer
C. Formatting ToolbarExplanation
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.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
May 06, 2011Quiz Created by
Ricklincs
Back to top