CISA 316 Questions & 100% Correct Answers

You can use a ___ function to return a value from a table that is based on an approximate match lookup. :~~ VLOOKUP The ___ error value means that a value is not available to a function or formula. :~~ #N/A If you are creating a calculated column or formula within an Excel table, you can use the ___ structured reference in the formula. :~~ qualified If all the logical conditions are true, the AND function returns the logical value___. :~~ TRUE If you see ___ as the result of a VLOOKUP formula, you might have entered a letter for the col_index_num instead of a number. :~~ #NAME? 2 | P a g e | © copyright 2024/2025 | Grade A+ Master01 | September, 2024/2025 | Latest update The ___ function calculates the difference between two dates and shows the result in months, days, or years. :~~ DATEDIF An error value begins with a(n) ___ followed by an error name that indicates the type of error. :~~ number sign To get the effect of a calculated column in a range of data, you must copy and paste the formula or use the ___ feature. :~~ AutoFill A formula that includes a structured reference can by fully qualified or unqualified. :~~ True You can use ___ to reference cells within an Excel table. :~~ cell and range addresses The ORERROR function can determine if a cell contains an error value and then display the message you choose. 3 | P a g e | © copyright 2024/2025 | Grade A+ Master01 | September, 2024/2025 | Latest update :~~ False You can calculate the number of cells in a range that match criteria you specify using the SUMIF function. :~~ False If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a ___ appears in the upper-left corner of the cell. :~~ green triangle In the Edit Formatting Rule dialog box, click the ___ button to open the Format Cells dialog box. :~~ Format The ___ function adds the values in a range that match criteria you specify. :~~ SUMIF For cell and range names, names of 5 to 15 characters are considered practical, although names can be up to 255 characte