Imported data appears entirely in column A. How do you separate the data into individual columns?
You can change, or ____, the contents of an active cell at any time.
Which of the following terms is NOT part of pivot table terminology?
Which setting must you modify to print a worksheet using a letterhead?
A ____ file contains data fields separated by a selected character.
Shape Data include the following steps?
In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional?i) Start date.ii) End date.iii) The type of day count basis to use.
Which table option gives you different background color for odd/even rows?
If all of the logical conditions are true, the and function returns the logical value _____.
In order to create a new report in Excel you have to go to:
To create an outline in Excel in order to easily expand a heading and show the summary below it, you would select from the menu:
A range of cells can be converted into an excel ________ so that the data can be analyzed.
When you click the header & footer button on the insert tab, excel switches to _____ view.
Which of the following is correct when #VALUE! error appears in cell?
Instead of using the Hide and Unhide feature for rows and columns, what feature lets you hide and unhide rows and columns interactively?
When tracking changes to a workbook, what restrictions can you apply?
A(n) ____ is a group of cells in a rectangular block
How do you change the orientation of a spreadsheet from portrait to landscape?
The countif function is sometimes referred to as a(n) _____ count.
Where do you place a MACRO that is supposed to run automatically after every entry on a worksheet?
What is the maximum number of columns allowable in an Excel worksheet?
Excel allows you to take a ____ of any open window and add it to a workbook.
The columns and pie slices in the charts above are ____.
Opening a workbook or switching from one sheet to another is an example of what?
The formula EXACT("Fish","fish") returns:
What is the answer for this formula? =if(A1>=B1,"Good","Not Good") ---> A1=90 , B1=90
To copy cell contents, you can select the cell and then press the ____ keys.
What is the fastest way to retrieve more than one comment?
What would the function "=Large(DataRange, 2)" return?
When using a spreadsheet, the expression =d8-d17 is called a ________.
Can Excel open two documents with the same file name simultaneously?
Each location in an Excel spreadsheet is called a:
Most software programs can both save and retrieve data in a(n) _______ file format.
You can use a template on Excel by going to...
Which keyboard shortcut selects all cells referenced by formulas in the selection?
In the Find and Replace function it is NOT possible to replace what you've searched for with an alternative at the same time.
Which of the following absolute references should be used to ensure that on copying, neither the column nor the row changes?
What is the correct answer: A1 value = 10 A2 value = 0 =IFERROR(A1/COUNT(A1:A2),"Err")
What will be displayed if custom format is [>8/15/16]"OVERDUE!";mm/dd/yy and cell contains 8/23/2016?
The total sales for Year 1 is in C20, and the total sales for Year 2, which is greater, is in D20. What formula will show the percentage increase?
When you widen a column that results in excess row height, you can eliminate the excess row height by:
When entering formulas and functions in Excel, the symbols *, /, +, and - are called:
Using ________ enables you to select one or more rows or columns and lock them into place.
True or False: A Name can be applied to a range of non-contiguous cells.
When a formatted number does not fit within a cell, what does the cell display?
True or False: You cannot insert comments for individual cells.
Cells and ranges in a worksheet can be formatted ____.
What is a sparkline in Excel?
You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?
When you're sharing a workbook with someone, how often does the workbook get updated?
Teachers: using these Excel questions with a class? Tell us about your class.