53:35
Accenture Common Applications & MS-Office Previous Year Quesitons | Accenture Technical Assessment 😮
Techie CodeBuddy
Overview
This video focuses on preparing for the Accenture technical assessment, specifically the common applications and MS Office section. It covers common previous year questions from MS Word, MS Excel, and MS PowerPoint, explaining the functionality and shortcuts for various features. The presenter walks through practical examples and provides insights into how these tools are used in a professional context, emphasizing the importance of understanding core functionalities for the exam.
How was this?
Save this permanently with flashcards, quizzes, and AI chat
Chapters
- The Accenture technical assessment includes a section on common applications and MS Office.
- This section typically contains 5-8 questions out of a total of 45.
- Preparation should focus on MS Word, MS Excel, and MS PowerPoint, as these are the most frequently tested applications.
- Solving previous year questions is the most effective way to identify key topics and focus areas.
Understanding the structure and focus of the technical assessment helps learners prioritize their study efforts and target the most relevant content for exam success.
The presenter mentions that the technical assessment has 45 questions, with 5-8 from the common applications and MS Office section.
- Notepad does not have a built-in spell-check feature, unlike MS Word, PowerPoint, and Excel.
- The shortcut Ctrl + M is used to indent a paragraph in MS Word, increasing the left margin.
- MS Paint includes rectangular and free-form selection tools, but not a circular selection tool.
- The Snipping Tool's functionality, such as automatic saving or capturing only active windows, can vary by version and is not always restricted to rectangular shapes.
Familiarity with basic functionalities and shortcuts in common applications like Word and Paint is crucial for efficient document creation and image editing, and these are often tested in assessments.
Demonstration of pressing Ctrl + M in MS Word to indent a selected paragraph, showing the increase in left-side spacing.
- Page orientation in MS Word can be set to either Portrait or Landscape via the Layout tab.
- Landscape orientation is a page layout setting, not a type of layout itself.
- The shortcut Ctrl + Shift + ^ (caret symbol) is used to format numbers in scientific notation in Excel.
- Other Excel formatting shortcuts include ` (tilde) for General format, # (hash) for Date format, and @ (at symbol) for Time format.
- Data validation in Excel, accessible through the Data tab, allows the creation of drop-down lists in cells.
Mastering Excel's formatting options and data validation techniques enables efficient data management and presentation, skills essential for data analysis roles.
Demonstration of using Data Validation in Excel to create a drop-down list for engineering branches (IT, CSE, ECE, ME).
- The F2 function key is used to rename a selected file or folder.
- In Gmail, the Drive icon is used to insert files from Google Drive into an email.
- Hashtags (#) are used on social media to draw attention, organize, and promote similar content.
- To remove a hyperlink from text in a Word document, right-click on the link and select 'Remove Hyperlink'.
Efficient file management, email composition, and understanding social media conventions are fundamental digital literacy skills applicable in various professional contexts.
Showing how to right-click a blue, underlined web address in a Word document and select 'Remove Hyperlink' to convert it back to plain text.
- Shift + Spacebar is the shortcut to select an entire row in MS Excel, while Ctrl + Spacebar selects an entire column.
- The VLOOKUP function searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
- The `TRUE` argument in VLOOKUP enables approximate matching, useful for ranges.
- The `LEFT` function in Excel extracts a specified number of characters from the beginning (left side) of a text string.
- The `LEN` function returns the number of characters in a text string, which can be used in calculations with other functions like `LEFT`.
Understanding advanced Excel functions like VLOOKUP, LEFT, and LEN is critical for data analysis, allowing for complex data manipulation and extraction.
Explaining the VLOOKUP formula `=VLOOKUP(60000, A2:D6, 2, TRUE)` and how it returns 'Indian Pacific' by finding an approximate match for 60,000 in the second column of the specified range.
- The `AND` logical function in Excel returns `TRUE` if all its arguments are true, and `FALSE` otherwise.
- Formulas like `=AND(D3>=75, D3<=200)` check if a value falls within a specific range.
- Excel formulas can be dragged down to apply to subsequent rows, with cell references adjusting automatically (relative referencing).
- Complex string manipulation can be achieved by combining functions like `LEFT`, `LEN`, `FIND`, and `TRIM` to extract specific parts of text based on delimiters like spaces.
Proficiency in logical and string manipulation functions allows for sophisticated data validation, conditional formatting, and text processing within spreadsheets.
Demonstrating how the formula `=AND(D3>=75, D3<=200)` applied to cell E3 and dragged down results in `TRUE` for cells where the value in column D is between 75 and 200 (inclusive).
- The default pointer type in MS PowerPoint is the arrow.
- A gear or cogwheel icon typically indicates computer settings.
- The VLOOKUP function's first argument is the value to search for, and it looks for this value in the leftmost column of the specified table array.
- The third argument in VLOOKUP specifies the column number from which to return the result.
- The fourth argument in VLOOKUP, `TRUE` or `FALSE`, determines if an exact or approximate match is required.
Understanding default settings and common icons, along with core functions like VLOOKUP, is essential for navigating software interfaces and performing data lookups efficiently.
Explaining the VLOOKUP function's arguments: lookup value, table array, column index number, and range lookup (TRUE/FALSE).
Key takeaways
- Prioritize studying MS Word, Excel, and PowerPoint for the Accenture technical assessment, as these are heavily featured.
- Solving previous year questions is the most effective strategy for identifying key topics and understanding the exam's focus.
- Mastering keyboard shortcuts (e.g., Ctrl+M for indent, F2 for rename, Shift+Space for row select) significantly improves efficiency in common applications.
- Understanding Excel formulas like VLOOKUP, LEFT, LEN, AND, and their practical applications is crucial for data analysis tasks.
- Familiarity with basic application features (spell check, page orientation, selection tools) and common icons (settings gear) is fundamental.
- The 'true' argument in VLOOKUP allows for approximate matching, which is useful when exact matches are not required or possible.
- Effective data validation and string manipulation in Excel enable robust data handling and reporting.
Key terms
Technical AssessmentCommon ApplicationsMS WordMS ExcelMS PowerPointSpell CheckIndentPage OrientationLandscapePortraitScientific NotationData ValidationDrop-down ListRename FileVLOOKUPLEFT functionLEN functionAND functionRelative ReferencingHyperlink
Test your understanding
- What is the primary purpose of the VLOOKUP function in MS Excel, and what does the 'TRUE' argument signify?
- How can you indent a paragraph in MS Word, and what is the shortcut key for this action?
- Explain the difference between Portrait and Landscape page orientations and where you would find these settings in MS Word.
- What are the key differences in spell-checking capabilities between Notepad and MS Word?
- Describe how to create a drop-down list in an MS Excel cell and what function or feature is used for this purpose.