download Mastguru Android App

Question Detail

3-D reference in a formula ?

  • Spans worksheets
  • Can not be modified
  • Only appears on summary worksheets
  • Limits the formatting options

Answer: Option A

Similar Questions :

1. What excel feature can you use if you want to work with one record at a time ?

  • Auto Complete
  • Data Form
  • Set Form
  • Auto Text

Answer: Option B

2. When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors.

  • True
  • False

Answer: Option A

3. When you press Ctrl + X after selecting some cells in Excel, what will happen then

  • The cell content of selected cells disappear from cell and stored in clipboard
  • The selected cells are deleted and cells are shifted up
  • The selected cells are deleted and the cells are shifted left
  • The cells selected are marked for cutting

Answer: Option D

4. With which of the following all formulas in excel starts ?

  • /
  • *
  • $
  • =

Answer: Option D

5. Entire worksheet can not be selected in one time.

  • True
  • False

Answer: Option B

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs