Another name for an input in a function is a(n) ________.
How does a user prevent circular references conflict errors?
True or False: Frequency is an array function.
What are ScreenTips in Microsoft Excel 2016?
The formula ISERR(A1) does not return TRUE if A1 is :
To use the Subtotals feature, the list that has numbers you want to add must be:
Tables are organized into rows, called ____.
In pivottables, ____ fields correspond to columns in the original data.
In Microsoft Excel 2016, if Sam wants to change the Office theme or background. then which of the following options will he use?
Which keyboard shortcut pastes copied information?
The formula SUMPRODUCT(a1:a4,b1:b4) is equivalent to:
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:
What does the Mod function do in an equation?
An absolute cell reference _____ change when copied to another cell.
Which of the following is NOT a 'Solving Method' available in the Solver Add-in?
Which of the following keyboard shortcuts is used for displaying the Record Macro dialog box that is used for recording macros?
How do you control which cells are printed?
To design a form using the form wizard, begin by clicking on the ____ tab on the access ribbon.
How do you turn data from rows into columns in Excel?
What's a quick way of rearranging the order of the worksheet tabs?
Spell check can be found in the _______ menu
What will be returned by entering the following formula? =SUM({1,0,1,0,1})
The best way to automate a complex, repetitive task within a worksheet, is to create:
____ calculates the average of a range of cells.
When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _.
Which Windows Keyboard Shortcut unhides any hidden rows within the selection.
To create smartart, switch to the insert tab and use a button in the ____ group.
Excel includes ____ types of smartart graphics.
The definition of a macro is:
State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
It is possible to password protect content of selected cells so that cannot be modified
If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?
An example of a(n) ____ chart is a column chart with a line chart.
Which worksheet function returns values along a linear trend?
In Excel, the Insights panel displays online information and images about the text you highlighted. What is that specific control that hold the insights panel when you right click on your highlighted text?
A data ____ table describes the fields you plan to maintain in a table
Deleting a PivotChart report automatically deletes the associated PivotTable report.
Rows are typically represented by _______ and contain data for individual records.
In a bar graph the horizontal axis is the:
Which worksheet function returns the sum of squares of deviations?
To remove extra space from a cell, use the formula:
In the formula =(B6+39)/SUM(D4:F8), which part is evaluated first?
How many conditions can be set for an individual cell's conditional formatting?
How would you search an entire workbook with Find & Select?
The Solver in MS Excel is used for what?
To force cell A1 to only accept the text value which of the following is correct?
What is the function of the word "=SUM" at the beginning of an Excel spreadsheet formula?
In Excel, you can choose a picture as the background of a:
What will the formula =A1*C1 return?
In the formula =if(a1=b1, c1, c2), the result will be c2 if ____.
Teachers: using these Excel questions with a class? Tell us about your class.