MGRADES EXAMS
GMetrix Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
In order to copy a macro from one workbook to another, is module needs to be copied from one
workbook to another - CORRECT ANSWER - true
True or false: a structured reference is a reference to a table or a section of a table in a workbook
- CORRECT 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 - CORRECT ANSWER - false
True or false: customize ribbon area under options only allows one to remove ribbon tabs -
CORRECT ANSWER - false
By default all cells on a worksheet are locked - CORRECT ANSWER - true
Which is true about calculations options drop down button? - CORRECT ANSWER - both
manually or automatically
True or false the protected workbook option can protect cells - CORRECT 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. - CORRECT ANSWER - true
How many formats does a custom number format have? - CORRECT ANSWER - four
, MGRADES EXAMS
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 - CORRECT 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. -
CORRECT ANSWER - false
True or false: custom themes made an excel cannot be applied to files in other Microsoft office
apps - CORRECT ANSWER - false
Through the _____ _____ _____ one can choose a macro, choose its options, and then assign a
keyboard shortcut to the Macro. - CORRECT 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. - CORRECT 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. - CORRECT ANSWER -
false
The _____ function requires ALL arguments to be true in order for it to return a true value -
CORRECT ANSWER - AND
The _____ function requires ONE arguments to be true in order for it to return a true value -
CORRECT ANSWER - OR
When one goes to save a workbook as a template, where is the folder saved by default? -
CORRECT ANSWER - Custom office templates folder
GMetrix Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
In order to copy a macro from one workbook to another, is module needs to be copied from one
workbook to another - CORRECT ANSWER - true
True or false: a structured reference is a reference to a table or a section of a table in a workbook
- CORRECT 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 - CORRECT ANSWER - false
True or false: customize ribbon area under options only allows one to remove ribbon tabs -
CORRECT ANSWER - false
By default all cells on a worksheet are locked - CORRECT ANSWER - true
Which is true about calculations options drop down button? - CORRECT ANSWER - both
manually or automatically
True or false the protected workbook option can protect cells - CORRECT 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. - CORRECT ANSWER - true
How many formats does a custom number format have? - CORRECT ANSWER - four
, MGRADES EXAMS
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 - CORRECT 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. -
CORRECT ANSWER - false
True or false: custom themes made an excel cannot be applied to files in other Microsoft office
apps - CORRECT ANSWER - false
Through the _____ _____ _____ one can choose a macro, choose its options, and then assign a
keyboard shortcut to the Macro. - CORRECT 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. - CORRECT 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. - CORRECT ANSWER -
false
The _____ function requires ALL arguments to be true in order for it to return a true value -
CORRECT ANSWER - AND
The _____ function requires ONE arguments to be true in order for it to return a true value -
CORRECT ANSWER - OR
When one goes to save a workbook as a template, where is the folder saved by default? -
CORRECT ANSWER - Custom office templates folder
