What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Also checkout these categories
MS Office MCQ Anatomy and Physiology of Skeletal System MCQ Refrigeration & Air-Conditioning MCQ Male reproduction and infertility MCQ Sitting Arrangement MCQ Radiologic Examination MCQ Phylum - Amphibia MCQ Relativity MCQ Rearrangement Set 15 MCQ Percentage MCQ General Science MCQ Letter and Symbol Series MCQ
- Which of the following formulas will Excel Not be able to calculate?
- Which key do you press to check spelling?
- The Paste Special command lets you copy and paste:
- You can convert existing excel worksheet data an charts to an HTML document by using
- Excel files have a default extension of
- How many characters can be typed in a single cell in Excel?
- You can check the conditions against __________ when applying conditional formatting
- Which button do you click to add up a series of numbers?
- Status indicators are located on the
- In help menu of Excel, which of the following tabs are found?
- Which of the following is a correct order of precedence in formula calculation?
- Which of the cell pointer indicate that you can move the content to other cell?
- Which elements of worksheet can be protected from accidental modification
- When the formula bar is active, you can see
- Which of the following series type is not valid for Fill Series dialog box?
- How do you select an entire column?
- The command Edit >> Fill Across Worksheet is active only when
- If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
- Where can you change automatic or manual calculation mode in Excel?
- Tab scroll buttons are place on Excel screen
- What is the short cut key to replace a data with another in sheet?
- To copy cell contents using drag and drop press the
- You can activate a cell by
- Which of the following you can paste selectively using Paste Special command?
- Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
- How can you remove borders applied in cells?ACC
- Which of the cell pointer indicates that you can fill series?
- Tab scrolling button
- How can you find specific information in a list?
- Which of the following is invalid statement?