Information Systems and Technology
Chapter Exam Questions
Course Introduction
Information Systems and Technology explores the fundamental principles and applications of information systems in modern organizations. The course examines the role of technology in managing data, supporting decision-making, and enhancing business processes. Students will learn about the hardware, software, networks, and databases that form the backbone of information systems, as well as emerging trends such as cloud computing, cybersecurity, and digital transformation. Emphasis is placed on aligning information system strategies with organizational goals and understanding how to leverage technology for competitive advantage and innovation.
Recommended Textbook
New Perspectives on Microsoft Office 2013 First Course 1st Edition by Ann Shaffer
Available Study Resources on Quizplus
20 Chapters
1948 Verified Questions
1948 Flashcards
Source URL: https://quizplus.com/study-set/1957
Page 2
Chapter 1: Creating a Database
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38989
Sample Questions
Q1) Which field is the primary key (unique identifier) in the Customer Table?
Answer: Cust#
Q2) A table is a predesigned database that includes professionally designed database objects.
A)True
B)False
Answer: False
Q3) There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.
Answer: navigation buttons
Q4) What is the minimum number of tables that must be created for this database?
Answer: At least two tables must be created: one for customers and one for products. Depending on the fields included in each table; a third table might be useful to track purchases by customers. However, that information might be included in one of the other tables.
Q5) A query is used to enter, edit, and view records in a database.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Building a Database and Defining Table
Relationships
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/38990
Sample Questions
Q1) Field names in a table may only be changed in Design view.
A)True
B)False Answer: False
Q2) <u>Relationship integrity</u> is a set of rules used by Access to maintaain consistency between related tables when data in either table is updated.
A)True
B)False
Answer: False
Q3) In the accompanying figure, the ____ is indicated by the red brackets.
A) Design view
B) Field Properties pane
C) Datasheet view
D) Relationship pane
Answer: B
Q4) The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.
Answer: Single
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Maintaining and Querying a Database
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38991
Sample Questions
Q1) The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.
A)aggregate functions
B)Zoom box
C)theme
D)logical operators
E)comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)query
Answer: H
Q2) The + symbol is an example of a(n) ____ operator.
A) arithmetic
B) logical
C) comparison
D) calculation
Answer: A
To view all questions and flashcards with answers, click on the resource link above.
Page 5
Chapter 4: Creating Forms and Reports
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38992
Sample Questions
Q1) The Report Wizard allows detail records to be <u>sorted</u> by up to four fields.
A)True
B)False
Q2) A form's object name appears on the tab for the form in the Access window.
A)True
B)False
Q3) By default, data in the reports created by Carmen will be grouped by ____.
A) ParticipantID
B) LocationSite
C) table
D) subtable
Q4) When using a wildcard character in the Find and Replace dialog box, it is necessary to select the <u>Any Part of Field</u> Match option. ____________________
A)True
B)False
Q5) Why is it important to use Print Preview before printing a report in Access?
Q6) A placeholder used in a value search when only part of a value is known is called a ____________________ character.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Essential Computer Concepts
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38993
Sample Questions
Q1) ____ is space on Windows Live servers where you can store up to 25 GB of files in public or private folders, or in folders that you make available to only people you specify.
A) HotDrive
B) MS Docs
C) i-Live
D) SkyDrive
Q2) Re-recordable DVDs come in two formats, ____________________ and DVD-RW.
Q3) A(n) ____________________ site is a website set up to look exactly like another website, but which does not actually belong to the organization portrayed in the site.
Q4) Harvey has purchased all the following software (among others). Which of these four programs is a different category than the other three?
A) Norton Utilities
B) Microsoft Office
C) Adobe Premier
D) Adobe Director
Q5) Name and describe the various pointing devices mentioned in the chapter.
Q6) The software that helps you navigate the web is called ____________________.
Q7) The term GB stands for ____________________.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38994
Sample Questions
Q1) Ctrl + G is used to access the ____.
A) Go to Next worksheet command
B) G column
C) Go to a location in the worksheet command
D) formula view
Q2) To move the active cell up one row, press ____.
A) Shift + Enter
B) Ctrl + Tab
C) Shift + Tab
D) Ctrl + Enter
Q3) In the figure above, Box 1 points to the formula =F13*G13 in the ____.
A) address box
B) address bar
C) formula box
D) formula bar
Q4) ____________________ view shows how the worksheet will appear when printed.
Q5) Column width is expressed in terms of the number of characters a column can contain or the size of the column in <u>points</u>. _________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38995
Sample Questions
Q1) One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
A) Master
B) Gallery
C) Palette
D) Painter
Q2) Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data?
A) abbreviate all text
B) change the font style
C) choose Wrap text for the columns
D) delete one column
Q3) A(n) ____________________ is a key that shows each color used in the worksheet and what it means.
Q4) A(n) ____________________ is text printed in the top margin of each page.
Q5) After you merge a range into a single cell, you cannot realign its content.
A)True
B)False
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Calculating Data With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38996
Sample Questions
Q1) The <u>WORKDAY</u> function displays the date of the weekday a specific number of weekdays past a starting date.
A)True
B)False
Q2) One way to perform a _________ is by changing one or more of the input values
To see how they affect the calculated results.
A) goal seek
B) gunction
C) search
D) what-if analysis
Q3) Using AutoFill, what would be the extended series of the initial entry Jan? ___
A) uary
B) Feb, Mar, Apr
C) Kan, Lan, Man, Nan
D) Jan1, Jan2, Jan3,
Q4) A(n) ____________________ reference contains both relative and absolute references.
Q5) A <u>lookup table</u> organizes numbers or text into categories. _____________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38997
Sample Questions
Q1) You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.
A) Format Data Labels
B) Format Legend
C) Format Chart Area
D) Format Axis
Q2) In pie charts, it's best to make the slice colors as similar as possible.
A)True
B)False
Q3) Placing a chart in a ____ displays only the chart and no worksheet cells.
A) new worksheet
B) tabbed view
C) graph display
D) chart sheet
Q4) The goal of a ______ is to convey the maximum amount of information within a very small space.
Q5) Each data source is a collection of ____________________, which is a range of values plotted as a single unit on a chart.
Q6) Each value from a data series is represented by a ________.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Exploring the Basics of Windows 8
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38998
Sample Questions
Q1) When using the Search menu, the ____________________ category is selected by default.
Q2) The Start screen contains multiple colored rectangles called ____, which represent applications and other resources your computer can access
A) tiles
B) widgets
C) biscuits
D) charms
Q3) You use Charms Tab buttons to identify and work with open desktop applications.
A)True
B)False
Q4) If you are using a touch screen, the movements you make with your fingers on the screen are known as ____________________.
Q5) If a button on an application's ribbon displays only an icon and not the button name, you can point to the button to display a ScreenTip.
A)True
B)False
Q6) You open the Search menu from the ____________________ bar.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Integrating Word, Excel, Access, and Powerpoint
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/38999
Sample Questions
Q1) When pasting an Excel chart into a Word document, using the ____ button makes the formatting the same as the Word document's and keeps the source file separate.
A) Keep Source Formatting & Embed Workbook
B) Use Destination Theme & Embed Workbook
C) Link & Use Destination Styles
D) Link & Keep Source Formatting
Q2) A link between two files can be broken.
A)True
B)False
Q3) Juliet wants to place an Excel chart into Word. Her best option would be to ____.
A) link it
B) embed it
C) insert it as a picture
D) not enough information to say
Q4) When PowerPoint creates slides from a Word outline, each outline paragraph given the Heading 1 style becomes the title of a new slide.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Internet Basics and Information Literacy
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39000
Sample Questions
Q1) The term "web" is short for ____.
A) World Wide Web
B) Global Network Web
C) Wide Area Web
D) Global Interweb
Q2) Claiming someone else's work as your own is an ethical and a legal violation.
A)True
B)False
Q3) A search ____ is the translation of your original question into a form that a search engine can understand.
A) context
B) matrix
C) function
D) query
Q4) Popular search engines including Google, Bing, and Yahoo!
A)True
B)False
Q5) What is a copyright? What does a copyright protect? In the US, what are some of the stipulations of the 1976 Copyright Act?
Page 14
Q6) MLA stands for ____________________ Association.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Introduction to Cloud Computing
Available Study Resources on Quizplus for this Chatper
50 Verified Questions
50 Flashcards
Source URL: https://quizplus.com/quiz/39001
Sample Questions
Q1) Using the SkyDrive app from the Start screen, to download a file from your SkyDrive, ____ the file and click Download on the bar that pops up.
A) double-click
B) right-click
C) alt-click
D) click
Q2) Each tile in your SkyDrive web browser window represents a(n) <u>folder</u>.
A)True
B)False
Q3) Office Web Apps include limited versions of all of the following Microsoft programs EXCEPT ____.
A) Word
B) OneNote
C) PowerPoint
D) Outlook
Q4) To subscribe to Office 365, you need a Microsoft account.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39002
Sample Questions
Q1) Printed documents use ____ to separate locations in a file path.
A) backslashes
B) arrows
C) colons
D) periods
Q2) The folder that contains the Windows 8 operating system is located in the level marked by box ____ in the accompanying figure.
A) A
B) B
C) C
D) D
Q3) The left pane of the File Explorer window is the ____ pane.
A) status
B) address
C) structure
D) navigation
Q4) Every file you save must have a storage location and a(n) <u>filename</u>.
A)True
B)False
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Creating a Presentation
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39003
Sample Questions
Q1) Ivan tells Kamilla that the first slide of her presentation will be the ____ slide.
A) Title
B) Entrance
C) Insertion
D) Animation
Q2) There are ____ text placeholders on the Title slide.
A) 2
B) 3
C) 4
D) 5
Q3) Kamilla has run out of room on her computer's hard drive, so Ivan helps her upload The file to her account on ____, Microsoft's free online storage area.
A) SkyView
B) SkyDrive
C) CloudView
D) CloudDrive
Q4) Please briefly describe a bulleted list, a numbered list, and an unnumbered list.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Adding Media and Special Effects
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39004
Sample Questions
Q1) Both shapes and pictures, such as photos and clip art, are treated as ____________________ in PowerPoint.
Q2) Referring to the accompanying figure, if you click the ____ option on the Start menu, your animation starts when you advance the slide show. A) With Previous B) After Previous C) On Click D) Reorder Animation
Q3) When you use ____________________ rows or columns, alternating rows or columns are filled with different shading.
Q4) The default transition is for one slide to disappear and the next slide to immediately appear on the screen.
A)True
B)False
Q5) Each cell in a table contains two pieces of information. A)True
B)False
Q6) To make a slide transition faster, decrease the ____________________.
Q7) The ____________________ is the formatting of the area inside a shape.
Page 18
To view all questions and flashcards with answers, click on the resource link above.
Chapter 17: Creating and Editing a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39005
Sample Questions
Q1) Which keystroke(s) should you use to move the insertion point to the end of the line you are currently on?
A) End
B) Page Up
C) Ctrl+Home
D) Alt+Ctrl+Page
Q2) A _______ is a set of characters that uses the same typeface.
A) font
B) theme
C) style
D) format
Q3) To select an entire document, <u>double-click</u>. in the white space to the left of the document text. ____________________
A)True
B)False
Q4) <u>Landscape</u> orientation is the default page orientation for Word documents.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 18: Navigating and Formatting a Document
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39006
Sample Questions
Q1) To access square bullets, click the ____ to access the full gallery of bullet styles.
A) Bullets button arrow
B) Bullets key menu
C) Show all tab
D) Options box
Q2) Heading 1 is the highest level used for the major headings in a document and applies the most noticeable formatting.
A)True
B)False
Q3) Click the ____ in the Clipboard group to open the Clipboard task pane.
A) Dialog Box Launcher
B) HOME tab
C) Format Painter
D) View All
Q4) Clicking the button indicated by item 2 in the accompanying figure would ____.
A) move the paragraph to the left
B) move the paragraph to the right
C) move the document to the right
D) move the document to the left
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 19: Creating Tables and a Multipage Report
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39007
Sample Questions
Q1) To delete the structure of a row, column, or table, select the row, column, or table, and then use ____.
A) the Delete button on the keyboard
B) the Backspace button on the keyboard
C) the Redo command
D) the Delete button in the Rows & Columns group
Q2) An explanatory comment or reference that appears at the end of a document
A)record
B)footnote
C)endnote
D)header
E)footer
F)reference marker
G)header row
H)sort
I)tab stop
J)section
Q3) Tabs and tables offer different advantages for aligning text. Explain the advantages of tabs and of tables. When would you use each method?
To view all questions and flashcards with answers, click on the resource link above.
21
Chapter 20: Enhancing Page Layout and Design
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/39008
Sample Questions
Q1) To format an entire document in columns, click Columns button in the Page Setup group on the <u>INSERT</u> tab and then click the number of columns you want in the Column gallery. _________________________
A)True
B)False
Q2) To quickly format a document in columns, click the Columns button on the _______ tab.
A) PAGE LAYOUT
B) DESIGN
C) FORMAT
D) HOME
Q3) A(n) <u>paragraph</u> border frames the contents of a single page.
A)True
B)False
Q4) A(n) ____________________ is a large letter that begins the text of a paragraph.
Q5) To insert special characters in Word, choose the Special Characters tab from the ____________________ dialog box.
Q6) Options for setting a page border
Page 22
To view all questions and flashcards with answers, click on the resource link above.