Spreadsheet Software - MCQs Online Quiz

Spreadsheet Software - MCQs Online Quiz. Attempt the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer, ICS Part-I Chapter No.9: Spreadsheet Software, for the exams, entry tests i.e., ECAT, for interview MCQs based questions for jobs, MS Excel MCQs, Microsoft Office MCQ, and MS Excel online test.

 

This post regarding ICS Part-1 Computer Chap No.9: Spreadsheet Software MCQs | Online Quiz covers the topics i.e., Spreadsheet Overview, Features of Spreadsheet Software, Microsoft Excel's Interface, Entering Data in Worksheet, Basics of Worksheet, Cell References and Ranges, Relative and Absolute Referencing, Named Ranges, Defining Range Names, Working with Formulas, Linking Worksheets, Functions (i.e., sum(), count(), min(), max(), today(), sqrt()), Function Wizard, Formatting and Customizing Data, Creating Custom Format, Symbols used in Custom Format, Aligning Cell Contents, Merge Cells and Wrap Text, Introducing Charts, Chart Wizard, Printing Worksheets and Chart, Page Orientation, Margins, Header and Footer, and Sheet:

👇

➤ Spreadsheet Software - Short Questions
➤ Word Processing - Short Questions
➤ Fundamentals of the Internet - MCQs
➤ Windows Operating System - MCQs
➤ Security Copyright & The Law - Short Questions
➤ Computer Architecture - Short Questions
➤ Computer Architecture - MCQs
➤ Applications and Uses of Computer - Short Questions
➤ Applications and Uses of Computer - MCQs
➤ Data Communication - MCQs 
➤ Data Communication - Short Questions
➤ Information Networks - Short Questions
➤ Information Networks - MCQs
➤ Basics of IT - MCQs
➤ Basics of IT - Short Questions

 

Chapter 9: Spreadsheet Software

MCQs | Online Quiz

 

1. A bold rectangular border around a cell of a worksheet indicates?
   1.   Active cell
   2.   Passive cell
   3.   Referenced cell
   4.   None of these
2. A cell in a worksheet can have ____ state?
   1.   Active state
   2.   Passive state
   3.   Current state
   4.   Active + passive states
3. A workbook is a collection of?
   1.   Cells
   2.   Cell ranges
   3.   Worksheets
   4.   None of these
4. In MS Excel, by default text is?
   1.   Left aligned
   2.   Right aligned
   3.   Center aligned
   4.   None of these
5. In MS Excel, the dollar sign ($) is used for?
   1.   Relative referencing
   2.   Absolute referencing
   3.   Simple referencing
   4.   None of these
6. The default value of each cell in a spreadsheet is?
   1.   0
   2.   Null
   3.   No value
   4.   Undefined
7. The font size is measured in?
   1.   Pixels
   2.   Points
   3.   DPI
   4.   None of these
8. The group of adjacent cells in a worksheet is called?
   1.   Workbook
   2.   Combined cells
   3.   Cell range
   4.   None of these
9. The horizontal dimension of a worksheet is called?
   1.   Row
   2.   Column
   3.   Cell range
   4.   None of these
10. The reference of a cell in a formula does not change when copied to another cell only if?
    1.   Absolute referencing is used
    2.   Relative referencing is used
    3.   Absolute + relative referencing is used
    4.   None of these
11. The shortcut key to make text darker in MS Excel is?
    1.   Ctrl + D
    2.   Ctrl + Alt + D
    3.   Ctrl + B
    4.   Ctrl + E
12. The term cell reference in worksheet is used for?
    1.   Contents of cell
    2.   Address of cell
    3.   Row number of cell
    4.   Column number of cell
13. There are ___ numbers of columns in a worksheet?
    1.   128
    2.   512
    3.   256
    4.   1024
14. There are ___ numbers of rows in a worksheet?
    1.   56536
    2.   63539
    3.   65536
    4.   65635
15. To multiply value of a cell B3 from Sheet 2 with cell D4 of current worksheet, the formula will be?
    1.   b3sheet2*d4
    2.   sheet2b3*d4
    3.   sheet2!b3*d4
    4.   sheet2!d4*b3
16. Which of the following function is not available in MS Excel?
    1.   Month()
    2.   Min()
    3.   Max()
    4.   None of these
17. Which of the following function is used to get the current date of your computer?
    1.   Date()
    2.   Current()
    3.   TodayDate()
    4.   Today()
18. Which of the following is not spreadsheet software?
    1.   MS Excel
    2.   Lotus123
    3.   Google Sheets
    4.   None of these
19. Which of the following is represents the relative referencing of cell located in 2nd row and 5th column?
    1.   2E
    2.   E2
    3.   $2$E
    4.   E$2
20. Which of the following symbol is used to specify range in a particular built-in function?
    1.   Semicolon (;)
    2.   Colon (:)
    3.   Dot (.)
    4.   Hyphen (-)