To quickly sum the values in the last column, you must enable the built-in Total Row feature within the table structure. By navigating to the Design tab of the Ribbon and selecting the Total Row option, a dedicated row appears at the bottom of your table. This row automatically calculates sums, averages, or counts for each numeric column, placing the total directly in the final cell. This method is efficient because it leverages the table's native formatting tools rather than requiring manual formula entry or complex ribbon navigation.

Question 2 Easy Mcq

✓ Correct ✗ Incorrect

In a selected column-layout PivotChart, what's one way to swap which fields are listed across the horizontal axis, and which fields are listed in the legend?

On the Design tab of the Ribbon, click the Switch Row/Column button.

Right-click the chart, and from the pop-up menu select Swap Legend and Axis.

On the Analyze tab of the Ribbon, click the Change Data Source button, then select which field goes where.

On the Format tab of the Ribbon, click the Legend button, then from the drop-down, select the field attached to it.

Explanation:

In a PivotChart, the Switch Row/Column button on the Design tab instantly reorients the data layout by moving fields between the horizontal axis and the legend area. This action effectively swaps the categories displayed across the bottom with those shown in the legend box without altering the underlying data source. Clicking this specific tool is the most direct method to change the visual orientation of the chart's fields. It allows users to quickly compare how different field assignments impact the readability and structure of the report. This feature is essential for optimizing how large datasets are presented to an audience.

Question 3 Easy Mcq

✓ Correct ✗ Incorrect

True or False: If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.

True

False

Explanation:

The COUNT function is designed to simply tally the total number of items present in a list, regardless of their values. When duplicate items exist, the function treats each entry as a distinct element within the collection. Consequently, it increments the total count for every single instance found, ensuring that all duplicates are fully included in the final result. This behavior distinguishes it from functions like COUNTIF or UNIQUE, which might filter or aggregate based on specific criteria. Therefore, the statement claiming duplicates are excluded is incorrect because the standard count operation inherently includes every item.

Question 4 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following Excel 2013 features allows sharing file with other people and working together in real time?

Representational State Transfer (REST)

SkyDrive

Online Meeting

Both b and c

Explanation:

SkyDrive, now known as OneDrive, serves as the cloud storage platform that enables users to upload files and instantly share them with others via a link or email. This cloud-based infrastructure allows multiple people to access the same document simultaneously, facilitating real-time collaboration where edits are saved automatically. Online Meeting further enhances this capability by providing a dedicated space for teams to discuss the shared content while working together. Together, these integrated features transform static spreadsheets into dynamic, collaborative workspaces accessible from any device with an internet connection.

Question 5 Easy Mcq

✓ Correct ✗ Incorrect

If you have a worksheet that's several pages long, how can you get the column headers across row 5 to print at the top of each page?

Copy row 5 on page 1. In Page Layout view, scroll down and paste into the top row of the remaining pages.

From the View tab, click Headers. Click in the box on the top of the page, then type $5.

Right-click the header of row 5. From the pop-up menu, select Print on Every Page.

From the Page Layout tab, click Print Titles. In the Sheet tab, click in Rows to Repeat at Top, then click the header of row 5.

Explanation:

To ensure column headers appear at the top of every printed page in a long worksheet, you must use the "Print Titles" feature found in the Page Layout tab. This function allows you to specify a specific row, such as row 5, to be repeated automatically on each new page during printing. By selecting the "Rows to Repeat at Top" option and clicking the desired header row, the software configures the print layout to include those cells consistently without requiring manual copying or pasting. This method is the standard and most efficient way to manage repeating headers for multi-page documents in spreadsheet applications.

Question 6 Hard Mcq

✓ Correct ✗ Incorrect

Which of the following formulas can be used to extract a word containing specific text?

#VALUE!

{=MAX(IF(ISERROR(SEARCH(H5&"*",files)),0,ROW(files)-ROW(INDEX(files,1,1))+1))}

Explanation:

This complex formula extracts a specific word by first replacing spaces with a long string of characters to treat each word as a continuous block. It then locates the target text using a search function and calculates the starting position within that expanded block. By applying the MID function with these calculated coordinates, it isolates the desired word while the TRIM function cleans up any trailing padding characters, effectively retrieving the exact text segment.

Question 7 Easy Mcq

✓ Correct ✗ Incorrect

The insert function dialog box has a(n) ____ option

Normal

Content and formats

None of these

Explanation:

The correct option is Search because this setting allows the inserted content to be placed directly into the document's existing table of contents structure. When selected, the dialog box updates the TOC hierarchy to reflect the new entry immediately, ensuring consistent navigation and accurate page numbering. This feature is essential for maintaining a dynamic and up-to-date document outline without requiring manual reformatting. It streamlines the workflow by automatically integrating new sections into the master list. Users can rely on this option to preserve the logical flow of their document. Consequently, it is the standard choice for adding new chapters or sections efficiently.

Question 8 Easy Mcq

✓ Correct ✗ Incorrect

Which method will you use to update table data from a Sharepoint list?

On the Data tab, in the Data Tools group, click Refresh

On the View tab, in the Show/Hide group, click Refresh

On the Design tab, in the External Data group, click Refresh

None of the above

Explanation:

The correct approach involves accessing the Data tab within the Power Query Editor, where the External Data group houses the Refresh command. This specific location is designed to synchronize current information from the source SharePoint list with the existing table data. Clicking Refresh ensures that any new entries or modifications made in the SharePoint environment are accurately imported and displayed in your dataset. This method maintains data integrity by pulling the latest records directly from the cloud-based source. Consequently, this is the standard and most effective way to update external data connections in this context.

Question 9 Easy Mcq

✓ Correct ✗ Incorrect

The cursor in the given image is on A3 cell. If you want to move the cursor to E8 cell, then which of the following shortcuts can be used?

Ctrl + L

Shift + Z

Ctrl + end

Shift + end

Explanation:

The Ctrl + End shortcut is designed to instantly move the cursor to the very last used cell in the active worksheet. Since cell E8 is located within the populated data range of the sheet, pressing this combination will jump directly to the bottom-right corner of that data block, which includes E8. This command is highly efficient for navigating large spreadsheets without manually scrolling through empty rows and columns. It automatically detects the boundary of your actual data, making it the correct choice for reaching any cell within the used range.

Question 10 Easy Mcq

✓ Correct ✗ Incorrect

What is the Mini Toolbar used for?

It provides a smaller substitute for the Quick Access Toolbar

It gives quick access to common formatting commands

It gives you quick access to common functions

It provides a smaller substitute for the Ribbon

Explanation:

The Mini Toolbar is a floating menu that appears automatically when you format text, such as changing font color or adding bold. It provides quick access to common formatting commands without requiring you to navigate back to the main Ribbon. This feature allows users to apply styles instantly while keeping their cursor in the document. By offering these tools in a compact pop-up, it streamlines the editing process significantly. Consequently, it is specifically designed to give immediate access to frequent formatting options.

Question 11 Easy Mcq

✓ Correct ✗ Incorrect

Column A contains first names and Column B contains last names. What formula would output in the format "Last, First" in cell C7?

#VALUE!

A red triangle at the top right corner of a cell indicates what?, mcq

mcq, A red triangle at the top right corner of a cell indicates what?

Explanation:

The ampersand (&) operator in spreadsheet software is the standard function used to concatenate, or join, multiple text strings into a single continuous value. By placing text values from different columns around the "&" symbol with a comma and space in between, the formula effectively combines the first name and last name into the desired "Last, First" format. This method allows users to dynamically create formatted text strings directly within a cell without needing to manually edit the content. Consequently, this specific syntax is the correct and most efficient way to achieve the required output structure in the target cell.

Question 12 Easy Mcq

✓ Correct ✗ Incorrect

True or False: Sparklines are also often called "micro charts."

False

True

Explanation:

Sparklines are indeed frequently referred to as micro charts because they are small, simple line or bar graphs embedded directly within text or tables to show trends without axes. These compact visualizations function by stripping away unnecessary elements like titles and scales to focus purely on the data pattern. The term "micro chart" accurately describes their miniature size and their specific role in providing quick, at-a-glance insights within a larger document. This synonymy is widely accepted in data visualization literature, making the statement factually correct. Understanding this terminology helps in selecting the right tools for concise data reporting.

Question 13 Easy Mcq

✓ Correct ✗ Incorrect

Placing a chart in a ____ dlls.

Chart sheet

Data series

Surface

Junk

Explanation:

