You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating various types of reports. You have created a report in the format given below:In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell.Which of the following formulas will provide the required result?
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet.Which of the following options will you use to accomplish the task?
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?Each correct answer represents a part of the solution. Choose all that apply.
DRAG DROP -You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2010 to create different reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.Select and Place:
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are facing a problem that when you type in a function and pressEnter, the cell shows the function as you typed it, instead of returning the function's value as shown below:Which of the following is the reason that is causing the above problem?
HOTSPOT -You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.Hot Area:
