Excel Practice Test UPDATED Actual Exam Questions and CORRECT Answers
6 views 0 purchase
Course
Excel
Institution
Excel
Excel Practice Test UPDATED Actual
Exam Questions and CORRECT Answers
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? -
CORRECT ANSWER- Open
Which command among the window control buttons is used to close an open file and
completely exit the Microsoft...
Excel Practice Test UPDATED Actual
Exam Questions and CORRECT Answers
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? -
CORRECT ANSWER✔✔- Open
Which command among the window control buttons is used to close an open file and
completely exit the Microsoft Excel program? - CORRECT ANSWER✔✔- Close
Which ribbon option opens a related dialog box? - CORRECT ANSWER✔✔- Launcher
What command do you you to increase or decrease the view of a selected cell or range of
cells to fill the Excel Window area for better visibility? - CORRECT ANSWER✔✔- Zoom
to Selection
What occurs when the cursor is moved over a cell and a user clicks? - CORRECT
ANSWER✔✔- The cell is selected
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? -
CORRECT ANSWER✔✔- Key Tips
Which notebook-like feature organizes the sheets for use in Excel? - CORRECT
ANSWER✔✔- Workbook
Which view is the default view used in Microsoft Excel? - CORRECT ANSWER✔✔-
Normal
Sharon's spreadsheet contains information about the number of music downloads in F25. In
this address, '25' identifies the: - CORRECT ANSWER✔✔- row
What command will arranged Microsoft Excel windows so that they appear side-by-side on
the screen? - CORRECT ANSWER✔✔- Arrange All
, What is the name of the list of frequently used Excel commands available when a user right-
clicks an item in the worksheet? - CORRECT ANSWER✔✔- Shortcut Menu
Which command on the Home ribbon allows data to be moved from one worksheet location
to another? - CORRECT ANSWER✔✔- Cut
What is the process of using the mouse to move or copy cells called? - CORRECT
ANSWER✔✔- Drag and Drop
John wants to print only the Inventory worksheet that he is currently working on in his
workbook. Which option should he choose? - CORRECT ANSWER✔✔- Print Active Sheet
Which command on the Fill options dialog box is the default option if a month or day is
entered? - CORRECT ANSWER✔✔- Fill Series
Alicia needs to delete the data in cells B5. Which command would she select - CORRECT
ANSWER✔✔- Clear
Which would be used to help organize and identify Microsoft Excel files by providing details
about the files? - CORRECT ANSWER✔✔- Document properties
When entering data into a cell, which keyboard key is used to remove characters to the left of
the insertion point? - CORRECT ANSWER✔✔- Backspace Key
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? - CORRECT ANSWER✔✔- Fill
Handle
Joyce has updated the data in an existing spreadsheet. Which command would she select to
preserve the data for future use? - CORRECT ANSWER✔✔- Save
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.