A chart sheet is a dedicated worksheet in spreadsheet applications specifically designed to display charts without cluttering the main data grid. When you place a chart here, it creates a separate visual area that allows for better readability and easier management of large datasets. This separation ensures the graphical representation remains distinct from the raw numbers, making it the standard location for embedding charts within a workbook.

Question 14 Easy Mcq

✓ Correct ✗ Incorrect

Which Function should be used to count all the cells which are not empty?

All of the Above

Explanation:

The COUNTA function is specifically designed to count all non-empty cells within a selected range, regardless of whether they contain numbers, text, or logical values. Unlike functions that only tally numeric data, this tool treats any cell with content as a valid entry, making it the ideal choice for determining the total number of populated items. It effectively ignores only those cells that are completely blank, ensuring an accurate count of all active data points in your spreadsheet.

Question 15 Easy Mcq

✓ Correct ✗ Incorrect

Under which ribbon item can you find protection options?

Data

View

Edit

Review

Explanation:

The Review tab is specifically designed to help users manage document security and collaboration settings. Within this section, you can access the Protect Document group, which contains essential tools like restricting editing permissions and adding password protection. This centralized location ensures that all safety measures are applied consistently to maintain file integrity. By selecting this tab, you gain direct control over who can view or modify the content. It serves as the primary hub for enforcing access controls and preventing unauthorized changes. Therefore, all protection options are logically grouped under this dedicated ribbon item.

Question 16 Easy Mcq

✓ Correct ✗ Incorrect

If a range name is used in a formula and the name is deleted, what happens to the formula?

The formula display a warning but the actual cell address is substituted for the deleted name.

The formula becomes invalid and displays a #NAME? error.

The actual cell addresses replace the original range name in the formula.

The formula becomes invalid and displays a #N/A error

Explanation:

When a range name is deleted from a workbook, any formula referencing that name loses its defined identifier. The spreadsheet application cannot resolve the missing name to a specific cell range, causing the formula to break immediately. Consequently, the cell displays a #NAME? error because the system interprets the deleted name as an unrecognized function or variable. This error occurs instantly without substituting the original cell address or generating a warning message. The formula remains invalid until the name is redefined or the formula is manually edited to use direct cell references.

Question 17 Easy Mcq

✓ Correct ✗ Incorrect

What "Insert" option should you use for a PDF?

Spreadsheet

Chart

Picture

Object

Explanation:

The "Object" insert option is specifically designed to embed external files, such as PDF documents, directly into a host application like Microsoft Word. Unlike pictures which are treated as static images or spreadsheets which are data grids, objects maintain a live link to the source file, allowing the embedded PDF to be viewed, opened, or updated as needed. This method preserves the original formatting and interactivity of the PDF while keeping it contained within the current document structure.

Question 18 Easy Mcq

✓ Correct ✗ Incorrect

What is a quick way of viewing the underlying data of any cell of a PivotTable?

Select a cell, then on the PivotTable - Design tab of the Ribbon, click New Report.

Double-click the cell to display the data in a new worksheet.

Select a cell, then press Ctrl + Shift + D.

Select a cell, then on the PivotTable - Analyze tab of the Ribbon, click Show Detail.

Explanation:

Double-clicking a PivotTable cell instantly creates a new worksheet containing the raw source data for that specific entry. This action bypasses the summarized view to reveal the exact rows and columns contributing to the displayed value, making it the fastest method to inspect individual records. It effectively filters the entire dataset to show only the underlying items matching the selected cell's criteria. This feature is built directly into Excel to help users quickly verify data accuracy or trace specific values without manual filtering.

Question 19 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following tabs will you use to hide the header row of the table (given in the image)?

Insert

Data

Design

View

Explanation:

The Design tab in Microsoft Word contains the specific tools needed to customize table styles and structure. Within this tab, you can access the Table Properties dialog box where the Header row option is located. By unchecking this option, the header row is effectively hidden from the table display while keeping the data intact. This feature is essential for creating clean tables where the header information is not needed in the final output. It provides a direct way to manage the visual presentation of tabular data without altering the underlying content.

Question 20 Easy Mcq

✓ Correct ✗ Incorrect

Where in the ribbon is the "Zoom to Selection" tool located?

Insert tab

Data tab

Review tab

View tab

Explanation:

