MS Excel Basics Quiz

  What is MS Excel?

• Spreadsheet 

• Database Management 

• Presentation

• Workbook 

What is the keyboard shortcut for copying cells in Excel?

• Ctrl + X

• Ctrl + C

• Ctrl + V

• Ctrl + Z

In Excel, what does the function COUNTA() do?

• Counts the number of cells in a range that are not blank

• Counts the number of cells in a range that are greater than zero

• Counts the number of cells in a range that contain text

• Counts the total number of cells in a range

What does the term "cell" refer to in Microsoft Excel?

• A group of worksheets

• The intersection of a row and column

• A type of chart

• A formatting option

Which function is used to sum a range of cells in Excel?

• AVG()

• MAX()

• SUM()

• TOTAL()

What is the purpose of the AutoSum button in Excel?

• It adds up a range of cells

• It multiplies a range of cells

• It calculates the average of a range of cells

• It finds the maximum value in a range

   What are the shortcut keys for AutoSum

• ALT and S

• ALT and =

• CTRL and S

• CTRL and =

How do you insert a new worksheet in Excel?

 

• Press Ctrl + N

• "Insert" Go to the "Home" tab and click "Insert Sheet"

• Right-click on a sheet tab and choose

• Both A and B

How can you merge cells in Excel?

• Use the "Merge & Center" button

• Apply a cell style

• Use the "Merge Cells" option in the Format menu

• Both A and C

In Microsoft Excel spreadsheets, rows are designated as _______.

•  1, 2, 3, ....

• A, B, C, ....

• A1, B1, C1, ....

• I, II, III, ....