MGMT 111 Excel Questions

Which type of function would you use to format a value as a label?

A cell with a formula that will be solved for specific results is called a(n):

Excel comes with many built-in formulas called:

A text hyperlink that you create in OneDrive & copy & post on social media/in a document/email to others is a(n):

The text label that describes each data series in a chart is the:

To access OneDrive online, open your browser and go to:

You have created an Excel workbook on your personal computer. What must you do before you can share this file?

In an Excel table, the first row of the table with unique descriptive titles or labels is the:

An object that you can use to display a choice, run commands, or perform actions in a worksheet is called a:

To highlight info in a sheet by setting different colors/fonts for cells containing data that meet criteria, use:

Text in a worksheet that displays a name/main title/row/column titles, and similar descriptive information is called:

a function within a function is described as:

In a histogram chart, the category labels are shown:

A single workbook is called an object while the term for a grouping of similar objects is a:

Excel can check data as it is entered using a process called data:

LinkedIn and Twitter are examples of:

Instead of typing the code or instructions to create a macro program, you:

a quick way to insert a new column or row in an existing worksheet is to select a column or row and press:

In Microsoft Excel, the file you create and edit is called a:

A column chart that illustrates the frequency of each data point in a data set is called a(n):

For workbooks to be linked, they must all be accessible over a network, on the same computer, or

ActiveX controls are found under this tab:

In Visual Basic, each line preceded by an apostrophe and shown in green is a:

A forecast sheet calculates:

To display the entire code for a Power Query, click the Advanced Editor button in the Advanced group of the:

This function displays the contents of the cell at the intersection of an identified column and row:

A pop-up text box for a cell with explanations or questions for coworkers is a(n):

importable doc that includes raw data, no formatting, and uses "," or other characters to separate the data into columns

The Statistical function that does computations only after data meets multiple criteria is:

A file format that is designed for exchanging data on the web is called:

When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:

By default, Excel 2021 files are saved with this extension

The Link button is located on this tab:

It is important to remember that Excel calculates these operations before any others are performed. 

To quickly select all the cells in a worksheet:

Use this button to combine two or more cells into one cell and center the text over a group of columns.

When you click on a cell to activate it, the cell address appears in the:

A radio button that enables the user to select one choice from a set of possibilities is a(n):

The Math & Trig function that totals cells ONLY if they meet specified criteria, is:

The Standard Deviation functions are found in this category:

The language that is specific to Power Query is:

This type of cell reference does not change when copied and remains in a fixed position during operations.

In a financial function, nper stands for:

The Create Relationship dialog box identifies a Table and a Related Table; the Related Table has a:

When you copy a formula with a relative cell reference, the copied cell reference is:

In an Excel worksheet dates and times are:

Which of the following is true of comments you create in an Excel Onlineworkbook?

To find information about your Microsoft Office account settings, go to:

the chart feature that allows you to specify which data is shown and which is hidden in the:

The rectangle that surrounds a SmartArt graphic is called a(n):

Once you place a screenshot in a worksheet, it becomes:

A pop-up message that appears after an error is entered is called a(n):

Calculated data that appears in the Power Query but is not a field in the source data is called a:

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

Available options that alter your Excel settings globally are found in the:

As you record a macro, Excel converts your keystrokes into:

A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n):

A series of scenes created by 3D Map that visualize your data is a(n):

This Excel feature allows users to use common arithmetic operations to perform a calculation:

Which depicts how a value compares to a measure?

Shared workbooks save a record of each change that has been made, which is called a(n):

What Excel add-in builds three-dimensional maps in a separate window for worksheet data?

You can build a data consolidation by category as long as the:

A saved set of values in a worksheet that functions as a "what-if" analysis tool is a:

Website data can be imported into Excel if the data is:

When you create a workbook from an Excel macro-enabled template, to use the macro you must first click:

The Microsoft Office relational database application that works with Excel to import and export data is called:

You can tell when an Excel template is macro-enabled by looking at its:

The Mark as Final command results in a(n):

if you wish to make formatting changes to identical worksheets in a workbook, do this before applying the changes

The type of chart that shows percentages of a whole and has no axes is a:

To use the services in OneDrive, you need to have:

To create a slicer, click the Insert Slicer button in the Filter group on the:

A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding "$"

The thin black plus sign pointer is used to:

To prohibit changes to the layout of the workbook separately from the data, select:

An Excel chart that is displayed on its own sheet in the workbook is called a:

A forecast sheet inserts functions into its tables from which function category?

When you apply a predesigned set of built-in format options for an Excel table, you use a:

Select the Keep me signed in check box to stay signed into OneDrive when you:

The term for specified Excel data that is indicated with a fill color, a horizontal bar, or an icon within the cell is:

When you want to delete characters in a cell to the left of the insertion point press:

To access recently used and popular Excel templates, open the Backstage view for the _____ command.

The Excel chart element that displays args in your data and can be used to forecast data by plotting future args is the:

A range of cells that shows calculated results of one or more formulas is called a:

To run a macro with a single click, assign a:

Summary measures for a data range such as the mean or average, the maximum, the minimum, or a count are:

To update a Power Query Editor, choose:

After you select and cut cells, the cells are placed:

To sort numerical data from the largest to the smallest value, use this sort order:

A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n):

To open the Visual Basic Editor with a keyboard shortcut, press:

An Excel command that recognizes a pattern and duplicates it is:

Which of the following is true of the Excel Online application versus Excel 2021installed on your PC?

Organization charts/matrices/pyramids/bulleted lists, etc. available within Office applications are called:

When you use Excel’s subtotal command your list data is formatted as a(n):

Available Add-ins for Excel are found in the:

This symbol alerts Excel that you are entering a formula and not text:

Excel function evaluates a specified condition/statement & returns a value if the condition or statement is true or not

To return the Ribbon to its original settings, click:

An Excel add-in with statistical and engineering functions is the:

Which Office Online application is a productivity tool for taking notes and recording audio?

a chart that includes two chart types such as a line chart and a column chart is referred to as a:

When you want column and row headings displayed no matter where you are in the worksheet, use:

The database function that counts the cells in the field that are not empty and that meet the criteria is:

a variegated blend of colors in a chart element is called a:

Alternative text can be added to an object in a worksheet to provide oral descriptions through use of a(n):

you check a workbook's macro security settings in the:

This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

In an OR function, if any one of the arguments is true, the result is:

The security warning bar does not open when you open a workbook with macros if you choose

If the data on your source worksheets might be edited after you have created your consolidation, you should:

A new excel workbook uses the default theme named:

A character such as an exclamation point that marks or signifies a component of an external reference is called a(n):

a regular group of cells in excel is a(n)

How many scenarios can be displayed in a worksheet at any one time?

The process of arranging rows of data in an identified order is called:

When you import a document into Excel that uses special characters, you are importing a:

Which function calculates a date from a start date going forward or backward in time?

The first key in a macro shortcut is always:

Macros must be saved in an Excel workbook with this extension.

To run a macro that was recorded with relative references, you must first:

To apply changes to your chart’s Shape Fill, Shape Outline, or Shape Effectsseparately, use the:

A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is a:

To save a custom grouping or subset of items in a PivotTable, create a(n):

A range of cells that you select in which to apply a function is called a(n):

The Error Checking options area lets you determine this formatting property of your error indicator.

Like many financial functions, the PV function uses the concept of a(n):

function calculates loan payment amounts when the borrower makes regular payments & loan has a constant interest rate:

Which statement is true once an Excel workbook has been shared in OneDrive?

Properties that are embedded in an Excel file, such as the user name at time of creation, are called:

If a workbook refers to data in another workbook, it is a:

Imported content in a worksheet that originated in another program or format is:

When you create a Warning alert box to prevent an invalid data entry, its message shows a(n):

You can find a button which toggles between Record Macro and Stop Recording in the:

The keyboard shortcut to insert a hyperlink is:

color-coded editing tool that applies different colors to each cell/cell range included within a formula is called the:

When you want to make the same change to many functions or formulas in a worksheet use this command:

When a formula contains a syntax error, it returns...

Database functions all follow the same syntax and have three:

basic conditional formatting command that uses relational or comparison operators

To use Office Online, you must:

The acronym “Please Excuse My Dear Aunt Sally” helps the user remember:

The Slicer tool creates an on-screen window that acts as a(n):

Solver is an enhanced Excel tool that is an example of an Excel:

A  static consolidation shows calculated values that:

A Solver problem has three components, known as:

A collection of tables and queries in a workbook is called a:

When you change the preset group of elements in an Excel chart, you are changing the:

To edit an Excel worksheet that is marked as final and therefore should not be edited, click:

To use an Advanced Filter in Excel, you first need to create a:

the background color for a chart element is called the:

The default view in Excel is:

The Locked cell property is active by default for all cells, but is not enabled until you turn on:

The Insert Controls button for creating forms is found on this tab:

A conditional column uses a(n) _____ to display new data in a query.

What text function repeats a text string as many times as you specify?

The Excel tool button that allows you to step through each part of a formula is called:

The Personal Macro Workbook is a choice in the:

chart styles are based on

A combination of instructions, filters, and sorts that establishes a connection to and displays data is a:

A step in finalizing a workbook for distribution in which you research a label or a value in a workbook is:

To edit an Excel worksheet that is marked as final and therefore should not be edited, click:

This chart type displays the frequency of multiple data series relative to a center point with an axis for each category

A problem-solving method that starts with a result and calculates the value to reach that result is: