A Journal Entry is the specific standard form designed to document actions tied to particular contacts within a system. When recorded, these entries automatically populate the Timeline view, providing a chronological history of interactions. This feature allows users to track communication patterns and maintain a detailed audit trail for each relationship. Unlike other forms that might focus on scheduling or general tasks, this tool prioritizes the logging of specific contact-related events. It ensures that every significant action is captured in a centralized, time-based sequence for easy review. Consequently, it serves as the primary mechanism for building a comprehensive contact history.

Question 2 Easy Mcq

✓ Correct ✗ Incorrect

Documentation of all __________ should be placed in the compliance manual.

Hiring

Training

Firing

Auditing

Explanation:

Training documentation is essential because it proves that employees have received the necessary instruction to comply with laws and internal policies. Recording these sessions creates a verifiable history of knowledge transfer, which is critical during regulatory inspections or investigations. Without this specific record, an organization cannot demonstrate that staff were properly equipped to follow compliance protocols. Therefore, maintaining comprehensive training logs is a fundamental requirement for a robust compliance manual. This ensures accountability and provides a clear defense against allegations of negligence or non-compliance.

Question 3 Medium Mcq

✓ Correct ✗ Incorrect

Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

If a calculated item is contained by a field, then the subtotal summary function cannot be changed.

Sum, count and average functions can be used as a subtotal.

Var and Varp functions cannot be used as a subtotal.

None of the above.

Explanation:

In a PivotTable, the Subtotal field automatically applies a summary function like Sum, Count, or Average to grouped data. However, when a specific field is set to display as a Calculated Item, the system locks the subtotal function for that specific item to ensure the calculation remains consistent with the custom formula. This restriction prevents the standard automatic summary from overriding the user-defined logic, making it impossible to change the subtotal method for that particular calculated item.

Question 4 Easy Mcq

✓ Correct ✗ Incorrect

Suppose that you have downloaded a new font from the web for your Microsoft Word 2016 document. If you want to open this document on another computer that doesn

General

Proofing

Save

Advanced

Explanation:

To ensure a document with a custom font opens correctly on another computer, you must save the file as a PDF or use the "Save As" feature to embed the font data. This action preserves the original formatting and prevents the text from reverting to a default system font. Without saving the document in a way that retains these specific styles, the recipient's computer will likely display the text with a different font, altering your intended design. Therefore, selecting the save option is the critical step to maintain document integrity across different machines.

Question 5 Medium Mcq

✓ Correct ✗ Incorrect

While working in Microsoft Excel 2016. for which of the following options. if included in a worksheet. we cannot use the Track Changes option?

Comment

Table

Chart

Picture

Explanation:

In Excel 2016, the Track Changes feature is designed to record edits made directly to cell data and formulas within the worksheet grid. While comments, tables, and pictures can exist on a sheet, the specific tracking mechanism does not capture modifications to the structural elements of a table object itself, such as adding or deleting rows and columns within that table range. This limitation exists because table structures are managed through a distinct interface that separates from the standard cell-by-cell editing history, making the table option the one excluded from standard change tracking.

Question 6 Medium Mcq

✓ Correct ✗ Incorrect

What will happen if the Junk E-mail filter of Microsoft Outlook 2010 does NOT consider a message to be spam but considers it to be phishing?

It will shift the message to the Spam folder.

It will disable all the links in the e-mail.

It will disable the Reply and Reply All commands.

It will delete the e-mail.

Explanation:

When Outlook 2010 identifies a message as phishing, its primary security mechanism is to neutralize potential threats by automatically disabling all hyperlinks within the email. This prevents users from accidentally clicking on malicious URLs that could lead to credential theft or malware downloads, even if the message is not classified as spam. By restricting link functionality, the software effectively blocks the main vector of phishing attacks without deleting the message or altering its folder location. This behavior ensures that users can still review the email content safely while being protected from executing harmful actions embedded in the message.

Question 7 Easy Mcq

✓ Correct ✗ Incorrect

Format Painter will not normally work with pictures in which the text wrapping is set to:

Square

Behind Text

In Front of Text

In Line with Text

Explanation:

The Format Painter tool copies formatting attributes like font style, size, and color, but it does not replicate the underlying layout properties of an object. When text wrapping is set to "In Line with Text," the picture is treated as a character within the text flow rather than an independent floating object. Because this wrapping style fundamentally changes how the image interacts with the document's text stream, the formatting applied to the source picture cannot be successfully transferred to a target picture using this specific wrapping method.

Question 8 Easy Mcq

✓ Correct ✗ Incorrect

This question is based upon the figure shown belowIn the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?

By using the 'Orientation' button in the alignment group of the 'Home' tab.

By using the 'Format Cells' in the context menu.

By using the 'Orientation' button on the 'Page Layout' tab.

By using the 'WordArt' button on the 'Insert' tab.

Explanation:

To change the text direction within a cell, users access the 'Orientation' button located in the Alignment group on the 'Home' tab. Clicking this icon opens a gallery of preset angles, allowing immediate rotation of the text without altering the cell's width or height. This feature is specifically designed for formatting text appearance directly within the worksheet grid. It provides a quick and intuitive way to fit long labels or organize data visually. Consequently, selecting the appropriate angle from this menu is the standard method for this task.

Question 9 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?

Manage Data Model

Filter

Advanced

Data Validation

Explanation:

Data Validation is the specific feature designed to control what users can enter into a cell by setting rules for data types, such as numbers, dates, or text lengths. By defining these constraints, Excel automatically prevents invalid entries from being saved, ensuring data consistency and accuracy across the workbook. This tool is essential for creating dropdown lists and enforcing strict input formats without requiring manual checks. It operates independently of other data management tools, focusing solely on restricting input at the source. Consequently, it is the only option that directly addresses the requirement to limit cell entries to a certain data type.

Question 10 Easy Mcq

✓ Correct ✗ Incorrect

How can we define a name to a cell in a Microsoft Excel 2016 Worksheet?

Right-click on the cell and click on "Define Name".

Click on the "Formulas" tab and click on "Define Name" under the "Define Names" group.

Click on the "Home" tab and click on "Format" under the "Cells" group.

Click on the "Home" tab and click on "Define Name" under the "Define Names" group.

Explanation:

To assign a name to a specific cell in Excel 2016, you simply right-click directly on that cell to open its context menu. Within this menu, selecting the "Define Name" option immediately opens the New Name dialog box. This direct method allows you to type a custom identifier that makes your spreadsheet formulas and references much easier to read and manage. By choosing this specific action, you bypass the need to navigate through complex ribbon tabs, ensuring a quick and efficient workflow for organizing your data.

Question 11 Easy Mcq

✓ Correct ✗ Incorrect

Changes that affect the entire presentation are indicated in the ____ section of the revision pane.

Global Changes

Recent Changes

Accepted Changes

Presentation Changes

Explanation:

The revision pane in presentation software categorizes edits into specific areas, where the Global Changes section is dedicated to modifications that impact the entire document or all slides simultaneously. This area allows users to efficiently manage widespread updates like changing fonts or themes across the whole presentation. By isolating these broad edits, the software ensures that global adjustments are applied uniformly without needing to edit each slide individually. Consequently, any change intended to affect the entire presentation is logically and functionally located within this designated global section.

Question 12 Easy Mcq

✓ Correct ✗ Incorrect

Consider the given image for the following question.There are red triangles in the upper-right corner of each cell under the column titled ‘"Class'" What do they signify?

They represent that the cells are containing formatted data.

They represent that some data validation is associated with the cells.

They represent that the comments are associated with the cells

They represent that the cells cannot be edited.

Explanation:

The small red triangle in the corner of a spreadsheet cell is the standard visual indicator for a comment or note attached to that specific cell. When a user hovers over or clicks this icon, a pop-up window appears displaying the text or feedback entered by the creator. This feature allows for adding context or reminders without cluttering the main data view, making it the definitive sign of associated comments rather than data formatting, validation rules, or protection settings.

Question 13 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, which of the following is the correct syntax of the VLOOKUP command?

#NAME?

#VALUE!