The "Zoom to Selection" tool is found on the View tab because this section of the ribbon manages all display and navigation settings for the document. This specific command allows users to quickly adjust the zoom level to fit a selected range of cells or objects within the visible window. Accessing it here ensures that visual adjustments are grouped logically with other viewing tools like zoom controls and layout options. By placing it on the View tab, the interface keeps all actions related to screen presentation and interaction in one intuitive location for efficient workflow.

Question 21 Easy Mcq

✓ Correct ✗ Incorrect

This question is based upon the figure shown belowWhich part of the formula displays references in the given picture?

Explanation:

The correct part of the formula is the cell reference, which points to specific data within the spreadsheet grid. In the provided image, section B clearly shows a cell address like A1 or B2, indicating where the value is located. This reference allows the formula to dynamically pull data from the exact cell intended, rather than using a static number. Without this reference, the calculation would lack the necessary input from the worksheet. Therefore, identifying the cell address is the key to understanding how the formula functions.

Question 22 Easy Mcq

✓ Correct ✗ Incorrect

State whether true or false:When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

True

False

Explanation:

When table headers are turned off in a spreadsheet application, the interface automatically removes the header row to save space. This action specifically clears the Autofilters applied to those headers, as they are intrinsically linked to the header row's visibility. However, any other filters applied directly to data columns remain active and unaffected by this change. Consequently, the statement is true because the removal of headers inherently causes the removal of their associated Autofilters.

Question 23 Easy Mcq

✓ Correct ✗ Incorrect

Kristen is working on confidential data and wants to make the Excel 2010 document password protected. Which of the following sets of steps will allow her to protect the document with a password?

Open File menu -> Click on Info -> Click on Protect Document -> Click on Encrypt with Password

Open File menu -> Click on Security -> Select Password Protection

Open File menu -> Click on Security -> Click on Protect Document -> Click on Secure with Password

Open File menu -> Click on Info -> Click on Security -> Click on Encrypt with Password

Explanation:

In Excel 2010, the correct workflow to secure a file involves navigating to the File menu, selecting Info, and choosing Protect Document to access the Encrypt with Password option. This specific path ensures the document is encrypted so that a password is required to open it, directly addressing the need for confidentiality. The process utilizes the built-in encryption features designed for protecting sensitive data within the application's interface. By following these exact steps, the user effectively locks the document against unauthorized access. This method is the standard procedure for applying password protection in this version of the software.

Question 24 Easy Mcq

✓ Correct ✗ Incorrect

Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?

Need to set the cell to bold.

Go to page set up and set to print as black and white.

Change out the printer cartridge.

The formatting for grid lines isn't set on the cell.

Explanation:

Grid lines are purely a visual formatting element used to organize data within the spreadsheet interface, but they are not printed by default. To make them appear on paper, you must explicitly enable the "Print gridlines" option within the page setup or print settings. Without this specific setting activated, the software will only print the actual cell contents, resulting in a clean sheet without the separating lines. Therefore, the issue is strictly a matter of missing formatting configuration rather than a hardware failure or color setting.

Question 25 Easy Mcq

✓ Correct ✗ Incorrect

True or False: The print area cannot be set to discontinuous ranges.

False

True

Explanation:

The statement is false because Microsoft Excel explicitly allows users to define a print area that includes multiple, non-contiguous ranges. By selecting separate blocks of data and applying the "Set Print Area" command, you can configure the printer to output these distinct sections on a single page or across multiple pages. This feature is particularly useful for printing specific headers with different data tables or combining scattered reports without needing to merge them into one continuous block. Consequently, the capability to handle discontinuous ranges is a standard function within the page setup options.

Question 26 Easy Mcq

✓ Correct ✗ Incorrect

The transpose action in Excel is found in:

TRANSP() formula

Paste Special Command

A format option

An add-in

Explanation:

The transpose action in Excel is accessed through the Paste Special command, which allows users to switch rows and columns when pasting data. By selecting the source range, copying it, and then choosing Paste Special with the Transpose option checked, the data orientation is inverted instantly. This built-in feature eliminates the need for complex formulas or external tools, making it the standard method for rearranging tabular layouts. It is a direct function of the Excel interface rather than a hidden format setting or a separate add-in. Users simply need to ensure the destination area is empty to avoid overwriting existing information during the process. This straightforward workflow makes transposing data a quick and efficient task for any spreadsheet user.

