Choose True or False.A PivotChart is a graphical representation for a summary of data displayed in a Pivot table.
Excel's __________ can be used to construct a frequency distribution for categorical data.
Print all, pages, and selected record(s) are options available from the ____ for printing forms.
State whether true or false:No data is deleted when an outline is hidden or removed.
What will F11 command do?
True or False: You can save any Excel document as a web page.
Excel 2003: True or False: You can never open any workbook that has previously been saved and given a name.
Which keyboard shortcut selects cells that contain formulas that directly reference the active cell?
Is it possible to sort by the color of a cell in the most recent version of excel?
What is the effect of adding an apostrophe before the equals sign in the cell entry =(98-42)^0.5?
Which of the following feature correctly represents the following statement? In Excel we can use text series (such as January, February, March, or Sunday, Monday, Tuesday) and numeric series (such as 1, 3, 5, or 2014, 2015, 2016). Instead of entering these series by hand, you can use the fill handle to create them automatically.
If cell A1="Smith,Joe" then =Find(",",A1) returns:
What is the difference between a workbook and a worksheet?
True or False: To calculate trig functions in degrees, you must convert them, or Excel will calculate them in radians.
John selects separate theme colors, formatting effects and theme fonts from their respective galleries. Now he wants to save the current settings for future use. In the Themes option under the Page Layout tab, which of the following is the correct option that can be used to save the current theme?
A formula may return any of the following error values:
When your chart is selected, how can you get a small pop-up of alternate chart styles to choose?
In Microsoft Excel 2016, which of the following statements is/are correct about dates?i) The default date format uses 4 digits for the year.ii) The dates are left-justified in the cells by default.
If you start a date series by dragging down the fill handle of a single cell that contains the date 12/1/19, what will you get?
Which Group on the ribbon gives you quick access to the Sum, Average, Count, Min, and Max functions?
How do you view the 5th decimal place when calculating costs?
Is it possible to determine the day of the week for a particular date?
The ____ is the typeface used to display and print data. it is measured in
A cell with a numerical value has a green corner. What does this mean?
Which worksheet function returns the standard error of the predicted y-value for each x in the regression?
In Excel, right-clicking the sheet navigation arrows at the bottom-left of the window opens which dialog box?
In the following formula, where is the Table Array located? =VLOOKUP(A5:A19,[RegionalSales]FY2012!$D$2:$J$31,7,FALSE)
In Excel, which error does VLOOKUP return when the lookup value is not found?
The less precise way to move objects in report layout view is to ____.
The path to the format painter button is ____.
In the following formula: =if(a1=""yes"", ""done"", ""restart""), what happens if a1= no? _____
A(n) ________ is a worksheet where totals from other worksheets are summarized and displayed.
Which of the following formulas is not entered correctly?
Circular errors are caused by adding the cell name of a/an _______ cell to a formula
The ____ button allows you to erase recent cell entries.
All functions begin with the formula prefix ____.
To make data easier to understand, use a ________ instead of a table of numbers.
In which tab do you find Macros in Excel 2013?
The clear all option in the clear button removes the ____ from the active cell.
Which of the following statements is correct about the #Data constant in Microsoft Excel 2016?
Which language is used to create macros in Excel?
For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?
What does the function DATE(year, month, day) do?
Which of the following statements is correct about Excel file protection?
By default, excel keeps a change history of ____ days for a shared workbook.
Voice and unified communications are ________ applications that use 64-byte ip packets.
How to you create a pivot table?
In an Excel pie chart, the rectangular box beside the chart that shows which color stands for each slice is the ____.
To view a cell comment, do which of the following?
How will you display the Go To dialog box?
Teachers: using these Excel questions with a class? Tell us about your class.