Exam 6: Getting Started With Excel

-In the figure above, Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed. -Tyler inserts a new column between columns C and D. The newly inserted column has the ____.

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon.

To go to column A of the current row, press ____.

Ctrl + G is used to access the ____.

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points. _________________________

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Normal view shows how the worksheet will appear when printed. _________________________

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

According to the order of operation in Excel:

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

In ____ orientation, a page is taller than it is wide.

Cutting moves the selected content, whereas copying duplicates the selected content. _________________________

In the above figure, which box displays the ScreenTip displaying the syntax of the SUM function?

Two common ____________________ changes are adding borders to cells and changing the font size of text.

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders. -Samantha has entered several formulas in her worksheet. All of a sudden, she realizes that the cells that once displayed the formula results are now displaying the formulas and all of the columns are wider. She must have switched to ____.

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed. -Tyler wants to include the years that each client has been with him. He wishes to insert a new column called "Year" between Column C (Phone Number) and Column D (Number of Days ). To do this, Tyler selects ____.

The name of the active workbook appears in the status bar of the Excel window.