Digital Accountant

What is the primary function of the GET Transform tool in Power Query Editor (part of Excel)

• To perform calculations on existing data columns
• b) To extract specific parts of text data from a source column

Which of the following is NOT a common use case for the GET Transform tool?

• Extracting first names from a full name column
• Isolating zip codes from an address column
• Performing addition on two numerical columns

Which sign do we use for cell referencing ?

• #
• %
• $
• ^

Which of the following is NOT required when using the XLOOKUP function in Excel?

• Lookup value (the value you're searching for)
• Lookup array (the range containing the data to search)
• Return array (the range containing the data to return)
• Exact match (optional, can be TRUE or FALSE)

Which of the following is NOT a way to access the Data Validation menu in Excel

• Select the cell(s) and go to the Data tab, then click Data Validation.
• Right-click the selected cell(s) and choose Data Validation from the context menu.
• Press the keyboard shortcut Ctrl+Shift+D.
• Click the format painter and apply formatting from a cell with existing data validation

When using the Sort button in Excel, what happens by default when you sort data by a text column (e.g., names)

• Numbers are sorted before text
• Text is sorted case-sensitively (A precedes a).
• Text is sorted case-insensitively (A and a are considered equal)
• Dates are sorted before text

What is the primary goal of an ideation session?

• Reviewing current processes
• Criticizing existing ideas
• Generating creative solutions
• Finalizing project plans

What is the purpose of voting and prioritization in an ideation session?

• Encourage competition among participants
• Determine the most feasible and impactful ideas
• Suppress creativity
• Ensure everyone's ideas are implemented

What is the purpose of a daily stand-up meeting in Agile?

• To assign tasks to team members
• To provide progress updates
• To review completed work
• To conduct detailed project planning

What is the primary focus of Lean Agile practices?

• Maximizing documentation
• Maximizing resource utilization
• Maximizing customer value
• Maximizing project scope