MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Calculator Sound Recorder Macro Recorder Media player Calculator Sound Recorder Macro Recorder Media player ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Apostrophe (') Hash (#) Exclamation (!) Tilde (~) Apostrophe (') Hash (#) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS