Which worksheet function returns the rank of a number in a list of numbers?
In an Excel table with data in rows 2 to 6, you enter the formula =B2*C2 in cell D2. What happens if you select D2 and drag its fill handle down to D6?
What will be the result of this formula =MOD (40, 0) ?
Cell A1 of an Excel sheet contains the text "this is a book". What is the result of entering =PROPER(A1) in cell A2?
Which of the following is NOT a way to align a cell?
What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?
_____ messages appear as screentips next to the active cell.
in relation to the Backstage view in Microsoft Excel 2016, which of the given commands! options are available under the Info tab?1. Protect Document2. Manage Workbook3. Browser View Options
If you choose Find & Replace All when the cursor is in one cell, it will result in:
In Excel 2016, the Forecast Sheet feature can turn a worksheet which contains historical financial data in a visual forecast worksheet. What type of chart is used by default if you do not use a chart of your own choice?
What is the purpose of the Σ button?
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
Column A lists a long string (example:A3= 1234Smith1740.434.21) where the first four digits are the employee number. What formula in B3 will extract only the employee number from the string in cell A3?
Formatting a cell in Currency, you can specify...
Robert inserts a PivotTable in Sheet 2 of a worksheet. He drags the "Days" field from the PivotTable Fields to Values section. Which of the following options will be the default selection under Values?
How can you format one sparkline separately from all the others?
Currency figures in Excel can be changed from US Dollars to the:
In an Excel worksheet, the cells in the Registrations column have small red triangles in their upper-right corners. What do these signify?
A ____ is text and graphics that print at the bottom of every page.
If you want to set the print area which ribbon should you use?
What function do you use to find the present value of a series of annual cash flows at a specified discount rate?
Which feature lets you scroll through two worksheets simultaneously, making it easier to check one sheet against another?
Identify all the arguments and the correct order of arguments needed to execute the IF() function.
What is the main difference between a Sumif equation and a Sumifs equation?
Which of the following is True when #NAME, error appears in Excel cell?
Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?
Which of the following is mixed cell reference with a fixed row address?
How will you apply restrictions on data entry except the whole number to selected cells on the worksheet?
Where can the 'Show All Comments' command be found?
Values are evaluated using ________ operators.
Which of the following is not a predefined replacement for the [format] portion of the following expression? FORMAT (expression, [format])
What does an asterisk signify in a formula?
Which worksheet function returns the probability associated with a Student's t-test?
Which database function estimates variance based on a sample from selected database entries?
Which Excel add-in will help you find a target result by varying multiple inputs to a formula?
Like the autofilter query technique, the ____ command displays a subset of the table.
What is a shortcut to minimize or maximize the ribbon?
The formula QUARTILE(a1:a100,2) returns the same value as:
In Microsoft Excel 2016, the Save As option can be accessed from which of the following tabs?
True or False. If you choose a larger font size, the height of the row is automatically made taller.
What keyboard shortcut will create a chart of the data in the current range in a separate Chart sheet?
How can you bring up the built-in Help?
True or False: The value in a cell that contains the formula =RAND() changes every time any change is made to the workbook.
A worksheet range is as following?
True or False: You can protect a single worksheet and leave the others with full access.
Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
Timelines are particularly designed for _______ fields that sort out data from a pivot table.
Which of the following is a valid option in the Data Validation Allow settings?
To build a PivotTable, how must your data be formatted?
A(n) ________ refers to a cell by its fixed position in the worksheet.
Teachers: using these Excel questions with a class? Tell us about your class.