CISSE Foundation Level
Computer Information Systems Applications flashcards
Read the question, say the answer to yourself, then turn the card to check. The first 10 of 68 cards are free; the rest come with the subject.
Card 1 of 68
Jump to a card
Complete Flashcard Reference
Review every card in this deck. Open any card to reveal its answer. The first 10 are free; the other 58 come with the subject.
What are the typical steps in installing an application?
1. Obtain the installer (a download, or physical or USB media). 2. Run the installer and accept the licence terms. 3. Choose an install location and any optional components. 4. Complete installation and, where required, restart the device. 5. Launch the application and complete any first-run setup, such as sign-in or default settings.
Why should a USB flash drive be safely ejected before it is unplugged?
The operating system may still be writing buffered data to it. Ejecting first flushes any pending writes and closes open handles, which prevents file corruption. Simply unplugging risks losing the unwritten data.
What is the difference between Save and Save As?
Save writes changes back to the same file under its existing name. Save As creates a new copy of the document under a new name or location, leaving the original unchanged.
What does mail merge do, and what two inputs does it combine?
It generates one personalised copy of a document per row of data, for example a standard letter addressed individually to every name on a mailing list, without editing each copy by hand. Inputs: a single template document holding merge fields, and a data source such as a spreadsheet or contact list.
How do relative, absolute and mixed cell references behave when a formula is copied?
Relative (B2): adjusts automatically to its new position, the normal default. Absolute ($B$2): stays fixed on the exact same cell wherever the formula is copied, used for a constant every row should refer to. Mixed ($B2 or B$2): fixes only the column or only the row.
What happens to a file when it is deleted in the operating system?
It goes first to the recoverable Recycle Bin or Trash, from which it can be restored. Only after that is it deleted permanently.
How do Track Changes and comments differ as collaborative editing tools?
Track Changes records every edit, with the editor's identity and a timestamp, so the original author can review, accept or reject each change rather than it being applied silently. A comment lets a reviewer leave a note attached to specific text without altering the text itself.
What two levels of password protection can a word processing document carry?
1. A password required before the document can be opened at all. 2. A separate password allowing it to be opened and read but not edited. Both protect sensitive content in transit or in storage.
Cells B2:B6 hold five students' scores: 45, 78, 62, 90 and 55. What do =SUM(B2:B6) and =AVERAGE(B2:B6) return?
SUM: 45 + 78 + 62 + 90 + 55 = 330. AVERAGE: 330 / 5 = 66.
What is a pivot table?
A tool that summarises and reorganises a large dataset interactively, grouping, aggregating and cross-tabulating it by dragging fields into rows, columns and values, without writing a single formula.
Why should an application not be removed just by deleting its files, and what is the correct way?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the relationship between the operating system and an application?
This answer comes with Computer Information Systems Applications. Buy the subject
Name the common tasks in managing files and folders.
This answer comes with Computer Information Systems Applications. Buy the subject
What may a new external storage device need before its first use?
This answer comes with Computer Information Systems Applications. Buy the subject
What role do the keyboard and mouse, the printer and the scanner play?
This answer comes with Computer Information Systems Applications. Buy the subject
What are an external monitor or projector, and a webcam and microphone, used for?
This answer comes with Computer Information Systems Applications. Buy the subject
Name the common features of word processing software.
This answer comes with Computer Information Systems Applications. Buy the subject
What does each of the Home, Insert, Layout, References and Review toolbars hold?
This answer comes with Computer Information Systems Applications. Buy the subject
What is a template, and why use one?
This answer comes with Computer Information Systems Applications. Buy the subject
What good practice does the guide set out for saving a document?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between character formatting and paragraph formatting?
This answer comes with Computer Information Systems Applications. Buy the subject
What does page setup control in a word processor?
This answer comes with Computer Information Systems Applications. Buy the subject
What do Ctrl + S, Ctrl + Z, Ctrl + Y, Ctrl + F and Ctrl + P do?
This answer comes with Computer Information Systems Applications. Buy the subject
What do Ctrl + C, Ctrl + X, Ctrl + V, Ctrl + B, Ctrl + I and Ctrl + U do?
This answer comes with Computer Information Systems Applications. Buy the subject
How is a table inserted and formatted in a word processor?
This answer comes with Computer Information Systems Applications. Buy the subject
Where can an image come from, and how can it be positioned in a document?
This answer comes with Computer Information Systems Applications. Buy the subject
What is a header or footer used for?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between a footnote and an endnote?
This answer comes with Computer Information Systems Applications. Buy the subject
What is a citation, and how is a bibliography built?
This answer comes with Computer Information Systems Applications. Buy the subject
What are the built-in proofreading tools, and what is their limitation?
This answer comes with Computer Information Systems Applications. Buy the subject
What are the steps in a simple mail merge?
This answer comes with Computer Information Systems Applications. Buy the subject
Why should a document be checked after converting it to another word processor's format?
This answer comes with Computer Information Systems Applications. Buy the subject
How is a table of contents generated automatically, and how is a list of figures built?
This answer comes with Computer Information Systems Applications. Buy the subject
What is a macro, and when does it save time?
This answer comes with Computer Information Systems Applications. Buy the subject
What should be checked when printing a document?
This answer comes with Computer Information Systems Applications. Buy the subject
Define a cell, a worksheet and a workbook.
This answer comes with Computer Information Systems Applications. Buy the subject
How do you jump to a cell, edit a cell and select a range in a spreadsheet?
This answer comes with Computer Information Systems Applications. Buy the subject
What is conditional formatting?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between a formula and a function?
This answer comes with Computer Information Systems Applications. Buy the subject
What do SUM, AVERAGE, IF, VLOOKUP/XLOOKUP and COUNTIF do?
This answer comes with Computer Information Systems Applications. Buy the subject
Cells B2:B6 hold 45, 78, 62, 90 and 55. C2 holds =IF(B2>50,"Pass","Fail"), copied down to C6. What does each row show?
This answer comes with Computer Information Systems Applications. Buy the subject
B2 holds =A2*D1, with a fixed rate in D1 and nothing below it. What goes wrong when the formula is copied down to B3 and B4?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between sorting, filtering and data validation?
This answer comes with Computer Information Systems Applications. Buy the subject
What is what-if analysis, and how do Goal Seek and a data table perform it?
This answer comes with Computer Information Systems Applications. Buy the subject
What does freezing panes do?
This answer comes with Computer Information Systems Applications. Buy the subject
How is a chart created in a spreadsheet, and what happens when its data changes?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between summarising, consolidating and outlining data?
This answer comes with Computer Information Systems Applications. Buy the subject
How can a workbook be protected and shared?
This answer comes with Computer Information Systems Applications. Buy the subject
What settings help a large worksheet print legibly?
This answer comes with Computer Information Systems Applications. Buy the subject
In a database table, what is a record and what is a field?
This answer comes with Computer Information Systems Applications. Buy the subject
What is each main Access object used for: table, query, form, report, macro?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between a primary key and a foreign key?
This answer comes with Computer Information Systems Applications. Buy the subject
What does enforcing referential integrity on a relationship prevent?
This answer comes with Computer Information Systems Applications. Buy the subject
What is a parameter query, and how is one made in Access?
This answer comes with Computer Information Systems Applications. Buy the subject
In an Access query criterion, what do the * and ? wildcards stand for?
This answer comes with Computer Information Systems Applications. Buy the subject
What does the slide master do in a presentation?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between a slide transition and an animation?
This answer comes with Computer Information Systems Applications. Buy the subject
What does each view show: Slide Sorter, Notes Page, Slide Show?
This answer comes with Computer Information Systems Applications. Buy the subject
How do speaker notes and Presenter View help a presenter?
This answer comes with Computer Information Systems Applications. Buy the subject
How is a slide set to advance automatically after a set time in PowerPoint?
This answer comes with Computer Information Systems Applications. Buy the subject
What are handouts in a presentation program, and which layout suits note-taking?
This answer comes with Computer Information Systems Applications. Buy the subject
In desktop publishing, what are frames and master pages?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between the internet and the World Wide Web?
This answer comes with Computer Information Systems Applications. Buy the subject
How are an IP address, a domain name and DNS related?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between a web browser and a search engine?
This answer comes with Computer Information Systems Applications. Buy the subject
Which search techniques narrow a web search?
This answer comes with Computer Information Systems Applications. Buy the subject
What is the difference between Cc and Bcc in an email?
This answer comes with Computer Information Systems Applications. Buy the subject
What do https and the padlock tell a user, and what should they do with an email asking for a password through a link?
This answer comes with Computer Information Systems Applications. Buy the subject
How to revise with these cards
- Answer out loud or on paper before you turn the card: recalling is what fixes it.
- Go through the deck in short sessions of ten to fifteen minutes, every day.
- Shuffle once you know the order, so you are not answering from memory of the sequence.
- When a card catches you out, read the chapter it links to, then try the topic in a past paper.