Express Employment Professionals Business Office Technology Certification

Windows® belong to which of the following types of operating systems?

• Single-user, single task operating systems
• Multi-user operating systems
• Single-user, multi-task operating systems
• Real-time operating systems (RTOS)

What error occurs when #REF! is shown?

• Misspelling of a name has occurred in the function
• Invalid equation
• The column is not wide enough to display
• The cell reference is not valid because the cell may have been deleted or pasted over

Jason works part-time at a marketing firm. Jason is using a company printer to print fliers for his garage sale. Which of the following describes Jason’s behavior?

• Ethical behavior
• Appropriate behavior
• Illegal behavior
• Unethical behavior

Which of the following is text which is printed at the top of each page of a document?

• Footer
• Header
• Style set
• Theme

In Microsoft® Excel®, which of the following keys can be pressed while dragging a worksheet to another location in the workbook to copy it?

• Enter
• Shift
• Spacebar
• Control

What does the star symbolize in the image?

• Chart present
• Text present
• Animation present
• Images present

Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiply the sum by 10. Which of the following formulas should he enter?

• +A1+B1*10
• =A1+B1*10
• =(A1+B1)*10
• &(A1+B1)*10

Memorandum format is used for which of the following types of communication?

• Formal communication between two businesses
• Informal communication between two businesses
• Communication among friends
• Intra-office communication

What is missing from the following IF Function? =IF(logical_test,value_if_true,______________)

• and_value_true
• count_if_true
• sum_true_value
• value_if_false

Which of the following is NOT a method to delete text?

• Pressing the control and A keys and pressing the backspace key
• Selecting text and pressing the backspace key
• Pressing the control and X keys
• Pressing the control and A keys and pressing the delete key