100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Exam (elaborations)

WallStreetPrep: Excel Crash course Exam Questions and Answers 100% Accurate

Rating
-
Sold
-
Pages
4
Grade
A+
Uploaded on
04-06-2024
Written in
2023/2024

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - ANSWER-Alt h i w What is a keyboard shortcut to open a file?` - ANSWER-Ctrl o What is the recommended workbook calculation setting for Excel? - ANSWER-Automatic Except for Data Tables To add a cell reference from a different worksheet into an existing formula with your keyboard, you should follow the following steps: - ANSWER-1. Hit F2 to get into the existing formula; delete any incorrect formulas or operators 2. Hit F2 again to enable "Enter" mode on the bottom-left corner of the Excel sheet 3. Holding down Ctrl, use PageUp or PageDown to find the desired worksheet 4. Let go of the Ctrl and PageUp/Down keys 5. Use the arrow keys to locate the desired cell reference 6. Hit Enter What is the keyboard shortcut to move sheets within a workbook? - ANSWER-Alt H O M What is the keyboard shortcut to open the formatting cells dialog box? - ANSWER-Ctrl 1 What are the keyboard shortcuts for auto-fitting a range of columns? - ANSWER-1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the shift key and use left and right arrow keys to highlight the range of columns. 3) Hit Alt H O I to auto fit the columns. When you are in the Format Cells dialog (Ctrl 1): What is the keyboard shortcut for moving across tabs (Number, Alignment, Font Border, Fill, Protection)? How do you move counter clockwise across form elements? How do you select a checkbox (put a checkbox next to it) - ANSWER-1) Ctrl Tab 2) Shift Tab 3) Spacebar If I want to add the title "Company Financials" in ce

Show more Read less
Institution
WallStreetPrep: Excel Crash Course
Course
WallStreetPrep: Excel Crash course








Whoops! We can’t load your doc right now. Try again or contact support.

Written for

Institution
WallStreetPrep: Excel Crash course
Course
WallStreetPrep: Excel Crash course

Document information

Uploaded on
June 4, 2024
Number of pages
4
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Topgrades20 West Virginia University
View profile
Follow You need to be logged in order to follow users or courses
Sold
12
Member since
2 year
Number of followers
10
Documents
812
Last sold
9 months ago

3.5

2 reviews

5
0
4
1
3
1
2
0
1
0

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions