Business
Business, 09.04.2021 23:10, naenae1405

Elias recorded a macro for formatting all of his data cells that include scientific number notation. After recording a long series of steps, he practices running the macro. Then he realizes that he meant to make all of these cells top-aligned instead of the default bottom-aligned. What is the most efficient way for Elias to fix this macro? Using the VBA editor, he could find every instance of “VerticalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

Using the VBA editor, he could find every instance of “HorizontalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

He could record the macro again, type in “xlBottom” to deactivate the default setting, and then select the top-align button under the Home tab.

He could record the macro again, select the bottom-align button under the Home tab to deactivate it, and then type in “xlTop” to trigger the correct setting.

answer
Answers: 2

Other questions on the subject: Business

image
Business, 22.06.2019 15:40, brookekolmetz
As sales exceed the break‑even point, a high contribution‑margin percentage (a) increases profits faster than does a low contribution-margin percentage (b) increases profits at the same rate as a low contribution-margin percentage (c) decreases profits at the same rate as a low contribution-margin percentage (d) increases profits slower than does a low contribution-margin percentage
Answers: 1
image
Business, 22.06.2019 21:00, kalbaugh
An important source of public scrutiny is "watchdogs." these are: the efforts of a firm's competitors, including how often the competitors attack the firm's strategies. taxpayer-supported government agencies that limit a firm's ability to compete in foreign markets. companies designated by the government to only produce products that support the government defense program. socially conscious groups that make it their mission to measure the social responsibility levels of businesses, and provide consumers with their opinions about the level of corporate responsibility of various companies.
Answers: 2
image
Business, 23.06.2019 00:40, kate5582
Mesa company produces wooden rocking chairs. the company has two production departments, cutting and assembly. the wood is cut and sanded in cutting and then transferred to assembly to be assembled and painted. from assembly, the chairs are transferred to finished goods inventory and then are sold. mesa has compiled the following information for the month of february: cutting department assemblydepartmentdirect materials $ 73,000 $ 13,000direct labor 73,000 108,000applied manufacturing overhead 159,000 171,000cost of goods completed and transferred out 233,000 255,000required: 1, 2, 3, & 4. prepare journal entries for the transactions in the cutting and assembly departments of mesa company. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field.)
Answers: 3
image
Business, 23.06.2019 08:30, strent45
During his last performance review, franco's boss urged him to set some short-term and long-term sales goals to him perform better at work. which workplace skill does franco's boss want him to improve?
Answers: 2
Do you know the correct answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....

Questions in other subjects: