Which formula yields the address of the last cell in a range?
Double clicking the currently-selected tab on The Ribbon will do what?
True or False: Once cells are merged in Excel, they can never be un-merged.
To ensure a worksheet will print all on one page, adjust the settings in the:
Which formula below will add the value of B2 to the value of C3
The formula QUARTILE(a1:a100,4) returns:
Which of the following wildcard characters can be used as comparison criteria for Text Filters?
To unhide a sheet and make viewable with other tabs in the current window:
An __________ is an object in a worksheet.
How to compute a sum?
Center, left and right text justification are examples of ________.
In Microsoft Excel 2016 worksheet, which of the following shortcuts is used for switching between displaying formulas and their results?
If cell A2 has a full name (Fristname, Middle Initial and Lastname) like "Karen E. McRich" which of the following formula will extract the lastname?
Rather than creating a new, blank workbook by clicking the File tab, selecting New, then clicking Blank, what's the keyboard shortcut?
How can you launch a regression in excel 2010?
If A1 is "=4*2" and B1 is "=6/2", what result would appear if C1 was "=A1(#)B1
You can use ____ to move around in a document that is too large to fit on the screen at once.
Validation rules are entered in the ____
The aggregate function extends the capability of the subtotal function. Which function calculates the variance of values in the range by examining a sample of the values?
Excel 2003: Also called a spreadsheet, the _____ is a unique file created by Excel.
Using the excel spell checker, you can ____.
In Microsoft Excel 2016, data sorting in columns can be performed on which Of the given Options?1. Values2. Cell Color3. Font Color4. Cell icon
Which formula returns the value in cell A10 of the worksheet named Budget Variances?
How do you ensure that the person using a spreadsheet can always see the column headings?
Which of the following is not an excel function category? ____
What's the recalculate shortcut?
What is the benefit of using Slicers?
The ____ option helps fit the data on a single page without making changes to individual margins.
The "Merge & Center" button does what?
What command reveals which cells must contain data for the function in the currently selected cell to work?
What is the purpose of the BIN2HEX function?
True of False? Excel 2013 will let you save a file into a cloud service, like Microsoft OneDrive or Sharepoint.
You can add an image to a template by clicking the Insert Picture From File button on the __ Toolbar?
The ____ aggregate function finds the smallest value.
A screen ____ is a portion, usually of one object or section of a window, of the screen.
Let's say you have rows of names & addresses, and you want to sort by Zip code. How would you do this?
Category values are usually located in the ____ of the data source.
The formula =REPLACE("the cat in the hat",12,3,"red") returns:
What is a logical function?
State whether following statement regarding images in Microsoft Excel 2010 is true or false:Microsoft Excel 2010 supports 3D rotation of images.
Identify the one function in the following list that does not require the use of any argument(s):
By default, the pivottable report uses the ____ function for numbers in the values area.
The oracle string concatenation function is _____.
What is the difference between pressing the delete key and using the clear command in the Home tab's Editing group?
John's PivotTable lists employee names with the Sum of Sales. The source data has Employee, Product and Sales columns. He wants to show the products under each employee name. Where should he double-click so that Excel asks him which field to show?
If you enter the formula =mod(2,5) into a cell, what will the cell display?
An Excel 2016 table has a Units column, its last column, containing 5, 8, 7 and 9. If you select the table and check Total Row on the Design tab, what does the total row show under Units by default?
What does the blue triangle and border color imply in cell B4?
How do you create a cell featuring a drop down list of values?
A "frequency distribution" is a summary table that shows the frequency of each value in a ___?
Teachers: using these Excel questions with a class? Tell us about your class.