#NAME?

Explanation:

The VLOOKUP function searches for a specific value in the first column of a table and returns data from a specified column index within that same range. The syntax requires the lookup value first, followed by the entire table array, the column number to retrieve, and an optional flag for exact or approximate matches. This structure ensures Excel knows exactly where to look and what to return, making the first option the only valid format for this powerful tool.

Question 14 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?

It will select cell A1.

It will select the complete Worksheet.

It will select all the Worksheets available in a Workbook.

It will add a Worksheet to the file.

Explanation:

The marked triangle represents the "Select All" button located at the intersection of the row and column headers in Excel. Clicking this specific control instantly highlights every single cell within the current worksheet, effectively selecting the entire sheet at once. This feature is designed to provide a quick method for performing global operations, such as formatting or deleting, across the whole data range without manually dragging the selection handle. It is a standard interface element that allows users to manipulate the entire worksheet content efficiently.

Question 15 Easy Mcq

✓ Correct ✗ Incorrect

The default chart colors are determined by what?

Slide Design Effects

Slide Background Graphics

Slide Fill Shading

Slide Color Scheme

Explanation:

The default chart colors are determined by the Slide Color Scheme, which provides a consistent set of hues for text, backgrounds, and graphical elements throughout the presentation. When a chart is inserted, it automatically inherits these predefined colors to maintain visual harmony with the slide's overall design. This mechanism ensures that all visual components align seamlessly without requiring manual adjustment for every new element added. By relying on the active color scheme, the software guarantees a professional and unified appearance across all slides. Users can easily modify this scheme to instantly update the color palette of existing charts and other objects.

Question 16 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Word 2016. which of the following types of circle represents the top of the hierarchy in a Sunburst chart?

Outermost circle

innermost circle

Both a and b

Neither a nor b)

Explanation:

In a Sunburst chart within Microsoft Word 2016, the hierarchy is visually structured with the innermost circle representing the highest level or root of the data. Each subsequent ring moving outward represents a deeper level of detail, making the center the definitive starting point for the entire diagram. This design ensures that the top of the hierarchy is immediately identifiable as the core element from which all other segments radiate. Consequently, the innermost circle is the only correct representation for the top of the hierarchy in this specific chart type.

Question 17 Easy Mcq

✓ Correct ✗ Incorrect

Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?

/noextensions

/nocustomize

/nopreview

/profiles

Explanation:

The /nopreview switch is specifically designed to launch Microsoft Outlook without displaying the Reading Pane, which is useful for users who prefer to read emails directly in the message list. When this command-line argument is applied, Outlook suppresses the pane that typically shows email previews on the right or left side of the window. This allows for a cleaner interface and can improve performance by reducing the initial rendering load. It is a standard configuration option for customizing the startup behavior of the application to suit specific workflow needs.

Question 18 Easy Mcq

✓ Correct ✗ Incorrect

In order to show a timeline; a progression; sequential steps In a process. task or workflow; or to emphasize movement or direction, which of the following Process type SmatArt graphics will be the most suitable option?

Arrow Ribbon

Basic Chevron Process

Continuous Picture List

Ascending Picture Accent Process

Explanation:

The Basic Chevron Process graphic is specifically designed to visually represent a clear sequence of steps or a chronological timeline. Its distinctive zigzag or chevron shape naturally guides the viewer's eye from left to right, effectively emphasizing the direction of movement and the logical progression of a workflow. This structural design makes it the ideal choice for illustrating how different stages connect in order. By using this format, complex processes become easy to follow and understand at a glance. It ensures that the sequential nature of the information is immediately apparent to the audience.

Question 19 Easy Mcq

✓ Correct ✗ Incorrect

By default, how many worksheets are there in a new Microsoft Excel 2016 workbook?

One

Two

Three

Five

Explanation:

When you create a new workbook in Microsoft Excel 2016, the application automatically generates a single default worksheet named "Sheet1" to provide an immediate starting point for data entry. This default setting ensures users have a clean, empty grid ready for use without needing to add additional sheets manually. While users can easily add more worksheets later, the initial state of any fresh workbook is consistently configured with exactly one sheet. This streamlined approach simplifies the onboarding process for new files and maintains a standard baseline across different versions of the software.

