Purchase Solution

Templates and macros in Excel

Not what you're looking for?

Ask Custom Question

1. When viewing available templates, all of the following will appear EXCEPT
templates you have created.
themes you have created.
recently-used templates.
sample templates installed with the software.

2. A macro button is used for frequently used macros and allows other users of the workbook to use the macro
True or False

3. You cannot delete a macro once it has been created and saved
True or False

4. There is no need to practice the steps of the macro before recording it
True or False

5. Macros should be broad enough to apply to a variety of situations or an action that is performed frequently in the workbook
True or False

6. Which of the following is NOT an Excel tool used to improve productivity in developing consistently-formatted workbooks?
Macros
Templates
Themes
Background

7. Which of the following is NOT a method for starting the Macro Recorder?
Press CTRL+M to start the Macro Recorder.
Click the View tab, click Macros, and click Record Macro.
Click the Developer tab, if visible, and click Record Macro.
Click the Macro Recording icon on the Status Bar if it has been added to the Status Bar.

8. Which of the following file formats can NOT store macros?
Excel Macro-Enabled Workbook (.xlsm)
Excel Binary Workbook (.xlsb)
Excel Macro-Enabled Template (.xltm)
Excel Workbook (.xlsx)

Purchase this Solution
Solution Summary

8 Multiple Choice questions with annotated solutions regarding Excel macros.

Solution Preview

1. Themes you have created
This is clearly irrelevant to templates.

2. True.

3. False. It is possible to delete macros in the Macro popup ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • Quantitative methods in healthcare management

    Use this template for your calculations and answers: • Excel template for Exercises 11.1 and 11.6 Note on using the Excel templates: Use the automated Excel tables in Sheets 1 and 3 to perform calculations, and Sheets 2 and 4 to record your answers

  • Support Strategies in implementing a new Technology

    Ø Decision making on Macros and Templates: Macros used in the organization can be access database, spreadsheets, a support strategy is formulated on using or not using the templates.

  • Problems with Converting from Word 2003 to Word 2007

    The first issue has to do with macros. If you do not use macros in any of your word documents routinely, then this will be of little consequence. Due to increasing security issues, the use of macros is becoming more locked down.

  • Critical Path of the Construction Project and Data Collection

    All works are done in Excel.

  • Assembly and process chart

    Click on the enable macros button to see all the details in the file. 2. Prepare a process chart for the headphone assembly Attached Microsoft excel file: process charts_Head phone assembly.xls contains the process chart. 3.

  • Accounting: Instructions for the Microsoft Excel Templates

    270400 Accounting: Instructions for the Microsoft Excel Templates Instructions for the Microsoft Excel Templates Detail and information on Excel is contained within the manual.

  • Managerial Accounting, Third Edition by James Jiambalvo

    Managerial Accounting, Third Edition by James Jiambalvo "Solving Managerial Accounting Problems Using Microsoft Excel for Windows Templates by Rex A Schildhouse"(Spreadsheet templates are attached to assist in better understanding problems) Check the

  • Capacity Planning Given Demand Chances

    You will have to "ENABLE MACROS" The solution uses an attached Excel spreadsheet to draw a decision tree in order to reach a decision for whether a bakery should make a small or large expansion presently.

  • What is a template? How can it be used to make designing a

    Are there any other common tasks that templates can be applied to? How, and where can you find the templates? Template may mean: * Graphics template, a stencil or overlay used in drawing, painting or sewing to replicate letters, shapes or patterns.

View More Related Solutions