Introduction to Excel Practice Questions
Course Introduction
Introduction to Excel is designed to familiarize students with the fundamental features and functions of Microsoft Excel, a leading spreadsheet application widely used in business, finance, and data analysis. The course covers essential skills such as data entry, formatting, basic formulas and functions, chart creation, and data organization. Through hands-on exercises, students learn how to navigate the Excel interface, manage worksheets, and leverage tools to analyze and present data effectively. By the end of the course, students will have the practical knowledge necessary to perform common spreadsheet tasks and support data-driven decision making in academic or professional settings.
Recommended Textbook
New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st Edition by June Jamrich
Available Study Resources on Quizplus
13 Chapters
935 Verified Questions
935 Flashcards
Source URL: https://quizplus.com/study-set/2189
2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43584
Sample Questions
Q1) ____________________ removes the data from the row or column as well as removes the row or column itself.
Answer: Deleting
Q2) Hides a window so that only its program button is visible on the taskbar.
A)function
B)Name box
C)worksheet
D)range
E)order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template
Answer: I
Q3) The worksheet is organized into individual cells._________________________
A)True
B)False
Answer: True
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) Put the following five steps in the order in which you would perform them to use the Paste Special function.?1.Select and copy a range.?2.Click the Paste button arrow in the Clipboard group on the HOME Tab.?3.Specify exactly what you want to paste.?4.Click Paste Special to open the dialog box.?5.Select the range where you want to paste the Clipboard contents.
A) 1, 2, 4, 3, 5
B) 1, 2, 4, 5, 3
C) 1, 5, 2, 4, 3
D) 1, 5, 2, 3, 4
Answer: C
Q2) Harold needs to format several cells with 11pt Calibri font,two decimal places,right-aligned,and a blue font color.The most efficient way to accomplish this would be to _____.
A) use Format Painter
B) format each element using the Toolbar
C) select all cells and use the Formatting dialog box
D) apply a table style
Answer: A
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. Page 4
Chapter 3: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43586
Sample Questions
Q1) In the formula =IF(A1=B1,C1,C2),the result will be C2 if ____.
A) A is equal to B
B) A does not equal B
C) A1+B1 is equal to C1
D) A1>B1 is equal to C2
Answer: B
Q2) ____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
A) Absolute
B) Relative
C) Mixed
D) Matched
Answer: C
Q3) A logical function is a function that works with values that are either ____.
A) right or wrong
B) absolute or relative
C) positive or negative
D) true or false
Answer: D
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43587
Sample Questions
Q1) The ____ identifies which data markers are associated with each data series.
A) x-axis
B) y-axis
C) chart area
D) legend
Q2) To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.
A) CREATE
B) VIEW
C) LAYOUT
D) DESIGN
Q3) ______ are horizontal and vertical lines that help you compare data and category values.
Q4) A ____________ displays data values as columns with the height of each column based on the data value.
Q5) A column chart turned on its side is called a bar chart,with the length of the bar determined by the data value.___________
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Working With Excel Tables, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43588
Sample Questions
Q1) Excel can summarize data in a range of data by inserting subtotals.
A)True
B)False
Q2) A table name cannot include ____.
A) numbers
B) spaces
C) underscores
D) letters
Q3) The first sort field in a sort is called the major sort field.____________________
A)True
B)False
Q4) Which of the following is true about Excel tables (as opposed to structured ranges of data)?
A) You cannot format quickly using a table style.
B) You cannot enter a formula in one table cell that is automatically copied to all other cells in that table column.
C) You cannot add new rows and columns that automatically expand the range.
D) You cannot freeze the top row of the worksheet.
Q5) The entry 20000 is the ____________________ for the first condition.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) To remove a worksheet group,you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.
A) Remove Group
B) No Group
C) Exit Group
D) Ungroup Sheets
Q2) When you reference cells and ranges in other worksheets,if the worksheet name contains spaces,you must enclose the sheet name in ____.
A) braces
B) brackets
C) parentheses
D) single quotation marks
Q3) Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________
A)True
B)False
Q4) To manually ____________________ a link and see the new data values,click the Update Values button.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) Protecting the _____ prohibits users from renaming,deleting,hiding,or inserting worksheets.
A) skeleton
B) structure
C) format
D) location
Q2) To open the Data Validation dialog box,click the Data tab on the Ribbon,and then click Authentication in the Data Tools group._________________________
A)True
B)False
Q3) Based on what she has learned,which of the following would Rina say is a true statement about digital signatures?
A) Adding a digital signature is the first step before you distribute a file.
B) A digital signature is often used to identify the author of a workbook that contains macros.
C) Before you can add a digital ID to a workbook, you need to obtain a digital signature.
D) Digital certificates are usually issued by Microsoft.
Q4) Input messages appear as ____________________ next to the active cell.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
Sample Questions
Q1) All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.
A)True
B)False
Q2) In the Edit Formatting Rule dialog box,click the _____ button to open the Format Cells dialog box.
A) Format Cells
B) Options
C) Format
D) Cell Tools
Q3) Which of the following is an effective alternative for the use of extensive nested IF functions?
A) compare table
B) function table
C) lookup table
D) case table
Q4) Nesting IF functions will allow for three or more outcomes.
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43592
Sample Questions
Q1) To calculate the number of montly payments required to pay off a loan or meet an investment goal,use the _______ function.
A) PMT
B) FV
C) PPMT
D) NPER
Q2) To calculate a series of values from a starting point without a defined ending point,you have to _______ the values.
A) interpolate
B) extrapolate
C) assess
D) plot
Q3) To calculate a declining balance depreciation,use the DVB function.
A)True
B)False
Q4) The function DDB is used to calculate a(n)declining balance depreciation._________________________
A)True
B)False
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) Aside from Solver,other Excel _______ provide the ability to perform statistical analyses,generate business reports,and retrieve financial data from the Internet.
A) parameters
B) add-ins
C) helper applications
D) constraint applications
Q2) {=SUM(B1:B10*C1:C10)} is an example of a(n)_______.
A) array formula
B) TABLE function
C) scenario
D) input value
Q3) The slack is the difference between the value in the cell and the value at the limit of the _______.
A) variable cell
B) result cell
C) constraint
D) risk factor
Q4) How does Goal Seek differ from traditional what-if analysis?
Q5) What are the steps to create a one-variable data table?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Analyzing Data With Business Intelligence
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43594
Sample Questions
Q1) You need at least ____ complete years of data to project a seasonal trend for the next year.
A) One
B) Two
C) Three
D) Four
Q2) A figure is a collection of data arranged in rows and columns.
A)True
B)False
Q3) A query is a request for information from a data source.
A)True
B)False
Q4) One way to interact with a database is with a query language.The most popular query language is _______.
A) ODC
B) UDC
C) OLE
D) SQL
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
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43595
Sample Questions
Q1) Describe the steps to review tracked changes in a shared workbook.
Q2) The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.
A) similar to
B) different from
C) modified from
D) copied from
Q3) To begin Rebecca needs to share her workbook.She will create a shared folder.What would be the best way to distribute the workbook to others?
A) Placing the file on the local drive
B) Placing the file on the cloud
C) Placing the file on flash drive
D) Placing the file on a CD-ROM
Q4) Digital signatures provide a way for the author to authenticate the document by "signing off" on it.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
14
Chapter 13: Working With Text Functions
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/43583
Sample Questions
Q1) Custom formats describe how Excel should display a:
A) Date or number
B) Time
C) Text string
D) All of the above
Q2) The LEN function returns the number of characters in a string.
A)True
B)False
Q3) The UPPER function converts all letters of each word in a text string to uppercase.
A)True
B)False
Q4) This symbol displays Months as 1 through 12:
A) m
B) mm
C) mmm
D) mmmm
Q5) The four most commonly used formats are called special formats.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15