Midterm Exam with 150+ Questions from Actual Past Exam, Exams of Nursing

Download Midterm Exam with 150+ Questions from Actual Past Exam and more Exams Nursing in PDF only on Docsity! Midterm Exam with 150+ Questions from Actual Past Exam and 100% Correct Answers Updated 2023-2024 Pressing the Delete key to delete cells only deletes the cell -------- Correct Answer ------- -- contents. To display the Column Width dialog box, begin by clicking the _____ button in the Cells group on the Home tab. -------- Correct Answer --------- Format Which button would you use to copy formatting to different locations in the worksheet? - ------- Correct Answer --------- Format Painter When you drag a column boundary, a box displaying a number appears above the mouse pointer. What does the number in this box represent? -------- Correct Answer ----- ---- the average number of characters In addition to using the Hide Columns option, Chapter 3 suggests that you can hide columns by -------- Correct Answer --------- setting the column width to zero. If you want to enter data on more than one line within a cell, press _____ to start a new line. -------- Correct Answer --------- Alt + Enter The Delete dialog box contains all of the following options except -------- Correct Answer --------- Entire worksheet. To insert a row in a worksheet, select the _____ and then click the Insert button in the Cells group. -------- Correct Answer --------- row below where the new row is to be inserted The formatting for numbers can be specified -------- Correct Answer --------- either before or after the number is entered into the cell. Data in cells is aligned -------- Correct Answer --------- according to the type of data. This feature is a set of formatting choices that includes colors, fonts, and effects. -------- Correct Answer --------- theme You can change the height of a row by positioning the mouse pointer on the boundary between rows until it displays as a _____ and then dragging up or down to the desired height. -------- Correct Answer --------- double-headed arrow pointing up and down Which button should you click if you want to rotate data in a cell? -------- Correct Answer --------- Orientation Excel measures row height in -------- Correct Answer --------- points. In the Number group on the Home tab, the format symbols you can use to format numbers include each of the following except the -------- Correct Answer --------- ampersand (&). On the Border tab in the Format Cells dialog box, the Presets section contains each of the following options except -------- Correct Answer --------- Top and Bottom. Which option allows you to combine cells? -------- Correct Answer --------- Merge Cells The Number tab in the Format Cells dialog box opens with the default number format category of -------- Correct Answer --------- General. When you insert rows into a worksheet, all references affected by the insertion -------- Correct Answer --------- are automatically adjusted. Excel measures row height in _____ and column width in _____. -------- Correct Answer --------- points; characters What is the first step in unhiding a row with the mouse? -------- Correct Answer --------- Position the mouse pointer on the slightly thicker gray line in the row header. If you want to apply the formatting you have just applied to one cell to other cells in your worksheet, you can use the Repeat command, which is executed by pressing -------- Correct Answer --------- Ctrl + Y. Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column? -------- Correct Answer --------- Accounting You can adjust a column width to fit the longest entry in the column by double-clicking -- ------ Correct Answer --------- on the column boundary line. If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by -------- Correct Answer --------- pressing Alt + Enter. What does the Orientation button in the Alignment group do? -------- Correct Answer ----- ---- rotates data in a cell To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position. -------- Correct Answer --------- the Select All button Buttons in the _____ group on the Page Layout tab allow you to adjust the printed output of your worksheet to conform to a specified number of pages. -------- Correct Answer --------- Scale to Fit When sorting data by more than one column, each subsequent column (after the first) is identified in the _____ option in the Sort dialog box. -------- Correct Answer --------- Then by When you click the Sort & Filter button and then click Filter, a _____ appears in each column label. -------- Correct Answer --------- filter arrow Unless you specify otherwise, Excel will print -------- Correct Answer --------- only the active worksheet. Suppose you were using the Find and Replace dialog box to replace all occurrences of 100 with 500. What, if any, options would you have to use in order to prevent 1000 from being replaced by 5000? -------- Correct Answer --------- Match entire cell contents When you specify multiple print areas with the Print Area button, how do the areas print? -------- Correct Answer --------- Each area is printed on a separate page. To display the Then by option in the Sort dialog box, click the _____ button. -------- Correct Answer --------- Add Level In Page Break Preview, a _____ indicates a page break inserted by Excel, and a(n) _____ indicates a page break inserted manually. -------- Correct Answer --------- dashed blue line; solid blue line When using the Sort & Filter button, by which column will the data be sorted? -------- Correct Answer --------- the first selected column If you want to sort data by a column other than the default column, which method would you choose? -------- Correct Answer --------- Click the Sort & Filter button, then click Custom Sort. The Sort & Filter button on the Home tab will sort data in the -------- Correct Answer ------ --- selected cells. Where can you preview your headers and footers before printing? -------- Correct Answer --------- at the Print backstage area Excel's spell checker checks the worksheet from _____ to _____. -------- Correct Answer --------- the active cell; the last cell in the worksheet that contains data The Page Break Preview allows you to view -------- Correct Answer --------- and adjust your worksheet page breaks. What happens if you select a column in a worksheet and then click Insert Page Break on theBreaks button? -------- Correct Answer --------- A page break is inserted to the left of the column. Can you specify more than one print area? If so, how? -------- Correct Answer --------- Yes, by selecting the first print area, clicking the Print Area button, clicking Set Print Area, and then selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area. You can display the Find and Replace dialog box by -------- Correct Answer --------- clicking the Find & Select button in the Editing group on the Home tab, then clicking Replace. If you specify more than one print area on a worksheet, how will they print? -------- Correct Answer --------- They will print on separate pages. Which of the following number formats adds a dollar sign and two decimal points and also lines up the currency symbols and decimal points? -------- Correct Answer --------- Accounting Double-clicking in a cell and then selecting the data in the cell will display the -------- Correct Answer --------- Mini toolbar. How can you tell if a worksheet contains hidden columns or rows? -------- Correct Answer --------- The light gray boundary line in the column or row header will display as a slightly thicker gray line. Buttons in the Font group allow you to change the font size, effects, and color, as well as -------- Correct Answer --------- add borders. When you insert columns in a worksheet, what happens to the cell references that are affected by the new columns? -------- Correct Answer --------- References automatically adjust. With the _____ feature, you can see how theme formatting will affect your worksheet. --- ----- Correct Answer --------- live preview Text typed into a cell will overlap into the next cell if it is too long. To prevent this, use options in the _____ section on the Alignment tab in the Format Cells dialog box. -------- Correct Answer --------- Text control On the Font tab in the Format Cells dialog box, you can do any of the following except -- ------ Correct Answer --------- rotate text. To add shading to a cell, use the _____ on the Fill tab in the Format Cells dialog box ---- ---- Correct Answer --------- Fill Effects button When applying formatting to cells in your worksheet, you can repeat the last command by pressing _____ or _____. -------- Correct Answer --------- Ctrl + Y; F4 This number format is used for very large and very small numbers, and it uses the letter E to tell Excel how many positions to move the decimal point. -------- Correct Answer ---- ----- Scientific To make a hidden row visible, start by -------- Correct Answer --------- selecting the row above and the row below the hidden one. Use this keyboard command to display the Insert Function dialog box. -------- Correct Answer --------- Shift + F3 If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first. -------- Correct Answer --------- parentheses When a formula contains two or more operators, Excel uses a specific order of operations to determine the sequence in which the operations are executed. Which of the following is the correct order of operations? -------- Correct Answer --------- negations, percentages, exponentiations, multiplications, divisions, additions, subtractions Instead of typing dollar signs to indicate absolute cell references, you can press the _____ function key repeatedly to cycle through the various combinations of cell references. -------- Correct Answer --------- F4 A cell reference can be any of the following except -------- Correct Answer --------- circular. In the formula =SUM(A4:A17), the cell range (A4:A17) is an example of a(n) -------- Correct Answer --------- cell reference argument. The _____ function returns the current date and time in a date-and-time format. -------- Correct Answer --------- NOW What symbol is used to identify an absolute cell reference? -------- Correct Answer ------- -- a dollar sign ($) Which function(s) would you use to find which employee has used the most vacation days and which has used the least? -------- Correct Answer --------- MAX and MIN This keyboard command displays the Print backstage area. -------- Correct Answer ------- -- Ctrl + P To insert the AVERAGE function, click the _____ button arrow and select Average at the drop-down list. -------- Correct Answer --------- AutoSum How can you make Excel automatically apply the Currency format to a number you enter in a cell? -------- Correct Answer --------- Type the number with a dollar sign and a decimal point. When entering data into a worksheet, you can make the next cell active by pressing the _____ key. -------- Correct Answer --------- Tab The Merge & Center button is located in the _____ group on the _____ tab. -------- Correct Answer --------- Alignment; Home If you position the mouse pointer on the gray boundary line between columns in the header, the pointer will turn into a double-headed arrow and you can -------- Correct Answer --------- change the column width. To select an entire row of cells using the keyboard, move the cell pointer to the desired row and press -------- Correct Answer --------- Shift + spacebar. If you want to fill cells using the fill handle but do not want the series to increment, hold down the _____ key while dragging the fill handle. -------- Correct Answer --------- Alt A _____ is a file created in Excel. -------- Correct Answer --------- workbook This is the keyboard command to display the Open dialog box. -------- Correct Answer -- ------- Ctrl + F12 The element of the Excel worksheet known as the _____ displays cell addresses and includes the column letter and row number. -------- Correct Answer --------- Name box You can access Excel's Help feature by pressing the _____ key. -------- Correct Answer --------- F1 If you enter a number that is too long to fit in a cell, Excel changes the display of the number to -------- Correct Answer --------- number symbols (###). When you want to copy the same basic formula from one cell to other cells, make sure your formula contains _____ cell references. -------- Correct Answer --------- relative When working in an Excel worksheet, the mouse pointer displays as a -------- Correct Answer --------- white plus sign. An Excel workbook file name can contain up to _____ characters and cannot include _____. -------- Correct Answer --------- 255; forward slashes (/) Which of the following elements of an Excel worksheet contains the tabs with commands and buttons? -------- Correct Answer --------- ribbon Excel's AutoComplete feature automatically inserts data in a cell that -------- Correct Answer --------- begins the same as a previous entry. To close a workbook, click the Filetab and then click the _____ option. -------- Correct Answer --------- Close If you want to edit only a portion of the data in a cell, _____ the cell. -------- Correct Answer --------- double-click When you insert a formula by clicking the AutoSum button, Excel first looks _____ the active cell for a range of cells containing numbers. -------- Correct Answer --------- above Which of the following function keys turns on the Extend Selection mode? -------- Correct Answer --------- F8 To close Excel, click the Close button that displays in the _____ corner of the screen. --- ----- Correct Answer --------- upper right To select an entire column using the mouse, position the cell pointer _____ and then click the left mouse button. -------- Correct Answer --------- on the column header This element performs calculations on values in a worksheet and contains a mathematical operator, value, cell reference, cell range, and function. -------- Correct Answer --------- formula This feature automatically corrects common typing errors. -------- Correct Answer --------- AutoCorrect