Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
- Which is used to perform what if analysis?
- Which of the following is not information you can specify using the solver?
- To copy cell contents using drag and drop press the
- What are the tabs that appear at the bottom of each workbook called?
- A __________ is a grid with labeled columns and rows.
- A circular reference is
- Which of the following is the oldest spreadsheet package?
- Which would you choose to create a bar diagram?
- You can select a single range of cells by
- Which of the following methods can not be used to edit the contents of a cell?
- Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
- The Chart wizard term data categories refers to;
- Concatenation of text can be done using
- How do you select an entire column?
- How can you show or hide the gridlines in Excel Worksheet?
- How do you rearrange the data in ascending or descending order?
- In Excel, a Data Series is defined as what?
- To save a workbook, you:
- Which of the following is not a worksheet design criterion?
- Which of the following is an absolute cell reference?
- You can copy data or formulas
- Which of the following is not the correct method of editing the cell content?
- Which of the following is invalid statement?
- To edit in an embedded excel worksheet object in a word document
- When a label is too long to fit within a worksheet cell, you typically must
- Which button do you click to add up a series of numbers?
- Which of the following is not true regarding Conditional Formatting?
- Which of following is Not one of Excels what-if function?
- Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
- The auto calculate feature