What is the name of the box where you enter data in Excel?
A cell
Write a formula to sum values in cells A1 to A5.
=SUM(A1:A5)
What does the SUM function do?
Adds all of the numbers within a range of cells
How do you make text bold in a cell?
Click the button or press Ctrl + B
A predefined formula that performs a specific calculation or task in Excel.
Write a formula to find the average of cells B1 through B10
=AVERAGE(B1:B10)
Which Function calculates the mean of the numbers in a range?
= AVERAGE
What icon is shown to represent the "fill" tool. (What adds color to a Cell)
Paint Bucket
How do you absolute reference cell A1 in a formula?
use the dollar sign { $a$1 }
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?
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:
How would you merge and center the text in cells A1 to D1?
select the range, then click Merge & Center on the Home tab
What symbol is used to signify a range in excel?
a colon 👉🏽 :
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)
What does the COUNT function do?
Counts the number of numeric values in a range
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
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
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?
How do you change the row height of multiple rows or columns to fit the content automatically?
double-click the the border of any selected Row or column