Choose True or False.Data of a copied cell remains on the clipboard until a cell is not edited.
How can you rename a worksheet?
Which worksheet function returns the average of selected database entries?
What is the best way to activate the Excel Help system?
Of the four chart types listed, which works best for summarizing time-based data?
What is the difference between the .XLSX and .XLS file format?
Assuming Cell A1 is populated with 16.8942, which of the following formulas would result in 16?
The code _____ will display the filename of the current workbook.
Which worksheet function returns the poisson distribution?
The ________ function returns one value if a condition is met, and a different value if it is not.
Which of the given statements are correct about the slicers in Microsoft Excel 2016?1. They can be used to filter data in a table.2. They can be used to filter data in a PivotTable.3. They can only be connected to PivotTables that share the same data source.
Functions like MATCH, INDEX, VLOOKUP and HLOOKUP require absolute cell references for the data range. What feature can make those references easier to read and understand?
You can access the find and replace feature by pressing the ____ key(s).
Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the "Marks Obtained" in the cell "I4"?
When you nest functions, you should have ____.
____provide descriptive text for the individual data markers, such as pie slices
The formula =countif(a1,a1) typed in cell b1 will result in:
The difference between centering text in a cell and centering a number is:
Which of the following types of files preserves cell properties, formulas, graphics, and other formatting?
Data can be arranged in ascending or descending order by using:
How to open VBA coding pane?
In the formula =VLOOKUP(a2,c2:d100,2,false) the final argument indicates:
Which of the following functions can be performed on a protected worksheet if the password is not known?
In Microsoft Excel 2016, what does the Look up value function do
Which of the following options can be copied using the format painter in Microsoft Excel 2016?1. Alignment2. Background color3. Cell text
Which of the following is not a term of MS-Excel?
In relation to the Clear option under the Home tab in Microsoft Excel 2016. which of the following options can be cleared from the cell?
When would the data validation command be unavailable on the data tab?
A 3D reference means
Which worksheet function returns the F probability distribution?
Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?
To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?
Which worksheet function estimates standard deviation based on a sample, including numbers, text, and logical values?
The following sequence, 1, 2, 3, etc., is an example of a(n) ____ series.
When you double-click a value in a PivotTable in Microsoft Excel 2010, Excel creates a new ________ with the data behind that value.
In relation to the Cube function in Excel 2016, which Of the following functions returns an aggregated value from the cube?
Data catalogs _____.
By default, excel aligns date entries at the ____ of the column.
While creating a new workbook or editing an existing one, some personal information might get added to the file automatically. If you want to share this workbook with others, then which of the following options will you use to remove such additional personal information?
_____ refers to cells not wide enough to display the entire entry.
Can you insert images from ClipArt into Excel?
Excel keeps the changed history of a workbook for ________ days by default
Which is the proper vba naming convention for a macro?
What is the purpose of the Select All button in the top-left corner of an Excel worksheet?
To change the color of a slice in a pie chart:
What does the Remove Duplicates command consider to be a match?
You can switch to page layout view by clicking the page layout button ____.
A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How you can do that?
In Excel's PMT(rate, nper, pv, [fv], [type]) function, fv and type are ____.
To erase an entire entry in a cell and then re enter the data from the beginning press the ____ key
Teachers: using these Excel questions with a class? Tell us about your class.