A. Ctrl+1
B. Ctrl+5
C. Ctrl+7
D. Ctrl+9
In MS-Excel how can you find specific information in a list?
A. Select Tools> Finder from Menu
B. Click the find button on the standard toolbar
C. Select Insert > find the Menu
D. Select Data > form from the Menu to open the data form dialog box and click the criteria button
In MS-Excel two common wildcard characters that Excel recognize are?
A. * And ?
B. < and >
C. ^ and /
D. None of these
In MS excel——- feature makes it easier to add negative data to a worksheet.
A. Auto sum
B. Sort
C. Filter
D. Autocomplete
Ctrl+Shift+1 shortcut keys in excel are used to:
A. Format number in currency format
B. Format number in commo format
C. Format number in date format
D. Format number in time format
What is the function of the VLOOKUP function in Excel?
A. To perform a vertical lookup and return a value based on a specified criteria.
B. To perform a horizontal lookup and return a value based on a specified criteria.
C. To add up a range of cells.
D. To find the average of a range of cells.