GMetrix Final Review Exam Questions
And All Correct Answers.
In order to copy a macro from one workbook to another, is module needs to be copied from one
workbook to another - Answer true
True or false: a structured reference is a reference to a table or a section of a table in a workbook -
Answer true
True or false: within the macro settings macros can be enabled , disabled , disabled for those that are
digitally signed or enabled with notifications - Answer false
True or false: customize ribbon area under options only allows one to remove ribbon tabs - Answer
false
By default all cells on a worksheet are locked - Answer true
Which is true about calculations options drop down button? - Answer both manually or automatically
True or false the protected workbook option can protect cells - Answer false
True or false: the auto recover option located on the save page of excel options such as the frequency in
which recovery information is saved for file. This does not automatically set files to save on a timer. -
Answer true
How many formats does a custom number format have? - Answer four
True or false: data violation which is done through the data tab, allows one to configure a range of cells
to limit which can be entered in those cells and decide on the message to display when the rule is
violated - Answer true
, True or false: Cell styles can be created through the cell styles drop-down button and then through
clicking new self style. A new style is automatically applied to selected cells. - Answer false
True or false: custom themes made an excel cannot be applied to files in other Microsoft office apps -
Answer false
Through the _____ _____ _____ one can choose a macro, choose its options, and then assign a keyboard
shortcut to the Macro. - Answer Step 1: View Tab
Step 2: Macors drop-down button
Step 3: View Macros
True or false: in the date area in the formats dialog box, one can set a date to one of a number of
international formats. - Answer true
True or false: in the currency or accounting areas in the format sells dialog box, one cannot set a
currency format to one of a number of international formats. - Answer false
The _____ function requires ALL arguments to be true in order for it to return a true value - Answer
AND
The _____ function requires ONE arguments to be true in order for it to return a true value - Answer
OR
When one goes to save a workbook as a template, where is the folder saved by default? - Answer
Custom office templates folder
Where are macros stored? - Answer modules
What sign two references to cells in other workbooks start with? - Answer Equal signs
Where are the Macro settings located? - Answer trust center settings
And All Correct Answers.
In order to copy a macro from one workbook to another, is module needs to be copied from one
workbook to another - Answer true
True or false: a structured reference is a reference to a table or a section of a table in a workbook -
Answer true
True or false: within the macro settings macros can be enabled , disabled , disabled for those that are
digitally signed or enabled with notifications - Answer false
True or false: customize ribbon area under options only allows one to remove ribbon tabs - Answer
false
By default all cells on a worksheet are locked - Answer true
Which is true about calculations options drop down button? - Answer both manually or automatically
True or false the protected workbook option can protect cells - Answer false
True or false: the auto recover option located on the save page of excel options such as the frequency in
which recovery information is saved for file. This does not automatically set files to save on a timer. -
Answer true
How many formats does a custom number format have? - Answer four
True or false: data violation which is done through the data tab, allows one to configure a range of cells
to limit which can be entered in those cells and decide on the message to display when the rule is
violated - Answer true
, True or false: Cell styles can be created through the cell styles drop-down button and then through
clicking new self style. A new style is automatically applied to selected cells. - Answer false
True or false: custom themes made an excel cannot be applied to files in other Microsoft office apps -
Answer false
Through the _____ _____ _____ one can choose a macro, choose its options, and then assign a keyboard
shortcut to the Macro. - Answer Step 1: View Tab
Step 2: Macors drop-down button
Step 3: View Macros
True or false: in the date area in the formats dialog box, one can set a date to one of a number of
international formats. - Answer true
True or false: in the currency or accounting areas in the format sells dialog box, one cannot set a
currency format to one of a number of international formats. - Answer false
The _____ function requires ALL arguments to be true in order for it to return a true value - Answer
AND
The _____ function requires ONE arguments to be true in order for it to return a true value - Answer
OR
When one goes to save a workbook as a template, where is the folder saved by default? - Answer
Custom office templates folder
Where are macros stored? - Answer modules
What sign two references to cells in other workbooks start with? - Answer Equal signs
Where are the Macro settings located? - Answer trust center settings
