When you write up a lookup formula to look up the text "budget", the formula considers any of the following a match: BUDGET, Budget, or BuDgEt. Is it possible to perform a case-sensitive lookup?
When working in a Pivot Table, the additional menu items "Options" and "Design" are found:
What is a circular reference?
What does SHIFT+DELETE do?
Which of the following statements are correct about worksheet grouping?
You can ____ the chart title text to select it.
True or False: Excel has trigonometry functions built into it.
The combination Ctrl+F1:
Which keyboard shortcut can be used to embolden text?
Which formulas use absolute references?
Where can I find formulas in excel without having to type it?
In Microsoft Excel 2016, the CHOOSE function can be used for selecting up to how many values based on an index number?
How can you insert a chart from selected data?
You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?
You're working with columns whose width and font-size should not be changed. Yet the columns are too narrow to display all the text in each cell. What tool should you use to solve the problem?
Can you create Macros on excel?
You can apply font styles and alignment options using the ____ tab of the ribbon.
If you're drawing multiple shapes, how can you keep the Shapes drop-down panel visible, so you don't have to keep clicking the Shapes button?
A ____ is essentially a dynamic summary report generated from a database.
Which worksheet function returns the one-tailed probability of the chi-squared distribution?
How do you print an Excel Workbook with the Title Row A1:A2 on each page?
In the formula =int(average(a1:a100)), which would occur first? ____
A chart sheet can contain ____.
In Excel, what happens when you click the box where the row headings and the column headings meet, at the top-left corner of the sheet?
A formula palette is used to:
What is the formula to find the first day of the following month?
In Excel a ____ is an instruction in a spreadsheet to carry out a calculation
The marketing team of XYZ Corp collects data of foods from multiple resources. If the marketing team wants to highlight the duplicate records of food, then which of the following sets of steps should be used?
How do you make a chart?
In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?
Which of the following are advantages of range names?
To quickly jump to the last cell in a worksheet press ____.
In the formula "=VLOOKUP(A3,$J$3:$K$12,2,TRUE)", the 4th argument of the VLOOKUP function, "TRUE", indicates
Because a chart is _______, it can be dragged to another area of the worksheet.
What is the correct way to refer the cell A10 on sheet3 from sheet1?
_____ is a single cell that occupies more than one cell row and/or column.
In a Excel spreadsheet, It's possible to select multiple non-adjacent ranges of cells.
The formula used to multiply cell a1 by cell c1 is ____.
By default, all cells in a workbook are:
Cell A1 contains the string " Tom Jones" (two blank spaces before the name Tom). To remove the two blank spaces, the formula is:
A ____ in excel is like a notebook.
The ____ button allows you to move through a formula step by step.
If there is text in cell C5 and the formula in cell F10 =SUM(B2:E6) then the formula result will...
You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?
In Windows, which command creates a connection to a shared network folder and assigns it a drive letter?
You can split the worksheet window into ____ separate panes.
To insert a character that is not part of an alphabetic font sent (such as copyright ©) use the:
A(n) _______ is a limit that is placed on a solver problem
A green flag will appear on the upper right-hand side of a cell when it contains:
The study of human interaction with machines in general is called ____.
Teachers: using these Excel questions with a class? Tell us about your class.