Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________
Which function returns the leftmost five characters in cell A1?
Quick keyboard combination for launching VBA:
The ____ aggregate function finds the largest value.
If you deselect an item from the filter menu, it is called the filter ____.
A(n) _______ is a file that stores a collection of related data.
When you enter a two-digit year that is less than 30, excel changes the year to ____.
What is a column on a worksheet?
A chart that is inserted directly in the current worksheet is called a(n) ____ chart.
Which of the following is a statistical function? _____
To enter data in a cell, you must first select the ____.
Which Excel feature allows a user to split apart values in a text string into separate fields?
One way to structure text files is to use a(n) _______.
A collection of worksheets contained within a single file is called a ____ .
What is the setting that is the default macro security setting?
Which of the following options allows us to copy content without formatting?
How may criteria can the SUMIF function have?
Which feature allows you to display multiple copies of your worksheet in side-by-side windows?
Right clicking on a cell then selecting insert from the cell menu allows you to do what?
True or False: If a file is saved, the actions that preceeded the save command cannot be undone.
What's one method of entering headers and footers?
Which of the following is a "Lookup and Reference" function?
Which worksheet function returns the inverse of the Student
When using the PERMUT (number,number_chose) function, what syntax error will occur if the number_chosen is non-numeric?
Pressing CTRL-Home moves the cursor to:
PMT (rate, nper, pv, [fv=0], [type=0]
Double-clicking the column line to the right of a column activates the ____ feature for the column.
In Excel's PMT(rate, nper, pv, [fv], [type]) function, pv stands for the ____.
Which of the following is not true about an offline cube file?
What is the function of 'Relationships' or 'Data Model'?
To split a merged cell, select the cell and click the ____ button.
Which options reflect a correct range?
What conclusion could you reach if Cell B13 contained the text Apple and the formula =LEN(B13) returned 6?
Maria needs to find unique values in a Microsoft Excel 2010 worksheet. Which of the following is correct about selecting data for finding unique values?
To add a blank table to a page, use the table button on the ____ tab.
In Excel, which function would you use to find the average of all the cells that meet multiple criteria?
The report layout tools tabs are ____ tabs available only when working with report objects.
Excel can retrieve external data from which of the following sources?
What is the option on the Document Inspector that finds the content type information?
Cell A1 contains the text string 'X489Smith1740'. To determine the number of characters in the text string, use the formula:
Which of the following statements are correct about Microsoft Excel Online?
A ____ is a reference to a cell or range of cells in another workbook.
In the formula, which symbol specifies the fixed columns or rows?
What does CTRL(CMD)+D do?
Microsoft Excel Services is a component of:
A ________ in a pie chart identifies the pie slices.
Apa-style papers use ________ as the title of the list of sources.
A worksheet is made up of _____ organized in a grid of rows and columns.
You drew a triangle on the page and want to place an exact duplicate to the right. You want to make certain that the duplicate isn't any higher or lower on the page. How can you do this?
Cell A1 contains "Chang", and cell A2 contains "Pie". What is the result of the formula: =CONCATENATE(A1," ","and"," ",A2)
Teachers: using these Excel questions with a class? Tell us about your class.