Excel Linked-In Quiz

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?

The status bar will read 'Caps Lock' in the lower left corner. 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: _____

Minimum and Maximum Values Signup and view all the answers

Where is the zoom slider bar located?

status bar at bottom of screen Signup and view all the answers

If you slide the mouse (or cursor) on a boundary between rows, what does your cursor look like?

a two-way up-down arrow Signup and view all the answers

How can you most easily navigate from one workbook to another?

Select Switch Windows in the View tab on the ribbon. Signup and view all the answers

What is the Mini-Toolbar?

It is a limited-feature bar that contains many of the features contained on the Home tab of the toolbar. Signup and view all the answers

What advice would you give Darren regarding his team's expense reporting?

Use one of the Microsoft Excel templates that is already built. Signup and view all the answers

What is Excel?

All of these answers Signup and view all the answers

How can you access Insights, which takes you outside of Microsoft and into the web?

the Smart Lookup feature in a drop-down menu on the ribbon Signup and view all the answers

How will Excel indicate that you've made a data entry error by typing '11O' instead of '110'?

11O will be left-aligned, while the other values will be right-aligned. 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?

Enter Jan in cell B1, and then drag the fill handle to cell M1. Signup and view all the answers

When will you use Save rather than Save As?

when you make changes to an existing workbook Signup and view all the answers

Date entries are numbers and by default they _____.

line up on the right side of the cell Signup and view all the answers

What limitation does the Undo feature have in Excel?

You can only undo actions consecutively and cannot select an action, for example, from 10 entries earlier. 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?

Undo the lines. Signup and view all the answers

How do you first know there are comments in the worksheet?

There is a little triangle in the upper right-hand corner of the cell. Signup and view all the answers

What should Karl avoid when naming his Excel file?

Avoid using an asterisk. 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?

Use =C4+B5 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?

A value of 29 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?

When you copy this formula, Excel will change H1 to H2, which has a zero value, and so on down the column. Signup and view all the answers

The most effective way to add up five different cells in a row is to _____

use the SUM function Signup and view all the answers

What is the basis of using formulas in Excel?

To perform calculations and analysis on data. 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.

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.