Question 20 Easy Mcq

✓ Correct ✗ Incorrect

The default appointment status setting is ____.

Free

Tentative

Out of Office

Busy

Explanation:

The default appointment status is set to Busy because it accurately reflects that a specific time slot is already occupied by a scheduled event. This setting prevents double-booking by signaling to others that the resource is unavailable for new requests. It serves as the standard baseline for calendar management, ensuring that only explicitly free or tentative slots can be successfully booked. This automatic behavior maintains organizational efficiency and respects the time commitments already established within the schedule.

Question 21 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is true regarding Microsoft Excel 2010 Web App?

It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.

It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.

Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.

A shared workbook can be loaded in the browser.

Explanation:

In Excel 2010 Web App, publishing a workbook to a SharePoint library enables the use of advanced visualization tools like sparklines and slicers directly within the browser interface. This feature allows users to create compact data trends and filter data views without needing the full desktop application. The web environment supports these interactive elements to enhance data analysis capabilities for shared documents. Consequently, these specific visual aids function correctly once the workbook is published and accessed via the web access page. This capability distinguishes the web app's analytical features from basic viewing modes.

Question 22 Easy Mcq

✓ Correct ✗ Incorrect

Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor on your Safe Recipients List?

No Automatic Filtering

Low

High

Safe Lists Only

Explanation:

The "Safe Lists Only" protection level is specifically designed to block any email that does not originate from a sender or recipient explicitly listed in your Safe Senders or Safe Recipients lists. This setting provides the highest degree of caution by treating all unsolicited messages as potential junk, ensuring that only trusted contacts can bypass the filter. Consequently, applying this level guarantees that emails from unknown sources are automatically moved to the Junk Email folder, strictly adhering to your defined safe lists.

Question 23 Medium Mcq

✓ Correct ✗ Incorrect

Which of the following statements regarding images in Microsoft Excel 2010 are true?

Microsoft Excel 2010 validates images which are in the form of external and active content.

Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.

Microsoft Excel 2010 supports 3D rotation of images.

Explanation:

Microsoft Excel 2010 includes a built-in security feature that automatically validates all external and active content, such as images, to prevent malicious code execution. This validation process ensures that any embedded macros or scripts within the image are scanned and neutralized before the file is opened. Consequently, users can safely view and interact with these images without risking their system's integrity, making the statement about validation accuracy. This security layer is a critical component of the application's overall protection strategy against potential threats.

Question 24 Easy Mcq

✓ Correct ✗ Incorrect

Charts can either be embedded in a worksheet or placed in a separate ____.

Worksheet

Dialog box

Chart sheet

Range

Explanation:

In spreadsheet applications, a chart can be displayed either within the same grid as data or on its own dedicated page known as a chart sheet. This separate area allows the entire visual representation to occupy the full screen without any data cells, making it ideal for presentations or detailed analysis. By placing the chart here, users ensure the graphic remains the sole focus, enhancing readability and professional presentation quality. This distinct layout option provides flexibility in how data visualizations are organized and shared within a workbook.

Question 25 Easy Mcq

✓ Correct ✗ Incorrect

By default. how many worksheets are there in a new Microsoft Excel 2016 workbook?

One

Two

Three

Five

Explanation:

When you create a new workbook in Microsoft Excel 2016, the application automatically generates a single default worksheet named "Sheet1" to provide an immediate starting point for data entry. This default setting ensures that users have a clean, ready-to-use environment without needing to manually add additional sheets immediately. While users can easily add more worksheets later as their project grows, the foundational structure of every new file begins with just this one sheet. This streamlined approach simplifies the initial setup process for both beginners and advanced users alike.

Question 26 Easy Mcq

✓ Correct ✗ Incorrect

In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?

The red triangles represent the comment associated.

The red triangles signify an associated data validation control.

The red triangles represent the tracking of the cell.

The red triangles signify that the cell is a hidden cell.

Explanation:

