#3: Cells in a spreadsheet are named by their: (A) data type (B) variable type (C) column number and row letter (D) column number and row number. #4: If an Excel column will contain prices of smartphones, which number format should you use: (A) accounting (B) data (C) currency (D) money
#5: Which Excel feature should you use to only show values in a column that fit certain criteria: (A) Design (B) Filter (C) File (D) Sort
#6: Which of the following would you use to search a table in Excel: (A) Descenter (B) Merge (C) Find and Select (D) Clear Rules
#7: You created a table in Excel but now you want to reorganize and summarize the information in a new format. Which of the following would you create: (A) Pivot Table (B) Filter (C) Data Type (D) Autofill
#8: In Excel, which would provide options to use if you were not sure how to display your information: (A) Formulas (B) Functions (C) A database (D)Recommended Charts