251. Which elements of worksheet can be protected from accidental modification September 6, 2025 by Admin 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 September 6, 2025 by Admin 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 September 6, 2025 by Admin 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? September 6, 2025 by Admin 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? September 6, 2025 by Admin 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 September 6, 2025 by Admin 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? September 6, 2025 by Admin 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 September 6, 2025 by Admin 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? September 6, 2025 by Admin 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? September 6, 2025 by Admin A. Page Break Preview B. Page Orientation C. Margins D. Headers and Footers ✅ The correct answer is option A.