Question 27 Easy Mcq

✓ Correct ✗ Incorrect

To move the insertion point to the next cell to the right in a table, you can ____.

Press the Tab key

Press the Alt + Tab key

Press Alt + Home

Press Backspace Tab Enter

Explanation:

In spreadsheet and word processing applications, the Tab key is the standard navigation command designed to move the active cell or insertion point directly to the next column on the right. When you press this key, the software automatically shifts focus from the current cell to the adjacent one, streamlining data entry and table editing. This behavior is consistent across most digital interfaces, making it the most efficient method for horizontal movement within a grid structure.

Question 28 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following function(s) accepts criteria?

SUMIF()

AVERAGEIF()

COUNTIFS()

DGET()

Explanation:

The SUMIF function is specifically designed to sum values in a range that meet a single specified condition, making the criteria argument essential for its operation. It evaluates each cell against the provided logical test and adds only those that satisfy the requirement. This dependency on criteria distinguishes it from basic sum functions that lack conditional logic. Consequently, the ability to filter data based on rules is the core feature that defines this function's utility. Without the criteria parameter, the function cannot perform its intended conditional summation task.

Question 29 Easy Mcq

✓ Correct ✗ Incorrect

The best way to apply page setup options to multiple worksheets is to ________.

Group the worksheets

Relative worksheets

Both

None of these

Explanation:

Grouping worksheets allows you to select multiple sheets simultaneously, enabling a single page setup command to apply uniformly across all selected pages. This method ensures consistent margins, headers, and footers throughout the workbook without needing to configure each sheet individually. By using this feature, you save significant time and maintain a professional, standardized document layout efficiently.

Question 30 Medium Mcq

✓ Correct ✗ Incorrect

What formula permits the use of multiple lookup criteria?

Index(match())

Vlookup(Index())

Sumproduct

Hlookup

Explanation:

The SUMPRODUCT function is uniquely capable of handling multiple lookup criteria by multiplying arrays of logical conditions together. When criteria are met, the function returns 1, and when they are not, it returns 0, effectively filtering the dataset before performing calculations. This mathematical approach allows users to sum or count values based on complex, multi-variable requirements without needing nested functions. It dynamically evaluates each row against every specified condition to ensure only the exact matches contribute to the final result. Consequently, it serves as the most robust and flexible tool for multi-criteria lookups in spreadsheet applications.

Question 31 Easy Mcq

✓ Correct ✗ Incorrect

How do you create Word Art?

On the Insert tab, in the Text group, click WordArt

On the Review tab, in the Text group, click WordArt

On the Page Layout tab, in the Themes group, click Effects

On the Page Layout tab, in the Page Setup group, click WordArt

Explanation:

To create stylized text in Microsoft Word, you must access the dedicated WordArt feature located on the Insert tab within the Text group. This specific location allows users to easily add decorative fonts and effects directly to their document. Clicking this button opens a gallery of pre-designed styles that transform plain text into visually appealing graphics. It is the standard and most direct method for adding artistic typography without needing external tools. This workflow ensures that the text remains editable while providing immediate access to professional design elements.

Question 32 Easy Mcq

✓ Correct ✗ Incorrect

Clicking the ____ box completes an entry.

INSERT

Enter

End

CRT+A

Explanation:

The Enter key is the standard command used to finalize data input in most software applications and operating systems. When you type text or numbers into a field, the system waits for confirmation before saving the entry or moving to the next item. Pressing Enter signals that the current input is complete and ready for processing, effectively committing the data to the database or application memory. This action triggers the underlying logic to validate the entry and update the interface accordingly. Without this confirmation step, the system would remain in an editing state, preventing the completion of the task. Therefore, it is the essential final step for successfully recording information.

Question 33 Medium Mcq

✓ Correct ✗ Incorrect

What is the simplest possible way to insert picture in cell A1 which shows on Mouse Hover on cell A1?

Right-click cell > Insert Comment > right-click on (yellow area) inside comment box > Format Comment > Fill > Fill Effects > Picture > (Browse to picture) > Click OK

None of them

Right-click cell > Insert Comment > right-click on shaded (grey area) on outside of comment box > Format Comment > Colors and Lines > Fill > Color > Fill Effects > Picture > (Browse to picture) > Click OK

