GMETRIX Pathway Exam

gmetrix

In order to copy a macro from one workbook to another, is module needs to be copied from one workbook to another

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: within the macro settings macros can be enabled , disabled , disabled for those that are digitally signed or enabled with notifications

false

True or false: customize ribbon area under options only allows one to remove ribbon tabs

false

By default all cells on a worksheet are locked

true

Which is true about calculations options drop down button?

both manually or automatically

True or false the protected workbook option can protect cells

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.

true

How many formats does a custom number format have?

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

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.

false

True or false: custom themes made an excel cannot be applied to files in other Microsoft office apps

false

Through the _ one can choose a macro, choose its options, and then assign a keyboard shortcut to the Macro.

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.

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.

false

The _ function requires ALL arguments to be true in order for it to return a true value

AND

The _ function requires ONE arguments to be true in order for it to return a true value

OR

When one goes to save a workbook as a template, where is the folder saved by default?

Custom office templates folder

Where are macros stored?

modules

What sign two references to cells in other workbooks start with?

Equal signs

Where are the Macro settings located?

trust center settings

Which option allows for a range of a worksheet to be password-protected?

allow edit ranges

What is the first step in protecting a worksheet?

Unblock the cells that should be editable

Through the _ drop-down button on the formulas tab, one can set workbook formulas to calculate manually or automatically.

calculation options

Which tab is the protected workbook option under?

Review

On the file tab under, options, a file can 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 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

Once the feature is used, option appear to where the series can be filled, or one could chose just to copy cells, fill formatting only, or fill a series without formatting.

Autofill

Which tab contains conditioning formatting?

Home

What function is required for this particular situations? As multiple conditions are being conditions are being checked and both must be true in order for the conditional formatting to take place.

AND

The windows allows one to edit and/or delete conditional formatting rules.

Manage Rules

Which tab contains the custom color formats?

Page Layout

A cell style can be modified through right-clicking the style and then clicking the _ button.

Format

What tab are Form controls found on?

Developer

A body and heading of fonts can be set through the Customize Fonts dialogue box, which is available through the Fonts drop-down arrow, but on which tab?

Page Layout

In which type of folder are macros stored?

modules

Which ribbon tab is hidden by default?

developer

By default, what is the status of worksheet cells?

Locked

Which is true about implementing he Protect Workbook feature?

sheets cannot be added

Which is the proper order for the formats of a custom number formats?

Positive, negative, zeros, text

Which conditional formatting conditions require a custom conditional formatting rule to be created? choose two answers

less / greater than or equal two

Which are aspects that compromise a theme?

Colors

Fonts

Styles

Where are the options for formatting a cell's date to an international format found?

number dialogue box launcher

Which function returns the opposite of a calculated value?

NOT

Which two functions are often used together to find a cell value within a grid, based on criteria?

INDEX / MATCH

Which function serializes a date so that it can be used in calculations?

DATE

Which data analysis feature allows for both summarizing data from multiple locations and, when wanted, showing the details of the data being summarized?

Data consolidation

Which specific function calculates a payment based on the starting amount, interest rate, and number of payments?

PMT

Which formula auditing options shows, through arrows, cells that rely on a selected cell for a formula?

trace dependents

What is not allowed in names of ranges?

cell addresses

spaces

Which type of chart trendline shows data trends in a straight line?

linear

Which best offers visual representation of filters in a pivot table?

Slicers

Which function allows for data from within a PivotTable to be displayed outside a PivotTable?

GETPIVOTDATA

Which is true about the behavior of PivotTables or PivotCharts? choose TWO

Changing data in a PivotTable also changes PivotChart (vice versa)

The __ function also returns the opposite of a calculated value. e calculated value could be a value calculated within another cell.

NOT

The _ is used to add a range if cells based on multiple conditions. Both the conditions and the range to sum must be specified

SUMIFS

The _ used to average a range of cells based on multiple conditions. both the range of cells and the conditions must be specified.

AVERAGEIFS

The _ function is used to get numeric count,. based on multiple conditions, for a range of cells.

COUNTIFS

The _ function uses a known value to get unknown information from a vertical table of information

VLOOKUP

The _ function uses a known value to get unknown information from a horizontal table of information

HLOOKUP

The _ function finds a cell that matches a condition within a range of cells. the function then returns the number of a cell within the range of cells

MATCH

The _ function used to find a matching value for a criterion at row-column intersection within a range of cells.

INDEX

The _ function displays the current date but not the current time.

TODAY

The _ function displays the current date and the current time.

NOW

The _ function serializes a date so that it can be used in a calculations.

DATE

True or False: Power of QUERY theory, accessed through the get data button, on the data tab, is used to transform data being imported by another file editor.

True

True or False: The consolidate data feature located on the data tab on is only used to summarize data

false

What is a nested function?

involves having one function inside of another function