Quiz : How Well Aware Are You With MS Spreadsheets

10 Questions | By Jhangen | Last updated: Aug 2, 2022 | Total Attempts: 2779

Questions

Settings

Create your own Quiz

Working on MS has become an integral part of office life. We're curious to know how well aware you are of MS spreadsheets. Can you answer all the technical and theoretical questions in excel? All the questions given in the quiz are in MCQ format & you are expected to choose the correct option. Your score will be reflected after you've attempted all the questions in the quiz. We challenge you a get a high score. Can you do it? Why not give this fun quiz a try? We are sure that you'll love it! All the best!

Questions and Answers

1.

Tables in spreadsheets are better than tables in word processors because they
- A.
  
  Use numbers only.
- B.
  
  Will have unchanging formats.
- C.
  
  Can be easily updated.
- D.
  
  Have accurate data.
2.

All changes to value, labels, or formulas in a spreadsheet are made in the
- A.
  
  Formula bar.
- B.
  
  Cell.
- C.
  
  Frame.
- D.
  
  Function line.
3.

Values, by default, are aligned
- A.
  
  To the left.
- B.
  
  To the right.
- C.
  
  Centered in the cell.
- D.
  
  At the top of the cell.
4.

How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?
- A.
  
  The equal sign (=) signals it.
- B.
  
  The division (/) sign signals it.
- C.
  
  Dates cannot be shown that way.
- D.
  
  It would not know.
5.

Operations are carried out in the following order:
- A.
  
  A - D - E - M - P - S
- B.
  
  M - D - E - P - S - A
- C.
  
  P - M - D - A - S - E
- D.
  
  P - E - M - D - A - S
6.

It is best to write formulas using cell references so that a spreadsheet
- A.
  
  Has no hidden information.
- B.
  
  Has all correct values.
- C.
  
  Can be updated easily.
- D.
  
  Can be more easily graphed.
7.

What are the two essential macro languages used in Ms. Excel?
- A.
  
  Tally and C#
- B.
  
  ZNM and oracle
- C.
  
  XLM and VBA (Visual Basic Applications)
- D.
  
  None of the above
8.

Which formula can be used for date and time functions?
- A.
  
  DATEVALUE()
- B.
  
  INDEX MATCH
- C.
  
  RAND()
- D.
  
  VLOOKUP
9.

How is the pivot table used in Ms Excel?
- A.
  
  To delete a large set of data
- B.
  
  To summarize a large data set
- C.
  
  To add new tabular data
- D.
  
  None of the above
10.

What are the two reports formats used in Excel?
- A.
  
  Landscape and A4
- B.
  
  Horizontal and Vertical
- C.
  
  Still and Moving
- D.
  
  Tabular and Compact