Quiz 2 Day2

1. What is the file extension for an Excel workbook (post-2003)?
   
   
   
   

• 1. A) .docx

• 1. B) .xlsx

• 1. C) .xls

• 1. D) .csv

What does each individual page in an Excel workbook represent?

• Document

• Cell
  
  

• Worksheet

• Slide

Which shortcut is used to create a new workbook in Excel?

• Ctrl+S
  
  

• Ctrl+O
  
  

• Ctrl+N

• Ctrl+W

What is the purpose of the COUNTIF function?

• Adds numbers

• Counts all empty cells

• Counts the number of times a value appears

• Filters data

Which function is used to compare two values and return TRUE or FALSE?

• VLOOKUP

• COUNT

• MATCH

• IF

Which feature allows Excel to adjust column width to the longest text in the column?

• Autofill

• AutoFit

• AutoFormat

• AutoWidthx`

1. To insert a new worksheet in Excel, what do you click?
   
   
   
   

• 1. A) Home > Insert

• 1. B) File > Add

• 1. C) Insert > New Sheet

• 1. D) "+" icon next to sheet tabs

1. Which tab contains the AutoSum feature in Excel?
   
   
   
   

• 1. A) View

• 1. B) Data

• 1. C) Formulas

• 1. D) Insert

What is a cell in Excel?

• A) A horizontal alignment

• B) A vertical alignment

• C) An area where you enter data

• D) A formula bar

1. What is used to organize and format sales data in Excel?
   
   
   
   

• 1. A) Text box

• 1. B) Chart

• 1. C) Table

• 1. D) Header