Terms
Formulas
Functions
Formatting
100

What is the name of the box where you enter data in Excel?

A cell

100

Write a formula to sum values in cells A1 to A5.

=SUM(A1:A5)

100

What does the SUM function do?

Adds all of the numbers within a range of cells

100

How do you make text bold in a cell?

Click the button or press Ctrl + B

200

A predefined formula that performs a specific calculation or task in Excel.

A Function
200

Write a formula to find the average of cells B1 through B10

=AVERAGE(B1:B10)

200

Which Function calculates the mean of the numbers in a range?

= AVERAGE

200

What icon is shown to represent the "fill" tool. (What adds color to a Cell)

Paint Bucket

300

How do you absolute reference cell A1 in a formula?

use the dollar sign     { $a$1 }

300

If cell A1 has your starting balance ($500), cell B1 has your expenses ($75), and cell C1 has your income ($200), write a formula to calculate the final balance.

=A1-B1+C1?

300

What is the purpose of a function in Excel, and can a formula contain multiple functions? Provide an example.  

A function in Excel helps you do math or other tasks easily, like adding numbers (SUM) or finding an average (AVERAGE). Yes, a formula can use more than one function. For example:

300

How would you merge and center the text in cells A1 to D1?

select the range, then click Merge & Center on the Home tab

400

What symbol is used to signify a range in excel?

a colon   👉🏽  :

400

Write a formula to find the difference between the  highest number of cells a1-a25 and the smallest number in the same range.

=MAX(A1:A25) - Min(A1:A25)

400

What does the COUNT function do?

Counts the number of numeric values in a range

400

Describe the process of formatting cells to show currency with no decimal places. 

Highlight the Range

go to format cells

Choose Currency

Take away decimal places

500

What is the difference between a workbook and a worksheet?

A workbook is the entire file, a worksheet is a single tab within the workbook

500

f cell A1 contains the number of items (5), cell B1 contains the cost per item ($12), and cell C1 contains the delivery fee ($10), write a formula to calculate the total cost.

Answer: What is =A1*B1+C1?

500
What does a counta function do?
Counts cells with a text value
500

How do you change the row height of multiple rows or columns to fit the content automatically?

Select the entire sheet 

double-click the the border of any selected Row or column

M
e
n
u