True or False: It is possible to upload a SWF file into Excel.
True or False: A sparkline usually shows trend information.
Next to a selected PivotChart in Excel 2016, three buttons appear. What does the button with the paintbrush symbol open?
What would the following formula do? =Sheet1!D9+Sheet1!E9
To get all rows and columns of data to print on one sheet, you can adjust the page breaks in Page Break Preview or:
Cells B3 through B121 list several values. What equation shows the average of those values?
Suppose that you have a worksheet that you update frequently by adding new data to columns. You may need a way to reference the last value in column A (the value most recently entered at bottom of column A). If column A contains no empty cells which of the formula returns the last value entered in column A (bottom one)?
True or False? The sumif function can sum data based on multiple criteria.
What is one way to get a new workbook?
True or false? The Quick Access Toolbar (QAT) is useful for adding popular commands.
To start a new line in a cell press the ____ keys
What is the correct formula to calculate the total of cell B3 and B4?
In Excel, when does a small green triangle appear in the top-left corner of a cell?
Which single-color fill option for a shape in Excel lets you choose a color and set how transparent it is?
When working in Page Break Preview, we can do which of the following?
Which of the following charts have no axes?
How do you make a long sentence fit into the column size?
How do you insert saved images?
A lookup table organizes numbers or text into categories. _____________
Cell A1 has this information "Current Value: $10.00" Which function extracts "Value:" from "Current Value: $10.00"?
To speed up the calculations of a data table on a worksheet,
A ____ total sums all of the data in a row or column.
The quickest ways to save as:
If $34 is entered into a cell, Excel will interpret it as:
Which menu option can be used to split a window?
Which of the following feature is correct about autofill?
How do you begin to record a macro?
How do you change the column labels from numbers to letters?
Which of the following is a correct way to hide the contents of a cell?
To autofill month names you need to type __ and then drag the fill handle. (choose all that apply)
What does the Surface chart type describe?
Which tab do you click to make paragraphs in Excel?
How can you zoom in and out of a worksheet, just by using your mouse?
Peter made an Excel sheet of the names and prices of articles sold at a jewellery store. When he opened it again, some price cells showed only pound signs (####). What should he do?
An example of a range address.
Which worksheet function returns the skewness of a distribution?
All of the following are options in the delete menu except ____.
Which solver method will change variable cells to meet an objective cell?
Cell references that reference other sheets behind the summary sheet are known as ____ references.
The definition of the array formula {=SUM((C90:C93)*(D90:D93))} is:
Which formula will provide the same result as the following: =SUMPRODUCT(A1:A10,B1:B10)
It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?
Which of these choices is NOT one of the four function arguments in a VLOOKUP?
When working with a large worksheet, you can split the window into ____ panes.
When I have selected a column, what is the shortcut I can use to completely delete it?
The ____ feature is especially useful when working with very large worksheets.
Which of the following is a valid type of graph?
Which is the following statement is True for Ribbon?
A ____ is an interactive view of worksheet data.
Can a macro save a file?
Teachers: using these Excel questions with a class? Tell us about your class.