CGS1060 EXAM 3 QUESTIONS AND ANSWERS 2025., Exams of Computer Science

Download CGS1060 EXAM 3 QUESTIONS AND ANSWERS 2025. and more Exams Computer Science in PDF only on Docsity!

CGS1060 EXAM 3 QUESTIONS AND

ANSWERS 2025.

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

From the Backstage view Print options, select ____________ under Settings to print all sheets in a workbook. A. Selection B. Active sheet C. Entire workbook D. Range - ANSWERC. Entire workbook If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format: A. .ods B. .xlsx C. .pdf D. .xls - ANSWERC. .pdf By clicking the File tab from the Excel ribbon, you have entered the _________ view. A. Backstage B. Compatibility C. Print layout D. Presentation - ANSWERA. Backstage The date and page number of an Excel workbook are commonly placed in a: A. File B. Header to footer C. Margin D. Text box - ANSWERB. Header to footer In Excel, the program name and name of the open file are displayed in the: A. Format bar B. Window bar C. Standard bar D. Title bar - ANSWERD. Title bar Excel even allows you to recover previously unsaved files in the event that you accidentally close a file without saving it. A. True B. False - ANSWERA. True By default, Excel's _______ feature is saving your workbook every 10 minutes in case your computer loses power or shuts down unexpectedly. A. AutoCorrect B. Save as C. AutoRecovery D. System restore - ANSWERC. AutoRecovery 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 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

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 Flash Fill is: A. An Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data. B. A command in Microsoft Office applications that enables users to search for instances of specific text or numerical data in workbooks or documents. C. The action of locking rows and columns in place so that they remain onscreen as the viewer scrolls through a workbook. D. An Excel method that lets you gather data from multiple worksheets or workbooks into a master worksheet that acts as a summary. - ANSWERA. An Excel tool that automatically completes the data being inserted, following a pattern it recognizes in the data. 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? A. Saturday, April 12, 2014 B. 04/12/ C. 4/12/ D. 41741.00 - ANSWERA. Saturday, April 12, 2014 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? A. 0.0017% B. $17. C. 17% D. $17 - ANSWERC. 17% 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. A. Copy handle B. Fill handle C. Range handle D. Entry handle - ANSWERB. Fill handle 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. A. Auto correct B. Auto recovery

C. Auto format D. Auto fill - ANSWERD. Auto fill (Excel) Which of the following is a logical operator and not a comparison operator? A. = B. <> C. Not D. <= - ANSWERC. Not (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) 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 (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

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) What is a visual representation of data used to convey information in an easy-to- understand and attractive manner called? A. Data label B. Legend C. Chart D. Object - ANSWERC. Chart (Excel) Prior to creating a chart, it is important to: A. Select/Highlight the data you wish to chart B. Format all of the data in the worksheet for the chart C. Create a separate worksheet for the chat D. Save the worksheet in HTML format - ANSWERA. Select/Highlight the data you wish to chart (Excel) A rectangular block of adjoining cells, for example A5:E5, is referred to as a cell ____. A. Square B. Border C. Block D. Range - ANSWERD. Range (Excel) What is the result of the Excel formula =OR(8=4, 5<=9)? A. True B. False - ANSWERA. True (Excel) Which of the following functions could be used in finding the largest value from cells C2 through C25? A. =MAX(C2:C25) B. =MIN(C2:C25) C. =HIGHEST(C2:C25) D. =SUM(C2:C25) - ANSWERA. =MAX(C2:C25) (Excel) To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table: A. Filers B. Sorting options

C. Styles D. Formulas - ANSWERC. Styles (Excel) Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed. True or False? A. True B. False - ANSWERB. False (Excel) The area within the X- and Y-axis boundaries where the chart appears is referred to as: A. Legend B. Chart title C. Data series D. Plot area - ANSWERD. Plot area (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