Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key TRUE ANSWER : ? YOUR ANSWER : ?
You can select a single range of cells by Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Shift key and an arrow key TRUE ANSWER : ? YOUR ANSWER : ?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Column Chart XY Chart Pie Chart Line Chart TRUE ANSWER : ? YOUR ANSWER : ?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Work sheet Data sheet Macro sheet Chart sheet TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an absolute cell reference? #a#1 $A$1 A1 !A!1 TRUE ANSWER : ? YOUR ANSWER : ?
How do you rearrange the data in ascending or descending order? Data, Form Data Subtotals Data, Table Data, Sort TRUE ANSWER : ? YOUR ANSWER : ?
The Cancel and Enter buttons appear in the: Sheet tabs Formula bar Title bar Menu bar TRUE ANSWER : ? YOUR ANSWER : ?
Which language is used to create macros in Excel? Visual Basic Java Visual C++ C TRUE ANSWER : ? YOUR ANSWER : ?
Comments can be added to cells using File > Comments Insert > Comments View > Comments Edit > Comments TRUE ANSWER : ? YOUR ANSWER : ?