MS Excel In a worksheet you can select The entire worksheet All of these Columns Rows The entire worksheet All of these Columns Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Save workbook Enter text and data Copy the worksheet Modifiy the worksheet Save workbook Enter text and data Copy the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells Justify in Edit > Cells All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Increase the column width Decrease the column width Shorten the label Adjust the row height Increase the column width Decrease the column width Shorten the label Adjust the row height ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP