SS2 Digital Tech 3rd Test/Third Term
  • 1. What is the primary purpose of a financial model?
A) To forecast a business's financial performance
B) To promote company Logo
C) None of the above
D) To write computer programming code
  • 2. Which software is most commonly used to build financial models?
A) Microsoft word
B) Adobe Photoshop
C) Microsoft Excel
D) CorelDraw
  • 3. Which financial statement shows a company's revenues and expenses over a specific period?
A) Ledger Statement
B) Income Statement
C) Cash Flow Statement
D) Balance Sheet
  • 4. Why is historical financial data important when building a new financial model?
A) It predicts the future with 100% certainty
B) It serves as a baseline to establish realistic assumptions
C) It is required by internet service providers
D) It replaces the need for any formulas
  • 5. Which Excel formula is used to calculate the total value of a row of financial figures?
A) =COUNT()
B) =SUM()
C) =TOTAL()
D) =AVERAGE()
  • 6. If you want to lock a specific cell reference in an Excel financial model so it does not change when copied, which symbol do you use?
A) #
B) &
C) %
D) $
  • 7. What is the main objective of Scenario Analysis in financial modeling?
A) To calculate the exact tax a business will pay tomorrow
B) To delete old data from the company database
C) To examine different possible future outcomes by altering multiple variables
D) To automate the payroll system of an organization
  • 8. Where can you locate the Scenario Manager and Goal Seek tools in the Excel ribbon?
A) Insert tab -> Charts
B) View tab -> Workbook Views
C) Data tab -> What-If Analysis
D) Home tab -> Conditional Formatting
  • 9. What is the purpose of the Goal Seek tool in Excel?
A) To secure a worksheet with a password
B) To find an input value needed to achieve a specific, desired formula outcome
C) To change all text in a sheet to uppercase lettering
D) To automatically spellcheck the financial model
  • 10. If you want to use Goal Seek to find out what sales volume is needed to reach a net profit of ₦5,000,000, your "To value" input should be:
A) 5,000,000
B) Sales volume
C) Net profit
D) 0
  • 11. Why should a financial model be flexible?
A) To allow users to easily change assumptions and see updated results instantly
B) To allow it to run without an operating system
C) So it can be printed on any size of paper
D) So that it automatically deletes old rows of data
  • 12. What is the primary goal of professional presentation design?
A) To use as many animations as possible
B) To hide the speaker from the audience
C) To display the maximum amount of text on a single slide
D) To effectively communicate a message to an audience
  • 13. Which software is considered an industry standard for creating presentations?
A) Adobe Photoshop
B) Microsoft Excel
C) Microsoft Access
D) Microsoft PowerPoint
  • 14. What is the purpose of a "Slide Master" in digital presentation software?
A) To automatically check for spelling errors
B) To play background music throughout the presentation
C) To export the presentation directly to a printer
D) To set a consistent layout, font, and background across all slides
  • 15. Which layout orientation is standard for modern digital presentations viewed on projector screens or TVs?
A) Portrait (4:3)
B) Vertical
C) Square
D) Landscape (16:9 widescreen)
  • 16. If your presentation template has a very dark navy-blue background, what color should your text be?
A) Deep purple
B) Transparent
C) Pure white or light yellow
D) Dark black
  • 17. What is the primary benefit of embedding a video file directly into a slide instead of using a web link?
A) It automatically translates the video into multiple languages
B) It makes the total file size smaller
C) It ensures the video can play smoothly even without an active internet connection
D) It prevents the audience from seeing the video content
  • 18. What is the difference between a "Slide Transition" and a "Custom Animation"?
A) Transition applies to the movement between slides; Animation applies to individual items on a single slide
B) Transition is only for audio; Animation is only for images
C) There is no structural difference between them
D) Transition changes text fonts; Animation changes slide backgrounds
  • 19. What is a primary cause of "Death by PowerPoint"?
