I85PREP
⌘ K
CLEP Information Systems study materials
CLEP Information Systems study resources

CLEP Information Systems practice questions

One question at a time. Build your CLEP Information Systems understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Office and Technology Applications

A user wants to keep the top row of a long spreadsheet visible while scrolling through records below it. Which spreadsheet feature should be applied?

  1. Freeze panes Correct answer.
  2. Conditional formatting
  3. AutoFilter
  4. Sort ascending

Explanation

Freeze panes locks specified rows or columns in place so they remain on screen while the rest of the sheet scrolls, which is exactly the behavior needed for a persistent header row. Sorting and filtering rearrange or hide data but do not keep any row visible during scrolling.

Question 2Office and Technology Applications

In a word processor, which feature automatically inserts a page number at the bottom of every page without manually typing it on each page?

  1. Text box
  2. Bookmark
  3. Header and footer Correct answer.
  4. Footnote

Explanation

Headers and footers repeat their content on every page of a section, and inserting an automatic page-number field there updates each page dynamically. Footnotes and text boxes are tied to specific locations and would not repeat automatically.

Question 3Office and Technology Applications

A spreadsheet cell displays the error value #DIV/0!. What condition most likely produced it?

  1. A column is too narrow to display a numeric result
  2. A formula refers to text where a number is required
  3. A formula divides by a cell that is empty or zero Correct answer.
  4. A formula references a deleted worksheet name

Explanation

#DIV/0! appears when a division operation has a divisor of zero, including a reference to a blank cell that is treated as zero. The other listed causes produce different error values such as #VALUE!, display hashes, or #REF!.

Question 4Office and Technology Applications

Which file format is best suited for emailing a finished document that must preserve its exact layout on the recipient's computer?

  1. CSV
  2. PDF Correct answer.
  3. DOCX
  4. TXT

Explanation

PDF embeds layout, fonts, and graphics so the document renders consistently on different systems, which is why it is preferred for final distribution. DOCX can reflow depending on the viewer, while TXT and CSV discard formatting entirely.

Question 5Office and Technology Applications

In a presentation program, what is the purpose of the slide master?

  1. It stores speaker notes for the current slide
  2. It defines consistent fonts, colors, and placeholders for slides that use it Correct answer.
  3. It records narration and slide timings
  4. It exports the presentation to video format

Explanation

The slide master holds the theme, fonts, colors, and placeholder positions that flow to all slides based on it, so edits there update the whole deck consistently. Speaker notes, export settings, and narration are separate features.

Question 6Office and Technology Applications

A user needs to combine several spreadsheet worksheets into one summary table that updates when the source sheets change. Which approach accomplishes this?

  1. Print each worksheet and retype the totals
  2. Create a formula that references cells in each source worksheet Correct answer.
  3. Copy the values and paste them as static numbers
  4. Save each worksheet as a separate CSV file

Explanation

A formula that references cells on other worksheets (a linked or 3-D reference) recalculates automatically whenever the source data changes, keeping the summary current. Static copies, retyping, and separate files all break the live link.

Question 7Office and Technology Applications

Which spreadsheet function is designed to look up a value in the leftmost column of a range and return a value from a specified column in the same row?

  1. COUNTIF
  2. CONCATENATE
  3. VLOOKUP Correct answer.
  4. SUMIF

Explanation

VLOOKUP searches vertically down the first column of a range and returns the matching row's value from a chosen column index. SUMIF and COUNTIF perform conditional aggregation, and CONCATENATE joins text strings.

Question 8Office and Technology Applications

A database table stores customer records, and the user wants each customer ID to be unique and never blank. Which database object enforces these rules at the table level?

  1. A query
  2. A report
  3. A form
  4. A constraint on the field Correct answer.

Explanation

Field constraints such as primary key, unique, and required (not null) are enforced by the table structure itself, so invalid data cannot be entered regardless of the interface used. Forms, queries, and reports present or retrieve data but do not define these integrity rules.

Question 9Office and Technology Applications

When writing a query, which clause is used to filter records so that only rows meeting a specified condition are returned?

  1. ORDER BY
  2. JOIN
  3. WHERE Correct answer.
  4. GROUP BY

