placeholder image to represent content

2003 HSC ITVET

Quiz by Benjamin

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
15 questions
Show answers
  • Q1
    What type of software installation allows users to select the components they wish to install?
    Typical
    Full
    Portable
    Custom
    30s
  • Q2
    A new printer was ordered. When it was received in the IT department the box appeared to have been opened and resealed. What would be the most appropriate source of information to determine if any item is missing?
    Driver disks
    Purchase order
    Warranty and registration cards
    Packing list
    30s
  • Q3
    A full backup of the fileserver is done every Friday night and an incremental partial backup on other working nights. A virus was downloaded and activated on Wednesday which irretrievably damaged a variety of files. What steps must be taken to best restore the system?
    Update virus pattern files; quarantine damaged files; remove the virus; restore using: full backup, Monday’s partial backup, Tuesday’s partial backup.
    Remove the virus; restore using: full backup, Tuesday’s partial backup, Monday’s partial backup; update virus pattern files; quarantine damaged files.
    Update virus pattern files; quarantine damaged files; remove the virus; restore using: full backup, Tuesday’s partial backup.
    Quarantine damaged files; remove the virus; restore using: full backup, Monday’s partial backup, Tuesday’s partial backup; update virus pattern files.
    30s
  • Q4
    What is the most appropriate method of transferring data from a 10 000-row spreadsheet to a table in a word processor document if there is no common file format?
    Create a screen dump and import it as a bitmap file.
    Export it as a delimited TXT file and import the TXT file.
    Save it as a TXT file and open the TXT file in the word processor.
    Copy and paste.
    30s
  • Q5
    An electronic publication on a company’s WAN contains a chart of the latest sales figures. What is the best method of automatically updating this chart?
    Linking to the chart
    Hyperlinking to the chart
    Embedding the chart
    Cut and paste the chart as required
    30s
  • Q6
    Ports A and B are used to connect peripheral devices to Macintosh and IBM-compatible PCs. Port A is the same on both types of computer. Port B looks different but has the same function on both types of computer. Which of the following is correct?
    Question Image
    Port A is slower and therefore can be daisy-chained.
    Port B cannot supply power to the peripheral.
    Port B can allow hot swapping of peripherals.
    Port B can use longer cables than Port A.
    30s
  • Q7
    Under current legislation, training is mandatory for members of some workplace committees. To which of the following does this apply?
    Anti-discrimination
    Environment
    Occupational Health and Safety
    Social
    30s
  • Q8
    Using the edit function of a word processor, how many changes would occur in the text below after executing the command ? FIND ' in' and REPLACE with ' it'?
    Question Image
    2
    6
    1
    4
    30s
  • Q9
    How do you centre the heading ‘Company A’ across two columns?
    Question Image
    Select the row, use the ‘Merge Cells’ command and align.
    Select the two cells, use the ‘Split Cells’ command and align.
    Select the two cells, use the ‘Merge Cells’ command and align.
    Select the first column, use the ‘Split Cells’ command and align.
    30s
  • Q10
    Which other formatting features are used to convert Table 1 to Table 2?
    Question Image
    Bold and align
    Bold and shade
    Borders and align
    Shade and align
    30s
  • Q11
    Why would operators use the form view rather than the table or list view when looking for data in a database?
    To reduce the security of data displayed and decrease the search time
    To increase the number of records displayed
    To improve readability and simplify search results
    To decrease the number of records displayed and decrease the search time
    30s
  • Q12
    Why is the record locking feature used in shared databases?
    To prevent any user changing any field at any time
    To prevent any user changing any record at any time
    To prevent multiple users changing the same field at the same time
    To prevent multiple users changing the same record at the same time
    30s
  • Q13
    Net pay is calculated by subtracting tax and union fees from gross pay. What would be the most effective formula to use in cell H2?
    Question Image
    =F2−G2−$B7
    =F2−G2−$B$7
    =F2−B8−B7
    =F2−G2+B7
    30s
  • Q14
    What would be the most effective formula to use in cell G5?
    Question Image
    =SUM(G2:G5)
    =ADD(G2:G4)
    =SUM(G2:G4)
    =G2+G3+G4
    30s
  • Q15
    What would be the most effective formula to calculate the average of the actual hours worked by the employees?
    Question Image
    =(SUM(D2:D4)+SUM(E2:E4))/COUNT(D2:D4)
    =Average(D2:D4)
    =SUM(D2:E4)/3
    =(SUM(D2:D4)+SUM(E2:E4))/3
    30s

Teachers give this quiz to your class