Exam (elaborations)
Excel Exam 2 With 100% Correct And Verified Answers
- Course
- Institution
Excel Exam 2 With 100% Correct And Verified Answers
[Show more]
Content preview
Excel Exam 2 With 100% Correct AndVerified Answers
To move to column A of the active row, - Correct Answer-Home
To move to the first cell of the active worksheet (A1), - Correct
Answer-Ctrl+Home.
activates the next sheet in the workbook, unless the last sheet is the
active sheet. - Correct Answer-Ctrl+PgDn
activates the previous sheet in the workbook, unless the first sheet is
the active sheet. - Correct Answer-Ctrl+PgUp
moves one cell to the right o - Correct Answer-Tab
moves one cell to the left - Correct Answer-Shift+Tab
How do you make a cell to change to editing mode - Correct
Answer-Double-click
By default, numeric values (numbers) appear - Correct Answer-
flush right within a cell
By default, text values (labels) appear - Correct Answer-flush left
within a cell.
Select non-adjacent cells in an Excel spreadsheet by - Correct
Answer-pressing and holding down the Ctrl key while clicking the
individual elements.
How do you display the formula version of your Excel spreadsheet
using the keyboard - Correct Answer-Ctrl+'
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii Vendarsol
, When entering a function, it is not necessary to - Correct Answer-
type in the range of cells used as the argument
You can indicate a range of cells used as the argument by - Correct
Answer-clicking and dragging over the cells.
Press the Esc key to - Correct Answer-Remove the flashing dotted
line from a cell or a cell range without deleting the contents of the
cell.
How do you 'turn off' the extend range function initiated by
pressing - Correct Answer-F8 key
By clicking the right mouse button it reveals a context-sensitive
menu containing several common commands such as - Correct
Answer-Cut, Copy and Paste that you can use on cells that have
been selected.
Can multiple worksheets within one workbook be viewed on-screen
at the same time. - Correct Answer-yes
The horizontal axis on an Excel chart is the - Correct Answer-X-axis
An embedded chart is a - Correct Answer-graphical representation
of worksheet data created within the worksheet rather than as a
separate worksheet.
When Excel examines the data that you have selected to build a
chart, the program assumes that - Correct Answer-the Category (X)
axis runs along the longest side of the selection.
In a spreadsheet, columns are identified by - Correct Answer-letters
In a spreadsheet,rows are identified by - Correct Answer-numbers
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii Vendarsol
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 Vendarsol. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79223 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now