Exam 1: Getting Started With Excel

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

Case-Based Critical Thinking Questions Case 1-2 Sam is a distributor of ceramics.He uses Excel 2010 to record his inventory and order forms.Sam's worksheet for his company's monthly orders needs to display summary information including total number of items ordered,and the amount of revenue generated from those orders. -First Sam will add the number of orders.He chooses to use the ____ function from the AutoSum feature.

A ____ is a single point on a computer monitor.

-In the figure above,"Documentation" and "Customer Orders" are names of ____.

One of the entries Roger enters into the spreadsheet automatically right-aligns in the cell.Which entry does this?

A worksheet displays the contents of the spreadsheet laid out in a grid of rows and ____________________.

The active cell has a ____ border.

The range reference for nonadjacent ranges separates each adjacent range reference by a colon._________________________

____________________ eliminates any empty space by matching the column to the width of its longest cell entry or the row to the height of its tallest cell entry.

To select a large range of cells,click the first cell in the range,press and hold ____,and then click the last cell in the range.

Put the following steps for selecting a nonadjacent range of cells in the proper order: 1)Select an adjacent range of cells. 2)With the Ctrl key still pressed,continue to select other cell ranges until all of the ranges are selected. 3)Release the mouse button and the Ctrl key. 4)Press and hold the Ctrl key,and then select another adjacent cell range.

To select a nonadjacent range,select an adjacent range,press and hold ____ and then select other adjacent ranges.

Which of the following number formats are converted by Excel once they are entered?

The ____________________ is a set of predefined rules used to determine the sequence in which operators are applied in a calculation.

In the figure above,the ____ replaces the current occurrence of the search string.

A newly inserted row has the same height as the row above it._________________________

Roger wants to include the year that each client has been with him.He wishes to insert a new column called "Year" between Column D (Dog Owner Name)and Column E (Address).____

When you work in Edit mode,some keyboard shortcuts will only apply to the text in the selected cell._________________________

-In the figure above,the row headings are the ____ of the worksheet window that identify the different rows in the worksheet.You click a row heading to select the entire worksheet row.

By default,Excel starts with a ____ maximized to fill the Excel window.