SimNet Exam 1 Already Rated A+
Create a New Workbook from the Backstage View 1. Click the File tab to open Backstage view.
2. Select New on left to display New area in the Backstage view
3. Click blank workbook to create new blank workbook
Save a Workbook with a Different File Name 1. Click...
Create a New Workbook from the Backstage View ✅1. Click the File tab to open Backstage view.
2. Select New on left to display New area in the Backstage view
3. Click blank workbook to create new blank workbook
Save a Workbook with a Different File Name ✅1. Click the File tab to open Backstage
view.
2. Click Save As to display the Save As area.
-When AutoSave is active, click Save a Copy to open the Save As area.
-The current folder name displays
3. Click Browse to open the Save As dialog box.
4. Type _______ in the File name area and press Enter to submit your answer.
5. Click save
Open a Workbook ✅Delete the contents in cell ___
Save New Workbook ✅1. Click the File tab to display the Backstage view.
2. Select Save As on the left to display the Save As area. (or try Ctr+S to open Save As area)
3. Select the location to save your workbook. (Click Recent to display a list of recently used folders.
Click OneDrive to see your cloud folder names.
Click This PC to save the file to the Documents or another folder on the computer.
Click Add a Place to select a commonly used cloud location.
Click Browse to open the Save As dialog box for further navigation (Figure 1-2).)
4. Click a folder name to open it and type the file name in the file name box.
5. Click Save
, Workbook File Formats ✅Excel workbooks are saved as .xlsx files, indicated as Excel Workbook in the
Save As area and dialog box. You can save a workbook in other formats for ease in sharing data. For
example, save a workbook in Excel 97-2003 format so that a coworker with an earlier version of Excel
can use the data, or create a PDF file to display data for users who do not have Excel.
Enter Labels and Values ✅When you type data that includes alphabetic characters and numbers, Excel
treats that data as a label. Examples include a street address or an ID such as ABC123. When you type
data with numbers that are not used in calculations, enter the data as a label by typing an apostrophe (ʼ)
before the data. Examples of this type of data include a telephone or Social Security number without
hyphens.
Enter Data into a Workbook ✅1. Select the cell and type the data. When you type, an insertion point
displays.
-The label or value appears in the cell and in the Formula bar.
2. Press Enter to complete the entry and activate the cell below.
-Press Tab to complete the entry and activate the cell to the right.
-Press any keyboard directional arrow key to complete the entry and activate the cell in the direction of
the arrow.
-Press Ctrl+Enter to complete the entry and keep the current cell active.
-Click the Enter button in the Formula bar to complete the entry and keep the cell active
Clear cell contents ✅1. Select the cell or cells
2. Press delete on the keyboard
-Click the Clear button [Home tab, Editing group] and choose an option
-Clear all removes formatting and content
-Clear Formats only clears formatting
-Clear Contents deletes content but keeps formatting
Edit Cell Contents ✅1. Double-click the cell to be edited.
-You can also click the cell and press F2 (FN+F2) to start Edit mode.
2. Position the insertion point in the cell or the Formula bar (Figure 1-6).
3. Edit the data.
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 CertifiedGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
