Formulas created using the point-and-click method contain ____ references.
How can you set 0.5 inch left indentation for a cell in Excel?
Which worksheet function returns the negative binomial distribution?
Error messages begin with the _____ symbol.
If you place the cursor in cell A2 which contains text and press the keystrokes CTRL-B / CTRL-I / CTRL-U the result will be:
A ___ is similar to a data bar in that it compares the relative values of cells in a range. Instead of bars in each cell, you see cell shading, where the shading color reflects the cell’s value?
To select nonadjacent changing cells, press and hold the _______ key as you click each cell.
To ensure that a collection of shapes are evenly spaced apart from left to right, select the shapes, click Page Layout > Align, and then click _.
Which character always appears in formulas with external references?
In which tab is located the Proofing group?
True of False: You can filter an Excel Pivot chart so that it shows only the information you want it to show.
The standard name of each cell is based on its ___________ and __________
____ shows you how a fill color will look before you apply it.
What's the function for calculating variance?
Which can format cell contents according to predetermined conditions?
Which keyboard shortcut applies strikethrough to selected cells in Excel?
A cell is referred to by its cell ____.
How can an interactive chart be created?
________ is the process of arranging data in a specific order based on the value in a field.
Anytime when you return more than a single cell, you should be using array formula. Array formulas are special formulas that work on an array of numbers and it will work effectively if you press the following keys combination?
Which of the following methods would you follow to remove subtotals?
What happens when you use the combination Ctrl+Space
Which Excel tool turns a list of text into a diagram made of shapes, such as a process or a hierarchy?
In the formula =VLOOKUP(A1,D1:H30,3,FALSE), the lookup value (A1) is being looked for in _.
Which of the following formats can you decide to apply in the AutoFormat dialog box?
Suppose you want VBA to run a loop that will continue until it finds an empty cell. Which of the following will allow you to do this?
How many users can work simultaneously on a shared workbook?
What is the default number for maximum iterations?
How can you remove duplicate rows in Excel?
To center worksheet data horizontally and vertically on a page, use the ________ dialog box.
If you want to print only from A1 to F20 of a much larger worksheet, and print that range several times, how could you make it the area that gets printed?
Which of the following formulas contains the correct syntax for a calculated field within a PivotTable?
____ is the amount added to the prinicpal of a loan by the lender.
Can Excel spreadsheets contain images?
What kind of formatting allows you to create a set of rules to format cells based on a cell value or another cell?
The formula bar displays the value or formula of the active cell. _________________________
The find & select button is found in the editing group on the ____ tab on the ribbon.
What is a group of cells that form a rectangle on the screen?
How do you close a formula?
Clipart can be found under what menu?
Which of the following depicts a correct range?
Which of the following is not a date and time function?
Choose True or False.VBA is used to automate tasks in Microsoft Excel 2010.
Which of the following features is/are available in Excel 2010?
The default border color around a chart title is ____.
Today is an example of a(n) ____________________ function.
In which tab is the page breaks preview located?
Columns and rows in a spreadsheet collectively are called a(n) ______.
Which worksheet function returns the standard normal cumulative distribution?
Statistical methods have been used for statistical analyses. A brief list of the more popular methods as following?
Teachers: using these Excel questions with a class? Tell us about your class.