All of the them

Explanation:

To display an image on hover, you must insert a standard cell comment rather than a note, as notes lack the specific formatting options required for image insertion. The correct procedure involves right-clicking the cell to insert a comment, then accessing the comment's formatting menu via the shaded grey area outside the box. Within the formatting dialog, navigating to Fill Effects and selecting the Picture option allows you to browse and insert the desired image. This specific workflow ensures the image appears exactly when the mouse hovers over the cell, fulfilling the requirement for a simple hover-triggered display.

Question 34 Easy Mcq

✓ Correct ✗ Incorrect

While creating a PivotTable in Excel 2016, where can a user place the PivotTable report? It is always placed in a new worksheet. It is always placed in an existing worksheet. It can either be placed in a new worksheet or in an existing worksheet. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?

TRUE

False

Explanation:

The ISTEXT function is a logical test that specifically checks if a given value is stored as text within a cell. When the input value is indeed text, the function returns TRUE to confirm the data type, whereas it returns FALSE if the value is a number, boolean, or any other non-text format. This behavior allows users to filter or validate data types effectively within their spreadsheets. The result is strictly a logical value representing the outcome of the type check.

Question 35 Easy Mcq

✓ Correct ✗ Incorrect

State whether the following is true or false: Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook

True

False

Explanation:

The statement is true because Excel Web App does provide Undo and Redo functionality for individual users editing a file. However, to prevent data conflicts and ensure consistency when multiple people are working on the same workbook simultaneously, the system automatically disables these features during active collaboration. This design choice prioritizes the integrity of the shared data over the ability to reverse actions in a multi-user environment.

Question 36 Easy Mcq

✓ Correct ✗ Incorrect

Which function returns the largest value amongst all values within the range H2:H30?

#REF!

Explanation:

The MAX function is the standard spreadsheet tool designed to scan a specific range of cells and automatically identify the highest numerical value within that set. When applied to the range H2:H30, it efficiently processes all entries to return the single largest result without requiring manual comparison. This built-in capability makes it the most direct and reliable method for finding the maximum value in any given dataset. Using this function ensures accuracy and saves significant time compared to alternative calculation methods. It is a fundamental operation for data analysis and reporting in almost every spreadsheet application. Therefore, selecting the option that invokes this specific function is the correct approach for this task.

Question 37 Easy Mcq

✓ Correct ✗ Incorrect

You can ____ a table field if the information stored in a field becomes unnecessary.

Block

Remove

Freeze

Hide

Explanation:

When data within a specific table field is no longer required for the system's functionality, the appropriate action is to permanently delete that field from the database structure. This process, known as removing or dropping a column, ensures that the database schema remains clean and optimized by eliminating redundant storage space. Unlike hiding or freezing, which only alter the field's visibility or position without deleting the data, removal effectively erases the field entirely. Consequently, this maintains database integrity by preventing the accumulation of unnecessary information that could impact performance or cause confusion.

Question 38 Easy Mcq

✓ Correct ✗ Incorrect

For a formula that calculates gross pay based on hourly wage (column A) and hours worked (column B), what are the cells in columns A and B called?

Antecedent Cells

Proprietary Cells

Dependent Cells

Precedent Cells

Explanation:

In spreadsheet terminology, the cells containing input data like hourly wage and hours worked are known as precedent cells because they precede the calculation. These specific cells provide the necessary values that the formula references to determine the final result. Conversely, the cell displaying the calculated gross pay is called the dependent cell, as its value relies entirely on the inputs. Understanding this directional relationship is fundamental to building logical and functional spreadsheets where data flows from inputs to outputs.

Question 39 Easy Mcq

✓ Correct ✗ Incorrect

If you want to enter the days of the week across a row, how can you save a lot of typing?

Click the Insert tab on the Ribbon and select the QuickParts drop-down. Choose Days of the Week.

Enter "Sunday" into the first cell, then drag the small dot at the lower-right corner of the cell to the right.

Enter "Sunday" into the first cell, then click the next cell to the right. From the Insert tab on the Ribbon, select Equation, then choose +6.

Enter "Sunday" into the first cell. Click the Insert tab on the Ribbon and select Complete Series.

Explanation:

