Exam 1: Getting Started With Excel

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the name of the sheets in the workbook

To move or copy a range of cells,select the correct order: 1)Move the pointer over the border of the selection until the pointer changes shape. 2)Select the cell or range you want to move or copy. 3)To move the range,click the border and drag the selection to a new location,or to copy the range,hold down the Ctrl key and drag the selection to a new location.

mm/dd/yyyy is known as ____.

A $\underline { \text { keyboard shortcut } }$ is a key or combination of keys that you press to access a feature or perform a command._________________________

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 ____.

____ makes it easier to enter repetitive text in cells.

If you want to create a new line within a cell,press the ____ keys to move the insertion point to the next line within the cell.

A(n)____________________ is a grouping of text and numbers in a rectangular grid or table.

An Excel formula always begins with a(n)____.

Which of the following will not change the location of the active cell?

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 notices that the Address column is too wide.He could use that extra space for other columns so he ____.

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.

What is the result of the expression =50+20/10*5?

Column width is expressed in terms of the number of characters a column can contain or the size of the column in $\underline { \text { points. } }$ _________________________

The formula used to multiply cell A1 by cell C1 is ____.

$\underline { \text { Normal } }$ view shows how the worksheet will appear when printed._________________________

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

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

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