The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called?
An organization chart, which shows the hierarchy within a company or organization, is available as _ that is included with Excel.
The Freeze Panes function allows the user to:
In Excel, what do most formulas begin with?
To set a page break in excel, select the _____.
A(n) ____ is an entry in a cell that contains text such as 2016 sales or travel expenses.
Grouping is ________.
An Excel workbook is a collection of ?
How can you delete the contents of a cell and its formatting at the same time?
_____ are an example of conditional formats in excel.
Which formula returns the value in cell A1 of the worksheet named MySheet?
What-If analysis functionality in Excel includes:
Under what tab can the Scenario Manager be found?
A(n) ____ identifies each data series in a chart, generally with a different color.
____ format codes allow you to specify how a cell entry assigned a format will appear.
A theme can be applied using the themes button in the themes group on the ____ tab on the ribbon.
Which of these characters is not allowed as part of a tab name?
What ribbon command on the Home tab can you use to change a cell's fill color automatically, based on the value of the cell?
Which of the following is/are correct about macro naming rules in Microsoft Excel 2016?
A ________can retrieve data from multiple fields in different tables in the data model
Function(argument1, argument2, ...) is ____.
When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
What is the function to display only the current date?
____ order arranges labels in reverse alphabetical order, from a to z
Cell A4 contains the number 19.5. What does the formula =T(A4) return?
What does it mean when the "marching ants" border around selected cells disappears?
How would you summarize sales data in a PivotTable by product name?
When using a Lookup to extract data, what is the meaning of the true/false argument?
How can you add a total row to an already created table?
An .xlsx file cannot store VBA macro code or Excel 4.0 macro sheets.
Why is it a good idea to keep track of numbers, projects and lists in Excel, rather than in text files?
Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.
Where do you find the picture icon?
If A1 contains the text "Red" and B2 contains "Blue" then =OFFSET(A1,1,1) returns
Which of the following is correct syntax for typing a function into a cell?
The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?
The default format for cells that meet a condition with conditional formatting is ____.
Which would you choose to create a bar diagram?
Which worksheet function returns the probability that values in a range are between two limits?
If two formulas that depend on one another need to be solved at once and a circular reference is created, this can be resolved by:
What function can be used to identify duplicate values in Column A?
John inserts a PivotTable based on a table that has a Days column containing only numbers. He drags the Days field into the Values area of the PivotTable Fields pane. Which summary does Excel use by default?
A formula with brackets such as {sum((C2:C1)*(D2:D11))} is called:
How can you remove an icon from the Quick Access Toolbar?
Which of the following logical functions doesn
What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?
True or False: The Remove Duplicates command treats items that are spelled the same but capitalized differently as two distinct items.
What is the correct syntax of the worksheet function “RANK”?
You're writing a macro and want to add the following comment: use this code. How would you add this comment?
Under the Format menu, under COLUMN, which of the following is NOT an option?
Teachers: using these Excel questions with a class? Tell us about your class.