MS Excel For SF

How do you save a workbook with a new name?

• Click the Save As button.

• Press Ctrl + S and enter a new name

• Click Format and select "Save As"

• Type Crtl + V and enter a new name

What is the purpose of the Quick Access Toolbar?

• To connect to external data sources

• To provide quick access to frequently used commands

• To manage user accounts and permissions

• To display the current date and time

The intersection of a row and a column is called a ________.

• Cell

• Sum

• Worksheet

• Chart

A group of cells is called a ________.

• chart

• multicell

• cluster

• cell range

Where is the fill handle located?

• in Backstage View

• at the beginning of any formula or function

• at the bottom-right corner of the selected cells

• on the right side of the home tab on the ribbon

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• It should use quotation marks instead of parentheses.

• There is nothing wrong with the formula.

• It should have an equals sign (=) at the beginning.

• It should use the COUNT function instead.

True or False: You can view a formula by double-clicking the cell that contains the formula.

• TRUE

• FALSE

Which of the formulas below are valid? Select all that apply.

• =5B+6B

• A3+100

• =R2*D2

• =F2+F3+F4-53

How do you merge two or more cells in Excel?

• Right-click the cells you want to merge, then select "Merge Cells" from the context menu.

• Use the Format Cells dialog box.

• none of these ways

• Select the cells you want to merge, then click the "Merge & Center" button on the Home tab.

How do you apply a cell style to a range of cells in Excel?

• none of these

• Click the "Cell Styles" button on the Home tab, then select the style you want to apply.

• Use the Format Cells dialog box.

• Use the Insert tab.