This method utilizes the built-in AutoFill feature in spreadsheet applications to automatically generate a sequential list of days. By typing the first day of the week and dragging the fill handle, the software detects the pattern and continues it across the row without requiring manual input for each cell. This technique significantly reduces repetitive typing and minimizes the risk of spelling errors or inconsistencies in the data. It is a standard, efficient workflow designed specifically for entering time-based sequences like dates or days. Users simply need to initiate the pattern once, allowing the application to handle the rest of the series automatically. This approach is faster and more user-friendly than manually entering each day or using complex menu commands.

Question 40 Easy Mcq

✓ Correct ✗ Incorrect

How do you make sure that a formula's result will always fit into the cell?

Set the font size to 8 or less.

Use Zoom to see the cell.

Set the cell's format to "Shrink to fit".

Make the cell very large.

Explanation:

The "Shrink to fit" format option automatically adjusts the font size within a cell to ensure the entire formula result remains fully visible without spilling over borders. This feature dynamically reduces text scaling while maintaining readability, guaranteeing that all characters fit neatly inside the defined cell boundaries. It is a built-in spreadsheet function designed specifically to handle long text or complex formulas that would otherwise exceed the cell's width or height. By applying this setting, users can preserve data integrity and visual clarity without needing to manually resize columns or rows. Consequently, this method provides a reliable and efficient solution for managing content overflow in any spreadsheet application.

Question 41 Easy Mcq

✓ Correct ✗ Incorrect

This question is based upon the figure shown belowWhich among the following options displays Legend entries in the given picture?

None of the above

Explanation:

The correct option accurately represents the legend entries visible in the provided figure, matching both the symbols and their corresponding labels. A legend serves as a key that deciphers the graphical elements, ensuring viewers can correctly interpret the data categories presented in the chart. This option aligns perfectly with the visual information, confirming its validity as the true representation of the figure's explanatory text.

Question 42 Easy Mcq

✓ Correct ✗ Incorrect

A ________________ consists of a grid made from columns and rows?

Label

Cell

Spreadsheet

Formula

Explanation:

A spreadsheet is a digital tool specifically designed to organize data into a structured grid format. This grid is formed by the intersection of vertical columns and horizontal rows, allowing users to input and manage information systematically. Each individual point where a column meets a row is known as a cell, which serves as the fundamental unit for storing data within the larger spreadsheet application. This structured layout enables efficient calculation, analysis, and visualization of complex datasets across various fields like finance and science. Therefore, the term that accurately describes the entire grid system composed of columns and rows is a spreadsheet.

Question 43 Easy Mcq

✓ Correct ✗ Incorrect

A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish this?

Use the ROUND() function.

Click the Decrease Decimal button twice.

In the cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.

Click the Decrease Decimal button once.

Explanation:

The Decrease Decimal button directly reduces the number of digits displayed after the decimal point in a cell without altering the underlying stored value. By clicking it once, the value 7.877 becomes 7.8, and clicking it a second time further rounds the display to 7.9, which matches the desired output. This feature allows for quick visual formatting of numerical data to meet specific presentation requirements. It is the most efficient method for adjusting decimal places compared to complex formatting dialogs. The operation is purely cosmetic, ensuring data integrity remains intact while improving readability.

Question 44 Easy Mcq

✓ Correct ✗ Incorrect

Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?

CTRL+SHIFT+"

CTRL+SHIFT+:

CTRL+;

None of the above

Explanation:

The correct shortcut is CTRL+SHIFT+: because pressing the colon key while holding these keys triggers Excel's built-in function to insert the current system time. This action relies on the computer's internal clock rather than manual typing, ensuring the timestamp is always accurate. The colon key specifically represents the time format in this context, distinguishing it from the semicolon used for dates. By utilizing this combination, users can instantly populate cells with dynamic time values that update automatically. This method is a standard feature in spreadsheet software designed to streamline data entry tasks.

Question 45 Easy Mcq

✓ Correct ✗ Incorrect

Excel's data validation feature enables you to...

request that all edits be sent to you for approval

set up certain rules that dictate what can be entered into a cell

limit what kinds of graphs a user can create

only accept data with a citation

Explanation:

Excel's data validation feature allows users to define specific rules that control the type of data entered into a cell, such as restricting input to a list, a date range, or a numerical value. This mechanism prevents errors by blocking invalid entries before they are saved, ensuring data consistency and integrity within the spreadsheet. By setting these constraints, you effectively dictate exactly what information is permissible in a designated area, streamlining data entry and reducing the need for manual cleanup later.

