Shortmcqs.com

MS Excel Mcqs

  1. Default Font Style in MS Excel 2007 is_________?
    A. Calibri
    B. Times New Roman

    A. Calibri

  2. In Excel, what is the maximum font size you can apply for any character?
    A. 1 to 408
    B. 1 to 409

    B. 1 to 409

  3. Microsoft Excel Owned by?
    A. Microsoft
    B. Facebook

    A. Microsoft

  4. Which of the following is the latest version of MS Excel?
    A. Excel 2016
    B. Excel 2019

    B. Excel 2019

  5. Default MS Excel 97/2003 extension is?
    A. .xlsx
    B. .xls

    A. .xlsx

  6. Default MS Excel 2007/2010 extension is?
    A. Xlr
    B. xlsx

    B. xlsx

  7. Which function calculates the largest value in a set of numbers?
    A. Maximum
    B. Average

    A. Maximum

  8. Microsoft Excel is used for?
    A. Creating 3d Animation
    B. Creating Spreadsheets

    B. Creating Spreadsheets

  9. In Excel Columns are labelled as____________?
    A. A, B, C, etc.
    B. 1, 2, 3, etc.

    A. A, B, C, etc.

  10. In Excel Rows are labelled as____________?
    A. A1, A2, A3, etc.
    B. 1, 2, 3, etc.

    B. 1, 2, 3, etc.

  11. In Microsoft excel which Shortcut is used for Help?
    A. F1
    B. F3

    A. F1

  12. Which of the following Shortcut is used for cell edit in Ms Excel?
    A. F4
    B. F2

    B. F2

  13. Which of the following shortcut is used for Print?
    A. Ctrl + P
    B. Window Key + P

    A. Ctrl + P

  14. Shortcut used to open workbook?
    A. Ctrl + U
    B. Ctrl + O

    B. Ctrl + O

  15. Shortcut used to insert Current (Date) in Excel Cell?
    A. Ctrl +;
    B. Ctrl + =

    A. Ctrl +;

  16. Shortcut used to insert Current (Time) in Excel Cell?
    A. Alt + Shift + ;
    B. Ctrl + Shift + :

    B. Ctrl + Shift + :

  17. Shortcut used to Create New Workbook?
    A. Shift + N
    B. Shift + M

    A. Shift + N

  18. Comments put in cells are called____?
    A. Delete File
    B. Cell Tip

    B. Cell Tip

  19. Which menu option can be used to split windows into two?
    A. View > Window > Split
    B. Window > Split

    A. View > Window > Split

  20. To drag a selected range of data to another worksheet in the same workbook, use the?
    A. Shift key
    B. Ctrl key

    B. Ctrl key

  21. Which Key used for Close Microsoft Excel?
    A. Alt + F4
    B. Alt + F2

    A. Alt + F4

  22. Ctrl + F Shortcut is used for?
    A. Save Record
    B. Find Record

    B. Find Record

  23. Ctrl + H is used for?
    A. Replace Record
    B. Update Record

    A. Replace Record

  24. Which of the following sign is used to begin MS excel formula/function?
    A. + Plus Sign
    B. = Equal Sign

    B. = Equal Sign

  25. Insert Table Option is available in which Menu?
    A. Insert
    B. View

    A. Insert

  26. In MS Excel, which one is default page orientation?
    A. Landscape
    B. Portrait

    B. Portrait

  27. What displays the content of active cell?
    A. Formula bar
    B. Name box

    A. Formula bar

  28. Which function in Excel tells how many numeric entries are there?
    A. Lookup
    B. Count

    B. Count

  29. You can open the Sort dialog box by choosing Sort from the_______menu?
    A. Data
    B. Tools

    A. Data

  30. Status indicators are located on the?
    A. Standard toolbar
    B. Formula bar

    B. Formula bar

  31. An excel workbook is a collection of?
    A. Worksheets and charts
    B. Data flow and ribbon

    A. Worksheets and charts

  32. Macros are “run” or executed from the …. menu?
    A. Insert
    B. Tools

    B. Tools

  33. How are data organized in a spreadsheet?
    A. Rows and columns
    B. Lines and spaces

    A. Rows and columns

  34. A function inside another function is called a …… function?
    A. Round
    B. Nested

    B. Nested

  35. Which function calculates your monthly mortgage payment?
    A. PMT (payments)
    B. PV (present value)

    A. PMT (payments)

  36. What type of chart is useful for comparing values over categories?
    A. Column Chart
    B. Pie Chart

    B. Pie Chart

  37. How many columns exist in a single worksheet?
    A. 16384
    B. 15384

    A. 16384

  38. MS Excel 2016 have ______ rows in one sheet?
    A. 1048577
    B. 1048576

    B. 1048576

  39. How many characters can fit into a single cell?
    A. 32767
    B. 38767

    A. 32767

  40. Total Number of Cells in one single sheet of the MS Excel 2016?
    A. 16,179,869,184
    B. 17,179,869,184

    B. 17,179,869,184

  41. A worksheet range is a?
    A. A group of cells
    B. A group of bytes

    A. A group of cells

  42. Getting data from a cell located in a different sheet is called …?
    A. Dollar
    B. Referencing

    B. Referencing

  43. Concatenation of text can be done using?
    A. Ampersand (&
    B. Equal (=

    A. Ampersand (&

  44. Excel uniquely identifies cells within a worksheet with a cell name?
    A. Column number and Numeric
    B. Column letters and row numbers

    B. Column letters and row numbers

  45. Which one is the correct size for A4 Size page in inches?
    A. 210 X 297
    B. 210 X 299

    A. 210 X 297

  46. A features that displays only the data in column (s) according to specified criteria?
    A. Vlookup
    B. Filtering

    B. Filtering

  47. Statistical calculations and preparation of tables and graphs can be done using?
    A. Excel
    B. Word

    A. Excel

  48. Which function in Excel checks whether a condition is true or not?
    A. Max
    B. IF

    B. IF

  49. The Greater Than sign (>) is an example of _____ operator?
    A. Logical
    B. Conditional

    A. Logical

  50. What type of chart is useful for showing trends or changes over time?
    A. 3D Chart
    B. Line Chart

    B. Line Chart

  51. The ____ feature of MS Excel quickly completes a series of data?
    A. Auto Fill
    B. Auto Data

    A. Auto Fill

  52. What type of chart is useful for comparing parts of a whole?
    A. Column Chart
    B. Pie Chart

    B. Pie Chart

  53. What do you use to create a chart?
    A. Chart Wizard
    B. Pivot Wizard

    A. Chart Wizard

  54. How will you graphically represent expenditure in different departments?
    A. Line Chart
    B. Pie Chart

    B. Pie Chart

  55. The basic unit of a worksheet into which you enter data in Excel is called?
    A. Cell
    B. Rows

    A. Cell

  56. How many sheets are there, by default, when we create a new Excel file?
    A. 2
    B. 3

    B. 3

  57. An Excel file is generally called a?
    A. Worksheet
    B. Workbook

    A. Worksheet

  58. It is a collection of data that is stored electronically as a series of records in a table?
    A. Serial
    B. Database

    B. Database

  59. In MS-Excel which of the following is an absolute cell reference?
    A. $A$1
    B. A1

    A. $A$1

  60. What type of chart will you use to compare performance of sales of two products?
    A. Bar Chart
    B. Pie Chart

    B. Bar Chart

  61. MS-Excel uses the ____ Function when creating a data table?
    A. Table
    B. Data

    A. Table

  62. What MS-Excel feature can you use if you want to work with one record at a time?
    A. Sorting Form
    B. Data Form

    B. Data Form

  63. In MS-Excel value used in a formula that does not change is called a?
    A. Constant
    B. Slicer

    A. Constant

  64. In MS-Excel, which key is used to insert comment/notes?
    A. Shift + F5
    B. Shift + F2

    B. Shift + F2

  65. In MS-Excel Chart wizard term data categories refers to?
    A. A horizontal axis
    B. A vertical axis

    A. A horizontal axis

  66. A Spreadsheet contains?
    A. Only Rows
    B. Rows and Columns

    B. Rows and Columns

  67. Which among following is associated with Excel?
    A. Spreadsheet
    B. Word processor

    A. Spreadsheet

  68. Which Key is used to open “Go To” Tab in MS Excel?
    A. F6
    B. F5

    B. F5

  69. Which function displays row data in a column or column data in a row?
    A. Transpose
    B. Index

    A. Transpose

  70. VLOOKUP Function used to?
    A. Finds Duplicate Values
    B. Finds Related Records

    B. Finds Related Records

  71. To protect a worksheet, you can choose protection and the protect sheet from the menu?
    A. Tools
    B. Edit

    A. Tools

  72. To Minimize/Maximize Workbook in MS Excel?
    A. Ctrl + F8
    B. Ctrl + F10

    B. Ctrl + F10

  73. Merge Cells Option Can Be Applied from Hyperlinks Can be in?
    A. Format Cells Dialog Box Alignment Tab
    B. Formatting Toolbar

    A. Format Cells Dialog Box Alignment Tab

  74. Which function in excel counts the numbers of characters in a cell?
    A. LEFT function
    B. LEN function

    B. LEN function

  75. Hyperlinks Can be in?
    A. Drawing Objects + Text + Picture
    B. Only text

    A. Drawing Objects + Text + Picture

  76. Which function converts miles to kilometers?
    A. Shift
    B. Convert

    B. Convert

  77. Which shortcut key is used to create new sheet?
    A. Shift + F2
    B. Shift + F9

    A. Shift + F2

  78. Which shortcut key is used to (delete selected) Columns and Rows?
    A. Ctrl + = (equal character)
    B. Ctrl + – (minus character)

    B. Ctrl + – (minus character)

  79. How many recent files you can display on File menu at maximum?
    A. 9
    B. 7

    A. 9

  80. The name box appears at the?
    A. Right of the formula bar
    B. Left of the formula bar

    B. Left of the formula bar

  81. In Excel which key is used for create a formula to sum all of the above cells?
    A. Alt+=
    B. Alt+-

    A. Alt+=

  82. In Excel which key is used to open the excel formula window/insert function?
    A. Ctrl+F3
    B. Shift+F3

    B. Shift+F3

  83. In MS Excel, which key is used for Hyperlink?
    A. Ctrl+K
    B. Ctrl+R

    A. Ctrl+K

  84. Which shortcut key is used to (insert) selected Columns and Rows?
    A. Ctrl + = (equal character)
    B. Ctrl + + (plus character)

    B. Ctrl + + (plus character)

  85. Which key is used to insert new worksheet in excel?
    A. Alt+Shift+F1
    B. Alt+F1

    A. Alt+Shift+F1

  86. Which key is used to create chart from selected data in excel?
    A. F10
    B. F11

    B. F11

  87. In Excel which key is used to Open the Format Cells window?
    A. Ctrl+1
    B. Ctrl+2

    A. Ctrl+1

  88. In Excel which key is used to select entire row?
    A. Alt+Space
    B. Shift+Space

    B. Shift+Space

  89. In Excel which key is used to select entire column?
    A. Ctrl+Space
    B. Shift+Space

    A. Ctrl+Space

  90. Shortcut to quit Microsoft Word, Excel, PowerPoint, Access etc is _____?
    A. Shift + F4
    B. Alt + F4

    B. Alt + F4

  91. Which shortcut is used to open visual basic window?
    A. Alt+F11
    B. Alt+F10

    A. Alt+F11

  92. Which language is used to create macros in Excel?
    A. Visual C++
    B. Visual Basic

    B. Visual Basic

  93. Which Shortcut keys are used to strikethrough highlighted selection in Excel?
    A. Ctrl+5
    B. Ctrl+6

    A. Ctrl+5

Back To Top