Exam (elaborations)
Excel Final Exam Review 2023/2024 ( graded A+ 100% verified)
- Course
- Institution
Excel Final Exam Review 2023/2024 ( graded A+ 100% verified)
[Show more]
Content preview
Excel Final Exam ReviewWhich group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula
Bar, or headings? - ANSB. Show
Which of the following notebook- like features organizes the sheets for use in Excel? - ANSA.
Workbook
Which view enables a user to create or modify a worksheet while seeing how it will look in
printed format? - ANSA. Page Layout
Which of the following would you use to enter, calculate, manipulate, and analyze data such as
numbers and text in Excel? - ANSB. Worksheet
John wants to be able to view multiple areas of his spreadsheet at the same time. What would
be his best option? - ANSB. Split
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will
take her to the last record on her spreadsheet? - ANSB. Ctrl + End
What occurs when the cursor is moved over a cell and a user clicks? - ANSB. The cell is
selected
Which tab do you use to display the area that contains the print command? - ANSD. File
Which area, on the left side of the formula bar, can you look at to determine the cell address of a
selected cell? - ANSC. Name box
Which Microsoft Office object would you use for quick, convenient, one-click access to
frequently used Excel commands? - ANSA. Quick Access Toolbar(QAT)
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
- ANSB. Open
Joan has a table that includes demographic information about her employees. What does all the
information about one employee represent? - ANSC. Row
Which of the following software programs is a powerful spreadsheet program that allows users
to organize data, complete calculations, and graph data? - ANSC. Excel
Which view is the default view used in Microsoft Excel? - ANSC. Normal
,Which ribbon option opens a related dialog box? - ANSC. Launcher
What command do you use to increase or decrease the view of a selected cell or range of cells
to fill the Excel Window area for better visibility? - ANSD. Zoom to Selection
What feature was created for users who prefer to use the keyboard rather than the mouse, and
provides keyboard code icons that may be used in conjunction with the ALT key? - ANSD. Key
Tips
Sharon's spreadsheet contains information about the number of music downloads in F25. "25"
identifies the: - ANSD. Row
What command will arrange Microsoft Excel windows so that they appear side by side on the
screen? - ANSC. Arrange All
Joan has entered her name in the First Name field in cell B2 of her table. What does her First
Name represent in the table? - ANSA. Entry
Which command do you use to close an open file and completely exit the Microsoft Excel
program? - ANSC. Exit
In Microsoft Excel, which feature makes an exact replica of the cell data and format while
keeping the original cell intact?
A. Paste B. Move C. Cut D. Copy - ANSD. Copy
Sharon's spreadsheet contains information about the number of music downloads in
F1:F25.F1:F25 represents a:
A. Cell B. Column C. Range D. Row - ANSC. Range
When entering data into a cell, which keyboard key is used to remove characters to the left of
the insertion point?
A. Delete key B. Backspace Key C. Left arrow key D. Enter key - ANSB. Backspace key
Joan is creating a table that will include demographic information about her employees. What is
each header in her table considered?
A. Label B. Value C. Formula D. Function - ANSA. Label
What is the name of the list of frequently used Excel commands available when a user
right-clicks an item in the worksheet?
A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu
D. Shortcut Toolbar - ANSC. Shortcut Menu
John wants to print only the Inventory worksheet that he is currently working on in his workbook.
Which option should he choose?
, A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page -
ANSB. Print Active Sheet
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same
characters as a previous entry?
A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell - ANSA. AutoComplete
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command
should he use to complete this task?
A. AutoFill B. Filter C. Find and Replace D. Sort - ANSA. AutoFill
What is the name of the small black square in the lower-right corner of the heavy border of an
active cell that repeats a cell's value in adjacent cells?
A. Fill handle B. Filler C. Copy handle D. Copy box - ANSA. Fill handle
Which command on the Fill options dialog box is the default option if you enter a month or day?
A. Copy Cells B. Fill Formatting Only C. Fill without Formatting D. Fill Series - ANSD. Fill Series
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted
as a group?
A. Segment B. Set C. Range D. Cluster - ANSC. Range
Jennifer needs to identify the values in column B for a sales report. Which type of entry should
she use in the column header?
A. Values B. formulas C. labels D. functions - ANSC. labels
What is the process of using the mouse to move or copy cells called?
A. Click and paste B. Drag and move C. Dragging D. Drag and Drop - ANSD. Drag and Drop
To help organize and identify Microsoft Excel files by providing details about the files, which of
the following would you use?
A. File details B. Document Properties C. File facts D. Document options - ANSB. Document
properties
Joyce has updated the data in an existing spreadsheet. Which command would she select to
preserve the data for future use?
A. Exit B. Open C. Save D. Save As - ANSC. Save
Alicia needs to delete the data in cell B5. Which command would she select?
A. Clear B. Copy C. Cut D. Format Painter - ANSA. Clear
Alicia needs to move the date in cell B5 to cell E5. Which command would she select?
A. Clear B. Copy C. Cut D. Format Painter - ANSC. Cut
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Ashley96. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now