Excel Chapter 1 Test Review | Questions & Answers (Rated A+)

Excel Chapter 1 Test Review | Questions & Answers (Rated A+) Excel Chapter 1 Test Review | Questions & Answers (Rated A+) ________ are a collection of worksheets. - ANSWER - workbooks What is the title of the blank workbook that opens when you first start Excel? - ANSWER - Book 1 The number of worksheets that a workbook can contain is: - ANSWER - Limited by your computer's memory The intersection of each column and row is called a ____. - ANSWER - Cell On the Ribbon each ____ surrounds a collection of groups. - ANSWER - tab The ____ toolbar, which appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet. - ANSWER - mini A(n) _________ is a list of additional commands associated with the selected command. - ANSWER - submenu In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered _____. - ANSWER - text When a cell entry is positioned at the far left in the cell, it is considered _____. - ANSWER - left In Excel, a number can contain the characters _______. - ANSWER - 0-9, operator symbols (+, -, / ,- ,% , . ,e ,E) To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ________. - ANSWER - 6E15 A ______ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. - ANSWER - range The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________. - ANSWER - paste area or destination area Saving the workbook frequently is important for the following reason: - ANSWER - Encase the computer shuts down or the application crashes. A file name can have the minumum of 2555 characters, including spaces. The only characters not allowed are: - ANSWER - | * ? " Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called _______. - ANSWER - formatting Combining two or more cells together is called _____ cells. - ANSWER - merging Dividing a cll into more than one cell is called _____. - ANSWER - splitting What effect does the Accounting Number Format have on the selected cells? - ANSWER - Has two decimal places and the dollar sign goes to the left edge of the cell What effect does the Comma Style format have on the selected cells? - ANSWER - Comma style does not have a dollar sign but has two decimal places and commas. A(n) ________ chart is drawn on the same worksheet as the data. - ANSWER - embedded The _______ identifies the colors assigned to watch bar in the chart on a worksheet. - ANSWER - legend Which key on the keyboard toggles between Insert mode and Overtype mode? _________ - ANSWER - Insert Key Which keyboard key moves the insertion point to the beginning of data in a cell? - ANSWER - Home Excel opens a new workbook with three ______. - ANSWER - worksheets The ________ is located near the tip of the Excel window, and is the control center in Excel. - ANSWER - robbon