Explanation

The WHERE clause applies a condition to individual rows, restricting which records appear in the result set. ORDER BY sorts results, GROUP BY aggregates rows, and JOIN combines tables.

Question 10Office and Technology Applications

A user wants to send the same personalized letter to 500 customers, pulling each name and address from a data source. Which word-processing feature performs this?

  1. Track changes
  2. Mail merge Correct answer.
  3. Macro recording
  4. Style templates

Explanation

Mail merge combines a main document with a data source so each record produces a personalized copy. Track changes manages edits, macros automate steps, and styles control formatting.

Question 11Office and Technology Applications

In a spreadsheet, cell C1 contains =A1+B1. If A1 is 10 and B1 is 5, and the formula is copied to C2 where A2 is 20 and B2 is 7, what does C2 display?

  1. 12
  2. 27 Correct answer.
  3. 15
  4. 30

Explanation

Relative references adjust when a formula is copied, so C2 becomes =A2+B2, which is 20+7=27. The original result of 15 stays in C1 because the formula adapts to its new row.

Question 12Office and Technology Applications

A worksheet formula should always refer to a tax rate stored in cell F1 no matter where the formula is copied. Which reference form should be used?

  1. Named range without a sheet reference
  2. Absolute reference such as $F$1 Correct answer.
  3. Relative reference such as F1
  4. Mixed reference such as F$1

Explanation

An absolute reference with dollar signs on both the column and row keeps the reference fixed when the formula is copied to other cells. Relative and mixed references shift at least partly, which would point to the wrong cell.

Question 13Office and Technology Applications

Which action best protects an emailed spreadsheet from unauthorized changes to its formulas while still allowing readers to view the data?

  1. Apply sheet protection with a password Correct answer.
  2. Convert the sheet to a chart
  3. Compress the file into a ZIP archive
  4. Rename the file with a .bak extension

Explanation

Sheet protection with a password restricts editing of locked cells and formulas while leaving the content readable. Zipping, renaming, or charting changes packaging or presentation but does not prevent edits.

Question 14Office and Technology Applications

A presentation must run unattended at a trade show kiosk, advancing slides automatically on a timer. Which setup accomplishes this?

  1. Add speaker notes to each slide
  2. Apply a transition sound to every slide
  3. Configure a self-running slide show with rehearsed timings Correct answer.
  4. Use presenter view on a second monitor

Explanation

A self-running show with recorded or rehearsed timings advances slides automatically without a presenter, which suits kiosk display. Presenter view requires a person, and notes or sounds do not control advancement.

Question 15Office and Technology Applications

A user needs to find every occurrence of a specific product code across a long document and replace it with a new code. Which feature is most efficient?

  1. Spell check
  2. AutoCorrect
  3. Find and Replace Correct answer.
  4. Word count

Explanation

Find and Replace locates every instance of a text string and substitutes it in one operation, optionally across the whole document. Spell check, word count, and AutoCorrect address different tasks.

Question 16Office and Technology Applications

In a relational database, what does a primary key do?

  1. It sorts records automatically on entry
  2. It links two tables by matching foreign values
  3. It uniquely identifies each record in a table Correct answer.
  4. It encrypts sensitive fields

Explanation

A primary key is a field or combination of fields whose value is unique for every row, guaranteeing each record can be identified distinctly. Foreign keys handle relationships, and sorting or encryption are separate concerns.

Question 17Office and Technology Applications

A user wants a chart that shows the proportion each department contributes to total spending. Which chart type is most appropriate?

  1. Line chart
  2. Pie chart Correct answer.
  3. Gantt chart
  4. Scatter plot

Explanation

A pie chart divides a whole into slices proportional to each category's share, which directly communicates part-to-whole contribution. Line charts show trends, scatter plots show correlation, and Gantt charts show schedules.

Question 18Office and Technology Applications

Which practice most reduces the risk of a macro virus in an office document received by email?

  1. Opening attachments only from trusted senders and disabling macros by default Correct answer.
  2. Saving the attachment to the desktop before opening it
  3. Renaming the attachment before opening it
  4. Forwarding the attachment to a colleague first

