EXCEL QUIZ

Q.1 Which is an example of a function?

• =Add(a3:a4)

• =A3+A4

• =SUM(A3:A4)

• A1+A2

Q.2 In help menu of Excel, which of the following tabs are found?

• A. Contents tab

• B. Answer Wizard tab

• C. Index tab

• D. All the above

Q.3 What does COUNTA () function do?

• A. counts cells having alphabets

• B. counts empty cells

• C. counts cells having number

• D. counts non-empty cells

Q.4 What is the correct way to refer the cell A10 on sheet3 from sheet1?

• A. sheet3!A10

• B. sheet1!A10

• C. Sheet3.A10

• D. A10

Q.5

Where is the fill handle located?

• A. on the right side of the Home tab on the Ribbon

  
  

• B. in Backstage view

  
  

• C. at the beginning of any formula or function

  
  

• D. in the bottom-right corner of the selected cell

  
  

Q.6

You can click the tabs at the bottom of a workbook to switch between ________.

• A. formulas

  
  

• B. permissions

  
  

• C. worksheets

  
  

• D. number formats

Q.7 Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• A. It should use the COUNT function instead.

  
  

• B. There is nothing wrong with the formula.

  
  

• C. It should use quotation marks instead of parentheses.

  
  

• D. It should have an equals sign (=) at the beginning.

  
  

Q.8 True or False: You can view a formula by double-clicking the cell that contains the formula.

• A. TRUE

• B. FALSE

• C. NO IDEA

• D. BOTH

Q.9 In MS Excel, Page border option is available under _______ tab

• A. INSERT

• B. PAGE LAYOUT

• C. VIEW

• D. NONE OF THESE

Q.10 ________is the best alternative to MS Excel offered by Google Inc.

• A. Google Slides

• B. Google Sheets

• C. GOOGLE WORKSAPCE

• D. GOOGLE KEEP