Download CGS1060 EXAM 3 QUESTIONS & ANSWERS(RATED A+) and more Exams Advanced Education in PDF only on Docsity!
CGS1060 EXAM 3 QUESTIONS &
ANSWERS(RATED A+)
An Excel workbook can consist of multiple _______ or "pages" each referenced by a tab at the bottom of the Excel program window. A. Scrapbook B. Documents C. Worksheets D. Templates - ANSWERC. Worksheets An Excel file is referred to as a: A. Workbook B. Document C. Database D. Presentation - ANSWERA. Workbook 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. A. Formula B. Format C. Standard D. Title - ANSWERA. Formula 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? A. Copy B. Cut - ANSWERA. Copy If you begin typing, the characters will appear in the cell of the worksheet known as the ______ cell that has its border bolded with a green color. A. Dominate cell B. Adjacent cell C. Active cell D. Reference cell - ANSWERC. Active cell Press the ______ key to move the active cell one position to the right on the worksheet. A. Backspace B. Shift + enter C. Tab D. Ctrl + home - ANSWERC. Tab A ____ is referenced by a column letter and row number such as C5. A. Grid B. Field C. Cell
D. Box - ANSWERC. Cell The default name for an Excel file is _______. A. Book B. Document C. Presentation D. DefaultDoc - ANSWERA. Book A new Blank Workbook in Excel 2013 contains one worksheet named: A. File 1 B. Current sheet C. Tab 1 D. Sheet1 - ANSWERD. Sheet When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called _______. A. Scrapbook B. Documents C. Databases D. Templates - ANSWERD. Templates Excel 2013 files have names that end with a default file extension of ____. A. .docx B. .xlsx C. .html D. .txt - ANSWERB. .xlsx The keyboard shortcut for the Print command is: A. Alt+V B. Ctrl+X C. Ctrl+V D. Ctrl+P - ANSWERD. Ctrl+P 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: A. A B. 1A C. 0A D. A0 - ANSWERA. A If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut? A. Copy B. Cut - ANSWERB. Cut Which page orientation prints the worksheet on paper that is wider than it is tall? A. Portrait Orientation B. Landscape Orientation - ANSWERB. Landscape Orientation
D. System restore - ANSWERC. AutoRecovery To save an Excel workbook using a different format, location, or filename click the File tab from the Excel ribbon and choose: A. Save B. Save as C. New D. Open - ANSWERB. Save as ____________ is the process of changing the appearance of cells and the overall layout of the worksheet. A. Justifying B. Printing C. Editing D. Formatting - ANSWERD. Formatting Combining two or more cells into a single cell creates a: A. Combination box B. Merged cell C. Grouping D. Combined cells - ANSWERB. Merged cell The background of a cell is called the: A. Border B. Highlight C. Fill color D. Paint - ANSWERC. Fill color Once a set of cell's in Excel have been combined (or merged), they can never be split apart. True or False? A. True B. False - ANSWERB. False 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. A. Wrap text B. Insert row C. Align text D. Merge and center - ANSWERA. Wrap text The edges or lines around a cell are referred to as the cell's: A. Membrane B. Fill color C. Border D. Fencing - ANSWERC. Border Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color? A. Home
B. Insert C. Page layout D. Formulas - ANSWERA. Home Cell ________ such as Heading and Title allow you to apply multiple formats to a cell at once. A. Styles B. Borders C. Themes D. Groupings - ANSWERA. Styles (Excel) Which of the following formulas is written in the correct syntax? A. =SUM(A1=B1) B. =SUM(A1:D1) C. SUM(D2-A2) - ANSWERB. =SUM(A1:D1) (Excel) Which of the following choices could be used in creating a named cell range? A. C B. $ C. Total earnings D. Monthly expenses - ANSWERD. Monthly expenses By default, textual data is ____ aligned within Excel cells. A. Center B. Left C. Right D. Top - ANSWERB. Left ____________ is used to copy the formatting of one cell to other cells. A. Format painter B. Fill color C. AutoFit D. Format theme - ANSWERA. Format painter If you have a column of data that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format. A. Time B. Percent C. Scientific D. Currency - ANSWERD. Currency 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: A. Calculation B. Function C. Hyperlink D. Summation - ANSWERC. Hyperlink
(Excel) Symbols such as +, -, and * that are used to specify the calculations to be performed in a formula are called: A. Addends B. Functions C. Operators D. Values - ANSWERC. Operators (Excel) The mathematical rule that Excel follows to perform calculations in a formula in the proper order is called the: A. Order of exponents B. Order of expressions C. Order of functions D. Order of Operations - ANSWERD. Order of Operations (Excel) Excel's prewritten formulas such as =SUM() or =AVERAGE() are normally referred to as: A. Calculators B. Functions C. Commands D. Summations - ANSWERB. Functions (Excel) What is the result of the Excel formula =AND(4=4, 15<=9)? A. True B. False - ANSWERB. False (Excel) All formulas begin with the ____________ sign. A. + (plus) B. - (minus) C. = (equal) D. * (asterisk) - ANSWERC. = (equal) (Excel) This function adds all the numbers given in a range of cells. A. SUM B. ADD C. INC D. DEC - ANSWERA. SUM (Excel) To make a cell reference absolute, ____________ are inserted into the cell reference. A. Exclamation marks B. Parenthesis C. Brackets D. Dollar sign - ANSWERD. Dollar sign (Excel) Copying the formula =A1B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2? A. =A2B B. =B1C C. =A1B D. =B2C2 - ANSWERA. =A2B
(Excel) Which symbol represents the amperand sign and is used to concatenate two or more values or cell contents? A. ^ B. * C. & D. @ - ANSWERC. & (Excel) Which operation in the formula =B5/(C6+C7)*2 will be processed first? A. Addition B. Multiplication C. Division D. Exponential - ANSWERA. Addition (Excel) In an Excel formula such as =E7+E8, the plus sign for addition is called a(n) _____. A. Calculations B. Functions C. Commands D. Summations - ANSWERB. Functions (Excel) 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): A. Grouped workbook B. Excel table C. Data Bar D. Data filter - ANSWERB. Excel table (Excel) Items such as a chart title, gridlines, data labels, and so on that can be added to a chart are commonly referred to as chart _____. A. Events B. Attributes C. Documents D. Elements - ANSWERD. Elements A. B. C. D. - ANSWER (Excel) 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")? A. True B. False C. Okay D. Not good - ANSWERD. Not good (Excel) Which Excel ribbon tab contains the Function Library command group? A. File
A. Legend B. Chart title C. Data series D. Plot area - ANSWERD. Plot area