Explanation

Macro viruses execute when document macros run, so disabling macros by default and trusting only verified senders blocks the primary infection path. Moving, renaming, or forwarding the file does not neutralize embedded code.

Question 19Office and Technology Applications

A user types a URL and presses Enter, but the browser shows a certificate warning for the site. What does this warning most directly indicate?

  1. The page contains too many images
  2. The user's password has expired
  3. The web server is offline
  4. The site's security certificate cannot be verified as trusted Correct answer.

Explanation

A certificate warning means the browser cannot validate the site's TLS certificate against a trusted authority or the name does not match, so the encrypted connection cannot be confirmed. Server availability, page content, and account passwords are separate issues.

Question 20Office and Technology Applications

Which cloud-based office suite capability lets multiple users edit the same document simultaneously and see each other's changes in real time?

  1. Print layout view
  2. Real-time co-authoring Correct answer.
  3. Offline synchronization
  4. Version history

Explanation

Real-time co-authoring allows several users to work in one shared document at once, with edits appearing live for all participants. Offline sync, version history, and print layout address storage, past revisions, and display respectively.

Question 21Office and Technology Applications

A spreadsheet uses =SUM(A1:A10) in cell A11, and a new row is inserted at row 5 within the range. What happens to the formula result after the insertion?

  1. It expands to include the inserted row's value Correct answer.
  2. It converts to an absolute reference automatically
  3. It produces a #REF! error
  4. It excludes the new row because the range is fixed

Explanation

Spreadsheet formulas adjust ranges when rows are inserted inside them, so SUM(A1:A10) becomes SUM(A1:A11) and includes the new value. Fixed exclusion, reference errors, and automatic absolute conversion do not occur.

Question 22Office and Technology Applications

A user applies a filter to a spreadsheet list, then runs a SUM over the entire original column. Why might the total differ from the sum of the visible rows?

  1. SUM recalculates only when the file is reopened
  2. SUM ignores hidden rows only when the filter is removed
  3. SUM includes hidden rows, so a function that respects filters is needed Correct answer.
  4. SUM converts filtered text to zero

Explanation

The SUM function adds every value in the range, including rows hidden by a filter, so the total reflects all records rather than only visible ones. A function designed to respect filters, such as SUBTOTAL, is required to total visible rows only.

Question 23Office and Technology Applications

A database designer stores a repeating list of phone numbers inside a single customer record field. Which normalization problem does this create?

  1. It violates first normal form by storing multiple values in one field Correct answer.
  2. It removes the need for a WHERE clause
  3. It creates a foreign key dependency
  4. It duplicates the primary key

Explanation

First normal form requires each field to hold a single atomic value; packing several phone numbers into one field makes searching, updating, and indexing unreliable. The other options misdescribe normalization concepts.

Question 24Office and Technology Applications

A user records a macro that deletes a worksheet, then runs it on a workbook where that worksheet does not exist. What is the most likely outcome?

  1. The macro skips the missing step silently
  2. The macro converts to a formula
  3. The macro stops with a run-time error Correct answer.
  4. The macro creates the missing worksheet

Explanation

A recorded macro replays exact instructions without built-in checks, so referencing a nonexistent worksheet raises a run-time error and halts execution. Silent skipping and automatic creation would require added error handling or explicit code.

Question 25Office and Technology Applications

An organization wants spreadsheet templates to enforce a standard layout and prevent users from overwriting header formulas. Which combination best achieves this?

  1. Apply conditional formatting to header cells
  2. Email the template and ask users not to edit headers
  3. Save the template as a read-only PDF
  4. Protect the worksheet and lock the header cells before distributing the template Correct answer.

Explanation

Locking cells and enabling worksheet protection makes the header formulas uneditable while leaving intended input areas available, and distributing it as a template standardizes layout. Requests, PDF conversion, or formatting do not technically prevent edits.

Question 26Office and Technology Applications

A user pastes a block of text into a word processor and wants each product name to appear in a consistent style throughout a long report. Which feature applies formatting to text based on its assigned role, such as heading or body, so the look can be changed everywhere at once?

  1. Mail merge
  2. Track changes
  3. Thesaurus
  4. Paragraph styles Correct answer.

