251. Which elements of worksheet can be protected from accidental modification A. Contents B. Objects C. Scenarios D. All of above ✅ The correct answer is option D.
252. You can convert existing excel worksheet data an charts to an HTML document by using A. FTP wizard B. Internet assistant wizard C. Intranet wizard D. Import wizard ✅ The correct answer is option B.
253. Excel uniquely identifies cells within a worksheet with a cell name A. Cell names B. Column numbers and row letters C. Column letters and row numbers D. Cell locator coordinates ✅ The correct answer is option C.
254. Where can you set the shading color for a range of cells in Excel? A. Choose required color form Patterns tab of Format Cells dialog box B. Choose required color on Fill Color tool in Formatting toolbar C. Choose required color on Fill Color tool in Drawing toolbar D. All of above ✅ The correct answer is option D.
255. What does COUNTA () function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells ✅ The correct answer is option D.
256. Which area in an excel window allows entering values and formulas A. Title bar B. Menu bar C. Formula bar D. Standard toolbar ✅ The correct answer is option C.
257. What is the short cut key to highlight the entire column? A. Ctrl + C B. Ctrl + Enter C. Ctrl + Page Up D. Ctrl + Space Bar ✅ The correct answer is option D.
258. Each excel file is called a workbook because A. It can contain text and data B. It can be modified C. It can contain many sheets including worksheets and chart sheets D. You have to work hard to create it ✅ The correct answer is option C.
259. How can you remove borders applied in cells? A. Choose None on Border tab of Format cells B. Open the list on Border tool in Format Cell toolbar then choose first tool (none) C. Both of above D. None of above ✅ The correct answer is option C.
260. Which of the following options is not located in the Page Setup dialog box? A. Page Break Preview B. Page Orientation C. Margins D. Headers and Footers ✅ The correct answer is option A.