MS Excel Questions & Answers | Basic Computer Knowledge

  • Shortcut Keys of MS-Excel and their Descriptions
    Shortcut Keys Description
    F2 Edit the selected cell.
    F5 Go to a specific e.g., C6
    F7 Spell chech selected text and/or document.
    F11 Create chart.
    Ctrl + Shift + ; Enter the current time.
    Ctrl + ; Enter the current date.
    Alt + Shift + F1 Insert new worksheet.
    Shift + F3 Open the Excel formula window.
    Shift + F5 Bring up search box.
    Ctrl + A Select all contents of the worksheet.
    Ctrl + B Bold highlighted selection.
    Ctrl + I Italic highlighted selection.
    Ctrl + K Insert link.
    Ctrl + U Underline highlighted selection.
    Ctrl + 5 Strike through highlighted selection.
    Ctrl + P Bring up the print dialog box to begin printing.
    Ctrl + Z Undo last action.
    Ctrl + F9 Minimise current workbook.
    Ctrl + F10 Maximise currently selected workbook.
    Ctrl + F6 Switch between open workbooks/windows.
    Ctrl + Page up Move between Excwl worksheets in the same Excel document.
    Ctrl + Page down Move between Excwl worksheets in the same Excel document.
    Ctrl + Tab Move between two or more open Excel files.
    Alt + = Create a formula to sum all of the above cells.
    Ctrl + ' Insert the value of the above cell into cell currently selected.
    Ctrl + Shift + ! Format number in comma format.
    Ctrl + Shift + $ Format number in currency format.
    Ctrl + Shift + # Format number in date format.
    Ctrl + Shift + % Format number in percentage format.
    Ctrl + Shift + @ Format number in time format.
    Ctrl + Arrow key Move to next section of text.
    Ctrl + Space Select entire column.
    Shift + Space Select entire row.

1.

If you press ___, the cell accepts your typing as its contents?

   A.) Tab
   B.) Ctrl+Enter
   C.) Enter
   D.) Alt+Enter

Answer: Option 'C'

Enter

2.

3-D reference in a formula ?

   A.) Spans worksheets
   B.) Can not be modified
   C.) Only appears on summary worksheets
   D.) Limits the formatting options

Answer: Option 'A'

Spans worksheets

Basic Computer Knowledge Quiz

3.

what term describes a background that appears as a grainy, non smooth surface?

   A.) Velvet
   B.) Gradient
   C.) Pattern
   D.) Texture

Answer: Option 'B'

Gradient

4.

To drag a selected range of data to another worksheet in the same workbook, use the?

   A.) Ctrl key
   B.) Tab key
   C.) Shift key
   D.) Alt key

Answer: Option 'A'

​Ctrl key

5.

You will use which feature in excel, if you want to work with one record at a time ?

   A.) Auto Complete
   B.) Sub Totals
   C.) Auto Filter
   D.) Data Form

Answer: Option 'D'

Data Form

6.

What term describes explanatory text attached to a cell?

   A.) Callout
   B.) Context
   C.) Comment
   D.) Dialog

Answer: Option 'C'

​Comment

7.

How can we set Page Border in Excel ?

   A.) From Edit menu
   B.) From Home
   C.) You can not set page border in Excel
   D.) From Tools menu

Answer: Option 'C'

You can not set page border in Excel

Basic Computer Knowledge Quiz

8.

Which function is used for creating a data table?

   A.) Sum
   B.) Table
   C.) Add
   D.) Count

Answer: Option 'B'

Table

9.

What type of chart will you use to compare performance of sales of two products ?

   A.) Column Chart
   B.) Line Chart
   C.) Pie Chart
   D.) Both A and B

Answer: Option 'A'

Column Chart

10.

To drag a selected range of data to another worksheet in the same workbook, use the ?

   A.) Ctrl key
   B.) Shift key
   C.) Alt key
   D.) Tab key

Answer: Option 'A'

Ctrl key

Basic Computer Knowledge Quiz

11.

Style sheet formats can be applied from ?

   A.) Table >> Autoformat
   B.) Format >> Autoformat
   C.) Table >> Cells
   D.) Fromat >> Cells

Answer: Option 'B'

Format >> Autoformat

12.

Which among following is types of excel data types ?

   A.) Numbers, Formulas, Labels
   B.) Data, Words, Numbers
   C.) Words, Number, Labels
   D.) Equations, Data, Numbers

Answer: Option 'A'

Numbers, Formulas, Labels

13.

Which among following wildcard characters are recognized by excel ?

   A.) + and -
   B.) ! and ^
   C.) * and ?
   D.) < and >

Answer: Option 'C'

* and ?

14.

What function displays row data in a column or column data in a row ?

   A.) Hyperlinks
   B.) Rows
   C.) Index
   D.) Transpose

Answer: Option 'D'

Transpose

Basic Computer Knowledge Quiz

15.

Which among following is associated with excel ?

   A.) Graphic program
   B.) Spreadsheet
   C.) Microsoft office
   D.) None of these

Answer: Option 'B'

Spreadsheet

16.

what term describes a background that appears as a grainy, non smooth surface ?

   A.) Pattern
   B.) Gradient
   C.) Velvet
   D.) Texture

Answer: Option 'B'

Gradient

17.

Which among following is associated with excel?

   A.) Graphic program
   B.) Spreadsheet
   C.) Word Processor
   D.) Presentation

Answer: Option 'B'

​Spreadsheet

18.

To open an existing workbook, click the Open button on the ___ toolbar ?

   A.) Form
   B.) Standard
   C.) Drawing
   D.) Formatting

Answer: Option 'B'

Standard

Basic Computer Knowledge Quiz

19.

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

   A.) Auto Complete
   B.) Data Form
   C.) Set Form
   D.) Auto Text

Answer: Option 'B'

​Data Form

20.

A value used in a formula that does not change is called a?

   A.) Constant
   B.) Cell address
   C.) Varaible
   D.) Static

Answer: Option 'A'

Constant


MS Excel MCQs Download Pdf

Recent Posts