MS Excel You can select a single range of cells by Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells 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 Pressing the Ctrl key while dragging over the desired cells 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value ? 350 Serial Number 50771 May 10, 2001 0.57 350 Serial Number 50771 May 10, 2001 0.57 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Column Chart Line Chart XY Chart Pie Chart Column Chart Line Chart XY Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS