Concept review 1
Using the dropdown lists below, create a formula that will return TRUE if a value in cel B5 is between 90 to 100
1. =AND 2. B5>=90 3. , 4. B5<=100
What formula would you use to get a TRUE value if cell C3 is greater than 14 or equal to 3
1. OR 2. C3>14 3. C3=3
You want to open the macro window so you can find a macro choose its options and assign a keyboard shortcut to it. Drag and match the steps in the correct order to access the macro window.
1. Select the view tab 2. Select the macros dropdown buttom 3. Select view macros
What function is required for this particular situation? As multiple conditions are being checked and both must be true in order for the conditional formatting to take place.
AND
Which option allows for range of a worksheet to be password protected
Allow Edit Ranges
Once the _____ feature is used options appear to where series can be filled, or one could choose just to cop cells, fill formatting only, or fill a series without formatting.
Autofill
Which is true about the Calculations Options drop-down button?
Both manually or automatically.
Though the ____ drop down button on the Formulas tab one can set workbook formulas to calculate manually or automatically.
Calculation Options
When one goes to save a workbook as a template where is the folder saved by default
Custom Office Templates Folder
What tab are form controls found on
Developer
What sign do references to cells in other workbooks start with
Equal Sign
Cell styles can be created through the cell style drop-down bottom and then through clicking new cell style. A new style is automatically applied to selected cells.
False
Custom themes made in excel cannot be applied to files in other Microsoft Office apps.
False
In the currency or accounting areas in the format cells dialog box, one cannot set a currency format to one of a number of international formats.
False
The customize ribbon area under options only allows one to remove ribbon tabs.
False
The protect workbook options can protect cells.
False
Within the macros settings, macros can be enabled, disabled, disabled for those that are digitally signed, or enabled with notification.
False
Where is the option to set or remove a password to protect an entire workbook located
File tab and through the protect workbook dropdown button
A cell style can modified through right clicking the style and then clicking the ___ button
Format
How many formats does a custom number format have
Four
Which tab contains Conditional Formatting
Home tab
The _____ window allows one to edit and/or delete conditional formatting rules
Manage Rules
On the file tab which option allows a file to be restored to a previous version if changes have been made prior to the last time the file saved recovery information and before the file was saved.
Manage Workbook
Where are macros stored
Modules
A body and heading set of fonts can be set through the customize fonts dialog box, which is available through the fonts drop down arrow, but on which tab.
Page Layout
Which tab contains the Custom color formats
PageLayout tab
Which tab is the Protect Workbook option under
Review tab
A structured reference is a reference to a table or a section of a table in a workbook.
True
By default, all cells on a worksheet are locked.
True
Data validation, which is done through the Data tab, allows one to configure a range of cells to limit what can be entered in those cells, and decide on the message to display when rule is violated.
True
In order to copy a macro from one workbook to another, its module needs to be copied from one workbook to another.
True
In the Date area in the format cells dialog box, one can seta date to one of a number of international formats.
True
The auto-recovery option located on the save page of excel options sets the frequency in which recovery information is saved for file. This does not automatically set files to save on a timer.
True
Where are the macros settings located
Trust Center Settings
What is the first step in protecting a worksheet
Unlock the cells that should be editable