Explanation

A paragraph style bundles font, spacing, and alignment settings under a named role, so every paragraph tagged with that style updates when the style definition is edited. This gives consistent formatting across a long document without manual reformatting.

Question 27Office and Technology Applications

A user wants a spreadsheet to display only rows where the Region column equals "West" while leaving the underlying data intact and restorable. Which feature is designed for this?

  1. Sorting the Region column
  2. Conditional formatting on the Region column
  3. Applying an AutoFilter to the Region column Correct answer.
  4. Freezing the Region column

Explanation

An AutoFilter temporarily hides rows that do not meet the chosen criterion while keeping all records in the sheet, and clearing the filter restores them. Sorting rearranges rows rather than hiding them, and the other options change display or visibility of panes, not row selection.

Question 28Office and Technology Applications

A presenter wants a slide to reveal bullet points one at a time on mouse click rather than all at once. Which presentation feature controls this?

  1. Slide transitions
  2. Slide master
  3. Animation settings applied to the bulleted text Correct answer.
  4. Speaker notes

Explanation

Animation settings determine how individual objects, such as a bulleted list, enter the slide and whether each item appears on a click. Transitions govern the change between whole slides, not the order in which content within a slide appears.

Question 29Office and Technology Applications

An office worker needs to send a scanned contract as an email attachment that any recipient can open without special software, while keeping the file small. Which format best meets these requirements?

  1. A plain-text file
  2. PDF Correct answer.
  3. A proprietary word-processor document format
  4. A spreadsheet workbook format

Explanation

PDF is a portable format that preserves the page layout and can be opened with widely available free readers, and it compresses scanned pages efficiently. Word-processor and spreadsheet formats may require specific software, and plain text cannot retain the scanned image.

Question 30Office and Technology Applications

In a spreadsheet, cell D4 contains the formula =B4*$C$1, where C1 holds a discount rate. The formula is copied down to D5 and D6. What does D6 compute?

  1. B4 times the value in C1
  2. B6 times the value in C3
  3. B6 times the value in C6
  4. B6 times the value in C1 Correct answer.

Explanation

The dollar signs make the column and row of C1 absolute, so that reference stays fixed as the formula is copied. The relative reference B4 shifts down with each row, becoming B6 in D6, so D6 multiplies B6 by the rate in C1.

Question 31Office and Technology Applications

A user wants the word "Pending" to appear in a status cell only when the adjacent due-date cell is earlier than today and the completion cell is blank. Which spreadsheet capability is appropriate?

  1. A nested IF formula that tests both conditions Correct answer.
  2. A pie chart of the status column
  3. A pivot table summarizing the status column
  4. A data validation list on the status column

Explanation

A nested IF can evaluate the date comparison and the blank check, then return "Pending" only when both are true. The other features display or restrict data but cannot derive a status from two conditions in another cell.

Question 32Office and Technology Applications

A user needs to compute the average score for students in a list but include only those in the "Senior" class. Which function is best suited?

  1. AVERAGEIF Correct answer.
  2. COUNTIF
  3. AVERAGE
  4. VLOOKUP

Explanation

AVERAGEIF averages only the cells that satisfy a stated criterion, which matches the need to restrict the calculation to one class. Plain AVERAGE ignores conditions, COUNTIF counts rather than averages, and VLOOKUP retrieves a value instead of calculating a mean.

Question 33Office and Technology Applications

A database table of orders must reference the customer who placed each order, and the customer must already exist in the customer table. Which database construct enforces this?

  1. A memo field in the order table
  2. A query with a calculated field
  3. An index on the order table
  4. A foreign key on the order table referencing the customer table Correct answer.

Explanation

A foreign key constrains each order's customer reference to values that exist in the customer table, preserving referential integrity. The other options affect storage, retrieval speed, or display but do not enforce the relationship.

Question 34Office and Technology Applications

A report must show each salesperson's total sales, sorted from highest to lowest, without altering the source table. Which approach meets the requirement?

  1. A form bound to the source table
  2. A table with a new column typed in manually
  3. A query that groups by salesperson, sums sales, and sorts descending Correct answer.
  4. A macro that deletes losing records

