Introduction to Excel Week 1

What function would you use to sum a range of cells in Excel?

• A) SUM

• B) AVERAGE

• C) COUNT

• D) MAX

What is the keyboard shortcut to save a workbook in Excel?

• Ctrl + V

• Ctrl + X

• Ctrl + B

• Ctrl + S

How can you insert a new row in an Excel spreadsheet?

• Press Ctrl + R.

• Right-click on the row number and select "Insert" from the context menu.

• Press Ctrl + Shift + R.

• Click on the "Insert" button in the Home tab of the ribbon.

How can you format a cell to display currency values?

• Use the "Number Format" dropdown menu in the Home tab of the ribbon and select "Currency."

• Type "$" symbol before the value in the cell.

• Press Ctrl + Shift + $

• Right-click on the cell, select "Format Cells," choose the "Currency" category, and then select the desired currency format.

What does the "AutoFill" feature in Excel do?

• Automatically formats cells based on conditional formatting rules.

• Automatically fills cells with random data.

• Automatically completes a series or pattern of data based on a selection.

• Automatically adjusts the width of the selected cells to fit the content.

How can you change the font size of selected text in Excel?

• Right-click on the selected text, choose "Font," and then adjust the font size.

• Press Ctrl + Shift + >.

• Use the "Font Size" dropdown menu in the Home tab of the ribbon and select the desired font size.

• Press Ctrl + Shift + F.

How can you adjust and decrease the width of a cell in Excel?

• Select the column(s) containing the cell(s) you want to adjust.

• Place your cursor on the right edge of the column header until it turns into a double-headed arrow.

• Click and drag the column boundary to the left to decrease the width or to the right to increase it.

• Release the mouse button when the column is at the desired width.

What functions are commonly used to perform calculations such as counting?

• COUNT: counts the number of cells in a range that contains numbers.

• COUNTA

• CONCATINATE

• COUNTIFS

What functions are commonly used to perform calculations such as finding the maximum value

• MAXIF

• MAXIMUM

• MAX: This function returns the largest value in a range.

• MAXIFAX

What functions are commonly used to perform calculations such as finding the minimum value,

• MINIMUM

• MINI

• MINIF

• MIN: This function returns the smallest value in a range.