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.

Formula palette is used to?

   A.) Format cells containing numbers
   B.) Create and edit formulas containing functions
   C.) entered assumptions data
   D.) copy all cells

Answer: Option 'B'

Create and edit formulas containing functions

2.

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

3.

The accounting style shows negative numbers in ?

   A.) Bold
   B.) Italics
   C.) Parentheses
   D.) Quotes

Answer: Option 'C'

Parentheses

4.

Merge cells option can be applied from?

   A.) Formatting toolbar
   B.) Format Cells dialog box Alignment Tab
   C.) Both of above
   D.) None of above

Answer: Option 'B'

Format Cells dialog box Alignment Tab

5.

Which function is used for creating a data table?

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

Answer: Option 'B'

Table

MS Excel MCQs Download Pdf

<

Recent Posts