excel gmetrix
using the dropdown lists below, create a formula that will return true if a value in cell B5 is between 90 and 100.
=AND(B5>=90,B5<=100)
what formula would use to get a true value if cell C3 is greater than 14 or equal to 3?
=OR(C3>14,C3=3)
which 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 a range of a worksheet to be password-protected?
allow edit ranges
once the _____ feature is used, options appear to where the series can be filled, or one could choose just to copy cells, fill formatting only, or fill a series without formatting.
autofill
which is true about the calculation options drop-down button?
both manually or automatically
through 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 signs
true or false: cell styles can be created through the cell styles drop-down button and then through clicking new cell style. a new style is automatically applied to selected cells.
false
true or false: custom themes made in excel cannot be applied to files in other microsoft office apps.
false
true or false: in the currency of accounting areas in the format cells dialog box, one cannot set a currency format to one of a number of international formats.
false
true or false: the customize ribbon are under options only allows one to remove ribbon tabs.
false
true or false: the protect workbook option can protect cells.
false
true or 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 drop-down button
a cell style can be 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
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?
page layout
which tab is the protect workbook option under?
review
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.
select the view tab. select the macros dropdown button. select view macros.
by default, all cells on a worksheet are locked.
true
true or false: a structured reference is a reference to a table or a section of a table in a workbook.
true
true or false: 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 the rule is violated.
true
true or false: in order to copy a macro from one workbook to another, its module needs to be copied from one workbook to another
true
true or false: in the date area in the format cells dialog box, one can set a date to one of a number of international formats.
true
true or false: the autorecover 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
