True or False: When you write a formula in Excel, the references in the formula are limited to that worksheet only.
###### in a cell means that the ____
Where can you print comments?
Peter was working in a Microsoft Excel 2016 workbook. His workbook closed due to a system error and he couldn't save it. Which of the following is the correct way to recover an unsaved workbook?
Which automation function calls a procedure in a dynamic link library or code resource?
To share your workbook with another user, what must they have?
A formula in Excel must begin with the operator:
If there is text in a column and you try to sort the entire column:
Which of the following keyboard shortcuts is used for moving from any cell to the beginning of a worksheet, i.e. cell A1?
What does COUNTA () function do?
An array range that includes both rows and columns is known as____?
An Excel worksheet is made up of columns and rows. Where these columns and rows intersect, they form little boxes called ____
You have two columns summing your account totals. The first column looks exactly right but the second one is not displaying the way you want. How do you make the two columns look the same?
Column A contains an apartment number, column B is the street number, and column C contains the street name. I would like all these values to be in the same cell; what function could I use to accomplish this?
You want to lock rows 1:2 and column A in place as you scroll through a large spreadsheet. Which command should you use?
What's one way of clearing the effect of a slicer that you've applied?
What additional ability does the Classic PivotTable Layout provide?
To hide a selected column, click the _____ button in the cells group on the home tab.
When creating a vertical page break without creating a horizontal page break as well, the active cell
Sam has a table with an Employee column and a Days column. He wants a PivotTable that shows how many employees have each Days value, for example 5 days = 3 employees and 6 days = 2 employees. Which field layout is correct?
In Excel 2013, the margin is set to which of the following values, by default, for each workbook?
If the source of sparkline data contains non-numeric data, they are neglected while plotting the sparklines.
If you aren't sure what type of chart to use for your data, how can Excel help?
If you save a workbook with the results of a Goal Seek calculation in place what will occur?
____ are named combinations of values that are assigned to variables in a model.
The Remove Duplicates command:
A(n) _____ chart is drawn on the same worksheet as the data.
Choose True or False.If a user specifies a print area from the backstage view, then it saves the setting with the workbook.
The ________, when outlined in black, indicates it is ready to accept data.
Functions can be selected by using the ________.
Which of the following options is not available on the Status bar?
Your transactions data set contains more than 10,000 rows. Some rows contain the same transaction. How would you remove the rows containing the identical transactions?
What is the default shortcut to apply accounting-style cell formatting? ex: ($5,454.25) for the value -5454.25
The source range for a Pivot table may not contain:
By default, after how many minutes does Excel 2013 auto save a user's workbook?
A pie chart ____.
The following sequence, 2, 4, 6, etc., is an example of a ____ series.
The characters +, -, *, and / are examples of ____.
I have a column of values in ranges A2:A100 that I need to concatenate with the number 2. Which of the following is not a way to do this?
In Excel, when does the mouse pointer change to a split double arrow?
What character is used in a formula cell reference so that it can be copied elswhere but still refer to the same cell or cells?
How can you drill down into a PivotTable to show details?
In Microsoft Excel 2016, Consolidate Option is available under which of the following tabs?
What does the function PV do?
Which feature lets you see two sheets of a workbook on screen simultaneously, so you don't have to switch back and forth?
You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?
In Microsoft Excel 2016, which of the following options is used to access the option that is used to get data from a text file?
State whether true or false:Case-sensitive sorting of text in Excel2007 can be performed.
Which of the following sorting options is NOT available under the Sort On dropdown menu in Sort dialog box while sorting the data of a table in an Microsoft Excel 2013 worksheet?
Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
Teachers: using these Excel questions with a class? Tell us about your class.