In spreadsheet applications like Excel, a small red triangle in the corner of a cell indicates that a comment or note has been attached to that specific cell. This visual marker serves as a quick indicator that additional context or information is available upon clicking the cell, allowing users to review notes without cluttering the main data view. The triangle acts as a standard icon for the "Comment" feature, distinguishing it from other cell properties like validation rules or hidden status. Therefore, identifying this symbol correctly helps users efficiently locate and manage their annotations within a large dataset. Recognizing this icon is a fundamental skill for navigating and maintaining organized spreadsheets effectively.

Question 27 Easy Mcq

✓ Correct ✗ Incorrect

You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

Fill color, More Fill Colors

Background Color

Texture

Pattern

Explanation:

The "More Fill Colors" option opens an advanced dialog where you can precisely adjust the transparency slider for a shape's fill. This feature allows you to control how much of the background shows through the shape by setting a percentage value. By selecting this specific tool, you gain direct command over the opacity level, enabling effects like fading or blending seamlessly with underlying elements. This level of control is essential for creating professional designs that require visual depth or layering. Therefore, this is the primary method within the Shape Styles group for managing transparency settings.

Question 28 Easy Mcq

✓ Correct ✗ Incorrect

Consider the given image and answer the following question.Suppose that you have entered some text in a Microsoft Word 2016 document as shown in figure 1 of the given image. Which of the following actions will you perform to achieve the text formatting (underline every word) as shown in figure 2 of the given image?

Select all the text and press Ctrl + U keys.

Select all the text and press Shift + U keys.

Select all the text and press Ctrl + Shift + W keys.

Select all the text and press Ctrl + Shift + T keys.

Explanation:

To apply underlining to text in Microsoft Word, you must first select the specific content you wish to format. Once selected, pressing the Ctrl and U keys simultaneously activates the built-in shortcut command for underlining. This action instantly applies the underline style to the entire selection, transforming the plain text into the formatted version shown in the target image. The combination of these two keys is the standard, efficient method for this specific formatting task within the application.

Question 29 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, the =TODAY()command returns:

the current day name

the date when the Excel file was created.

the current day and date.

the current date.

Explanation:

The =TODAY() function is a built-in Excel formula designed specifically to dynamically retrieve the current system date. When entered into a cell, it immediately displays today's date in the standard serial number format used by Excel. This value automatically updates every time the workbook is opened or recalculated, ensuring the displayed date always reflects the actual current day without manual intervention. It does not return the day name or the file creation date, but strictly the numeric date corresponding to the current moment.

Question 30 Easy Mcq

✓ Correct ✗ Incorrect

While changing the resolution of a picture in Microsoft PowerPoint 2016. which of the following is NOT included in the Adjust group under the Format tab?

Color

Corrections

Shapes

Artistic Effects

Explanation:

The Adjust group on the Format tab specifically houses tools for modifying image properties like brightness, contrast, and artistic effects. Shapes are a distinct category of objects used to create geometric figures, not image adjustments, which is why they do not belong in this group. This separation ensures that users can easily distinguish between editing existing pictures and manipulating drawing elements within their presentation.

Question 31 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft PowerPoint 2016, whicxh of the following keyboard shortcuts is used to add a new slide to a presentation?

Ctrl + N

Ctrl + S

Ctrl + F

Ctrl + M

Explanation:

The Ctrl + M shortcut is the dedicated command in Microsoft PowerPoint 2016 specifically designed to insert a fresh slide at the current position within your presentation. When you press this key combination, the software immediately creates a new blank slide and places it right after the one you are currently viewing, allowing you to quickly expand your content without navigating through menus. This direct access accelerates the workflow by letting you focus on adding content rather than searching for the slide insertion tool. It is a fundamental efficiency feature that supports rapid prototyping and building out presentation structures. Using this shortcut ensures a smooth transition between ideas as you develop your slides in sequence.

Question 32 Easy Mcq

✓ Correct ✗ Incorrect

Which among the following chart types do not have axes?

Bar charts

XY (Scatter) charts

Doughnut charts

Area charts

Explanation:

