Exam 7: Create, Navigate, Work With, and Print Worksheets

A red triangle in the upper-right corner of a cell indicates the existence of a(n)________.

The worksheet that is visible in the Excel application window is the ________ worksheet.

When using a touch screen,the Excel 2016 commands on the ribbon and in shortcut menus are rearranged to accommodate the use of a fingertip.

________ is a smart copy that will try to guess how you want values or formulas changed as you copy.

White space refers to blank areas of a worksheet that do not contain data or documentation,regardless of the actual color.

The intersection of a row and column is called a ________.

To select several contiguous columns,click the header of the first column,________ the header of the last column.

If you enter a date or time that is not recognized,Excel treats the information as ________ and left-aligns it in the cell.

Blank areas of a worksheet that do not contain data or documentation are called ________.

To insert a comment into a cell,you click New Comment in the:________ tab.

To change the width of a column,you click Column Width in the ________ tab.

A formula is a built-in program that would be used to find the average of a series of numbers.

In ________,the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.

A comment is a temporary storage location where information that was cut or copied is stored until you paste,move,or clear the information.

If you click ________,the insertion point is displayed in the formula bar.

Data formatted as a date takes the form of a serial number,with the number 1 representing January 1,1900.

The dollar sign ($)and comma (,)are stored as part of a numeric cell value.

To move right one screen,you would use the keyboard shortcut ________.

A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells.