Download 100 Exam - Information Technology and more Exams Internet and Information Access in PDF only on Docsity!
- What is the main purpose of data analysis in business? A. To store files only B. To interpret data and support decision-making C. To create logos D. To encrypt data Answer: B
- Which Excel feature lets you quickly summarize large datasets by categories? A. Slicers B. Pivot Tables C. Conditional Formatting D. Macros Answer: B
- Which Excel function removes extra spaces from text? A. TRIM B. PROPER C. LEFT D. TEXT Answer: A
- Which function converts text to proper case (capitalizes first letter of each word)? A. LOWER B. UPPER C. PROPER D. TRIM
Answer: C
- Which chart type is best for showing trends over time? A. Pie Chart B. Bar Chart C. Line Chart D. Doughnut Chart Answer: C
- What does the TEXT function do in Excel? A. Extracts characters B. Formats numbers/dates as text C. Removes spaces D. Counts cells Answer: B
- Which tool in Excel helps test different input values to see possible outcomes? A. Goal Seek B. What-If Analysis C. Data Validation D. Power Query Answer: B
- Which Excel feature automatically highlights cells based on rules (e.g., color scales)? A. Conditional Formatting B. Data Validation
A. A single worksheet B. An entire Excel file containing sheets C. A chart object D. A named range Answer: B
- Which of these is NOT a component of a Pivot Table? A. Rows B. Columns C. Values D. Macros Answer: D
- Which function extracts a given number of characters from the left of a string? A. RIGHT B. MID C. LEFT D. TRIM Answer: C
- Which function extracts characters from the middle of a text string? A. LEFT B. RIGHT C. MID D. TEXT Answer: C
- What is the purpose of removing duplicates in data cleaning? A. To add more rows B. To ensure unique records and prevent double-counting C. To format text D. To change headers Answer: B
- Which Power Query step splits a column into multiple columns using a delimiter? A. Use First Row as Headers B. Split Column by Delimiter C. Remove Top Rows D. Fill Down Answer: B
- Which Excel feature allows interactive filtering of Pivot Tables using buttons? A. Slicers B. Data Bars C. Sparklines D. Goal Seek Answer: A
- What does the TRIM(PROPER(cell)) formula accomplish? A. Removes spaces and capitalizes words B. Converts numbers to text C. Extracts numbers
B. Provide an interactive summary of KPIs in one view C. Encrypt data D. Replace Pivot Tables Answer: B
- Which function would you use to format a number as currency text in Excel? A. TEXT B. TRIM C. LEFT D. MID Answer: A
- Which of these helps automatically fill values based on patterns in Excel? A. Flash Fill B. Goal Seek C. Solver D. Power Pivot Answer: A
- What does 'Fill Down' do in Power Query? A. Copies a value downward to fill nulls in consecutive rows B. Removes duplicate rows C. Deletes top rows D. Splits columns Answer: A
- Which Excel feature allows you to compare scenarios like best-case and worst-case? A. Scenario Manager B. Pivot Table C. Text to Columns D. Sparklines Answer: A
- Which step would you use to parse a text file with '|' separators? A. Remove Duplicates B. Split Column by Delimiter C. Trim D. Use First Row as Headers Answer: B
- Which Power Query function checks if a text starts with a specific string? A. Text.AfterDelimiter B. Text.StartsWith C. Text.Length D. Text.Contains Answer: B
- Why is data cleaning important before analysis? A. To make files larger B. To ensure accuracy, consistency, and reliability of results C. To hide errors D. To increase duplicates
B. Keeps only metadata C. Removes company name/title rows to get to tabular data D. Converts text to numbers Answer: C
- Which Excel feature should you use to ensure a cell accepts only specific input (e.g., whole numbers)? A. Data Validation B. Conditional Formatting C. Goal Seek D. Flash Fill Answer: A
- Which Excel function returns the number of characters in a text string? A. LEN B. TEXT C. VALUE D. TRIM Answer: A
- What is a recommended first step when creating a Pivot Table from a dataset? A. Insert a chart first B. Ensure the data is in table/tabular format with headers C. Run Goal Seek D. Remove all formulas Answer: B
- Which Excel tool is important for automating repetitive data-cleaning steps? A. Power Query B. Charts C. Pivot Charts D. Data Bars Answer: A
- Which of these is a benefit of using slicers on a dashboard? A. They delete data B. They provide a visual, clickable filter for users C. They slow down workbooks D. They change formulas Answer: B
- What does setting 'Use First Row as Headers' fix after splitting columns? A. Converts numbers B. Sets descriptive column names for table operations C. Deletes the first row D. Removes duplicates Answer: B
- Which function would you use to format a date into 'MMMM YYYY' text format? A. LEFT B. TEXT C. TRIM
A. MID(cell, len-3,4) B. LEFT C. TRIM D. PROPER Answer: A
- What is the main purpose of budgeting in business? A. To predict stock prices B. To plan and allocate financial resources to meet goals C. To format financial statements D. To calculate tax only Answer: B
- How does forecasting differ from budgeting? A. Forecasting sets targets; budgeting predicts likely results B. Forecasting predicts likely results; budgeting sets targets C. They are identical D. Forecasting is a chart type Answer: B
- Which budgeting type focuses on daily operations (revenues and expenses)? A. Capital Budget B. Operating Budget C. Cash Flow Budget D. Investment Budget Answer: B
- Which forecasting technique uses historical data with decreasing weights for older observations? A. Moving Average B. Weighted Moving Average C. Exponential Smoothing D. Qualitative Forecasting Answer: C
- In a weighted moving average, what is important to define? A. Chart colors B. Weights assigned to recent periods C. Header titles D. Text case Answer: B
- Which financial model links the income statement, balance sheet, and cash flow statement? A. Pricing Model B. Integrated Financial Statement (Three-way) Model C. Project Finance Model D. Valuation Model Answer: B
- Which Excel tool helps create collaborative budgets and templates easily? A. PowerPoint B. Excel
A. A quantitative forecasting technique B. A qualitative forecasting technique using expert rounds C. A budgeting template D. A type of chart Answer: B
- Which of these is NOT a common type of financial model? A. Valuation Model B. Project Finance Model C. Canvas Model D. Reporting Model Answer: C
- Which Excel feature is recommended to link charts into PowerPoint while keeping them editable? A. Paste as image B. Paste Special -> Microsoft Excel Chart Object C. Paste as text D. Insert -> Object -> PDF Answer: B
- What is a key principle when designing financial presentations? A. Use as many charts as possible B. Keep it simple and highlight key figures C. Avoid labels D. Use inconsistent fonts
Answer: B
- Which statement shows a company's financial position at a point in time? A. Income Statement B. Balance Sheet C. Cash Flow Statement D. Budget Answer: B
- Which statement reports revenues and expenses over a period? A. Balance Sheet B. Income Statement C. Cash Flow Statement D. Statement of Changes in Equity Answer: B
- Which activity category in a cash flow statement includes sale of equipment? A. Operating Activities B. Investing Activities C. Financing Activities D. Equity Activities Answer: B
- Which method helps measure forecast accuracy by comparing forecast to actuals over time? A. Moving Average B. MAPE and error metrics
- Which forecasting method gives more weight to recent observations than older ones? A. Simple Moving Average B. Weighted Moving Average C. Unweighted Average D. Median Answer: B
- What is an expected outcome of completing a forecasting lab using Excel? A. Confusing charts B. Completed moving average and exponential smoothing forecasts C. Deleting data D. Encrypting workbook Answer: B
- Which of these is a key takeaway when presenting financial data? A. Use jargon; avoid visuals B. Accuracy, clarity, relevance C. Never use PowerPoint D. Provide raw data only Answer: B
- What is the main use of presentation tools like PowerPoint in financial reporting? A. To compute formulas B. To design and deliver clear financial slides and integrate Excel visuals C. To import databases D. To replace accounting systems
Answer: B
- Which activity is part of designing financial presentations in the lab? A. Insert songs B. Input charts and diagrams, format, and integrate Excel data C. Delete headers D. Encrypt slides Answer: B
- Which of the following is a trend in financial data presentation mentioned in the handout? A. Less visualization B. AI-powered predictive reporting and real-time dashboards C. Only paper reports D. Avoid dashboards Answer: B
- What does 'Paste Special -> Paste Link' do when pasting Excel range into PowerPoint? A. Embeds static image B. Creates a link so the slide updates when Excel changes C. Deletes source file D. Converts to PDF Answer: B
- Which financial statement component must balance with 'Total Liabilities and Equity'? A. Total Revenue B. Total Assets
