MS Excel MCQ Quiz - Objective Question with Answer for MS Excel - Download Free PDF

The correct answer is Escape (Esc)

Key Points

• Esc Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog, or message window.  

Additional Information 

• The spacebar can delete the content when you enter a value in the cell if you press it.
• MS Excel:
  • Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.
  • By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed.
  • Excel contains a large number of boxes called cells that are ordered in rows and columns.

The correct answer is Worksheets.

Key Points

• Workbook
  • In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.
  • A workbook contains several worksheets with related content and only one of the worksheets is active at a time.
• Worksheet
  • Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you Interact with to enter data.
  • Each Worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

Additional Information

• Excel
  • Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.
  • Using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
• To open Ms Excel on your computer, follow the steps given below:
  • Click on Start
  • Then All Programs 
  • The next step is to click on MS Office
  • Then finally, choose the MS-Excel option
• Alternatively, you can also click on the Start button and type MS excel in the search option available.

Note:

Important Points

• An Excel workbook is a collection of worksheets, also known as spreadsheets. It can contain multiple sheets where you can enter and organize data.
• Charts, on the other hand, are visual representations of data that can be created within a worksheet using the data present in that particular worksheet or other worksheets in the workbook.
• So, while a workbook can contain both worksheets and charts, the primary component of an Excel workbook is the collection of worksheets.

The correct answer is Select cell → Right click → Format cell

The correct answer is 15 cm.

Key Points

• In Microsoft Excel, the height of a row can be adjusted to accommodate the content within the cells.
• The maximum height of a row can be set to approximately 409 points, which translates to about 15 cm.
• This feature is useful when dealing with large text or images that need to fit within a single row without being cut off or hidden.

The correct answer is Select the empty cell available next in the left direction to the current selection.

Key Points

• The function of the shortcut key Ctrl + Shift + F4 is to select the empty cell available next in the left direction to the current selection. 
• Microsoft Office program includes MS-EXCEL.
• It is an electronic spreadsheet with many rows and columns that is used for data organization, graphic data representation, and various calculations.

Additional Information

The correct answer is SUBTRACT().

Key Points

SUBTRACT() is not a valid function in MS Excel

Subtract two or more numbers in a cell :

1. Click any blank cell, and then type an equal sign (=) to start the formula.

2. After the equal sign, type a few numbers that are separated by a minus sign (-).

for example, 100-50-30.

3. Press RETURN, then the result is 20.

Additional Information

SUM()

• The SUM() adds values.
• You can add individual values, cell references or ranges, or a mix of all three.
• For example: =SUM(A2:A10) Adds the values in cells A2:10.

• COUNTA - It will allow you to evaluate any gaps the dataset might have without having to reorganize the data.

COUNT()

• The COUNT() is generally used to count a range of cells containing numbers or dates excluding blanks

COUNTA()

COUNTA() will count everything as numbers, dates, text, or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for the count all.

The correct answer is Home.

Key Points

• The Home key is used to move the active cell to the first column on the current row in spreadsheet applications like Microsoft Excel.
• This function is helpful for quickly navigating to the beginning of the row without using the mouse.

Additional Information

• Page Up:
  • This key is used to move the active cell up by one screen.
• Ctrl + Home:
  • This key combination moves the active cell to the beginning of the worksheet (cell A1).
• Page Down:
  • This key is used to move the active cell down by one screen.

The correct answer is Ctrl + shift + L.

Key Points

Ctrl + shift + L is the shortcut to enable filtering of selected cells in MS-Excel.

Additional Information

Shortcuts in Excel:

The correct answer is "Formulae".

Key Points

• MS Excel
  • It is a spreadsheet program for data analysis and documentation.
  • It contains a number of rows and columns, where the intersection of a column and a row is a "cell".
  • Each cell contains one point of data.
  • It is developed by Microsoft.
  • It features calculation, graphing tools, pivot tables, etc.
• The function of (=) sign (Starting of Formula)
  • ​All Excel formulas begin with an equals sign,=, followed by a specific tag denoting the formula.
  • For example, =B1+B2+B3 is a formula that adds up the values in the cells B1 through B3.

Additional Information

The correct answer is Datasheet.

Key Points

• Datasheet
  • Each table that appears as a spreadsheet grid is called a datasheet. Hence, Option 2 is correct.
  • A datasheet is a useful way of viewing data in Access.
  • A database is a collection of tables.
  • Most importantly, datasheet view allows a user to view many table records at the same time.
  • In datasheet view, information is displayed in rows and columns—similar to a spreadsheet.
  • Records are displayed as rows, so each row is an individual record.
  • Within each row, columns represent fields within the record.
  • At the top of the datasheet, a window is the title bar, the Quick Access toolbar, and the Ribbon.
  • The bottom of the window has a status bar and on the right side of the window is a scroll bar as you would expect.
  • Many of the features that are common to spreadsheets are present in Access datasheet windows.
  • A user can modify row height, column width, font size to change the amount of data that fits without scrolling.
  • A user can also change the order of the rows or columns displayed in the window.
  • Datasheet views are a common display tool for tables, queries, and forms in Access.
  • There are some irregularities in the functionality of the datasheet windows for these depending on the underlying data sources.

Image of Datasheet View:

 Additional Information

• Query
  • A query is like a saved filter. It enables us to combine data into a single datasheet from multiple tables.
• Record
  • A record is a row in a table that consists of information about something.
• Table
  • A spreadsheet table, in OpenGL Tablets, is an analog of the Excel table with rows, columns, formulas, and calculations as contents.
  • Spreadsheets can also call decision tables or other executable tables to make decisions on values, and based on those, make calculations.

The correct answer is Pie chart.

• Doughnut Chart:
  • Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart.
  • The doughnut chart is similar to a pie chart.
  • Just like a pie chart, a doughnut chart shows the relationship of parts to a whole.
• A doughnut chart can contain more than one data series.Example of Chart:

The correct answer is Option 3 is correct.

Key Points

• The SUM function adds values.
• You can add individual values, cell references or ranges, or a mix of all three.
• For example: =SUM (A2: A10) Adds all the values in cells A2: A10.
•  =SUM (A2, A10) Adds the respected values in cells A2, A10.
• To add numeric values in column D, from rows D10 to D15, the formula that should be used is : =SUM (D10:D15)

Additional Information

Important functions used in MS Excel:

• AVERAGE() - To calculate the average of the range of the cells.
• CONCATENATE -  Combine text, numbers, dates, and more from multiple cells into one.
• COUNTA - It will allow you to evaluate any gaps the dataset might have without having to reorganize the data.
• ROUND - It returns the round-off value of the decimals.

The correct answer is 409 points.

Key Points

• Rows can have a maximum height of 409 points.
• This number represents how many one-seventy seconds of an inch the row can hold.
• The default size of an Excel row is 15, which correlates to 20 pixels or about one-fifth of an inch. 

Important Points

Worksheet and workbook specifications and limits:

• Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns
• Column width - 255 characters
• Page breaks - 1,026 horizontal and vertical
• Row height - 409 points 

The correct answer is CONCATENATE .

Key Points

CONCATENATE:

• This function joins two or more text strings into one text string.

its syntax is :

• CONCATENATE (text1, text2,...).
• The text items can be text strings, numbers, or single-cell references.

Additional Information

Some important mathematical functions used in MS Excel are:

• SUM
• AVERAGE
• AVERAGEIF
• COUNTA
• COUNTIF
• MOD
• ROUND