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

Created with That Quiz — the math test generation site with resources for other subject areas.