Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/19

Click to flip

19 Cards in this Set

  • Front
  • Back
Cells, unlock:
a.) Click Format,
b.) Click Cells
c.) Click the Protection tab
d.) Deselect the Locked checkbox
e.) Click OK
Data, create error alert message:
a.) Click Data
b.) Click Validation
c.) Click the Error Alert Tab
d.) Make sure that Show error alert after invalid data is entered check box is checked.
e.) Select an alert style.
f.) Enter the title and text for the error alert message.
g.) Click the OK button
Data, create input message:
a.) Click Data
b.) Click Validation
c.) Click the Input Message tab
d.) Enter a title and text for the input message
e.) Click the OK button
Data, create validation rule:
a.) Click Data
b.) Click Validation
c.) Click the Settings tab
d.) From the Allow list box, select the type of data allowed in the cell
e.) Enter the validation rule using the available input boxes
f.) Click the OK button
Macro, edit:
a.) Click Tools
b.) Point to Macro
c.) Click Macros
d.) Select the Macro in the list, and then click the Edit button
e.) Use the Visual Basic Editor to edit the macro code.
Macro, record:
a.) Click Tools
b.) Point to Macro
c.) Click Record New Macro
d.) Enter a name for the macro, and specify the location in which you want to store the macro
e.) Specify a shortcut key (optional)
f.) Enter a description of the macro (optional)
g.) Click the OK button to start the macro recorder
h.) Perform the tasks you want to automate
i.) Click the Stop Recording button on the Stop Recording toolbar (or click Tools, point to Macro, and then click Stop Recording)
Macro, run:
a.) Press the shortcut key assigned to the macro
or
a.) Click Tools
b.) Point to Macro
c.) Click Macros
d.) Select the macro from the list of macros
e.) Click the Run button
Macro, set security level for:
a.) Click Tools
b.) Point to Macro
c.) Click Security
d.) Click the Security Level tab
e.) Select the options button for the level of security you want to set
f.) Click the OK button
Macro button, create:
a.) Click View
b.) Point to Toolbars
c.) Click Forms
d.) Click the Button tool on the Forms toolbar, and then click and drag the mouse pointer until the button is the size and shape you want.
e.) Release the mouse button. Select the macro you want to assign to the button. With the button still selected, type a new label.
Name, create for a range:
a.) Click Insert
b.) Point to Name
c.) Click Create
d.) Specify whether to create the ranges based on the first row, last row, first column, or last column in the list
e.) Click the OK button
Name, create for a cell:
a.) Select the cell or range to which you want to assign a name
b.) Type the name into the Name box on the Formula bar
or
a.) Click Insert
b.) Point to Name
c.) Click Define
d.) Enter the name of the range in the Names in workbook text box
e.) Click the Add button
f.) Click the OK button.
Name, edit definition:
a.) Click Insert
b.) Point to Name
c.) Click Define
d.) Select the range name you want to edit
e.) Change the cell reference in the Regers to box
f.) Click Add
Name range, replace cell reference with:
a.) In a worksheet formula, replace the text for the cell reference with the text for the name.
or
a.) If the cell reference and name definition both lie in the same worksheet, click Insert
b.) Point to Name
c.) Click Apply
d.) Select the names you want to apply from the Apply names list box
e.) Click the OK button
VBA, insert a command:
a.) Open the Visual Basic Editor
b.) Display the macro in the Code window
c.) Click at the end of a VBA command
d.) Press Enter
e.) Type the new command
VBA code, view:
a.) Click Tools
b.) Point to Macro
c.) Click Macros
d.) Select a macro
e.) Click Edit
Visual Basic Editor:
a.) Click Tools
b.) Point to Macro
c.) Click Visual Basic Editor
or
a.) Click Tools
b.) Point to Macro
c.) Click Macros
d.) Select a Macro
e.) Click Edit
Workbook, protect:
a.) Click Tools
b.) Point to Protection
c.) Click Protect Workbook
d.) Enter a password (optional)
e.) Click the check boxes to indicate whether you want to protect the workbook’s structure, windows, or both
f.) Click the OK button
Worksheet, protect:
a.) Unlock the cell or range of cells that you don’t want to protect.
b.) Click Format
c.) Click Cells
d.) Click the Protection tab
e.) Deselect the Locked check box
f.) Click Tools
g.) Point to Protection
h.) Click Protect Sheet
i.) Enter a password (optional)
j.) Select all of the actions that you will allow users to do even if the sheet is protected.
k.) Click the OK button.
Worksheet, unprotect:
a.) Click Tools
b.) Point to Protection
c.) Click Unprotect Sheet