subject

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?

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

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

C. 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.

D. 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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 20:00
What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs
Answers: 2
question
Computers and Technology, 23.06.2019 20:30
Column a of irma’s spreadsheet contains titles for each row, but her document is too big and will be printed three pages across. she wants to be sure that every page will be understood. what can irma do to with this problem?
Answers: 3
question
Computers and Technology, 24.06.2019 13:50
Write a program that performs a simple n-body simulation, called "jumping leprechauns." this simulation involves n leprechauns, numberd 1 to n. it maintains a gold value g_i for each leprechaun i, which begins with each leprechaun starting out with a million dollars worth of gold, that is, g_i = 1000000 for each i = 1,. in addition, the simulation also maintains, for each leprachaun,i, a place on the horizon, which is represented as a double-precision floating point number, x_i. in each iteration of the simulation, the simulation processes the leprachauns in order. processing a leprachaun i during its iteration begins by computing a new place on the horizon for i, which is determined by the assignment:
Answers: 3
question
Computers and Technology, 24.06.2019 21:30
Aobject is used for displaying the results of a question based on stored data. a. query b. report c. table d. form
Answers: 2
You know the right answer?
Elias recorded a macro for formatting all of his data cells that include scientific number notation....
Questions
question
Physics, 22.09.2019 19:10
question
Physics, 22.09.2019 19:10
question
Chemistry, 22.09.2019 19:10
Questions on the website: 13722363