Download SPREADSHEET MODELLING FINAL EXAM 2024 REAL EXAM 200 QUESTIONS AND ANSWERS (VERIFIED ANS) and more Exams Computer Science in PDF only on Docsity!
SPREADSHEET MODELLING FINAL
EXAM 2024 REAL EXAM 200 QUESTIONS
AND ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+ | LATEST
VERSION
Where do sheet tabs display in a workbook? a. under the ribbon b. lower area of the workbook window c. on the status bar d. on the right side of the workbook window ------CORRECT ANSWER------- -----b. lower area of the workbook window The median function finds ___. a. the average value in a range of cells b. the one number that corresponds to an argument in the function c. all numbers that correspond to an argument in the function d. the middle value in a range of cells ------CORRECT ANSWER------------d. the middle value in a range of cells which of the following excel features recognizes a pattern in the data of a worksheet? a. if function b. countif function c. find and replace d. flash fill ------CORRECT ANSWER------------d. flash fill
in a conditional format, we use ___ to represent the value of a cell relative to other cells a. excel table b. data bar c. filter d. sparkline ------CORRECT ANSWER------------b. data bar we can group multiple worksheets by right-clicking on the sheet tab, and then click ___ on the shortcut menu. a. tab color b. select all sheets c. grouping d. protect sheet ------CORRECT ANSWER------------b. select all sheets T/F: you can sort a table in ascending or descending order. ------CORRECT ANSWER------------true what are the default names of worksheets? a. sheet1, sheet2, etc. b. worksheet1, worksheet2, etc. c. 1, 2, 3, etc. d. excel 1, excel 2, etc ------CORRECT ANSWER------------a. sheet1, sheet2, etc. if you edit data in a worksheet that is associated with a pie chart, ___. a. the pie slices will be automatically updated b. the pie slices must be manually updated c. a new second pie chart must be created d. an error message will display ------CORRECT ANSWER------------a. the pie slices will be automatically updated
which of the following displays trends over time? a. line chart b. pie chart c. what-if analysis d. an axis ------CORRECT ANSWER------------a. line chart in goal seek, you enter the specific value that you want to achieve in the ___ box. a. goal seek dialog b. set cell c. by changing cell d. to value ------CORRECT ANSWER------------d. to value Where is the fill handle located? a. on the home tab b. in the lower right corner of a selected cell c. in the top right of an active cell d. on the quick access toolbar ------CORRECT ANSWER------------b. in the lower right corner of a selected cell row heading are identified by ____. a. lowercase letters b. roman numerals c. uppercase letters d. numbers ------CORRECT ANSWER------------d. numbers there are commands to change style such as the total or heading 1 style on the ____. a. themes gallery b. cell styles gallery
c. fonts gallery d. charts gallery ------CORRECT ANSWER------------b. cell styles gallery T/F: the mini tool bar enables us auto fill date or formula. ------CORRECT ANSWER------------false hold down the ____ key to select nonadjacent cells. a. spacebar b. f c. alt d. ctrl ------CORRECT ANSWER------------d. ctrl when you type data in a cell and press tab, what cell becomes the active cell? a. the cell below b. the cell above c. the insertion point does not move d. the cell to the right ------CORRECT ANSWER------------d. the cell to the right what is the name of box that displays the selected cell? a. name box b. ribbon box c. formula box d. status box ------CORRECT ANSWER------------a. name box when you click a chart, you will see two additional tabs (____ and ___) for working with the chart a. layout tab and formula tab b. view tab and design tab
T/F: the y-axis of a chart is also referred to as the category axis ------ CORRECT ANSWER------------false A ___ in a pie chart identifies the pie slices. a. data series b. data label c. data market d. data point ------CORRECT ANSWER------------b. data label in a lookup formula, the defined range is referred to as the ___. a. named range b. validation list c. defined name d. table array ------CORRECT ANSWER------------d. table array a method to find a specific value for a cell by adjusting the value of one other cell is ___. a. goal seek b. validation c. protection d. look up ------CORRECT ANSWER------------a. goal seek we can define a name to represent a range of cells in the ___. a. cell range b. validation list c. table array d. name box ------CORRECT ANSWER------------d. name box
in a cell that contains a function, to copy the VALUE to another to cell-- rather than the function-- use the ___. a. paste command b. format painter command c. pasta special command d. paste link command ------CORRECT ANSWER------------c. paste special command T/F: present value represents the amount of the loan before any payments are made. ------CORRECT ANSWER------------true T/F: you cannot insert new data into a named range ------CORRECT ANSWER------------false a technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ___. a. data validation b. data protection c. what-if analysis d. goal seek ------CORRECT ANSWER------------a. data validation to see how different interest rates and different payment periods will affect a monthly payment, use a ___. a. validation list b. two-variable data table c. table array d. defined name ------CORRECT ANSWER------------b. two-variable data table
d. format as table ------CORRECT ANSWER------------d. format as table ___ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results. a. criteria b. filtering c. custom filtering d. auto filtering ------CORRECT ANSWER------------b. filtering T/F: to quickly locate specific text, formatting, or type of information within a workbook, use the find command. ------CORRECT ANSWER------------true the page break view shows where the page breaks will occur by displaying ___. a. a welcome screen b. an arrow to move the pages around in the worksheet c. blue dashed lines and the page number on the worksheet d. the header and footer ------CORRECT ANSWER------------c. blue dashed lines and the page number on the worksheet T/F: the outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click ------CORRECT ANSWER------------true clicking a ___ will take you to another location in the worksheet, another file location, a webpage on the internet, or to your organizations internet. a. hyperlink b. welcome screen c. save as dialog box d. page break ------CORRECT ANSWER------------a. hyperlink
to tile multiple open worksheets on the screen, use the ___ command. a. go to b. split c. rearrange d. arrange all ------CORRECT ANSWER------------d. arrange all the outline bar along the left side of the worksheet enables you to ___ levels of detail with a single mouse click. a. copy and open b. paste and close c. show and hide d. copy and paste ------CORRECT ANSWER------------c. show and hide A data ____ table describes the fields you plan to maintain in a table. ------ CORRECT ANSWER-----------definition Press ____ to return to cell A1 in a worksheet. ------CORRECT ANSWER--- --------Ctrl+Home In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. ------CORRECT ANSWER----- ------rows and columns To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. ------CORRECT ANSWER-----------inserts
When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions. ------ CORRECT ANSWER-----------arrow You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function. ------ CORRECT ANSWER-----------insert function The Subtotals command offers summary information such as ____. ------ CORRECT ANSWER-----------all of the above To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. ------CORRECT ANSWER-----------convert to range One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data. ------ CORRECT ANSWER-----------any of the above The PivotTable button is available in the Tables group on the ____ tab. -----
- CORRECT ANSWER-----------Insert By default, the PivotTable report uses the ____ function for numbers in the Values area. ------CORRECT ANSWER-----------SUM
You can use the ____ tab to change the SUM function to a different summary function, in a PivotTable. ------CORRECT ANSWER----------- summarize values by You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data. ------CORRECT ANSWER-----------refresh A worksheet ____ is a collection of two or more selected worksheets. ------ CORRECT ANSWER-----------group Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. ------CORRECT ANSWER-----------ranges To select adjacent worksheets, you use the ____ key. ------CORRECT ANSWER-----------shift To select nonadjacent worksheets, you use the ____ key. ------CORRECT ANSWER-----------Ctrl Rather than retyping the same formulas across a series of worksheets, you can enter them all at once by creating a worksheet ____. ------CORRECT ANSWER-----------group The ____ caption indicates a worksheet group. ------CORRECT ANSWER-- ---------[Group]
You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6. ------CORRECT ANSWER----------- mixed The ____ button on the Ribbon is used to create a hyperlink. ------ CORRECT ANSWER-----------hyperlink When you click a(n) ____, the computer switches to the file or portion of the file that it references. ------CORRECT ANSWER-----------hyperlink The default template has column widths is set to ____ characters. ------ CORRECT ANSWER-----------8. The default template has ____ worksheets inserted in the workbook. ------ CORRECT ANSWER-----------three A ____ is a blank workbook that you can open with the text, formats, and formulas already built into it. ------CORRECT ANSWER-----------template To create a template, you simply save an Excel workbook in template format using the ____ dialog command. ------CORRECT ANSWER----------- Save As
To evaluate a condition in Excel, you use the ____ function. ------ CORRECT ANSWER-----------IF ____ just above a cell in the header row of an Excel table to select the column data but not the header. ------CORRECT ANSWER-----------click You could test two or more conditions and determine whether all conditions are true using the ____ function. ------CORRECT ANSWER-----------AND If all of the logical conditions are true, the AND function returns the logical value ____. ------CORRECT ANSWER-----------True You can ____ IF functions to allow for three or more outcomes. ------ CORRECT ANSWER-----------nest An alternative to using several nested IF functions is to use a ____ table. -- ----CORRECT ANSWER-----------lookup When you retrieve a particular value from a lookup table, the ____ value is the value you are trying to find. ------CORRECT ANSWER-----------lookup Lookup ____ allow you to use tables of data to "look up" values and insert them in another worksheet location. ------CORRECT ANSWER----------- functions
You can edit existing conditional formatting rules from the Conditional Formatting ____ dialog box. Click the Edit Rule button and make the appropriate changes. ------CORRECT ANSWER-----------rules manager The ____ function calculates the number of cells in a range that match criteria you specify, such as counting the number of company employees located in Austin. ------CORRECT ANSWER-----------COUNTIF The ____ function adds the values in a range that match criteria you specify, such as adding the total salary paid to Austin employees. ------ CORRECT ANSWER-----------SUMIF The ____ function calculates the average of values in a range that match criteria you specify, such as calculating the average salary paid to employees in each city. ------CORRECT ANSWER-----------AVERAGEIF ____ formatting changes a cell's formatting when its contents match a specified condition. ------CORRECT ANSWER-----------Optional Applications typically include an interface to assist the user in using the system, ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____. ------CORRECT ANSWER-----------all of the above The following is a valid function name: ____. ------CORRECT ANSWER----- ------none of the above
Range names must begin with ____. ------CORRECT ANSWER----------- either a or b The ____ box displays all of the names in the workbook. ------CORRECT ANSWER-----------name Any blanks or parentheses in a row or column label will be changed to ____ in defined names. ------CORRECT ANSWER-----------underscore characters One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature. ------CORRECT ANSWER-----------validation In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only integers. ------CORRECT ANSWER------ -----whole number In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept any type of numeric value. ------CORRECT ANSWER-----------decimal In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only values from a list. ------CORRECT ANSWER-----------list
