Question 1

Which of the following action removes a sheet from workbook?

Accepted Answer

A)  select the sheet, then choose edit >> delete sheet 
B)  select the sheet then choose format >> sheet >> hide 
C)  both of above 
D)  none of above 
A)  select the sheet, then choose edit >> delete sheet 
B)  select the sheet then choose format >> sheet >> hide 
C)  both of above 
D)  none of above

Question 2

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Accepted Answer

A)  from edit menu choose clear and then formats 
B)  from edit menu choose delete 
C)  click on remove formatting tool on standard toolbar 
D)  double click the format painter and then press esc key in keyboard 
A)  from edit menu choose clear and then formats 
B)  from edit menu choose delete 
C)  click on remove formatting tool on standard toolbar 
D)  double click the format painter and then press esc key in keyboard

Question 3

While finding and replacing some data in Excel, which of the following statement is valid?

Accepted Answer

A)  you can find and replace within the sheet or workbook 
B)  excel does not have option to match case for find 
C)  both are valid 
D)  none are valid 
A)  you can find and replace within the sheet or workbook 
B)  excel does not have option to match case for find 
C)  both are valid 
D)  none are valid

Which of the following action removes a sheet from workbook?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

While finding and replacing some data in Excel, which of the following statement is valid?

Microsoft Word: Shortcut Keys, Formatting, and Features

MS Word: Tools, Formatting, and Mail Merge Features

Microsoft Word and Excel FAQ

Excel Functions and Formatting Tips

Powerpoint Features and Functions

Powerpoint and Excel Questions and Functions

Excel Functions, What-If Analysis, and Internet Basics

Internet and Technology Terminology

Internet and Technology Terminology

Microsoft Office and Technology

Filters

Exam 5: Excel and Powerpoint Functions and Shortcuts

Which of the following action removes a sheet from workbook?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

While finding and replacing some data in Excel, which of the following statement is valid?

Microsoft Word: Shortcut Keys, Formatting, and Features

MS Word: Tools, Formatting, and Mail Merge Features

Microsoft Word and Excel FAQ

Excel Functions and Formatting Tips

Powerpoint Features and Functions

Powerpoint and Excel Questions and Functions

Excel Functions, What-If Analysis, and Internet Basics

Internet and Technology Terminology

Internet and Technology Terminology

Microsoft Office and Technology

Filters