CGS 1060 FINAL EXAM STUDY GUIDE 4 QUESTIONS WITH COMPLETE SOLUTIONS, Exams of Computer Science

Download CGS 1060 FINAL EXAM STUDY GUIDE 4 QUESTIONS WITH COMPLETE SOLUTIONS and more Exams Computer Science in PDF only on Docsity!

CGS 1060 FINAL EXAM STUDY GUIDE 4

QUESTIONS WITH COMPLETE

SOLUTIONS.

An Excel file is referred to as a: - ANSWERworkbook When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called _______. - ANSWERtemplates In Excel, a ____ is referenced by a column letter and row number such as C5. - ANSWERcell An Excel workbook can consist of multiple _______ or "pages" each referenced by a tab at the bottom of the Excel program window. - ANSWERworksheets The default name for an Excel file is _______. - ANSWERBook If you begin typing in Excel, the characters will appear in the cell of the worksheet known as the ________ that has its border bolded with a green color. - ANSWERActive cell Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of the worksheet whose cell reference is given by: - ANSWERA Press the ______ key to move the active cell one position to the right on the worksheet.

• ANSWERTab This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell. - ANSWERFormula If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut? - ANSWERCut If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use: Copy or Cut? - ANSWERCopy A new Blank Workbook in Excel 2016 contains one worksheet named: - ANSWERSheet Excel 2016 files have names that end with a default file extension of ____. - ANSWER.xlsx To save a workbook in a format compatible with Excel 97-2003 versions, the file extension should be: - ANSWER.xls

Use the ____________ command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it. - ANSWERWrap Text A linked object, such as a word, phrase, symbol, or image, that you can click to move to a different place in the same workbook, another workbook, or a web site; or to open an e-mail message window is known as a: - ANSWERhyperlink All formulas begin with the ____________ sign. - ANSWER= A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell ____. - ANSWERrange Which of the following formulas is written in the correct syntax? - ANSWER=SUM(A1:D1) Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell? - ANSWER17% If you have a column of data in Excel that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format. - ANSWERCurrency Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1? - ANSWERSaturday, April 12, 2014 The ____________ feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting. - ANSWERAuto Fill In Excel, a black symbol in the lower right-hand corner of the active cell. Users can click and drag the fill handle to copy cell contents or create a series. - ANSWERfill handle Flash Fill is: - ANSWERan Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data. This function adds all the numbers given in a range of cells. - ANSWERSUM Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally referred to as: - ANSWERfunctions Symbols such as +, -, and * that are used to specify the calculations to be performed in a formula are called: - ANSWERoperators

The mathematical rule that Excel follows to perform calculations in a formula in the proper order is called the: - ANSWERorder of operations Which of the following functions could be used in finding the largest value from cells C through C25? - ANSWER=MAX(C2:C25) Which Excel ribbon tab contains the Function Library command group? - ANSWERFormulas Which operation in the formula =B5/(C6+C7)2 will be processed first? - ANSWERaddition Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents? - ANSWER& Copying the formula =A1B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2? - ANSWER=A2*B To make a cell reference absolute, ____________ are inserted into the cell reference. - ANSWERdollar signs To automatically add row and column headers and analyze a group of related data independenly from other cells in the worksheet, you can convert a range of cells to a(n):

• ANSWERExcel table Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed. True or False? - ANSWERFalse To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table: - ANSWERstyles Which of the following choices could be used in creating a named cell range? - ANSWERMonthlyExpenses Which of the following is a logical operator and not a comparison operator? - ANSWERNot What is the result of the Excel formula =AND(4=4, 15<=9)? - ANSWERFalse What is the result of the Excel formula =OR(8=4, 5<=9)? - ANSWERTrue Suppose cell D5 has a value of 17. What will be the value of cell E5 if it contains the formula =IF(D5<=10,"OK","Not Good")? - ANSWERNot Good What is a visual representation of data used to convey information in an easy-to- understand and attractive manner called? - ANSWERchart