Questions and Answers
Excel's menu system is known as the?
ribbon
Some of the buttons in the ribbon have a small arrow in the bottom right corner. What are these arrows?
dialog box launchers
Where on a drop-down menu can you access the full list of available commands?
in All Commands
Which indicator in Excel lets you know if Caps Lock is on?
Signup and view all the answers
Suppose you highlight a column of data in an Excel worksheet. In the status bar below, you'll see all of the following by default, except: _____
Signup and view all the answers
Where is the zoom slider bar located?
Signup and view all the answers
If you slide the mouse (or cursor) on a boundary between rows, what does your cursor look like?
Signup and view all the answers
How can you most easily navigate from one workbook to another?
Signup and view all the answers
What is the Mini-Toolbar?
Signup and view all the answers
What advice would you give Darren regarding his team's expense reporting?
Signup and view all the answers
What is Excel?
Signup and view all the answers
How can you access Insights, which takes you outside of Microsoft and into the web?
Signup and view all the answers
How will Excel indicate that you've made a data entry error by typing '11O' instead of '110'?
Signup and view all the answers
How can you use AutoFill to provide all 12 months in a year across the columns in row 1 starting at column B?
Signup and view all the answers
When will you use Save rather than Save As?
Signup and view all the answers
Date entries are numbers and by default they _____.
Signup and view all the answers
What limitation does the Undo feature have in Excel?
Signup and view all the answers
What is the best action to take if you need to adjust two lines of data you just entered?
Signup and view all the answers
How do you first know there are comments in the worksheet?
Signup and view all the answers
What should Karl avoid when naming his Excel file?
Signup and view all the answers
How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for the next four months?
Signup and view all the answers
If you want to get the percentage increase in profits from January to February and use the formula shown below, what will be returned?
Signup and view all the answers
What is the correct formula to use in cell F2 if H1 has a value shown as 2.1 percent and you want to drag it down to the other rows?
Signup and view all the answers
The most effective way to add up five different cells in a row is to _____
Signup and view all the answers
What is the basis of using formulas in Excel?
Signup and view all the answers
Study Notes
Excel Basics
- The menu system in Excel is referred to as the ribbon.
- Buttons with a small arrow in the bottom right corner are called dialog box launchers.
- For frequently used commands, the full list can be accessed under All Commands in a drop-down menu.
Working with Text and Indicators
- The status bar displays "Caps Lock" when typing is in capital letters.
- Highlighted data columns will display certain statistics on the status bar, but Minimum and Maximum Values are not shown by default.
Navigation and Zooming
- The zoom slider bar to adjust the display size is located on the status bar at the bottom of the screen.
- To navigate between multiple open workbooks, select Switch Windows from the View tab in the ribbon.
Toolbars and Templates
- The Mini-Toolbar provides quick access to features found on the Home tab.
- For standard templates, use existing Microsoft Excel templates for expense reporting.
Excel Functionality
- Excel encompasses various functionalities, making it integral for operations.
- Access Insights via the Smart Lookup feature from the ribbon's drop-down menu.
Data Entry and Organization
- Incorrect entries, like typing 11O instead of 110, will result in left-alignment for errors, while correct entries remain right-aligned.
- To auto-fill months, start with Jan in cell B1, then drag the fill handle to cell M1.
Saving and Data Alignment
- Use Save to update existing workbooks, and Save As for new files.
- Date entries by default line up on the right side of cells.
Undo Limitations
- The Undo feature can only revert actions consecutively; past actions cannot be selectively undone.
- To adjust recently entered lines, the best action is to Undo those entries.
Recognizing Comments and File Naming
- Comments in a worksheet are indicated by a small triangle in the upper right corner of the relevant cell.
- Avoid using special characters like asterisks when naming files in Excel.
Formulating Calculations
- To calculate year-to-date profits, the formula in cell C5 should be written as =C4+B5.
- Without parentheses, formulas follow Excel’s operation hierarchy, which may result in unintended values.
Using Percentages and SUM Function
- For a percentage increase in profits, understanding formula parsing is crucial, as it affects outcome values.
- The most effective way to sum five different cells in a row is by using the SUM function.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of Excel's menu system and features with this quiz. Learn about terms like the ribbon and dialog box launchers, as well as how to customize the Quick Access Toolbar. Perfect for anyone looking to enhance their Excel skills.