A) A) A computer system failure during a speech
B) Forgetting to plug in the projector power cable
C) Boring the audience with overly cluttered, wordy, and poorly designed slides
D) Using an unapproved license key for office software
  • 20. Before delivering an important digital presentation, what is the best technical practice?
A) Change all fonts to a decorative design at the last minute
B) Delete the original project asset files
C) B) Test the presentation equipment, media links, and audio levels beforehand
D) Copy all content back into a simple text file
  • 21. What is the primary purpose of HTML in web development?
A) To handle server-side background operations
B) To manage database security systems
C) To style layout colors and text fonts
D) To define the structure and content of a web page
  • 22. What does the acronym CSS stand for?
A) Cascading Style Sheets
B) Creative Slide Sheets
C) Computer Style Sheets
D) Complex Structural System
  • 23. Which language is primarily used to control the visual presentation and layout of a web page?
A) HTML
B) PHP
C) CSS
D) SQL
  • 24. What does the acronym HTML stand for?
A) Hyperlink Text Management Logic
B) HighTech Markup Language
C) HyperText Markup Language
D) Home Tool Management Layout
  • 25. Which software tool is specifically used by a client to interpret HTML/CSS code and display a visible web page?
A) Web browser
B) File Transfer Protocol Client
C) Database Engine
D) Database Engine
  • 26. Which HTML tag contains metadata about the web document that is not displayed directly in the main browser window area?
A) <head>
B) <section>
C) <body>
D) <footer>
  • 27. All visible content of a web page (such as text, images, and links) must be placed inside which tag pair?
A) <head></head>
B) <body></body>
C) <title></title>
D) <meta></meta>
  • 28. Which HTML element represents the highest level of heading on a web page
A) <h1>
B) <h6>
C) <h5>
D) <heading>
  • 29. What is the correct HTML tag used to define a basic paragraph of text?
A) <text>
B) <br>
C) <p>
D) <para>
  • 30. Which HTML tag is used to create a numbered, ordered list?
A) <list>
B) <ol>
C) <ul>
D) <li>
  • 31. Which method of adding CSS is recommended for maintaining consistency across a website with multiple pages?
A) External Style Sheets
B) Inline Styling
C) Internal Style Sheets
D) Embedded JavaScript Styling
  • 32. Which HTML tag is used to link an external CSS stylesheet file to an HTML document?
A) <script>
B) <link>
C) <anchor>
D) <style>
  • 33. In a CSS declaration, which character is used to separate the property name from its corresponding value?
A) Colon ( :)
B) Period ( .)
C) Semicolon ( ; )
D) Comma ( ,)
  • 34. Which CSS selector targeting method uses a prefix period symbol (e.g., .main-text) to apply styles to multiple elements?
A) Class Selector
B) Element Selector
C) ID Selector
D) Universal Selector
  • 35. Which symbol is used in CSS to target an element with a unique ID attribute ?
A) Ampersand ( & )
B) Dot ( . )
C) Asterisk ( *)
D) Hash/Pound ( #)
  • 36. According to the CSS Box Model, which layer represents the space immediately outside the border of an element?
A) Padding
B) Content
C) Margin
D) Height
  • 37. What does CSS Padding clear or create space around?
A) B) The space inside an element, between the content and its border
B) The space between two different HTML files
C) The space between lines of paragraph text
D) The space outside the element's border
  • 38. Which CSS property is used to change the background color of an element?
A) background-color
B) text-color
C) shading
D) color-bg
  • 39. What happens if a web designer forgets to close a structural tag like <div> in their HTML code?
A) The text will automatically turn bright red
B) The website file will be automatically deleted
C) The computer will crash completely
D) B) The layout of the web page will break or display incorrectly
  • 40. h file extension must be used when saving a standard web page file containing HTML structure?
A) .exe
B) .css
C) .txt
D) .html
Created with That Quiz — the math test generation site with resources for other subject areas.