Class Test #2: SAO 7

What is the default file extension for an Excel workbook?

• .docx

• .pptx

• .xlsx

• .txt

Which function is used to find the sum of a range of values?

• AVERAGE

• COUNT

• SUM

• MAX

How many columns are there in Microsoft Excel 2019?

• 16,384

• 1,048,576

• 256

• 65,536

The last column in Excel is labeled as:

• Z

• ZZ

• IV

• XFD

Which of the following is NOT a valid data type in Excel?

• Text

• Number

• Formula

• Chart

What is the shortcut key to save a file in Excel?

• Ctrl + A

• Ctrl + S

• Ctrl + X

• Ctrl + P

To select the entire column in Excel, you should press:

• Ctrl + Space

• Shift + Space

• Alt + Space

• None of the above

How can you quickly open an existing Excel file?

• Ctrl + O

• Ctrl + N

• Ctrl + X

• Alt + F4

Which formula is used to count the number of numeric values in a range?

• COUNT

• COUNTA

• COUNTIF

• SUM

What is the shortcut key to open the Sort dialog box?

• Alt + D + S

• Ctrl + S

• Shift + S

• Alt + O