Doughnut charts are a specific variation of the pie chart designed to display proportional data as segments of a circle. Unlike bar, scatter, or area charts which rely on Cartesian coordinates to map values against horizontal and vertical axes, doughnut charts encode data directly within the angular width of their slices. This circular layout eliminates the need for traditional X and Y axes, making the visual representation purely radial and focused on the relationship between each segment and the whole.

Question 33 Easy Mcq

✓ Correct ✗ Incorrect

Question: Suppose that you have inserted a few images into a Microsoft Word 2016 document. From which of the following views under the View tab will you be NOT able to edit those images?

Print Layout

Web Layout

Outline

Draft

Explanation:

The Draft view is designed to maximize printing speed by hiding non-essential visual elements like images, headers, and footers. Because the software suppresses these graphical components to focus solely on text structure and page breaks, any inserted images are completely invisible and therefore cannot be selected or edited within this specific view. In contrast, other views like Print Layout or Web Layout render images fully, allowing for direct manipulation. Consequently, Draft view is the only option listed where editing images is functionally impossible due to their deliberate omission from the display.

Question 34 Easy Mcq

✓ Correct ✗ Incorrect

If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cells .

True

False

Explanation:

When a table cell is vertically split using the Draw Table option, the software automatically distributes the existing content between the two new cells. This ensures that no text is lost during the split operation, as the original text is intelligently divided and placed into the appropriate sections. Consequently, the statement that text will appear in both newly created cells is accurate, making the scenario described true. This behavior maintains data integrity while allowing users to adjust table dimensions dynamically.

Question 35 Medium Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, which of the following keyboard shortcuts is used for the "Clear filter" command for Slicer in a Pivot table?

Alt + C

Ctrl + C

Windows + C

Shift + C

Explanation:

In Excel 2016, pressing Alt + C while a PivotTable is selected activates the context-sensitive ribbon shortcut menu. When a Slicer is active, this specific combination directly triggers the "Clear Filter From" command, instantly removing the applied filter without needing to navigate through menus. This shortcut is designed for rapid data manipulation, allowing users to reset slicer states efficiently. It leverages the built-in accessibility keys that map frequently used commands to keyboard inputs for enhanced workflow speed. Mastering this key helps streamline the process of comparing different data subsets by quickly toggling slicer visibility.

Question 36 Easy Mcq

✓ Correct ✗ Incorrect

How would you add a logo to all the slides in a presentation?

In the Normal editing View, paste the logo onto every slide in the presentation.

In the Slide Master View, add the logo to the slide master and the title slide layout.

In the Slide Master View, add the logo to the blank slide layout.

None of the above

Explanation:

To apply a logo consistently across every slide, you must edit the Slide Master, which acts as the underlying template for the entire presentation. By inserting the logo directly onto the master slide, it automatically appears on all standard layouts that inherit from it. Additionally, adding it to the specific title slide layout ensures the branding is visible even on that unique slide type. This centralized approach guarantees uniformity and saves significant time compared to manually placing the image on each individual slide.

Question 37 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following options can be copied using the format painter in Microsoft Excel 2016?

Alignment

Background color

Cell text

None of the above

Explanation:

The Format Painter tool in Excel is designed to replicate specific visual formatting attributes from a source cell to a target cell. It successfully copies properties such as font styles, cell borders, number formats, and background colors. However, it is intentionally restricted from copying the actual text content or data values within a cell. Therefore, background color is a valid attribute that can be transferred, while alignment and cell text fall outside its functional scope.

Question 38 Easy Mcq

✓ Correct ✗ Incorrect

Suppose there are some files in a folder named 'demo', which were archived to a file named demo.pst. Now you want to restore this archive to a folder named 'demo1'. Which option in the File tab will you use for this purpose, in Microsoft Outlook 2010?

Info

Open

Options

None of these

Explanation:

In Microsoft Outlook 2010, the "Open" command within the File tab is specifically designed to locate and extract archived data files like .pst archives. When you select this option, you can browse to the demo.pst file and choose the destination folder, demo1, to restore all contained items. This function directly handles the extraction process, making it the correct tool for restoring archived emails and contacts to a new location.

