MS Excel Getting data from a cell located in a different sheet is called ___ Accessing Referencing Updating Functioning Accessing Referencing Updating Functioning ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Goal seek Scenario Manager All of above Solver Goal seek Scenario Manager All of above Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Average Sum Max Pmt Average Sum Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Workbooks Group of Columns Group of Worksheets Group of Rows Group of Workbooks Group of Columns Group of Worksheets Group of Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Use the word menu bar and toolbars Embedded Hyperlinked placed in a word table Linked Use the word menu bar and toolbars Embedded Hyperlinked placed in a word table Linked 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 Adjust the row height Shorten the label Increase the column width Decrease the column width Adjust the row height Shorten the label ANSWER DOWNLOAD EXAMIANS APP