Explanation

A grouped query with an aggregate sum and a descending sort produces the ranked totals while leaving the stored data unchanged. Forms display records, deleting records destroys data, and manual entry is error-prone and not derived from the source.

Question 35Office and Technology Applications

A user wants a single spreadsheet cell to show the current date each time the file is opened, rather than a fixed date typed earlier. Which approach achieves this?

  1. Using the TODAY function in the cell Correct answer.
  2. Formatting the cell as text
  3. Typing today's date into the cell
  4. Entering the date in a header

Explanation

The TODAY function recalculates and returns the current date whenever the workbook recalculates or is opened, so the cell stays current. A typed date is static, and text formatting or a header does not produce an updating value.

Question 36Office and Technology Applications

A team wants to reuse a consistent set of colors and fonts across many presentations so that a single change updates all slides. Which feature should they use?

  1. A hyperlink to a style guide
  2. A theme applied to the presentation Correct answer.
  3. Individual font changes on each slide
  4. A slide transition effect

Explanation

A theme stores coordinated color, font, and effect choices, and editing the theme updates every slide that uses it. Manual per-slide changes are inconsistent and must be repeated, while the other options do not control styling.

Question 37Office and Technology Applications

A user must produce a document where each page shows a different branch address in the footer while the body text stays identical. Which feature is most efficient?

  1. A single footer typed once
  2. Section breaks with a different footer per section Correct answer.
  3. Saving a separate file for each branch
  4. Track changes enabled

Explanation

Section breaks divide the document so each section can carry its own header or footer, allowing different addresses while sharing the body text. Separate files duplicate content, one footer cannot vary by page, and track changes only records edits.

Question 38Office and Technology Applications

A worksheet's summary formula uses a range that was defined as a named range, and a user later inserts new rows inside that range. What is the main benefit of the named range in this situation?

  1. The named range prevents any rows from being inserted
  2. Formulas referring to the name continue to cover the expanded range automatically Correct answer.
  3. The named range hides the inserted rows from view
  4. The named range converts the formula into a static value

Explanation

A defined name that refers to a range expands when rows are inserted within it, so formulas using the name keep including the new data. Names do not block edits, freeze results, or hide rows; they simply provide a stable, self-documenting reference.

Question 39Office and Technology Applications

A user imports a text file into a spreadsheet, and every record lands in a single column because the values are separated by semicolons while the import assumed commas. What is the most direct fix?

  1. Apply a currency format to the column
  2. Merge the imported cells
  3. Sort the single column alphabetically
  4. Rerun the import and specify the semicolon as the delimiter Correct answer.

Explanation

Delimited text must be split using the character that actually separates fields, so choosing the semicolon as the delimiter places each value in its own column. Sorting, formatting, or merging cells cannot separate the concatenated values.

Question 40Office and Technology Applications

An analyst builds a pivot table from a sales table and later adds new rows to the source data. The pivot table totals do not include the new rows. What is the most likely explanation?

  1. Pivot tables can never summarize more than one hundred rows
  2. The pivot table has been converted to a chart
  3. The pivot table's source range does not cover the added rows and must be refreshed or extended Correct answer.
  4. The new rows contain text instead of numbers

Explanation

A pivot table caches data from the range it was built on, so rows added outside that range are not included until the source is extended and the table is refreshed. Pivot tables handle large datasets, and a chart conversion would not explain stale totals.

Question 41Internet and World Wide Web

A user types a web address into a browser. Which protocol is primarily responsible for transferring the requested web page files between the server and the browser?

  1. SMTP
  2. SNMP
  3. HTTP Correct answer.
  4. FTP

Explanation

HTTP (Hypertext Transfer Protocol) is the application-layer protocol browsers and web servers use to request and deliver web resources such as HTML pages, images, and scripts. SMTP handles email, FTP handles bulk file transfer sessions, and SNMP handles network device management.

Question 42Internet and World Wide Web