Question 39 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, how can we publish a Workbook to Power BI?

File > Options > Publish to Power BI

File > Save As > Change "File as type" > Publish to BI

File > Share > Publish to BI > Save to Cloud

File > Publish > Publish to Power BI

Explanation:

In Microsoft Excel 2016, the direct method to connect a workbook to Power BI is found within the File menu under the Publish option. Selecting this command opens a dedicated dialog box that allows you to choose the specific Power BI dataset and enter your authentication credentials. This streamlined workflow ensures that the Excel data is securely transmitted and formatted correctly for immediate visualization in the Power BI service without requiring manual data export or complex configuration steps.

Question 40 Easy Mcq

✓ Correct ✗ Incorrect

While working in a Microsoft Word 2016 document, which of the following tabs on the ribbon is used to display the Navigationpane?

Home

Insert

Review

View

Explanation:

The Navigation Pane is a powerful tool that helps users quickly locate specific content within a document by displaying headings, pages, or search results. This feature is exclusively accessed through the View tab on the ribbon interface in Microsoft Word 2016. By selecting the "Navigation Pane" check box in the Show group under this tab, the interface expands to reveal a dedicated panel on the left side of the screen. Consequently, this specific tab is the designated location for managing document structure visualization and navigation aids.

Question 41 Easy Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016. which of the following options used for displaying or hiding formulas changers) the state of a cell?i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them.ii) Switch between displaying formulas and formula results on a worksheet.iii) Show hidden formulas by removing the protection from cells.

Only option i).

Only options ii) and iii].

Only options i) and iii).

All options i) .ii) and iii).

Explanation:

In Excel 2016, the "Show Formulas" button toggles the display between calculated results and the underlying formula text, directly addressing option ii). Additionally, protecting a worksheet with a password prevents formulas from appearing in the formula bar, which validates option i). While removing protection reveals hidden formulas, the primary mechanism for changing the display state involves both the toggle button and protection settings, making the combination of these two methods the correct approach.

Question 42 Easy Mcq

✓ Correct ✗ Incorrect

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

Digital signatures help authenticate the source of the messages.

Both the sender and the receiver of a message can verify that the message has not been altered during transmission, if the message is digitally signed.

Digitally signed e-mails meet legal requirements for admissibility and authenticity.

All of the above.

Explanation:

Digitally signing an email in Microsoft Excel 2010 utilizes cryptographic technology to verify the sender's identity, ensuring the message truly originates from the claimed source. This process also creates a secure hash that detects any unauthorized alterations to the data during transmission, guaranteeing integrity. Furthermore, these digital signatures often satisfy specific legal standards for document admissibility and authenticity in various jurisdictions. Consequently, the feature provides a comprehensive security solution that covers authentication, integrity, and legal compliance simultaneously.

Question 43 Medium Mcq

✓ Correct ✗ Incorrect

In Microsoft Excel 2016, when do we receive a "#Value!" error in the VLOOKUP function?i) When the "lookup_value" argument is more than 255 characters.ii) When the "col_index_num" argument contains text.iii) When the "col_index_num" argument is equal to 0.

Only option i) is correct.

Only options i) and ii) are correct.

Only options ii) and iii) are correct.

All options i), ii) and iii) are correct.

Explanation:

The VLOOKUP function returns a #VALUE! error when the column index number is invalid, such as when it is zero or contains text, because the function requires a positive integer to identify the target column. Additionally, the lookup value argument cannot exceed 255 characters in Excel 2016, as this limit is enforced to prevent memory overflow during the search process. Both of these specific input violations trigger the #VALUE! error code, making the first two conditions the valid reasons for this error to occur.

Question 44 Easy Mcq

✓ Correct ✗ Incorrect

How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?

By using the last backup .pst file.

By scanning the .pst file with scanpst

By re-logging into the mail account.

The file cannot be repaired.

Explanation:

