An .xlsx workbook is saved into .csv format. What is preserved in the new .csv file?
Is it possible to make Pivot table using multiple sources of data?
Which of the following is a concatenating operator?
Excel's ________ function retrieves the date and time from the computer's calendar and clock.
Does changing the number of displayed decimals change the value Excel is storing?
A(n) ____ contains little or no formatting.
A _______ is a predefined formula that helps perform common mathematical functions.
True or False: The formula =((A2+B5)*5% is valid.
Selecting the Rows 5 & 6 then choose Insert->Row
When is an absolute cell reference used?
Which function repeats text a given number of times?
Which formula needs to be typed in B3 to increase sales by 3.5% from the cell above, and then take advantage of autofill to fill the rest of the cells in the column instead of retyping the formula for every cell?
Which of the following series type is not valid for Fill Series dialog box?
You can apply the bold font style by pressing the ____ keyboard shortcut keys.
Cell A1 contains the string "tom jones". To transform the contents to "Tom Jones" the formula is:
What does the 1 represent in this formula: =Now()+1
Arrow a is indicating a(n) _____ protein.
An error value begins with a(n) _____ followed by an error name that indicates the type of error.
Cell A1 contains a text string Apple, Cell A2 contains a value 5. What will be the result of the formula: =A1*A2
____ is extremely useful for making large tables more manageable in size and appearance.
The Quick Access toolbar does which of the following?
Which of the following function can be used to pad a cell with characters, such as the dot?
When you insert a row, you have to reset all the equation references because:
By using names, data can be understood and maintained in a much easier way. Peter creates a Named range, but he is not aware about the scope of the Name. Which of the followings is the default level of scope for a Name?
Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?
The function DAY(date)
If the Ribbon is taking up too much space on your screen, what can you do?
Cell A2 contains the value 8 and cell B2 contains the value 9. What happens when cells A2 and B2 are merged and then unmerged?
When does the ##### error appear in an Excel cell?
The default number format is ________.
The logic for the formula in cell B2: =IF(A2>5,.2,0) is expressed as:
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?
State whether true or false:When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
True or False: Data being typed does not appears in both the active cell and Formula bar.
State whether true or false:A Macro project can be digitally signed.
A ________ identifies a worksheet in a workbook.
An Excel formula can reference cells on other worksheets in the:
What is one way to center text in a cell?
What tool would you use to prevent the input in a cell of a date outside a specific range?
After activating a chart, which sequence adds a trendline to the chart?
The accounting number format assigns a floating dollar sign. _________________________
True or False: Charts from Excel can be pasted into Power Point.
In Excel, how do you make Excel save a backup copy of a workbook automatically every time you save it?
To convert the date 12/14/2014 in cell A1 to text in the format of YYYYMMDD, which is a valid option?
A _______ describes the location of a cell based on its column and row location.
If your Microsoft Excel workbook closes due to system error before you could save it, then which of the following is the correct way to recover it?
A chart that compares three set of values in a three-dimensional chart is _____.
When entering a formula, what key or combination of keys can be hit to quickly make a cell an absolute reference?
What is the quickest way to highlight all of the blank cells in selected section that has both filled and blank cells?
Teachers: using these Excel questions with a class? Tell us about your class.