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.

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

2.

What term describes explanatory text attached to a cell ?

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

Answer: Option 'C'

Comments

Basic Computer Knowledge Quiz

3.

When creating a vertical page break ?

   A.) The active cell must be in row 1
   B.) The active cell must be A1
   C.) The active cell must be in row 10
   D.) The active cell must be in column A

Answer: Option 'A'

The active cell must be in row 1

4.

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

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

Answer: Option 'C'

Standard

5.

 To insert three columns between columns A and B you would

   A.) Select column A
   B.) Select A and B
   C.) Select B
   D.) All of above

Answer: Option 'C'

Select B

6.

You can convert existing Excel worksheet data and charts to HTML document by using the ?

   A.) Intranet Wizard
   B.) Internet Assistant Wizard
   C.) Import Wizard
   D.) Export Wizard

Answer: Option 'B'

Internet Assistant Wizard

7.

Shortcut to delete the selected column ?

   A.) Insert + -
   B.) Shift + -
   C.) Alt + -
   D.) Ctrl + -

Answer: Option 'D'

Ctrl + -

8.

Which function calculates your monthly mortage payment ?

   A.) PV
   B.) NPER
   C.) PMT
   D.) All of above

Answer: Option 'C'

PMT

9.

Which among following is associated with excel ?

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

Answer: Option 'B'

Spreadsheet

10.

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

11.

Which of the following is not a valid Zoom percentage in Excel?

   A.) 100
   B.) 200
   C.) 400
   D.) 500

Answer: Option 'D'

500

12.

Which function in excel counts the numbers of characters in a cell?

   A.) LEN
   B.) LENGHT
   C.) LGT
   D.) LT

Answer: Option 'A'

​LEN

13.

Which types of charts can excel produce?

   A.) Line graphs and pie charts only
   B.) Bar charts, line graphs and pie charts
   C.) Bar charts and line graphs only
   D.) Only line graphs

Answer: Option 'B'

Bar charts, line graphs and pie charts

14.

What is shortcut to enter current date in cell in excel ?

   A.) Ctrl + ;
   B.) Alt + ;
   C.) Shift + &
   D.) Ctrl + $

Answer: Option 'A'

Ctrl + ;

15.

Protection and the Protect Sheet options can be selected from?

   A.) Format
   B.) Data
   C.) Edit
   D.) Tools

Answer: Option 'D'

Tools

16.

What term refers to a specific set of values saved with the workbook ?

   A.) Range
   B.) Scenario
   C.) Data set
   D.) File set

Answer: Option 'B'

Scenario

17.

A function inside another function is known as ?

   A.) Nested function
   B.) Switch function
   C.) Sandwich function
   D.) Round function

Answer: Option 'A'

Nested function

18.

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

19.

On an excel sheet the active cell in indicated by?

   A.) A dotted border
   B.) A dark wide border
   C.) A blinking border
   D.) By italic text

Answer: Option 'B'

A dark wide border

20.

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

   A.) Pivot Table Report
   B.) Pivot Table List
   C.) Pivot Table Field List
   D.) HTML

Answer: Option 'A'

Pivot Table Report


MS Excel MCQs Download Pdf

Recent Posts