Spreadsheet Applications Exam Review
Course Introduction
Spreadsheet Applications introduces students to the fundamental concepts and practical skills necessary to utilize spreadsheet software effectively in both academic and professional settings. The course covers data entry and formatting, formula creation, use of functions, chart and graph generation, data analysis tools such as sorting, filtering, and pivot tables, and the design of user-friendly spreadsheets.
Emphasis is placed on real-world problem-solving and decision-making using spreadsheets, enabling students to organize data, perform calculations, automate tasks, and present information clearly and efficiently. No prior experience with spreadsheet software is required, making this course accessible to beginners.
Recommended Textbook
New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons
Available Study Resources on Quizplus
13 Chapters
1319 Verified Questions
1319 Flashcards
Source URL: https://quizplus.com/study-set/1082
2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21371
Sample Questions
Q1) In the figure above,which box displays the highlighted cells used in the function?
A)1
B)3
C)5
D)6 Answer: B
Q2) The worksheet is organized into individual cells.
A)True
B)False
Answer: True
Q3) Every function follows a set of rules,or \(\underline { \text { syntax } }\),which specifies how the function should be written._________________________
A)True
B)False
Answer: True
Q4) Speed Fill enters text based on patterns it finds in the data.
A)True
B)False Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21372
Sample Questions
Q1) In a workbook's theme,_____ colors are designated for text and background,_____ colors are used for accents and highlights,and _____ colors are used for hyperlinks.
A)Four, two, six
B)Two, four, six
C)Four, six, two
D)Six, four, two
Answer: C
Q2) Antoinette wants to be sure that her worksheet does not contain any duplicates.She will use the highlight cells rule _____ to check for this.
A)Equal to
B)Between
C)Duplicate Values
D)A Date Occurring
Answer: C
Q3) A(n)____________________ is text printed in the top margin of each page. Answer: header
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: 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/21373
Sample Questions
Q1) Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.
A)Data Validation
B)Goal Seek
C)Goal Set
D)If Conditional
Answer: B
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
Answer: D
Q3) An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.
Answer: approximate match lookup
To view all questions and flashcards with answers, click on the resource link above.
5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21374
Sample Questions
Q1) When combination charts have data series with vastly different values,you can create ____ charts.
A)dual axis
B)secondary
C)multivalued
D)multiple axis
Q2) The cell with the largest value contains a \(\underline { \text { data marker } }\)that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________
A)True
B)False
Q3) Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.
A)FORMAT
B)EDIT
C)DESIGN
D)LAYOUT
Q4) Describe the some of the concepts and definitions associated with loans before using a PMT function.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21375
Sample Questions
Q1) ____ order arranges labels in reverse alphabetical order,from Z to A.
A)Reverse
B)Major
C)Ascending
D)Descending
Q2) In the figure above,if you only want to set one criterion for this filter,you will ____.
A)leave the lower boxes empty
B)enter "0" into the lower boxes
C)enter "none" into the lower boxes
D)access a pull-down menu of options
Q3) You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.
A)Or
B)Both
C)And
D)Either
Q4) To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21376
Sample Questions
Q1) Which of the following is NOT an option for arranging your workbooks?
A)tiled
B)cascade
C)horizontal
D)lateral
Q2) Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?
A)Family Budget
B)Inventory List
C)Team Roster
D)Fax Cover Sheet
Q3) When Ryder goes to save the workbooks,what is the required file extension?
A)wxls
B)xlww
C)xlsx
D)xlwx
Q4) Using multiple worksheets makes it more difficult for you to group your data.
A)True
B)False
Q5) ____________________ appear whenever you place the pointer over a hyperlink.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21377
Sample Questions
Q1) Defined names are automatically substituted for existing range references in a formula.
A)True
B)False
Q2) Property that determines whether or not changes can be made to a cell
A)Stop
B)Warning
C)Information
D)locked
E)macro
F)VBA
G)defined name
H)input message
I)validation rule
J)digital certificate
Q3) _____ messages appear as ScreenTips next to the active cell.
A)Value
B)Input
C)Key
D)User
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21378
Sample Questions
Q1) The ____________________ error value means that the formula or function contains a number divided by 0.
Q2) When you want to reference an entire column of data in a table,you create a column
A)label
B)name
C)variable
D)qualifier
Q3) If you are not sure of a table's name,click in the table,click the _____ tab on the Ribbon,and then click the Table Name box in the Properties group.
A)LAYOUT
B)FORMAT
C)TABLE TOOLS DESIGN
D)STRUCTURED REFERENCES
Q4) If any logical condition listed in the function is true,the \(\underline{\text { AND }}\) function returns a TRUE value._________________________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21379
Sample Questions
Q1) You can use the ____________________ Window to view the impact of a changing value in one worksheet on the cell values in the other cells.
Q2) One simple measure of the return from an investment is the ____________________ period,which is the length of time required for an investment to recover its initial cost.
Q3) Calculates the payment in each period required to pay off a loan or reach an investment goal
A)PPMT function
B)rate of return
C)IPMT function
D)IRR
E)PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function
Q4) A red tracer arrow indicates that an error has been received from the ____________________ cell or passed to the dependent cell.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What If Analyses
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21380
Sample Questions
Q1) The ____________________ input cell is the cell on which values placed in the first column of the data table are based.
Q2) Aria explains to you that if you want to use Solver to maximize a company's net income,you first need to understand that a(n)_______ is a cell that is maximized,minimized,or set to a specific value.
A)goal cell
B)objective cell
C)changing cell
D)constraint
Q3) CVP analysis is sometimes called \(\underline { \text { breakthrough } }\)analysis._________________________
A)True
B)False
Q4) In Solver,changing cells are sometimes referred to as _______ cells.
A)self-adjusting
B)variable
C)key
D)constraint
Q5) ____________________ constraints always show a slack of 0.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Connecting to External Data
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/21381
Sample Questions
Q1) A data _______ is any file that contains the data you want to retrieve.
A)roster
B)link
C)dialog
D)source
Q2) One way to structure text files is to use a(n)_______.
A)index
B)matrix
C)delimiter
D)register
Q3) The general form of a URL for a file located on your computer will be _______.
A)file:///drive:/path/filename
B)file://drive://path/filename
C)file://drive:/path//filename
D)file:///drive:///path///filename
Q4) The accompanying figure illustrates an example of \(\underline { \text { space-delimited } }\)text._________________________
A)True
B)False
Q5) What are the steps to filter data in a query?
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/21382
Sample Questions
Q1) Describe the steps to review tracked changes in a shared workbook.
Q2) Word _______ a linked object every time you open the Word document or any time the Excel source file changes while the Word document is open.
A)updates
B)changes
C)copies
D)saves
Q3) The item marked 1 in the accompanying figure is checked to _______.
A)allow individual editing of the workbook
B)allow simultaneous editing of the workbook
C)allow alternate editing of the workbook
D)allow consecutive editing of the workbook
Q4) Once workbook sharing is removed,the contents of the tracking log are _______,and there is no way to retrieve the history of edits made to the document.
A)saved
B)copied
C)erased
D)backed up
Q5) What are the steps to filter data in a query?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Your Files
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/21370
Sample Questions
Q1) When you move a folder,you also move all of the files contained in the folder.
A)True
B)False
Q2) You can switch to Details view or Large icons view in File Explorer by using the view buttons on the status bar.
A)True
B)False
Q3) Level \(\underline { 4 }\) of the Windows 8 file system includes a folder for your user account,such as the User folder._________________________
A)True
B)False
Q4) Lastly,James wants to know how you display a listing of all the apps currently open on a Windows 8 machine,on a touch screen.You tell him simply to ____.
A)swipe from the right edge of the screen toward the center
B)swipe from the left edge of the screen toward the center
C)move two fingers apart in the center of the screen
D)triple-tap the screen
Q5) In order to use SkyDrive,you need to have a(n)____________________ account.
To view all questions and flashcards with answers, click on the resource link above. Page 15