1. Home
  2. GK Questions
  3. Computer Awareness
  4. MS-Excel

MS-Excel — GK Questions with Answers

10 Computer Awareness Questions20 Computer Awareness Questions50 Computer Awareness Questions100 Computer Awareness Questions Current Affairs 2026 Today's GK Quiz Static GK हिन्दी
41 questions
  1. Which software is used for calculation and accounts work?
    1. Letter writing
    2. Spreadsheet
    3. Presentation
    4. Painting
    Show answer

    Answer: (B) Spreadsheet

    Accounts are done in a spreadsheet.

  2. The software best suited to track a billing account —
    1. Web authoring
    2. Electronic publishing
    3. Spreadsheet
    4. Word processing
    Show answer

    Answer: (C) Spreadsheet

    Add-and-subtract work belongs to the spreadsheet.

  3. Most suitable for numerical and statistical calculation —
    1. Database
    2. Document processor
    3. Graphics package
    4. Spreadsheet
    Show answer

    Answer: (D) Spreadsheet

    Spreadsheet.

  4. Which one is a spreadsheet package?
    1. VisiCalc
    2. Unity
    3. Ada
    4. Photoshop
    Show answer

    Answer: (A) VisiCalc

    VisiCalc.

  5. In which direction do the rows and columns of a worksheet run?
    1. Columns horizontal, rows vertical
    2. Columns vertical, rows horizontal
    3. Depends on the application
    4. Both (2) and (3)
    Show answer

    Answer: (B) Columns vertical, rows horizontal

    Columns are vertical, rows horizontal.

  6. What is the point where a row and a column meet called?
    1. Cell
    2. Grid
    3. Table
    4. Box
    Show answer

    Answer: (A) Cell

    A cell.

  7. What is a collection of worksheets called?
    1. Excel book
    2. Worksheets
    3. Excel sheets
    4. Workbook
    Show answer

    Answer: (D) Workbook

    A workbook.

  8. Which is not related to spreadsheet software?
    1. Worksheet
    2. Cell
    3. Formula
    4. Virus detection
    Show answer

    Answer: (D) Virus detection

    Virus scanning is a utility’s job.

  9. How is data arranged in a spreadsheet?
    1. Lines and spaces
    2. Layers and planes
    3. Height and width
    4. Rows and columns
    Show answer

    Answer: (D) Rows and columns

    Rows and columns.

  10. Data in a worksheet goes into its smallest unit, the —
    1. Tab
    2. Cell
    3. Box
    4. Range
    Show answer

    Answer: (B) Cell

    The cell.

  1. The default view in Excel —
    1. Work
    2. Auto
    3. Normal
    4. Roman
    Show answer

    Answer: (C) Normal

    Normal.

  2. A cell with a bold boundary is called —
    1. Relative
    2. Active
    3. Absolute
    4. Passive
    Show answer

    Answer: (B) Active

    The active cell.

  3. The easiest way to select a column —
    1. Double-click one cell of the column
    2. Drag from the first cell to the last
    3. Click the column heading
    4. Click the row heading
    Show answer

    Answer: (C) Click the column heading

    The lettered heading of the column.

  4. The letter-and-number identifier of a cell is its —
    1. Cell location
    2. Cell position
    3. Cell address
    4. Cell coordinates
    Show answer

    Answer: (C) Cell address

    The cell address.

  5. An invalid formula in Excel —
    1. = A2 + A1
    2. = A2 + 1
    3. = 1 + A2
    4. = 1A + 2
    Show answer

    Answer: (D) = 1A + 2

    “1A” is not a cell address.

  6. The function that gives the total characters in a cell —
    1. Len
    2. Length
    3. Mid
    4. Sid
    Show answer

    Answer: (A) Len

    LEN.

  7. What does the TODAY( ) function enter?
    1. System time
    2. Date and time
    3. The date only
    4. The time the file was opened
    Show answer

    Answer: (C) The date only

    Only today’s date.

  8. The characteristic that computes results dynamically from Excel data —
    1. Goto
    2. Table
    3. Chart
    4. Formula and function
    Show answer

    Answer: (D) Formula and function

    Formulas and functions.

  9. The area of the Excel window for entering values and formulas —
    1. Standard Toolbar
    2. Menu Bar
    3. Title Bar
    4. Formula Bar
    Show answer

    Answer: (D) Formula Bar

    The formula bar.

  10. What is =SUM(B1:B10)?
    1. Just a function name
    2. A formula using a function
    3. A cell address
    4. A value
    Show answer

    Answer: (B) A formula using a function

    A formula built with the SUM function.

  1. A prerecorded formula that shortcuts a complex calculation —
    1. Value
    2. Data series
    3. Function
    4. Field
    Show answer

    Answer: (C) Function

    A function.

  2. An active cell can be represented by —
    1. 4A
    2. A4
    3. A＄4
    4. ＄A＄4
    Show answer

    Answer: (B) A4

    The plain form is A4.

  3. The cell reference ＄A4 is —
    1. Mixed
    2. Absolute
    3. Relative
    4. All the above
    Show answer

    Answer: (A) Mixed

    Column locked, row free = mixed.

  4. A worksheet accepts numbers/characters, text and also —
    1. Formulas
    2. Functions
    3. Logic
    4. All of these
    Show answer

    Answer: (A) Formulas

    Formulas.

  5. In which chart can only one data series be plotted?
    1. Pie
    2. Line
    3. Bar
    4. Column
    Show answer

    Answer: (A) Pie

    Pie.

  6. Which chart shows how parts add up to a whole —
    1. Pie
    2. Line
    3. Stacked bar
    4. Embedded
    Show answer

    Answer: (C) Stacked bar

    The stacked bar (and the pie) — among the options, the stacked bar.

  7. A chart that sits inside a worksheet is named —
    1. Formatting chart
    2. Embedded chart
    3. Aligning chart
    4. Hanging chart
    Show answer

    Answer: (B) Embedded chart

    An embedded chart.

  8. Another name for the scatter chart —
    1. XX chart
    2. YX chart
    3. XY chart
    4. YY chart
    Show answer

    Answer: (C) XY chart

    XY.

  9. Charts in Excel are produced with —
    1. Chart wizard
    2. Pivot table
    3. Pie chart
    4. Bar chart
    Show answer

    Answer: (A) Chart wizard

    The chart wizard.

  10. Pie charts are typically created with which software?
    1. Browser software
    2. Database software
    3. Desktop publishing software
    4. Spreadsheet software
    Show answer

    Answer: (D) Spreadsheet software

    Spreadsheet.

  1. The shortcut to select an entire row —
    1. Shift + Space
    2. Ctrl + Space
    3. Alt + Space
    4. None of these
    Show answer

    Answer: (A) Shift + Space

    Shift + Space.

  2. The shortcut to select the current column —
    1. Ctrl + Space
    2. Ctrl + B
    3. Shift + Enter
    4. Ctrl + Enter
    Show answer

    Answer: (A) Ctrl + Space

    Ctrl + Space.

  3. Keys that take you to the first cell of the row —
    1. Tab
    2. Shift + Tab
    3. Esc + Home
    4. Shift + Home
    Show answer

    Answer: (D) Shift + Home

    Shift + Home.

  4. The shortcut to hide an entire row —
    1. Ctrl + 2
    2. Ctrl + 9
    3. Ctrl + N
    4. Ctrl + -
    Show answer

    Answer: (B) Ctrl + 9

    Ctrl + 9.

  5. The key that creates a chart —
    1. F2
    2. F5
    3. F7
    4. F11
    Show answer

    Answer: (D) F11

    F11.

  6. The key that edits the selected cell —
    1. F2
    2. F5
    3. F7
    4. F11
    Show answer

    Answer: (A) F2

    F2.

  7. The shortcut that enters today’s date in Excel —
    1. Ctrl + Shift + ;
    2. Ctrl + ;
    3. Alt + ;
    4. Shift + ;
    Show answer

    Answer: (B) Ctrl + ;

    Ctrl + ;

  8. The key that makes the cell accept your typing —
    1. Enter
    2. Ctrl + Enter
    3. Tab
    4. Insert
    Show answer

    Answer: (A) Enter

    Enter.

  9. The key used in combination with another key to perform a task —
    1. Function
    2. Space bar
    3. Arrow
    4. Control
    Show answer

    Answer: (D) Control

    Control, the modifier.

  10. The shortcut to switch between open workbooks —
    1. Ctrl + F6
    2. Ctrl + F9
    3. Ctrl + F10
    4. Ctrl + F4
    Show answer

    Answer: (A) Ctrl + F6

    Ctrl + F6.

  11. The extension of an Excel file —
    1. .xis
    2. .xas
    3. .xlsx
    4. .lxs
    Show answer

    Answer: (C) .xlsx

    .xlsx.

More chapters in this subject