The ScanPST utility, also known as the Outlook Data File Checker, is the official Microsoft tool designed specifically to detect and repair corruption in .pst files. It works by scanning the file structure for errors such as damaged headers or incomplete data blocks and then automatically fixing them to restore file integrity. This built-in repair mechanism allows users to recover lost emails and attachments without needing to rely on external backups or third-party software. Running this tool is the standard, safe procedure for resolving issues caused by unexpected shutdowns or disk failures.

Question 45 Medium Mcq

✓ Correct ✗ Incorrect

Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?

Share 'report.xlsx' by saving it to SkyDrive.

Share 'report.xlsx' by saving it to a SharePoint site.

Share 'report.xlsx' by sending it through email.

Explanation:

Saving the report to a SharePoint site enables robust co-authoring, allowing multiple team members to edit the file simultaneously in a web browser. SharePoint automatically maintains a comprehensive version history for every document, ensuring that previous iterations are preserved and can be restored if data is accidentally lost. This centralized cloud storage provides the necessary security, collaboration features, and backup mechanisms that simple file sharing or email attachments cannot offer for a dynamic team environment.

Question 46 Easy Mcq

✓ Correct ✗ Incorrect

Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?

Explanation:

The COUNTA function counts all non-empty cells within the specified range A1:B8, regardless of whether they contain numbers, text, or formulas. Since the provided Excel sheet contains data in every single cell of this 2-row by 4-column block, the function tallies all 12 entries. Consequently, typing =COUNTA(A1:B8) in cell B9 returns the total count of 12, which corresponds to the correct option.

Question 47 Easy Mcq

✓ Correct ✗ Incorrect

You customized the navigation pane with a lot of folders and shortcuts but now you want to remove all of them. What command line switch would you use with outlook.exe to remove the folders you added?

/profiles

/resetfolders

/resetnavpane

/recycle

Explanation:

The /resetnavpane switch is specifically designed to restore the Outlook navigation pane to its default state by removing any custom folders or shortcuts you have added. When executed, this command clears your personalized layout and reloads the standard folder structure directly from the default profile settings. It provides a quick and effective way to undo navigation customizations without needing to manually delete each item individually. This utility ensures that your view returns to the original factory configuration instantly.

Question 48 Easy Mcq

✓ Correct ✗ Incorrect

Microsoft office online is an example of a(n) ________ productivity packages.

Webbased

Wizard

False

Spreadsheet

Explanation:

Microsoft Office Online operates entirely within a web browser, requiring no local installation and functioning through cloud-based servers. This architecture defines it as a web-based solution that allows users to access documents and collaborate in real-time from any device with an internet connection. Unlike traditional desktop software, it relies on internet connectivity to load applications and store files, making the web platform its core operational environment. Therefore, it serves as the primary example of productivity packages delivered via the internet rather than standalone programs.

Question 49 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following types of worksheets will not load in Microsoft Excel Services?

Worksheets with ActiveX controls

Worksheets with tables

Worksheets with hyperlinks

All of the above

Explanation:

Microsoft Excel Services, now part of the SharePoint ecosystem, operates within a secure sandbox environment that strictly prohibits the execution of ActiveX controls to prevent security vulnerabilities. Because these controls require direct system access and can execute arbitrary code, they are inherently incompatible with the web-based rendering engine used by Excel Services. Consequently, any worksheet containing ActiveX elements will fail to load or function correctly when accessed through the service, making this the specific limitation among the listed options.

Question 50 Easy Mcq

✓ Correct ✗ Incorrect

With reference to Microsoft Word 2016. which of the following types of chart is shown in the given image?

Surface char

Histogram chart

Area chart

None of the above

Explanation:

An area chart is a specific type of line chart where the area between the data line and the horizontal axis is filled with color, emphasizing the magnitude of change over time. In Microsoft Word 2016, selecting this chart type allows users to visualize cumulative totals or proportional contributions of different categories within a dataset. The visual representation clearly shows the shaded regions under the data lines, which is the defining characteristic that distinguishes it from other chart types like histograms or surface charts. This format is particularly useful for highlighting trends and the total volume of data across a continuous range.

Showing 50 of 129 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 Administrative Support Subjects

Microsoft Office - Administrative Support

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 Administrative Support Subjects

Quick Navigation

Similar Practices