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

The correct answer is Toggles between absolute and relative references.

Key Points

• In MS Excel, the F4 key is primarily used to toggle between different types of cell references when editing a formula.
• When you press F4 after selecting a cell reference in a formula, it changes the reference type between:
  • Relative reference (e.g., A1)
  • Absolute reference (e.g., $A$1)
  • Mixed reference (e.g., A$1 or $A1)
• This functionality is useful for ensuring that cell references behave as intended when formulas are copied to different locations in the worksheet.

Additional Information

• The F4 key can also be used to repeat the last action in some contexts, but its primary role in formula editing is to manage cell references.
• Understanding how to use absolute, relative, and mixed references can help you create more flexible and accurate formulas in Excel.
• Other keys that assist with formula editing include F2 (to edit the active cell) and Enter (to complete the formula).
• Efficient use of these keys can significantly enhance your productivity when working with complex spreadsheets.

The correct answer is option 4: embedded

Key Points

When you insert an Excel file into a Word document using options like Insert > Object > Create from File, the Excel data becomes embedded into the Word document. This means the Excel content becomes a part of the Word file, and you can double-click it to open and edit it using Excel tools within Word.

Explanation of options:

• Option 1 – placed in a word table: ❌ Only true if you copy and paste values as a table; not applicable when inserting the actual file.
• Option 2 – linked: ❌ Linking is a separate option where the data updates if the source Excel file is updated. Inserting doesn’t automatically link.
• Option 3 – hyperlinked: ❌ A hyperlink would open the Excel file separately; it doesn’t display the data inside Word.
• Option 4 – embedded: ✅ Correct. The Excel file is inserted and becomes part of the Word document.

Hence, the correct answer is: option 4: embedded

The correct answer is $

Key Points

• The dollar sign ($) is used to denote a relative cell reference in a formula in MS Excel.
• Relative cell references adjust the cell reference when the formula is copied or moved to another cell.
• For example, if a formula in cell A1 is copied to cell B1, a relative reference will update from A1 to B1.
• Using the dollar sign ($) before the column letter or row number makes it an absolute reference, which does not change when copied.

Important Points

• Relative references in Excel are crucial for creating formulas that can be copied across multiple cells.
• The use of the dollar sign ($) ensures that specific parts of the cell reference remain constant.
• Understanding the difference between relative and absolute references is fundamental for efficient spreadsheet management.

The correct answer is Both current date and time.

Key Points

• The "NOW" function is used to retrieve both the current date and time.
• The value returned by "NOW" updates automatically whenever the spreadsheet is recalculated.
• The format of the value depends on the cell's formatting settings (e.g., date, time, or both).
• The "NOW" function is dynamic, meaning the value changes every time the sheet is refreshed or recalculated.

Important Points

• The "NOW" function is available in most spreadsheet software such as Microsoft Excel, Google Sheets, and others.
• It is commonly used for dynamic timestamping or for calculations requiring the current date and time.
• "NOW" differs from the "TODAY" function, which only returns the current date without the time.

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