Question 46 Easy Mcq

✓ Correct ✗ Incorrect

This question is based upon the figure shown belowWhat is the significance of the red symbol at the top right corner of the cell, as shown in the picture?

It signifies that the cell contains a formula

It signifies that the cell contains a comment

It signifies that the cell contains a macro

All of the above

Explanation:

The red symbol in the top-right corner of a spreadsheet cell represents a comment or note attached to that specific location. When clicked, it expands to reveal hidden text intended for annotations or explanations without cluttering the main data view. This feature allows users to add context or reminders directly onto the worksheet while keeping the primary cell content clean. It is a standard visual indicator in applications like Microsoft Excel to distinguish cells containing supplementary information from those with only raw data. Recognizing this icon helps users quickly locate areas where additional details are stored for reference.

Question 47 Easy Mcq

✓ Correct ✗ Incorrect

Excel recognizes certain values, such as ____ and Quarter 1, as parts of larger lists. When you drag the fill handle from a cell containing one of these values, Excel fills the cells with the appropriate series?

January, Sunday

Jan, 1st

A, B

First, Second

Explanation:

Excel utilizes built-in lists of recognizable values like month names (e.g., January) and day names (e.g., Sunday) to automatically generate sequential series. When you drag the fill handle from a cell containing one of these specific values, the software identifies the pattern and continues the list with the next logical item, such as February or Monday. This feature allows users to quickly populate dates or time periods without manually typing each entry. The system maps these common English terms to their corresponding positions in the calendar or week cycle. Consequently, selecting standard full names ensures the fill handle functions as intended to create accurate, continuous data sets.

Question 48 Easy Mcq

✓ Correct ✗ Incorrect

June 6th, 2011 was a Monday. Based on the normally set week, date value 6/6/2011 is in cell A1. The formula in B1 =Weekday(A1) returns:

Monday

None of the above

Explanation:

The WEEKDAY function returns a numeric code representing the day of the week, where Monday is 1 and Sunday is 7. Since June 6th, 2011 was indeed a Monday, the function correctly outputs the number 2 because the default return type for this function is the numeric value rather than the text name. This numeric system allows for easy mathematical calculations involving days, such as determining the day of the week for future dates. Therefore, the result is 2, which corresponds to Monday in the standard Excel weekday numbering scheme.

Question 49 Easy Mcq

✓ Correct ✗ Incorrect

Function used to join several text strings to one is:

CONTATENATE

CONCATENATE

CONTACTENATE

CHAR

Explanation:

The correct function is CONCATENATE, which is the standard command used in many programming languages and spreadsheet applications to merge multiple text strings into a single continuous string. This operation works by taking two or more distinct text values and combining them sequentially without adding any extra characters between them by default. It is the fundamental tool for creating longer text fields from shorter components, making it essential for data formatting and string manipulation tasks. The spelling must be precise as "CONCATENATE" is the accepted technical term, distinguishing it from similar-sounding but incorrect variations. Understanding this function allows users to efficiently manage and combine textual data in various computational environments.

Question 50 Easy Mcq

✓ Correct ✗ Incorrect

The ____ of a cell determines how the labels and values look.

Value

Formula

Label

Format

Explanation:

The format setting controls the visual presentation of data within a cell, dictating how numbers appear as currency, dates, or percentages. It also manages the display style of text, such as font color, size, and alignment. By applying specific formatting rules, you ensure that the labels and values are presented consistently and professionally. This setting acts as a style layer that overlays the underlying data without changing its actual content. Consequently, adjusting the format is the direct method to change how information looks to the user.

Showing 50 of 1521 questions

Filter by Difficulty

easy medium hard

Track Progress

Difficulty Filter

easy Easy

medium Medium

hard Hard

Other Subjects

Business Finance & Management

Industrial Engineering & Manufacturing

IT & Programming

Design & Multimedia

Content Writing & Translation

Administrative Support

Quick Navigation

Other Business Finance & Management Subjects

Excel - Business Finance & Management

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Filter by Difficulty

Track Progress

Difficulty Filter

Other Subjects

Other Business Finance & Management Subjects

Quick Navigation

Similar Practices