Spreadsheet Fundamentals
Practice Questions
Course Introduction
Spreadsheet Fundamentals introduces students to the essential concepts and practical skills required to effectively use spreadsheet software for data organization, analysis, and presentation. The course covers foundational topics such as data entry, formatting, formula creation, and the use of basic functions to perform calculations. Students will learn how to manage datasets, create and interpret charts and graphs, and implement best practices for data integrity. By completing hands-on exercises and real-world scenarios, students will gain confidence in using spreadsheets for academic and professional tasks, preparing them for more advanced data management and analysis.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
13 Chapters
1286 Verified Questions
1286 Flashcards
Source URL: https://quizplus.com/study-set/1601 Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31798
Sample Questions
Q1) Using ________ often decreases the amount of time it takes to enter cell references in formulas.
Answer: semi-selection,semi selection
Q2) Use the Find command to jump to a cell that is not currently visible.
A)True
B)False
Answer: False
Q3) Besides the Page Setup dialog box,where else can you create headers or footers?
A)Page Layout tab,Text group,Header & Footer
B)Insert tab,Text group,Header & Footer
C)Home tab,Text group,Header & Footer
D)View tab,Text group,Header & Footer
Answer: B
Q4) You should use ________ in formulas whenever possible instead of static numbers.
Answer: cell references
Q5) Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31799
Sample Questions
Q1) ________ references change when formulas are copy and pasted. Answer: Relative,Mixed
Q2) Which of the following is not a valid =IF statement?
A)=IF(A5>19,"Greater","Not Greater")
B)=IF(A5>19,b7,b9)
C)=IF(A5>19,1,9)
D)=IF(A5>19,Greater,Not Greater)
Answer: D
Q3) When working with dates,Excel actually assigns ________ numbers to each date. Answer: serial
Q4) What will you see if you enter the TODAY function without the parenthesis?
A)#VALUE?
B)Nothing.It will fill in the parenthesis for you. C)#FUNCTION?
D)#NAME?
Answer: D
Q5) The test argument in an IF statement must evaluate to either ________. Answer: True or False,False or True
Q6) The MIN and MAX functions can be used with ________ as well as numbers. Answer: dates,variables,arguments,expressions
Page 4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31800
Sample Questions
Q1) What icon is not displayed when you select a chart?
A)Chart Elements
B)Chart Types
C)Chart Styles
D)Chart Filters Answer: B
Q2) A bar chart uses ________ bars. Answer: horizontal
Q3) What is not found on the Chart Elements List?
A)Chart Type
B)Data Table
C)Gridlines
D)Legend Answer: A
Q4) Which tab displays the tools for creating charts?
A)View
B)Chart
C)Insert
D)Data Answer: C
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31801
Sample Questions
Q1) When you have frozen rows and columns,what happens when you press the Ctrl+Home combination?
A)A1 becomes the active cell.
B)Column A and whatever row was active when you pressed the combination becomes the active cell.
C)Row 1 and whatever column was active when you pressed the combination becomes the active cell.
D)The first unfrozen cell becomes the active cell.
Q2) Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.
A)True
B)False
Q3) Which table style option shows the field names when it is checked?
A)Header Row
B)Total Row
C)First Column
D)Banded Columns
Q4) In Page Break Preview,the area to be printed has a light blue background.
A)True
B)False
Page 6
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Subtotals, Pivot-tables, and Pivot-charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31802
Sample Questions
Q1) Where would you access the Manage Relationships dialog box to create a data model in Excel?
A)Relationships on the Data tab
B)Data Models on the Analyze tab
C)Layout on the Design tab
D)Joins on the Data tab
Q2) If you have related data stored in multiple tables,create a(n)________ to create a PivotTable on the combined data
A)Access link
B)data collection
C)Excel table
D)data model
Q3) In a PivotTable Fields task pane,the ________ filters the data to display results based on particular conditions you set.
Q4) The calculation option which displays the values of a specific field from greatest to least is Rank ________.
Q5) A PivotChart has live updates as you change the PivotTable.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
92 Verified Questions
92 Flashcards
Source URL: https://quizplus.com/quiz/31803
Sample Questions
Q1) A(n)________ is a rule that Solver must enforce to reach the objective value.
A)binding constraint
B)non-binding constraint
C)objective
D)solving method
Q2) Goal Seek changes multiple variables to reach the optimal goal
A)True
B)False
Q3) Use Paste Names to document a list of all named ranges in a workbook.
A)True
B)False
Q4) If you would like to determine how many bags of popcorn to sell at a profit margin of $5 to raise $100 and have no constraints,which what-if analysis tool should you choose?
Q5) ________ analysis enables you to compare how changes affect a related outcome.
Q6) Goal Seek would be the best what-if analysis tool to use to discover the necessary interest rate to keep your car payment below $500 per month.
A)True
B)False
Q7) Scenario manager is on the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31804
Sample Questions
Q1) The MONTH function would return 25 when used on a cell containing August 25,2018.
A)True
B)False
Q2) The real functionality of MATCH and INDEX functions comes from nesting them.
A)True
B)False
Q3) If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date,which formula would provide the correct result?
A)=DAYS(End_Date,Start_Date)
B)=DAYMONTH(Start_Date)
C)=IF(DAYMONTH(Start_Date)<31,Start_Date,1)
D)=DAY(Start_Date)
Q4) If you need to find out how many days between two dates,which function would you use?
A)DAY
B)DAYS
C)DAYSBETWEEN
D)EDATE
To view all questions and flashcards with answers, click on the resource link above.
9
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31805
Sample Questions
Q1) The Significance argument in a PERCENTRANK function is the input for confidence intervals.
A)True
B)False
Q2) Which of the following represents the number of data points in a sample minus one?
A)F ratio
B)Probability
C)Degrees of Freedom
D)Critical value
Q3) What are the two arguments for the FREQUENCY function?
A)data_array,correlation_array
B)data_array,bins_array
C)data_array,set_value
D)data_array,outlier
Q4) ________ statistics help analyze differences between groups and relationships within groups of data.
Q5) The Analysis ToolPak is available on the Insert Tab.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/31806
Sample Questions
Q1) The formula =B2*B7 is located in cell C7.Which cell is the dependent cell?
A)B2
B)C7
C)B3
D)B7
Q2) By default,automatic updates are ________ to protect the destination file from virus infection
Q3) The user can define an optional ________ that appears when the mouse pointer hovers over a hyperlink.
Q4) A Warning error style prevents the user from entering invalid data.
A)True
B)False
Q5) Which of the following is an example of Pascal Case notation.
A)pascalCaseNotation
B)PascalCaseNotation
C)pascal_case_notation
D)Pascal Case Notation
Q6) ________ locks 2 windows together and enables you to view them line by line as you scroll through them.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Q7) The ________ function checks a cell to determine if the cell contains an error.
Chapter 10: Imports, xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/31807
Sample Questions
Q1) ________ is a standalone desktop application that has Power View functionality outside of Excel
Q2) Which of the following are settings that control how imported data in cells connect to their source data?
A)Import settings
B)Data range properties
C)Link settings
D)Data Control settings
Q3) The return of the RIGHT function is always a number.
A)True
B)False
Q4) Which of the following functions is not a text string manipulation tool?
A)CONCATENATE
B)MATCH
C)TRIM
D)LEFT
Q5) There are 27 Text string manipulation functions.
A)True
B)False
Q6) The ________ is the area that contains the dashboard in Power View.
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/31808
Sample Questions
Q1) Current Excel files are based on XML.
A)True
B)False
Q2) You can export Quick Access Toolbar settings to other users.
A)True
B)False
Q3) A shared workbook cannot be merged using the Compare and Merge Workbooks tool.
A)True
B)False
Q4) A cell that contains a comment is marked with a green triangle.
A)True
B)False
Q5) Merge Cells is available while change tracking is turned on.
A)True
B)False
Q6) Use the ________ to make sure your files are backwardly compatible.
Q7) A(n)________ is a note to a collaborator containing questions or suggestions about the workbook.
Page 13
Q8) The Office ________ controls the overall appearance and color of the interface of Office.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 12: Templates, styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/31809
Sample Questions
Q1) What color are comments in VBA?
A)Black
B)Green
C)Red
D)Blue
Q2) A(n)________ is a partially completed document that you use as a model to create other documents that have the same structure and purpose.
Q3) What file extension do templates use?
A).xlsx
B).xlsm
C).xltx
D).xlsb
Q4) Use these instead of numbers in formulas in templates whenever possible.
A)Cell references
B)Functions
C)Styles
D)Text
Q5) Delete macros in the ________ dialog box.
Q6) Data and Model,Titles and Headings,and Good,Bad,and Neutral are examples of predefined Cell ________.
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Office 2016 Common Features
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/31797
Sample Questions
Q1) The ________ is used to increase or decrease the size of the document onscreen.
Q2) A(n)________ is a button or area within a group that you click to perform a task.
Q3) You can use Excel to organize records,financial transactions,and business information in the form of worksheets.
A)True
B)False
Q4) A(n)________ consists of one or more lines at the top of each page.
Q5) A(n)________ is a predesigned file that integrates formatting elements,such as a theme and layouts.
Q6) Bold and Italic are examples of toggle command buttons.
A)True
B)False
Q7) The status bar identifies the current file name and the application in which you are working.
A)True
B)False
Q8) When you ________ a selection,the selection in the Clipboard is placed into another location.
Q9) Microsoft's cloud storage is called ________ .
To view all questions and flashcards with answers, click on the resource link above. Page 16