https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-6914074430480076 Most Important MS Excel Questions & Answers Part : I

Ad Code

Responsive Advertisement

Most Important MS Excel Questions & Answers Part : I

RITA NEGI August 01, 2023

 

1. What is Title Bar ?

 It displays the Title of the Workbook on which you are currently working . By default, the first new Workbook is named as Book 1.




2. Which are the three options available on Quick Access Toolbar by default?

 By default following appears on the Quick Access Toolbar :

  • SAVE : To save your file (you may also press keyboard button (Ctrl + S).
  • UNDO : To rollback the action that you last took (Ctrl + Z).
  • REDO : To reapply the action you rolled back or to repeat an action (Ctrl + Y).


3. What is the role of page break ?

Page Break plays an important role in MS excel . Page Break  view is useful to determine where the page will break when you are trying to print an Excel sheet that spans multiple pages . You can also set the page view using Workbook Views group in the View tab on Ribbon .

4. What is cell address ?

Cell address is a combination of Column Letter(s) and row number that intersect at the cell position. For example , if the cell address is A3, it means it is at the intersection of column A and row 3 .

5. What are cell comments ? 

Cell Comments are notes that can be inserted into any cell in Excel . They are used to explain formulas, cells, and other data in the spreadsheet itself .

6. Which charts are used to display the contribution of each value to the total ?

Pie Charts are used to display the contribution of each value to the total .

 7. Name the cell referencing in which both row and column will not change when copied .

Absolute cell references, a formula always refers to the same cell or cell range used in it . If a formula copied to a different location, then the cell address remains the same . 


RITA NEGI

Posted by RITA NEGI

Post a Comment

0 Comments