MS Excel Getting data from a cell located in a different sheet is called ___ Referencing Updating Functioning Accessing Referencing Updating Functioning Accessing ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP