Download WGU C268 SPREADSHEETS FINAL OA STUDY GUIDE TEST B and more Exams MS Microsoft Excel skills in PDF only on Docsity!
WGU C268 SPREADSHEETS FINAL OA
STUDY GUIDE TEST BA
⩥ worksheet. Answer: contains the actual data and calculations ⩥ cells. Answer: store individual pieces of data or calculations ⩥ File Menu. Answer: menu used to manipulate workbooks ⩥ Home. Answer: area includes items used in formatting the appearance of data in cells ⩥ Insert Area. Answer: include features that allow you to place specialized elements into your workbooks, such as charts, pictures, and shapes ⩥ Page Layout Menu. Answer: menu items are used to format the appearance of worksheets ⩥ Formulas Menu. Answer: menu items aid in performing calculations using Excel's built-in functions
⩥ Data Area. Answer: used to aid in importing and working with large amounts of data ⩥ Review Menu. Answer: menu items help in sharing an Excel workbook with colleagues ⩥ View Menu. Answer: menu items are used to change how a worksheet is displayed on the screen ⩥ Info portion of the File. Answer: menu displays information about the current workbook and the users who have contributed to the file ⩥ New portion of the File. Answer: menu contains features related to creating a new workbook ⩥ Templates. Answer: can be particularly useful because they often contain data, formatting and calculations that relate to common spreadsheet tasks ⩥ Open. Answer: used to select a different workbook that you want to be opened in Excel or select a workbook that has been saves on Skydive or locally on your computer ⩥ Save and Save As Functions. Answer: allow you to (1) save the current workbook, (2) save a copy of the current workbook with a new
⩥ Help Area. Answer: provides access to Microsoft's extensive online help materials, information about how to get started with Excel, as well as information about the version of Excel you are using ⩥ What is the actual number of worksheets that you can store in a single workbook. Answer: It is is limited by the memory resources of your computer ⩥ provides a way to specifically define and refer to cells. Answer: Addressing Scheme ⩥ values stored in another cell of a worksheet. Answer: referencing a cell ⩥ refers to more than one cell at a time as long as the cells are in a continuous block. Answer: referencing a range of cells ⩥ To reference a range of cells. Answer: you specify the upper left cell in the range followed by the ":" character and the lower right cell in the range ⩥ How to enter data in a cell. Answer: select the cell you would like to use (by clicking on the cell) and type in the data you would like to store in the cell
⩥ How to modify data in a cell. Answer: double click on the cell you wish to change and make the changes to the text that you desire or modify the text in the formula bar that appears above the cells in the worksheet and below the Excel menu items ⩥ Fill Feature. Answer: feature allows you to automatically populate cells in a worksheet ⩥ Freeze Panes. Answer: feature in Excel allows you to "Lock" rows and columns so that they don't disappear when you navigate through the data table ⩥ absolute cell reference. Answer: A cell reference that remains constant when a formula is pasted into a new cell ⩥ character in front of the part of the reference that we wish to remain constant when a formula is pasted into a new cell. Answer: $ ⩥ What are the 3 functions of the The function wizard. Answer: (1) allows you to enter or select the inputs (called arguments) for the function (2) provides a description of the function and each argument (3) lists the function result based on the inputs you enter.
⩥ "EFFECT" function. Answer: calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged. ⩥ "NPER" function (number of payments to be made). Answer: calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount. ⩥ "PMT" function. Answer: calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off the loan, and the original loan amount. ⩥ "PV" function. Answer: calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment. ⩥ "FV" function. Answer: calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment. ⩥ which function will return the interest rate that is paid on the loan or investment described by the arguments. Answer: "Rate" function
⩥ which function is used to calculate the real, or effective, interest rate paid on a loan accounting for compounding interest. Answer: "EFFECT" function ⩥ what are the arguments for the EFFECT function. Answer: the interest rate quoted on the loan (nominal_rate) and the number of times per year that interest will be charged (npery) ⩥ which function is used to calculate the number of payments I will make on a loan before it is paid off. Answer: "NPER" function ⩥ what are the arguments for the NPER function. Answer: the interest rate charged on a loan (rate), and payment amount (pmt), and the original loan amount (pv). ⩥ which function is used to calculate the payment amount for a loan. Answer: "PMT" function (define) ⩥ what are the arguments for the PMT function. Answer: the interest rate charged on the loan (rate), the number of payments made on the loan (PMT), and the original loan amount (pv). ⩥ which function is used to calculate the current value for a loan or investment.. Answer: "PV" function
⩥ Operator "OR". Answer: combines Boolean expressions to determine if ANY of the combined expressions are TRUE ⩥ Checks to see if the opposite of the logical expression is true.. Answer: negation ⩥ Function used to evaluate negation, or the opposite of a Boolean expression. Answer: "NOT" ⩥ "Not" function. Answer: =NOT(logical) ⩥ What are the 3 arguments the "IF" statement accepts. Answer: (1.) The first is a Boolean expression (logical_test) comparing two values. The other two arguments are used to specify the results of the function depending on the results of the Boolean expression. (2.) The second argument (value_if_true) is used to specify the result of the IF function if the Boolean expression result is TRUE. (3.) The third argument (value_if_false) is used to specify the result of the IF function is the Boolean expression is FALSE. ⩥ example of "IF" function. Answer: =IF(logical_test,[value_if_true],[value_if_false]) ⩥ function allows you to determine the number of cells within a range of cells that contain a specific value. Answer: "COUNTIF" function
example: =COUNTIF(range,criteria) ⩥ function is used to calculate the total for a set of values that match a specific criterion. Answer: "SUMIF" function example: =SUMIF(range,criteria,[sum_range]) ⩥ function is used to calculate the average for a set of values that match a specific criterion. Answer: "AVERAGEIF" function example: =AVERAGEIF(range,criteria,[average_range]) ⩥ VLOOKUP accepts four arguments. Answer: (1.) The first argument, "lookup_value", refers to the information that will use to pull a value from the reference table. (2.) The second argument, "table_array", defines the location of the reference table (3.) third argument of the VLOOKUP function is "col_index_num", or the column in the table that contains the information you wish to have returned (4.) fourth argument is "[range_lookup]." This allows you to specify if Excel must find an "Exact Match" for the "lookup_value" in the first column of the reference table or if the "lookup_value" can fall within a range of values in the first column of the lookup table.
⩥ RATE function requires three arguments. Answer: (1.) the number of payments to be made (nper) (2.) the amount of the payments (pmt) (3.) the original amount, or present value, of the loan or investment (pv). ⩥ which two functions help you understand how much interest you will be paying on a loan (or earning on an investment if payments are being made to you instead of by you). Answer: Rate and Effect ⩥ Function returns the current date. Answer: TODAY () ⩥ Function returns the current date and time formatted as a date and time. Answer: NOW() ⩥ Function returns the day portion of a date (a number between 1 and 31). Answer: DAY (serial_number) ⩥ Function returns the month portion of a date (a number between 1 and 12). Answer: MONTH (serial_number) ⩥ Function returns the year portion of a date (a number between 1900 and 9999). Answer: YEAR (serial_number)
⩥ Function returns the day of the week for a date. Answer: WEEKDAY (serial_number, [return_type]) ⩥ returns the week of the year for a date. Answer: WEEKNUM (serial_number, [return_type]) ⩥ TODAY function (define). Answer: function returns the current date by checking with the operating system ⩥ NOW function (define). Answer: function returns the current date and time by checking with the operating system. ⩥ DAY function (define). Answer: function returns the "day" portion of a date. It requires a number as the only argument ⩥ MONTH function (define). Answer: function requires a number as its only argument. It also expects that number to correspond with a specific date and will return a number between 1 and 12 that represents the month associated with that date.
(define). Answer: function returns the minute portion of a time as a number from 0 to 59 ⩥ SECOND (serial_number) (define). Answer: returns the second portion of a time as a number from 0 to 59 ⩥ HOUR function (define). Answer: function requires one argument - a number that corresponds with a particular time. It returns the hour as a number from 0 to 23 to avoid confusing times in the morning with times in the afternoon or evening. ⩥ MINUTE function (define). Answer: function returns the minute portion of a time. It also requires a number that corresponds with a specific time as the only argument. It will return a number between 0 and 59. ⩥ SECOND function (define). Answer: function behaves like the HOUR and MINUTE functions. It returns a number between 0 and 59 that represents the second portion of a time. ⩥ LEN (text)
(define). Answer: function returns the length, in number of characters, of a block of text ⩥ SEARCH (find_text,within_text, [start_num]) (define). Answer: function returns the position of a specific character, word, or phrase within a block of text ⩥ LEFT (text,[num_chars]) (define). Answer: function returns a specified number of characters starting from the beginning of a block of text ⩥ MID(text,start_num,num_chars) (define). Answer: function returns a specified number of character from the middle of a block of text ⩥ RIGHT(text,[num_chars]) (define). Answer: function returns a specified number of characters starting from the end of a block of text ⩥ UPPER (text) (define). Answer: function converts a block of text to all upper-case characters ⩥ LOWER (text)
