MIS 112 Final
Which operator in Excel combines multiple range references into a single reference (e.g., if I want to sum up the values in non-contiguous cell-ranges across the worksheet)? "," (comma) ":" (colon) ";" (semi colon) " " (space)
"," (comma)
Please see the attached workbook. Using the formula =B2/C2 what error is displayed? #N/A #NULL! #DIV/0! #NAME?
#DIV/0!
The Excel function: ISERR() returns TRUE if the cell contains any error value except which of the following? #N/A #REF! #VALUE! #NULL!
#N/A
Which of the following error codes indicates that a formula refers to a cell that is invalid? This type of error can occur if a referenced cell is deleted from the worksheet. #REF! #VALUE! #N/A #NAME?
#REF!
Examine the attached file: PS1_formulas.xlsx Calculate the total yearly sales for the West Region and the South Region in cells "F5" and "F7" (shaded in orange). What is the total widget sales for all regions for the year? $9,019 $13,218 $16,060 $24,914
$24,914
Examine the attached file: PS1_formulas.xlsx What is total widget sales for the West Region for the year? $13,282 $5,129 $4,015 None of the above
$5,129
What is the file format (file extension) used when you save an Excel workbook as a single file webpage? .html .mht or .mhtml .xlsx .txt
.mht or .mhtml
Please refer to the figure. Within the "Number" tab, how many categories are available for displaying numbers? 12 8 10 14
12
In the attached spreadsheet, please use an appropriate formula to compute the total of the Cells C2 through C11 (surrounded by a red border in the worksheet). What is this total? 14537.45 14875.5 14787.45 9787.45
14787.45
Please refer to the figure. How many worksheets are contained in the workbook shown? 1 5 3 A1
5
Which of the following formulas will display both the current date and time when entered into a cell in an Excel worksheet? = NOW() = DATE() = TIME() = TODAY()
= NOW()
Examine the attached Excel file. When the formula in "D2" is copied to the cells below it, cell "D3" will contain what formula? =(B3*C3)*$B$7 =(B3*C3)*B8 =($B$3*$C$3)*$B$7 =(B3*C3)*B7
=(B3*C3)*$B$7
In the attached Excel workbook PS1_Comments_Calculation.xlsx , which of the following formulas can be used to calculate Sophie's total score in both the exams? ={B4+C4} =B4*C4 =B3+C3 =B4+C4
=B4+C4
Which of the following options, when used as a formula in the Custom Data Validation criteria for cell A1, will ensure that the entry in cell A1 begins with the letter P and contains exactly four characters? =COUNTIF(A1, "P???")=1 =COUNTIF(A1, "P???")=4 =COUNTIF(A1, P???)=4 =COUNTIF(A1, P???)=1
=COUNTIF(A1, "P???")=1
If you place the link target in cell C1 on the same worksheet, how will you use an absolute reference to that cell as the link_location in the HYPERLINK formulas? =HYPERLINK($C$1) =HYPERLINK(C1$) =HYPERLINK(C1$C1*) =HYPERLINK("","C1$C1*")
=HYPERLINK($C$1)
Please see the attached workbook. The grade of the student should be "Pass" if his/her score is greater than 65. Otherwise, the grade should be "Fail". Which of the following formulas could you use for this scenario? =IF(D2>65,"Fail","Pass") =IF(D1>65,"Pass","Fail") =IF(D2>65,"Pass","Fail") =IF(E2>65,"Pass","Fail")
=IF(D2>65,"Pass","Fail")
Based on the class lecture, which of the following is true about table renaming? Table renaming is not recommended in Excel as it will cause formulas to stop functioning properly Renaming a table is done automatically when a Table is extended (e.g., when you add a new row of data) A table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS) Excel tables are named based on the worksheet it is located in, e.g., a table in "Sheet1" will be named "Sheet1Table1" or "Sheet1Table2"
A table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS)
Which of the following statements is true? A workbook can have at most 3 worksheets. A worksheet can have many workbooks. A workbook can have many worksheets. A worksheet can have at most 3 workbooks.
A workbook can have many worksheets.
Please refer to the figure. In an Excel worksheet, what column name comes directly after Column Z? AA AZ ZA ZZ
AA
If you copy a formula down a column, and need a cell reference to stay the same (for example, you don't want B2 to change to B3), what type of cell reference do you need? (Example: Use of F4 key) Absolute Relative Frozen Automated
Absolute
Which of the following is TRUE with respect to charts? After you create a chart, you have great deal of flexibility in customizing it. Data is NOT needed to create a chart. Plot area contains all the elements of the chart. A Pie chart is another name for a Column chart.
After you create a chart, you have great deal of flexibility in customizing it.
If you write a lookup formula to look up the text 'education', the formula considers which of the following a match? EDUCATION Education education All answers provided are correct
All answers provided are correct
An Excel formula may return which of the following errors? #REF! #DIV/0! #VALUE! All of the above
All of the above
Which of the following is TRUE of the "Protect" option in an Excel Workbook? it helps prevent unauthorized users from copying existing worksheets it helps prevent unauthorized users from revealing hidden sheets it helps prevent unauthorized users from inserting new worksheets All of the above options are true
All of the above options are true
How can you edit the contents of cell (by entering cell-edit mode)? Choose the best answer. All of the options provided are correct Double-click the cell Select a Cell and press F2 Select a Cell and then click inside Formula bar
All of the options provided are correct
How will you refresh the query after moving the cell pointer anywhere within the external data table in the worksheet? Right-click and choose Refresh from the shortcut menu Choose: Data (tab) -> Connections (command group) -> Refresh All. Click "Refresh" in the Workbook Connections dialog box (displayed by choosing: Data (tab) -> Connections (command group) -> Connections ). All the options in this question are valid
All the options in this question are valid
Examine the attached workbook. Fill in the blank: You can add a title to the vertical axis of the chart by using Chart Layouts (Chart Tools "Design" tab) --> Add Chart Element --> __________ Chart Titles Legend Axis Titles Data Labels
Axis Titles
Which of the following is the default font type and font size in Excel 2016? Calibri, 11 point Arial, 12 point Times New Roman, 10 point Cambria, 14 point
Calibri, 11 point
Which of the following concepts are useful in understanding relationships between cells and formulas? Cell Credits Blue-on-Green Precedents Cell Dependents The One-Time Rule
Cell Dependents
What command would you use to import a CSV file? Choose Data --> Get External Data --> From Text Choose Data --> Get External Data --> From CSV Choose Data --> Import Data --> External None of the provided options is correct
Choose Data --> Get External Data --> From Text
To gain access to the Table Tools / Design tab in the Excel Ribbon when working with tables, you should do the following: Click anywhere on the table Such a tab does not exist, the only tab you can get access to is: Table Format/Design Click on the Home tab on the Ribbon, and check the appropriate box to make it appear The Table Tools/Design tab does not provide any useful commands, so it is pointless trying to access it
Click anywhere on the table
How do you set up a data validation (using the data validation dialog box) that restricts data entry to a decimal number within limits? Click the Settings tab (in the Data Validation box). In the Allow box, select 'Decimal'. In the Data box, select 'between', and set the minimum and maximum. Home (tab) -> Editing (group) -> Find & Select -> Data Validation Formulas (tab) -> Calculation (group) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Text Length'.
Click the Settings tab (in the Data Validation box). In the Allow box, select 'Decimal'. In the Data box, select 'between', and set the minimum and maximum.
Which option under conditional formatting applies background color proportional to the cell's value. Color scales Icon sets Data Bars Highlight Cells rules
Color scales
Please refer to the attached workbook. What does the pivot chart depict? Compares the amount in the three branches on the basis of AcctType. Compares number of accounts in the three branches by account type Compares the customer type in the three branches None of the answers provided is correct
Compares the amount in the three branches on the basis of AcctType.
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? Ctrl + N Ctrl + E Ctrl + W Ctrl + B
Ctrl + N
Which of the following keyboard shortcuts will add the current time to a cell in an Excel worksheet? Ctrl + Shift + : Ctrl + ; Ctrl + ' Ctrl + T
Ctrl + Shift + :
What is the shortcut to open the Find and Replace dialog box with the "Find" tab open? Ctrl+H Ctrl+F Ctrl+A Ctrl+Alt+F
Ctrl+F
What is the shortcut key to create hyperlink when you select an object or a cell? Ctrl+H Ctrl+I Ctrl+J Ctrl+K
Ctrl+K
Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default? Developer Review Home Insert
Developer
Examine the attached workbook. If you format a chart element with the font seen in Chart 2, how can you reset it to its original state? Format tab (chart tools) --> Reset to Match Style (under the "Current Selection" group) Right click on the chart --> Reset to Match Style Either of the previous options (resetting through the menu or the right-click options work) Home tab --> Wrap Text, followed by, Paste
Either of the previous options (resetting through the menu or the right-click options work)
Which older version of Excel file can Excel 2016 NO LONGER open? Excel can open all of these files. Excel 4 Excel 97 Excel 2000
Excel can open all of these files.
What is the result of the formula=2^3 * (,10*10 Excel tells you that the formula contains an error 800 600 150
Excel tells you that the formula contains an error
Please use the attached workbook as an external data source. The workbook has a table called 'Employee'. When you import data, after selecting all the columns from the table using the query wizard (Data(tab) -> Get External Data (group) -> From Other Sources -> From Microsoft Query), how will you filter the records to retrieve those that have a value that ends with 'm' for 'Name'. From the Column to Filter list, select Name. In the right panel, select 'ends with' from the first drop-down list and then type 'm' in the second drop-down list box From the Column to Filter list, select Name. In the right panel, select 'begins with' from the first drop-down list and then type 'm' in the second drop-down list box From the Column to Filter list, select Name. In the right panel, select 'equals' from the first drop-down list and then type 'm' in the second drop-down list box From the Column to Filter list, select Name. In the right panel, select 'equals' from the first drop-down list and then select 'Sam' from the second drop-down list
From the Column to Filter list, select Name. In the right panel, select 'ends with' from the first drop-down list and then type 'm' in the second drop-down list box
After pressing "Alt + H" while in an open Excel worksheet, a number of Key Tips are displayed. Which ribbon tab do these Key Tips relate to? Home Review Insert Formulas
Home
Which of the following is a VALID method of hiding rows or columns? Home (ribbon tab), (then) Format (in the Cells group) --> Hide & Unhide (from the drop down list) Click on the Row/Column header, (then) right-click and choose Delete Right-click on the cell, (then) choose "Insert" Home (ribbon tab), (then) Paste (in Clipboard group)
Home (ribbon tab), (then) Format (in the Cells group) --> Hide & Unhide (from the drop down list)
Which of the following functions could be used if you want to display "NOT FOUND" when you lookup for an item that is not part of the lookup_vector? SUM MATCH INDEX IFERROR
IFERROR
When (or why) does Excel draw arrows to indicate an error source? For finding dependencies between two images pasted in different worksheets In Tracing Error Values Error-checking the sheet Background Because Functions Must Have Arrows
In Tracing Error Values
Please see the attached Excel workbook. Suppose you are on Sheet1 and you have selected cells A5:B5. What happens when you insert a background image through the following sequence of steps? Page Layout (tab) -> Page setup (command group) -> Background? It adds the background image to the selected cells It adds the selected background image to Sheet1, Sheet2, Sheet3 in the current workbook It adds a background image to the currently active worksheet It adds a chart with the background image embedded
It adds a background image to the currently active worksheet
When a column is sorted within a table, which of the following is true about the drop-down list in the header row? The header row background fill color changes to a darker shade It displays a different graphic to remind you that the table is sorted by that column There is no change to the header for that column before or after sorting The header row (for that column) is now disabled and until the sort is cleared, no further actions are permitted
It displays a different graphic to remind you that the table is sorted by that column
Fill in the blank: Every chart type has a set of ____ that you can choose from (with settings for chart elements such as a title, data labels, axes, and so on). Shapes Categories Layouts Attributes
Layouts
Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell? No, it only deletes the cell's style No Yes, but only if the data is text Yes
No
Please examine the attached workbook. The chart was created based on data in cells A1 through C6. If new data is added in cells A7 through C7, will the chart include the new data automatically? PS2_Chart1 No, this feature is only supported for Clustered Column charts Yes, but only because it is a Stacked Column chart No Yes
No
For this question, please download the attached Excel workbook. Convert the data on Sheet1 into a table. Next answer the following question: If you proceed to remove duplicate values using the "Remove Duplicates" feature in "Table Tools", will Excel remove one of the two table rows? Yes, because Excel can see that the dates in the two cells are the same value. No, because dates that are a duplicate cannot be removed. No, because Excel does not let you remove duplicates when you only have 2 rows in a table (removing a row makes it a 1-row table, which is not really a table). Yes, because the duplicate values are determined by the value displayed in the cell and not necessarily by the value stored in the cell. No, these are not considered duplicates by Excel. To remove the duplicate data you must ensure that the date in the second row is formatted the same way as the date in the first row.
No, these are not considered duplicates by Excel. To remove the duplicate data you must ensure that the date in the second row is formatted the same way as the date in the first row.
Can you print data in an Excel Form attached to a table? No, you cannot Yes, you can always perform an action like Printing in Excel You can print forms with the "Print" button on the Form only Printing is disabled unless you buy the "Print Form" Excel Professional feature app from Microsoft
No, you cannot
Which type of chart does not allow format changes to the Plot area? Bar chart Treemap Thermometer chart None of the (other) options provided is correct
None of the (other) options provided is correct
When you use the HLOOKUP() function, which of the following parameters represents the row number from which the matching value will be returned? range lookup lookup_value row_care_param None of the options provided is correct
None of the options provided is correct
Please see the attached workbook. What value of Discount is returned when you use an VLOOKUP function with a quantity entered (i.e., value looked up) of 1001 and a range-lookup parameter of FALSE? 3% 6% 12% None of the other answers are correct
None of the other answers are correct
Please see the attached Excel workbook image. The cells highlighted in yellow contain a Total Row. How can such a Total Row be added to a table? Once you have a table, you can click the "Table Tools / Design" tab. Then, under "Table Style Options" check the box for "Total Row." This cannot be done anymore, it is an unsupported feature in Excel 2013 The most effective way is to add a new row, and manually add total options Adding a Total Row requires knowledge of Visual Basic which is not covered in this course
Once you have a table, you can click the "Table Tools / Design" tab. Then, under "Table Style Options" check the box for "Total Row."
Please refer to the attached Excel workbook. How can you add a dollar ($) symbol to values in a column as seen in the "Grand Total" column? The simplest way is to click on the "Wrap text" button in Home tab. From the dialog box that pops up, pick the default $-symbol formatting. This is automatically provided to you when you make an Excel Table One way to do this is by going through the "Format Cells" dialog, and selecting "Accounting" (with a $ symbol and 2 decimal places) as your formatting option from within the Number tab The correct way to do this is by going through the "Format Table" menu, and selecting the option of "Number" (with 2 decimal places and a $ symbol)
One way to do this is by going through the "Format Cells" dialog, and selecting "Accounting" (with a $ symbol and 2 decimal places) as your formatting option from within the Number tab
Please refer to the attached workbook. What happens if the following value filter is added to the existing report? Value filter: Sum of Sales is greater than 5000. Only one record corresponding to the 'CA' state remains as its total sales amount is greater than 5000. Only one record corresponding to the 'AZ' state remains as its total sales amount is greater than 5000. Nothing happens. Both the records remain. No records remain as they don't satisfy the condition specified.
Only one record corresponding to the 'CA' state remains as its total sales amount is greater than 5000.
Which of the following is TRUE about Web queries? Performing Web queries creates a new HTML file Performing Web queries copies information from an HTML file into the current workbook Web queries are not useful in Excel because an external data can change None of the options provided is true
Performing Web queries copies information from an HTML file into the current workbook
What is the primary purpose of "Protected View?" Protect you from malware Prevent your peers from accidentally editing data Make it impossible for people to change your data unless they have a password Encrypt your spreadsheet data
Protect you from malware
Please refer to the figure. What Excel element is shown in the red box? File button Quick Access toolbar Scrollbar Ribbon
Quick Access toolbar
Please see the attached workbook. Which of the following steps allow you to add a comment to a specific cell? (When you move over the cell with your mouse, the comment will pop up) Review -> Comments -> New Comment Review -> Comments -> Show Ink Formulas -> Lookup&Reference Review -> Changes -> Allow Users to Edit Ranges
Review -> Comments -> New Comment
Please refer to the figure. What Excel element is shown in the red box? File button Quick Access toolbar Scrollbar Ribbon
Ribbon
cumulativesum.xlsx Please see the attached workbook. Cell C7 currently has a number entered manually. This number should be replaced with a formula. What is the best formula to use in cell C7? SUM(C2:C6) SUM(B[2:7]) SUM(B$2:B7) SUM(B&2:B7)
SUM(B$2:B7)
Which of the following methods is a VALID way to get into cell edit mode? Clicking the cell one time enables you to edit the cell contents Selecting the cell that you want to edit, and then clicking in the Formula bar Pressing F9, which enables you to edit the cell contents directly in the cell Pressing F4 allows you to the edit the cell contents
Selecting the cell that you want to edit, and then clicking in the Formula bar
Please refer to the figure. Which of the following View ribbon tab options was used to display the horizontal bar between the nonconsecutive rows containing "Astoria, OR" and "Victoria, TX"? Split New Windows View Side by Side Hide
Split
While comparing two sheets using the "View Side by Side" feature, there is an option which lets you scroll the two sheets in sync. What is that option called ? Synchronous Scrolling None of the (other) options provided is correct Toggle Side View
Synchronous Scrolling
Excel formatting tools are available at the following locations: The Format Cells dialog box and the Home Tab of the Ribbon On the Home Tab of the Ribbon only On the Mini toolbar that appears when you right-click a range or a cell, and the Home Tab of the Excel Ribbon The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar
The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar
What part(s) of a table can be selected? An entire column, but not an entire table An entire row, but not an entire column The entire table or an entire row only The entire table, an entire row, or an entire column from a table can be selected
The entire table, an entire row, or an entire column from a table can be selected
f a pivot chart is created and the underlying table is deleted, what occurs? The pivot chart is also deleted. The pivot chart remains. The data the Chart is based on is invalid since the Pivot Table has vanished. The chart is not deleted, but it no longer contains the data from the underlying table.
The pivot chart remains.
Excel formatting tools are used to achieve which of the following? To create programming code in Java/C++ To make the end result attractive and more functional To distract readers from inaccuracies in text and figures The primary use of formatting is to create Excel Pie Charts All of the options listed are valid
To make the end result attractive and more functional
Which formula would you use if you want to accept only text that begins with a specific character 'a' for a given cell 'A1'? Use a formula: =LEFT(A1)="a" Use a formula: =RIGHT(A1)='a' Use a formula: =UPPER(A1)='A' None of the options provided is valid
Use a formula: =LEFT(A1)="a"
Which of the following is an advantage of using Excel tables? Tables are the best way to display percentages of a whole (e.g., portfolio percentage composition) By sorting results largest-to-smallest, tables allow you to search for hidden patterns in data, much like playing a record backwards Tables encrypt our data so a hacker is unable to read it by obtaining a copy of the Excel workbook Using table and column names in formulas provides greater flexibility as extending a table does not require re-writing of formulas
Using table and column names in formulas provides greater flexibility as extending a table does not require re-writing of formulas
Which of the following options provides correct syntax for the VLOOKUP function? VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) VLOOKUP(lookup_value, table_array, row_index_num, range_lookup) Either of the two previous choices will work None of the options provided is valid
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
Please see the attached workbook. If you copy cell "B6" and paste it as a formula in cell "C6," will it produce the correct total for Year 2? No, because the result will be the total for Quarter 1. No, because you must directly enter the formula for each quarter in cell C6. Yes for Excel 2013, but not for previous versions of Excel. Yes, the formula range will be adjusted automatically
Yes, the formula range will be adjusted automatically
Different table formatting styles can be previewed by mousing over different options within "Table Styles" (i.e., you can see what the appearance will be like without actually applying a new style). Is this statement accurate? Yes, the statement is accurate No, this is a false statement The statement is accurate only for the first 7 styles previewed. After that, to conserve memory, Excel will apply a style and you can start the preview process over again. Yes, previews are possible as long as the Total Row option is not checked
Yes, the statement is accurate
When you try to import data from MS-Access into Excel, which of the following is TRUE? You can import a table or a query Excel no longer supports this type of import Excel imports reports, forms and query SQL You must convert the database into XML output before the import
You can import a table or a query
Which of the following characters is VALID for use in an Excel workbook file name? _ : " \
_
Which of the following is a VALID range name in an Excel workbook? Income Taxes _2ndyear 3rdQuarter Total_percent%
_2ndyear
Please see the attached workbook. The formula in cell C4 is "=B4 + (B4 * $C$1)". Formulas in range C4:C7 use a / an _________ reference to cell C1. absolute columnar mixed none of the options provided is correct
absolute
What type of cell reference does the formula in E2 use? (refer to the attached image, the formula is highlighted) price oriented absolute relative incorrect
absolute
A pivot table and a pivot chart are joined in a two-way link, if you make structural or filtering changes to one, the other _______. also changes remains unchanged shows a sparkline graphic to highlight the change can be eliminated to avoid duplicates
also changes
Consider the HLOOKUP function in Excel. If the "range_lookup" argument is set to TRUE, we need to sort the first column of the range in ____________ order descending ascending color coded ranged
ascending
Please see the attached workbook. In cell A2, how is the data validation done? by checking if there are no numbers present by checking if there are no special characters such as '#','$','*' etc. by checking if the number of characters is between 4 and 20 by checking to ensure there are at least 5 characters present
by checking if the number of characters is between 4 and 20
In Excel, the ISNONTEXT() function returns TRUE if its argument refers to which of the following? content other than text (e.g., a date or a number) or a blank cell a cell containing data in a numeric or date format this function is used primarily for blank or empty cells a cell with alphanumeric characters
content other than text (e.g., a date or a number) or a blank cell
Which of the following can be retrieved from a web page using web queries? .gif image contents of scripts .jpeg images data in a table
data in a table
While creating a parameterized web query the ampersand character (&) is used to ______. delimit the parameter from the prompt delimit the name from the value delimit each name/value pair begin the URL query string
delimit each name/value pair
What does the Excel keyboard shortcut Ctrl+Alt+F9 do? highlights error codes in the current workbook calculates only the formulas in the active worksheet. Other worksheets in the same workbook aren't calculated. forces a complete recalculation of all formulas in all open workbooks. Ctrl+Alt+F9 will not do anything in Excel
forces a complete recalculation of all formulas in all open workbooks.
What is the use of the following data validation formula: =ISTEXT(A1) ? forces the cell A1 to accept only text forces the cell A1 to accept only numbers forces the cell A1 to accept only ' * ' forces the cell A1 to accept only ' + '
forces the cell A1 to accept only text
Please see the attached workbook. What is the URL Query String for the extract in the attached worksheet? http://www.imdb.com/ http://www.imdb.com/careers http://www.imdb.com/latest http://blackboard.eller.arizona.edu/
http://www.imdb.com/
A #REF! error occurs in Excel when a formula uses a / an ________ cell reference valid invalid multi-cell average summation within a
invalid
In Excel, what does the MODE function in a range return? most frequently occurring value in a range mean of the values in the range most frequently occurring text entry in a range middle value of the range
most frequently occurring value in a range
You select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard. Which of the following holds TRUE? only the contents of the cell are removed only the formatting of the cell is removed the contents and formatting of the cell are removed no changes occur
only the contents of the cell are removed
You can protect your Excel workbook with a password. Which of the following is TRUE about password protected workbooks? passwords are NOT case sensitive passwords are case sensitive if you forget your workbook password, you can email the TA to retrieve it for you workbook passwords automatically expire in 360 days
passwords are case sensitive
Which of the following options best describe what the following formula would do? =VLOOKUP(D2,PAGES!A2:B10,2,TRUE) perform the vlookup in a different worksheet which has an exact match perform a vlookup in the same worksheet (exact match) perform a vlookup in a different worksheet which does not have an exact match None of the (other) options provided is valid
perform a vlookup in a different worksheet which does not have an exact match
A group of cells is referred to as which of the following? group range pack class
range
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______. select a row select a column select a range select multiple rows or columns
select a column
For VLOOKUP() and HLOOKUP(), the lookup_value argument can include wildcard characters if the lookup_value argument is ______ and the range_lookup argument is ________ numeric; true numeric; false text; false text; true
text; false
