What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Line Chart XY Chart Pie Chart Column Chart TRUE ANSWER : ? YOUR ANSWER : ?
Which button do you click to add up a series of numbers? The Formula button The total button The autosum button The quicktotal button TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not a valid data type in Excel ? Label Character Number Date/Time TRUE ANSWER : ? YOUR ANSWER : ?
You can use the formula palette to Copy a range of cells Create and edit formula containing functions Format cells containing numbers Enter assumptions data TRUE ANSWER : ? YOUR ANSWER : ?
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F11 F9 F8 TRUE ANSWER : ? YOUR ANSWER : ?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Logical Math & Trigonometry Statistical TRUE ANSWER : ? YOUR ANSWER : ?
The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here TRUE ANSWER : ? YOUR ANSWER : ?
Each excel file is called a workbook because You have to work hard to create it It can be modified It can contain many sheets including worksheets and chart sheets It can contain text and data TRUE ANSWER : ? YOUR ANSWER : ?
What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3!A10 Sheet3.A10 A10 TRUE ANSWER : ? YOUR ANSWER : ?
Excel files have a default extension of in Excel-2003 Xlw Wk1 Xls 123 TRUE ANSWER : ? YOUR ANSWER : ?