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.

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

2.

Shortcut to edit the selected cell ?

   A.) F3
   B.) F8
   C.) F4
   D.) F2

Answer: Option 'D'

F2

3.

Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result?

   A.) NOT
   B.) IF
   C.) OR
   D.) AND

Answer: Option 'B'

​IF

4.

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

5.

Style sheet formats can be applied from ?

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

Answer: Option 'B'

Format >> Autoformat

MS Excel MCQs Download Pdf

Recent Posts