Which organization develops and publishes the HTML and CSS specifications that define how web pages are structured and styled?

  1. The Internet Engineering Task Force (IETF)
  2. The Internet Corporation for Assigned Names and Numbers (ICANN)
  3. The World Wide Web Consortium (W3C) Correct answer.
  4. The Institute of Electrical and Electronics Engineers (IEEE)

Explanation

The W3C is the main standards body that develops recommendations for HTML, CSS, and many other core web technologies. The IETF focuses on Internet protocols such as TCP/IP, IEEE publishes many hardware and networking standards, and ICANN coordinates domain names and IP address allocation.

Question 43Internet and World Wide Web

In a URL such as https://www.example.com/library/index.html, which component is 'index.html'?

  1. The path to the resource Correct answer.
  2. The top-level domain
  3. The query string
  4. The domain name

Explanation

In a URL, the portion after the host identifies the specific resource on the server; here '/library/index.html' is the path to the file. The domain name is 'www.example.com', the top-level domain is 'com', and a query string would follow a question mark.

Question 44Internet and World Wide Web

A web page uses hyperlinks so that a reader can jump from one document to a related document. What is this defining characteristic of the Web called?

  1. Hypertext Correct answer.
  2. Packet switching
  3. Client-server separation
  4. Statelessness

Explanation

Hypertext is text displayed with links that let readers move nonlinearly among related documents, and it is the core idea behind the World Wide Web. Packet switching describes how data is divided and routed, while client-server and statelessness describe architecture and protocol behavior rather than linked documents.

Question 45Internet and World Wide Web

Which top-level domain is a sponsored TLD restricted to accredited degree-granting institutions?

  1. .gov
  2. .net
  3. .org
  4. .edu Correct answer.

Explanation

The .edu sponsored top-level domain is reserved for institutions of higher education that are accredited and degree-granting. .gov is for government entities, .org is an open generic TLD commonly used by nonprofits, and .net is an open generic TLD originally intended for network providers.

Question 46Internet and World Wide Web

What is the primary purpose of a search engine's web crawler?

  1. To automatically discover and download web pages for indexing Correct answer.
  2. To cache DNS responses for faster lookups
  3. To encrypt traffic between the browser and the server
  4. To assign IP addresses to web servers

Explanation

A crawler (spider) follows links across the Web, retrieves pages, and feeds their content to an index that supports search queries. Encryption is handled by TLS, IP assignment by DHCP, and DNS caching by resolvers, none of which is the crawler's role.

Question 47Internet and World Wide Web

Which HTML element creates a hyperlink to another web page?

  1. <img>
  2. <p>
  3. <table>
  4. <a> Correct answer.

Explanation

The anchor element <a> with an href attribute defines a hyperlink to another resource. The <img> element embeds an image, <p> marks a paragraph, and <table> structures tabular data.

Question 48Internet and World Wide Web

A browser receives an HTTP response with status code 404. What does this indicate?

  1. The client is not authorized to view the resource
  2. The requested resource was not found on the server Correct answer.
  3. The request succeeded and content follows
  4. The server redirected the client to a new URL

Explanation

HTTP status codes in the 4xx range indicate client-side errors, and 404 specifically means the server could not find the requested resource. A successful response is 200, a redirect is 3xx, and an authorization failure is 401 or 403.

Question 49Internet and World Wide Web

A web developer wants a small block of content to be independently linkable and reusable inside many pages without an iframe. Which technology is designed for this purpose?

  1. CSS media queries
  2. URL query strings
  3. HTTP cookies
  4. Custom web components Correct answer.

Explanation

Web components let developers define encapsulated, reusable custom elements that can be embedded across pages and referenced independently. Media queries adapt layout to device characteristics, query strings pass parameters, and cookies store small client-side state data.

Question 50Internet and World Wide Web

Which statement best describes the role of DNS in accessing a website?

  1. It translates a human-readable domain name into an IP address Correct answer.
  2. It compresses images to reduce page load time
  3. It encrypts the content of web pages before transmission
  4. It stores copies of web pages for offline browsing

Explanation

DNS is a hierarchical naming system that resolves domain names such as www.example.com into numeric IP addresses so clients can reach the correct server. Encryption is handled by TLS, page caching by browsers or proxies, and image compression by servers or content delivery tools.