To copy formatting from one area in an Excel worksheet and apply it to another area, you would use
The Edit > Copy Format and Edit>Paste Format commands form the menu
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 Format Painter button on the standard toolbar
Correct answer is D
No explanation has been provided for this answer.
Text
Drawing objects
Pictures
All of the above
Correct answer is D
No explanation has been provided for this answer.
Which of the following is used to perform WHAT IF analysis in Excel?
Solver
Goal seek
Scenario Manager
All of the above
Correct answer is D
No explanation has been provided for this answer.
In Excel, comments put in cells are called
Smart Tip
Cell Tip
Web Tip
Soft Tip
Correct answer is B
No explanation has been provided for this answer.
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
Correct answer is B
No explanation has been provided for this answer.